Weekly executive social listening brief, written and emailed

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.

Additional information

What does this prompt do?

Pulls last week's brand and competitor data from Brandwatch and writes a plain-English executive brief, no chart dumps.
Covers total mention volume versus the prior week, sentiment, share of voice against each named competitor, three trending topics, and the single most influential post.
Saves the brief as a new entry in your 'Weekly Brand Report' Notion database so leadership has a permanent archive.
Emails the same summary from Gmail to your leadership distribution list every Monday at 8am Eastern.

What do I need to use this?

A Brandwatch login with access to the project that holds your brand and competitor queries.
A Notion workspace with a 'Weekly Brand Report' database (or any database you want to use for the archive).
A Gmail account that can send to your leadership distribution list.

How can I customize it?

Change the schedule. Switch from Monday at 8am ET to a different day, time, or cadence (daily, biweekly).
Swap the recipients. Point the email at a different distribution list, or add Slack delivery as a second channel.
Tune the brief. Add or remove sections like geography, top influencers, or category-level sentiment, and tell the agent which competitors to call out by name.

Frequently asked questions

Does this replace the scheduled email reports Brandwatch already sends?

Yes. The native Brandwatch reports are raw chart attachments that most exec teams ignore. This workflow uses the same underlying data, but the agent writes a short narrative on top so leadership actually reads it.

How does the agent know which queries belong to my brand versus competitors?

On the first run, it lists your Brandwatch projects and queries and asks you to confirm which queries are your brand and which are each competitor. After that it remembers the mapping and uses it every week.

Where does the written brief end up?

It gets saved as a new page in the Notion database you pick (we suggest one called 'Weekly Brand Report'), and the same summary is emailed to your leadership distribution list. The Notion archive gives you a permanent searchable record.

Can I see charts in the brief, or is it text only?

Text only by design. The whole point is a tight executive narrative. If you want charts, you can keep the native Brandwatch report running alongside this one.

What if mention volume is unusually high or low one week?

The agent calls that out at the top of the brief, frames it against the prior week, and explains the likely driver based on the trending topics and top posts it pulled.