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.
Steps
- Trigger: Scheduled data collection
Cron node, daily or weekly. - Information gatheringWeb scraping service
Scraping service, RSS feeds and HTTP requests. - Data preparationWeb scraping service
Cleans and merges the collected data. - AI analysisOpenAI
GPT-4o returns structured JSON. - Output: Report generationGoogle Docs
Populates a Google Docs report. - Output: Team notificationSlack
Slack or email alert with key insights. - 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
Daily Shopify order summary in Slack
Also for scheduling and ops, 5 steps.
Gmail summaries in Notion with audio
Also for scheduling and ops, 10 steps.
Fireflies meeting recaps to Notion
Also for scheduling and ops, 7 steps.
OpenAI and Slack: 17 templates compared
Same two apps, different steps.
OpenAI and PostgreSQL: 2 templates compared
Same two apps, different steps.
Send a recurring summary
Other templates that do this task.