Monitor competitor prices with Google Shopping and Google Sheets, alert via Slack and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 15 nodes and runs on a schedule (every 24 hours). Along the way it connects Google Sheets, Slack and Gmail. It also calls searchapi.io over HTTP.
How it runs
Trigger: On a schedule (every 24 hours).
- Get Products from Sheet (Google Sheets): uses Google Sheets
- Clear Memory and Normalize Columns (Code): runs custom JavaScript code
- Loop Through Each Product (Loop Over Items (Split in Batches)): loops over the items in batches
- Prepare Search Query (Code): runs custom JavaScript code
- Build Daily Summary Report (Code): runs custom JavaScript code
- Search Google Shopping Prices (HTTP Request): calls searchapi.io
- Post Daily Summary to Slack (Slack): uses Slack
- Email Daily Report (Gmail): uses Gmail
- Analyze Pricing Gap (Code): runs custom JavaScript code
- Save Result to Memory (Code): runs custom JavaScript code
…plus 4 more steps. See the full node list below.
Services it uses
HTTP calls to: searchapi.io
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 (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Filter
n8n-nodes-base.filter - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail
From the author
Who is this for? E-commerce store owners, product managers, marketplace sellers, and pricing analysts who want to automatically track competitor pricing and get actionable alerts when their products are overpriced or underpriced relative to the market. What…