Block 1 - Error Trigger
- Type / Role
- n8n-nodes-base.errorTrigger - errorTrigger
- Config choices
- Version 1
Generate AI market research reports from NewsAPI and competitor sites to Notion, Sheets and Slack
Workflow preview
100%
$20/month : Unlimited workflows
2500 executions/month
THE #1 IN WEB SCRAPING
Scrape any website without limits
HOSTINGER 
Early Deal
DISCOUNT 20% Try free
Early DealDISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
1. Workflow Overview
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 w...
Best for
- Market Research automation workflows
- AI Summarization automation workflows
- advanced n8n builders looking for reusable templates
Tools used
n8n-nodes-base.errortrigger, n8n-nodes-base.stickynote, n8n-nodes-base.scheduletrigger, n8n-nodes-base.code, n8n-nodes-base.httprequest, n8n-nodes-base.merge, n8n-nodes-base.notion, n8n-nodes-base.googlesheets
Source and attribution
This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by sato rio.
Original n8n.io source1.1 Workflow description
- Title
- Generate AI market research reports from NewsAPI and competitor sites to Notion, Sheets and Slack
- Workflow name
- Generate AI market research reports from NewsAPI and competitor sites to Notion, Sheets and Slack
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
1.2 Logical Blocks
This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.
2. Block-by-Block Analysis
Block 2 - Main Overview1
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 3 - Section
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 4 - Section 6
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 5 - Section 7
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 6 - Section 8
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 7 - Section 9
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 8 - Schedule Trigger1
- Type / Role
- n8n-nodes-base.scheduleTrigger - scheduleTrigger
- Config choices
- Version 1.2
Block 9 - Research Configuration1
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 10 - Fetch News Data1
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.2
Block 11 - Scrape Competitor Site1
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.2
Block 12 - Merge Data1
- Type / Role
- n8n-nodes-base.merge - merge
- Config choices
- Version 3
Block 13 - Prepare AI Analysis Prompt1
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 14 - Execute OpenAI Analysis1
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.2
Block 15 - Structure Analysis Results1
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 16 - Save Report to Notion1
- Type / Role
- n8n-nodes-base.notion - notion
- Config choices
- Version 2.2
Block 17 - Log Data to Google Sheets1
- Type / Role
- n8n-nodes-base.googleSheets - googleSheets
- Config choices
- Version 4.5
Block 18 - Slack Completion Notification1
- Type / Role
- n8n-nodes-base.slack - slack
- Config choices
- Version 2.2
Block 19 - Slack Error Notification1
- Type / Role
- n8n-nodes-base.slack - slack
- Config choices
- Version 2.2
3. Summary Table
| Workflow | Generate AI market research reports from NewsAPI and competitor sites to Notion, Sheets and Slack |
|---|---|
| Complexity | advanced |
| Nodes | 19 |
| Categories | Market Research, AI Summarization |
| Author | sato rio |
| Published | 08 Jan 2026 |
4. Reproducing the Workflow from Scratch
-
1. Download the workflow JSON
Use the JSON export at /data/workflows/12581/12581.json as the source template for this automation.
-
2. Import the template into n8n
Open n8n, import the downloaded JSON, and review each node before activating the workflow.
-
3. Configure credentials and variables
Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.
-
4. Test with sample data
Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.
-
5. Activate and monitor
Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.
5. General Notes & Resources
Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.
Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.
Frequently asked questions
What does Generate AI market research reports from NewsAPI and competitor sites to Notion, Sheets and Slack do?
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 w...
What do I need before importing this workflow?
Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.
Can I customize this workflow?
Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Market Research, AI Summarization use case.