Weekly Industry Trends Report: NewsWhip to Notion and Gmail

Build me an agent workflow that publishes a weekly industry trends report every Monday at 7am (America/New_York). Trigger: cron, weekly Monday 07:00 ET.

Step 1 — Pull the data from NewsWhip for the prior 7 days. Use Search Articles (Historical) with Lucene-style filters scoped to our industry topics and language=en, sorted by fb_total_interactions and again by nw_score to get two ranked views of the top stories. Also call Get Articles by Region and Category for our primary region and category over a 168-hour window. From the combined result set, identify: (a) the dominant themes of the week, (b) rising-momentum stories that have a high predicted_interactions value but are still early in their lifecycle, (c) the top authors and publishers by volume and by engagement, and (d) any notable shifts in publisher mix vs. a typical week.

Step 2 — Synthesize a narrative trends report. Use this consistent structure every week so reports are comparable over time:

1) Executive summary (3-5 sentences). 2) Dominant themes this week (3-5 themes, each with a short paragraph and 2-3 representative article links). 3) Rising momentum (stories flagged by high predicted engagement but still early; explain why each one matters). 4) Publisher and author mix (who is owning the conversation, what shifted vs. last week, top 5 publishers and top 5 authors). 5) Three to five suggested angles our team could write or pitch, each with a one-line rationale tying it back to the data.

Step 3 — Save the report to Notion. Use Create a Page in the Trend Research database. Set structured properties: Week of (date, the Monday of the report week), Category (select, our industry topic), Top story (text, headline of the #1 article by engagement), and Publishers tracked (number). The page body should contain the full report from Step 2, formatted with proper Notion headings, bullet lists, and links.

Step 4 — Email the recap. Use Gmail Send a Message to the marketing distribution list (configurable, e.g. marketing@company.com). Subject: "Industry trends: week of {{Monday date}}". Body: the executive summary, the three to five suggested angles, and a link to the new Notion page for the full report. Keep the email body short and skimmable; the Notion page is the source of truth.

Inputs the agent should expose as configurable: industry topics / Lucene query, region, category, language, NewsWhip lookback hours (default 168), Notion database id, Notion property field names, Gmail sender, Gmail recipients, and report timezone. Bake in error handling so an empty NewsWhip response still produces a short "quiet week" report rather than a failed run.

Additional information

What does this prompt do?

Pulls the past seven days of articles in your industry from NewsWhip and surfaces the most engaging stories.
Writes a structured trends report into a Notion database with a consistent format so weeks become comparable over time.
Calls out rising-momentum stories early using predicted engagement, plus shifts in publisher and author mix.
Emails the executive summary and a link to the full Notion page to your marketing distribution list.

What do I need to use this?

A NewsWhip account with access to historical article search.
A Notion workspace with a Trend Research database (or willingness to create one).
A Gmail account to send the weekly recap from.
A short list of industry topics, regions, or categories you want covered.

How can I customize it?

Change the schedule (for example Friday afternoons instead of Monday mornings) or shift the lookback window.
Swap in your own categories, regions, keywords, or publisher whitelist to focus on a specific niche.
Edit the report sections (themes, rising stories, publisher mix, suggested angles) or adjust the Notion property fields you want filled in.
Change the email recipients, subject line, and how much of the report goes in the body versus the Notion link.

Frequently asked questions

How is this different from a Google Alert?

Google Alerts surface individual links. This workflow synthesizes a full week of coverage into a narrative report with themes, rising stories, publisher mix, and suggested pitch angles, then files it in Notion so you can compare week over week.

Can it catch trends before they peak?

Yes. NewsWhip provides a predicted engagement score, so the agent can highlight stories that are still early but trending toward high reach. The report calls these out as rising-momentum items separate from the dominant themes of the week.

Do I need an existing Notion database for this to work?

An existing Trend Research database is ideal so each report has consistent properties like week-of, category, and top story. If you do not have one yet, you can create it in Notion first, or ask the agent to set up a starter database.

Can I send the recap somewhere other than Gmail?

The default uses Gmail to email a marketing distribution list, but you can point the recap at a Slack channel, a different mailing list, or skip email entirely and only file the Notion page.

How do I change which topics or regions get covered?

Edit the topics, categories, and regions in the prompt. The agent uses those values when querying NewsWhip, so updating them is the simplest way to retarget the report.