Track competitor pricing changes with Google Sheets, OpenAI, and Gmail
Needs changesNeeds changes. This template uses 2 thing(s) that n8n 3.0 removes: HTML Extract, OpenAI (legacy). 2 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 11 nodes and runs on a schedule (cron 0 9 * * *). Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: On a schedule (cron 0 9 * * *).
- Config (Edit Fields (Set)): sets 4 fields: GOOGLE_SHEETS_ID, MONITORED_SITES_SHEET_NAME, SNAPSHOTS_SHEET_NAME…
- Read Monitored Sites (Google Sheets): uses Google Sheets
- Fetch Website HTML (HTTP Request): calls an HTTP API
- Extract Page Text (HTML Extract): uses HTML Extract
- Read Previous Data (Google Sheets): uses Google Sheets
- Summarize Changes with AI (OpenAI): work with chat
- Format Results (Edit Fields (Set)): sets 3 fields: htmlRow, siteId, pageText
- Save Current Data (Google Sheets): append or update
- Aggregate: combines items into one
- Send Email Report (Gmail): uses Gmail
Services it uses
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- HTML Extract in Extract Page Text: replace with HTML node, 'Extract HTML Content' operation.
- OpenAI (legacy) in Summarize Changes with AI: replace with OpenAI node (AI section).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| HTML Extract Extract Page Text | HTML node, 'Extract HTML Content' operation |
| OpenAI (legacy) Summarize Changes with AI | OpenAI node (AI section) |
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - HTML Extract
n8n-nodes-base.htmlExtract - OpenAI
n8n-nodes-base.openAi - Aggregate
n8n-nodes-base.aggregate - Gmail
n8n-nodes-base.gmail
From the author
Quick Overview This workflow runs daily, checks competitor webpages listed in Google Sheets, compares the latest page text to the previous snapshot using OpenAI, stores the updated snapshot in Google Sheets, and emails a consolidated HTML change report via…