Competitor watch report with GPT-4o

Collects competitor pages and feeds, GPT-4o writes a report. This n8n template runs on a Cron node set daily or weekly, collects competitor information through a web scraping service, RSS feeds and HTTP requests, and cleans the data. OpenAI GPT-4o analyses it and returns structured JSON. The insights are stored in a PostgreSQL or MySQL database, written into a Google Docs report, and the team is alerted in Slack or by email. HubSpot, Salesforce or a custom CRM can be added through their API. It is written for small and medium-sized IT companies and SaaS companies.

n8nRead on 2026-11-167 steps

Steps

  1. Trigger: Scheduled data collection
    Cron node, daily or weekly.
  2. Information gatheringWeb scraping service
    Scraping service, RSS feeds and HTTP requests.
  3. Data preparationWeb scraping service
    Cleans and merges the collected data.
  4. AI analysisOpenAI
    GPT-4o returns structured JSON.
  5. Output: Report generationGoogle Docs
    Populates a Google Docs report.
  6. Output: Team notificationSlack
    Slack or email alert with key insights.
  7. Output: Data storagePostgreSQL
    Insights stored in a central database.

Limits

  • Needs its own PostgreSQL or MySQL database.
  • Needs an account with a web scraping service such as Apify or Crawlbase.

What it does well

  • Insights are kept in a database as well as in the report.

Before you import

Credentials listed: OpenAI, a web scraping service such as Apify or Crawlbase, PostgreSQL or MySQL, Google Docs and Slack. The database write uses an INSERT ... ON CONFLICT DO UPDATE query.

Similar templates