Generate AI market research reports from NewsAPI and competitor sites to Notion, Sheets and Slack
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 13 nodes and runs on a schedule (every day at 09:00) (plus 1 other trigger). Along the way it connects Notion, Google Sheets and Slack. It also calls newsapi.org and api.openai.com over HTTP.
How it runs
Trigger: On a schedule (every day at 09:00) (plus 1 other trigger).
- Research Configuration (Code): runs custom JavaScript code
- Slack: uses Slack
- Fetch News Data (HTTP Request): calls newsapi.org
- Scrape Competitor Site (HTTP Request): calls an HTTP API
- Merge: merges the data from its input branches
- Prepare AI Analysis Prompt (Code): runs custom JavaScript code
- Execute OpenAI Analysis (HTTP Request): calls api.openai.com (POST)
- Structure Analysis Results (Code): runs custom JavaScript code
- Save Report to Notion (Notion): uses Notion
- Log Data to Google Sheets (Google Sheets): append
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: newsapi.org, api.openai.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Error Trigger
n8n-nodes-base.errorTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Notion
n8n-nodes-base.notion - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack
From the author
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…