Automate Competitive Analysis with Notion & OpenAI in n8n

What This Automation Does

This workflow find latest news, products, and reviews for a company online. It collects customer opinions, sorts good and bad points, and adds all this data to a Notion database. It cleans duplicate info and skips bad links to keep data accurate. This saves lots of time and lowers mistakes.

The workflow uses OpenAI GPT-4o to read and summarize reviews and products into clear lists. SERP API searches web and finds relevant URLs. Then, web scraping nodes scan these sites for customer feedback and news. The info is cleaned and organized before placing it into Notion for easy access.

Tools / Services Used

• Notion API: Stores organized company data in a database.
• OpenAI GPT-4o API: Summarizes and extracts sentiments from text data.
• SERP API: Finds latest web results, news, and product links.
• Web Scraper nodes: Extract customer reviews and content from URLs.

Inputs → Process → Output

Inputs

• Company name or target query.
• API Keys for Notion, OpenAI GPT-4o, and SERP API.
• Configured Notion database with properties for reviews and sentiments.

Process

• SERP API searches for current news, reviews, and product info URLs.
• Loop runs through URLs to scrape review content robustly.
• OpenAI GPT-4o parses review text, detects pros, cons, sentiment levels.
• Duplicates filtered out before preparing data.
• Data formatted and sent to Notion database.

Output

• Clean, structured competitive intelligence in Notion pages.
• Summarized pros and cons with sentiment percentages.
• Up-to-date product and social media info for target company.

Beginner Step-by-Step: How to Use This Workflow in n8n

1. Import Workflow

1. Download the workflow file using the Download button on this page.
2. Inside the n8n editor, choose “Import from File” and upload the workflow file.

2. Configure Credentials and IDs

1. Add API Keys for Notion API, OpenAI, and SERP API in n8n Credentials settings.
2. Update your Notion database ID in the Notion API node properties.
3. If needed, update search queries, email addresses, or web links used in the nodes.

3. Test the Workflow

1. Run the workflow with a sample company name to check if data returns and maps correctly.
2. Look for successful Notion page creation and meaningful summaries from OpenAI.

4. Activate for Production

1. Toggle the workflow’s status to Active at the top of the editor.
2. Optionally, set a schedule trigger to run automatically on your needed frequency.

You can find a useful resource for self-host n8n if hosting on your own server is preferred.

Step-by-Step Guide

Step 1: Set Up Your Notion Database and Credentials

Create a Notion database with text and multi-select fields for pros, cons, and social info.

In n8n, add the Notion API credential using the integration token.

Share the database with the Notion integration user to avoid permission errors.

Step 2: Configure OpenAI GPT-4o Node for Insights Summarization

Use the OpenAI GPT node with the GPT-4o model.

Include a prompt that tells GPT to output pros, cons, sentiment percentages, and key product details as JSON.

Step 3: Set Up SERP API Node for Web Search

Configure SERP API with API key.

Set JSON body to fetch URLs and snippets for reviews and news.

Step 4: Loop Over Search Result URLs

Use Loop node to process each URL.

Invoke web scraping nodes to pull review content safely.

Step 5: Extract and Format Customer Reviews

Parse HTML content for review numbers, pros, cons, and sentiment data.

Structure data to match Notion’s database format.

Step 6: Remove Duplicate Entries

Filter out repeated entries using a node that checks by URL or title.

Step 7: Insert Data Into Notion Using Notion API Node

Map JSON fields to correct Notion properties (text, multi-select, URLs).

Run test to verify new pages are created properly.

Step 8: Add Sticky Note for User Reminders

Use Sticky Note to remind users to set the Notion database before each run.

Customizations ✏️

• Change the Notion database ID in the Notion API node to target different databases.
• Modify SERP API search parameters to filter by dates or regions.
• Change OpenAI prompt to add brand sentiment scores, competitor comparisons, or SWOT analysis.
• Add nodes for LinkedIn or Crunchbase APIs to expand company data sources.

Troubleshooting ????

Problem: “403 Forbidden error when accessing Notion database.”
Cause: Notion integration user lacks database access.
Solution: Share the database with the integration user and check API Key.

Problem: “Duplicate entries appearing in Notion.”
Cause: Missing or incorrect duplicate filtering node.
Solution: Ensure duplicate node filters before Notion insertion node using URL or title as keys.

Pre-Production Checklist ✅

• Verify all API Keys for OpenAI, SERP API, and Notion are set and valid.
• Test workflow with various companies for correct parsing and updating.
• Backup Notion databases before bulk updates.
• Confirm Sticky Note node messages are clear to all users.

Deployment Guide

Activate the workflow by turning it on in n8n.

Set schedule triggers as needed for daily or weekly automation.

Check workflow runs and errors regularly in the n8n execution dashboard.

Adjust node settings based on live data feedback.

Summary of Benefits and Results

→ Saves over 6 hours weekly collecting competitive insights.
→ Automates review scanning, summarization, and Notion database updates.
→ Reduces mistakes from manual data handling.
→ Provides clear pros, cons, sentiment stats, and product info.
→ Keeps data clean by removing duplicates and invalid URLs.
→ Easily customizable for different companies or research needs.