Generate AI market research reports from NewsAPI and competitor sites to Notion, Sheets and Slack

Description

Generate market research reports from news and competitor sites to Notion and Slack

This workflow automates market research and competitive intelligence by collecting industry news and competitor website updates, analyzing them with AI, and publishing structured insights to Notion and Slack.
It replaces manual monitoring and summarization with a repeatable, scalable workflow suitable for daily or weekly use.

Who’s it for

Marketing teams** who want to track industry trends and competitor messaging in one place
Product managers** looking for early signals to inform roadmap and prioritization decisions
Founders and analysts** who need automated market briefings without manual research

How it works

A scheduled trigger starts the workflow (daily by default).
Industry news is fetched via NewsAPI while competitor websites are scraped in parallel.
All collected content is consolidated and sent to OpenAI (GPT-4o) for analysis.
The AI generates a structured report including trends, SWOT insights, and recommended actions.
The full Markdown report is saved to a Notion database, and an executive summary is posted to Slack.
If any API call or scraping step fails, an error notification is sent to Slack.

How to set up

Add API credentials for OpenAI, NewsAPI, Notion, and Slack.
Configure keywords and competitor URLs in the Research Configuration node.
Select your Notion database and Slack channels in the relevant nodes.

Requirements

OpenAI API key (GPT-4o access)
NewsAPI account
Notion and Slack accounts

How to customize the workflow

Change the trigger to run weekly or on demand
Modify the AI prompt to focus on pricing, features, or specific competitors
Add additional sources such as RSS feeds or more competitor sites