Track weekly Google Shopping prices and log summaries to Google Sheets
UnknownWhat this workflow does
This workflow has 7 nodes and runs on a schedule (every week at 08:00). Along the way it connects Google Sheets and Apify (community).
How it runs
Trigger: On a schedule (every week at 08:00).
- Set the products to track (Edit Fields (Set)): sets 3 fields: products, country, language
- One search per product (Split Out): splits a list into separate items
- Search Google Shopping (Apify): run actor and get dataset (actors)
- Keep products that returned offers (Filter): keeps only the items that match a condition
- Summarize this week's prices (Code): runs custom JavaScript code
- Append prices to sheet (Google Sheets): append
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 @apify/n8n-nodes-apify 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 - Split Out
n8n-nodes-base.splitOut - Apify
@apify/n8n-nodes-apify.apify - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick Overview This workflow runs every Monday morning, searches Google Shopping for a list of products using Apify, summarizes credible weekly pricing metrics per product, and appends the results to a Google Sheets spreadsheet for ongoing price-history…