Weekly executive social listening brief

Build me a weekly executive social listening agent for our marketing leadership team. Trigger: cron, every Monday at 8am ET.

On each run, the agent should:

1. Use Brandwatch List Projects and List Queries (and List Query Groups) to identify the project that holds our brand and competitor queries. On the first run, confirm with me which queries are our brand and which are each named competitor, then remember that mapping for future runs.

2. For the trailing 7 days, call Brandwatch Get Chart Data to pull (a) volume by day, (b) sentiment breakdown, and (c) volume broken down by queryGroups so we can compute share of voice in a single call. Compare the totals to the prior 7 days.

3. Call Brandwatch Get Topics to surface trending and bursting topics with sentiment for our brand query, and Retrieve Mentions (sorted by reach) to grab the highest-reach posts of the week.

4. Synthesize a tight executive brief. Tone: confident, plain English, no jargon, no bullet padding, no charts. Sections: total mention volume vs prior week with the percent change called out; sentiment breakdown with one sentence on what shifted; share of voice vs each named competitor with the delta vs last week; three trending topics with one sentence each on what's driving them; the single most influential post of the week with author, channel, reach, and a one-line take on why it matters.

5. Use Notion Create a Page to add a new entry to our 'Weekly Brand Report' database (I'll provide the database ID). Title it 'Weekly Brand Report — week of <Monday date>' and put the full brief in the page body.

6. Use Gmail Send a Message to email the same brief to our leadership distribution list (I'll provide the address). Subject line: 'Weekly Brand Report — week of <Monday date>'. Body should be the brief itself, formatted as readable HTML with section headings, plus a link to the Notion page at the top.

Keep the prose tight and executive-ready. This is replacing Brandwatch's native scheduled email reports, which leadership ignores because they're raw chart dumps. The value is the AI-written narrative on top of the same data, archived in Notion as a permanent record.