Track competitor pricing and news changes in Google Sheets with Gemini, Gmail and Slack
Ready for 3.0What this workflow does
This AI workflow has 28 nodes and runs on a schedule (every week at 08:00). Along the way it connects Google Sheets, Google Gemini Chat Model, Gmail and Slack.
How it runs
Trigger: On a schedule (every week at 08:00).
- Settings (Edit Fields (Set)): sets 7 fields: google_sheet_url, your_company, your_offer…
- Read Previous Snapshots (Google Sheets): read
- Read Competitor List (Google Sheets): read
- Active Rows Only (Filter): keeps only the items that match a condition
- Has Page URL? (Filter): keeps only the items that match a condition
- Unique Competitors (Remove Duplicates): removes duplicate items
- Fetch Page (HTTP Request): calls an HTTP API
- Google News (Last 7 Days) (RSS Read): reads an RSS feed
- Extract Page Text (Code): runs custom JavaScript code
- Format News (Edit Fields (Set)): sets 4 fields: competitor, news_title, news_link…
…plus 13 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (15)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Remove Duplicates
n8n-nodes-base.removeDuplicates - RSS Read
n8n-nodes-base.rssFeedRead - Merge
n8n-nodes-base.merge - Gmail
n8n-nodes-base.gmail - Slack
n8n-nodes-base.slack
From the author
Quick overview Monitor competitor websites and news automatically every week. Built for founders, marketers and sales teams, this workflow detects pricing, product and messaging changes, uses Google Gemini to rate what matters to your business, logs every…