📊 Track weekly Google Shopping prices and log summaries to Google Sheets
⚡ 3 views · 📊 Market Research & Insights
Description
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 tracking.
How it works
- Runs every Monday morning on a schedule.
- Defines the list of product search queries plus the target country and language.
- Splits the product list so each product is searched individually.
- Uses Apify’s Google Shopping actor to fetch offers and prices for each product.
- Skips products where Google Shopping returns no offers.
- Aggregates the remaining offers into one weekly summary per product, trimming very low-price outliers and calculating metrics like lowest price, median, highest price, cheapest seller, and best discount.
- Appends the summary rows to a Google Sheets tab.
Setup
- Create an Apify account and add your Apify API token as an Apify credential in n8n.
- Connect Google Sheets credentials and select the target spreadsheet document and sheet tab in the Google Sheets append step.
- Replace the example product queries and adjust the country/language values to match your market and search needs.
🔗 Nodes Used
Google Sheets, Schedule Trigger, Filter
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File