Monitor competitor prices from Google Shopping via SearchApi with Google Sheets and Slack
UnknownWhat this workflow does
This workflow has 12 nodes and runs on a schedule (every day at 08:00). Along the way it connects Google Sheets, Slack and Searchapi (community).
How it runs
Trigger: On a schedule (every day at 08:00).
- Settings (Edit Fields (Set)): sets 4 fields: products, location, alert_pct…
- Get Price History (Google Sheets): uses Google Sheets
- Split Products (Code): runs custom JavaScript code
- Search Google Shopping (Search Api): search (google shopping)
- Find Market Price (Code): runs custom JavaScript code
- Format Price Alert (Code): runs custom JavaScript code
- Only With Price (Filter): keeps only the items that match a condition
- Alert Gate (Filter): keeps only the items that match a condition
- Append to History (Google Sheets): append
- Update Latest (Google Sheets): append or update
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @searchapi/n8n-nodes-searchapi is verified or supports 3.0 (used in Search Google Shopping).
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Search Api
@searchapi/n8n-nodes-searchapi.searchApi - Filter
n8n-nodes-base.filter - Slack
n8n-nodes-base.slack
From the author
Quick Overview This workflow runs daily to check Google Shopping prices for a list of products using SearchApi.io, compares results to the last run stored in Google Sheets, and posts a threshold-based summary to Slack while logging each run to History and…