Weekly competitor share-of-voice report in Notion

Build me an agent workflow that produces a weekly competitor share-of-voice report and saves it as a new page inside a Notion database.

Trigger: cron, every Monday at 8:00am in my local timezone.

Inputs I should be able to configure when I install the workflow:

1) My own brand: either a Talkwalker project ID + topic ID for my brand, or a free-text query if I don't have a project configured. 2) A list of competitors, each with a display name and a Talkwalker query string (3 to 8 competitors is typical). 3) The Notion parent: a database ID for a 'Competitive Intel' (or similarly named) database where the new page should be created. 4) Optional: a list of stakeholder names to address in the recommended actions section.

What the agent should do on each run:

Step 1 — Pull data for my brand. If a project + topic is configured, call Talkwalker's Get Histogram (Project) operation for the last 7 days, requesting volume, sentiment distribution, theme breakdown, and demographic split. If no project is configured, fall back to Talkwalker's Get Histogram (Global) operation with my brand query for the same window and metrics.

Step 2 — Pull data for each competitor. For each competitor in the list, call Talkwalker's Get Histogram (Global) operation for the same 7-day window with the same volume / sentiment / themes / demographics breakdown so the numbers are directly comparable. Histogram calls cost 10 credits each, so respect the configured competitor list and don't fan out beyond it.

Step 3 — Pull top influencers. For my brand and for each competitor, call Talkwalker's Get Top Influencers operation over the same 7-day window to identify the authors and sources driving each conversation. Capture name, reach/engagement, and a representative post or link if available.

Step 4 — Compare to the previous 7 days. Re-run histograms for the prior week (day 8 through day 14) for each brand so you can compute week-over-week deltas in volume, sentiment mix, and theme weight. Cache or pass these alongside the current-week numbers.

Step 5 — Synthesize. Don't just dump numbers. Write a real competitive analysis with: (a) a share-of-voice ranking of all brands by volume and by reach with WoW deltas; (b) sentiment leaders and losers, calling out who shifted positive/negative and why the themes suggest it happened; (c) the narrative themes each competitor is winning, with one or two example phrases per theme; (d) notable influencer moments per brand (which voice drove the spike, and what they said); (e) a 'so what for us' recommended actions section with 3 to 5 concrete moves my team should consider this week.

Step 6 — Write the report to Notion. Call Notion's Create a Page operation with the configured database as parent. Title format: 'Competitive SOV — Week of {Monday date}'. Page body sections, in order: Executive Summary; Share-of-Voice Rankings (volume + reach + WoW deltas); Sentiment Leaders & Losers; Narrative Themes by Competitor; Top Influencers & Notable Moments; Recommended Actions for Our Team; Methodology & Sources (lists the Talkwalker queries used and the date range, so the report is auditable).

Tone: written for a marketing leader skimming on Monday morning. Tight, opinionated, decision-oriented. Use bullets and short paragraphs, not walls of text. The agent's value is synthesis and framing, not charts.

Error handling: if a single competitor query fails (rate limited, bad query, no data), continue with the others and note the gap in the Methodology section instead of aborting the whole run. If the Notion create call fails, retry once, then surface the full report text so I can paste it manually.