{"product_id":"n8n-google-shopping-price-tracker-to-google-sheets-weekly","title":"n8n Google Shopping Price Tracker to Google Sheets Weekly","description":"\u003ch3\u003eTrack Google Shopping prices automatically—every week\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow searches Google Shopping for your selected products every Monday morning, summarizes credible weekly pricing metrics, and appends the results to Google Sheets—so you can build a reliable price history without manual checking.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e the workflow is set to execute every Monday morning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfigures product search queries:\u003c\/strong\u003e it defines a list of product queries, along with the \u003cem\u003etarget country\u003c\/em\u003e and \u003cem\u003elanguage\u003c\/em\u003e for Google Shopping.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches products individually:\u003c\/strong\u003e it splits the product list so each item is searched as its own query.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches offers and prices via Apify:\u003c\/strong\u003e it uses \u003cstrong\u003eApify’s Google Shopping actor\u003c\/strong\u003e to retrieve offers and pricing data for each product.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips empty results:\u003c\/strong\u003e if Google Shopping returns no offers for a product, that product is skipped.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a weekly summary per product:\u003c\/strong\u003e it aggregates remaining offers into one row per product, trimming very low-price outliers and calculating metrics such as \u003cstrong\u003elowest price\u003c\/strong\u003e, \u003cstrong\u003emedian price\u003c\/strong\u003e, \u003cstrong\u003ehighest price\u003c\/strong\u003e, \u003cstrong\u003echeapest seller\u003c\/strong\u003e, and \u003cstrong\u003ebest discount\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends to Google Sheets:\u003c\/strong\u003e each weekly summary row is written to a chosen spreadsheet document and sheet tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operators\u003c\/strong\u003e monitoring competitor pricing trends across consistent Google Shopping searches.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e building a repeatable price-tracking pipeline with n8n + Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRetail analysts\u003c\/strong\u003e maintaining weekly price history for reporting, benchmarking, or decision support.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduler:\u003c\/strong\u003e runs every Monday morning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/logic used:\u003c\/strong\u003e \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003efilter\u003c\/em\u003e, \u003cem\u003esplit out\u003c\/em\u003e, and \u003cem\u003eGoogle Sheets\u003c\/em\u003e append step (with supporting steps like a \u003cem\u003esticky note\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e requires an \u003cstrong\u003eApify API token\u003c\/strong\u003e added as an n8n credential to run the Google Shopping actor.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup summary:\u003c\/strong\u003e add your Apify credential in n8n, connect Google Sheets, select your spreadsheet and tab, and replace the example product queries plus country\/language values for your market.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45758757798067,"sku":"N8N-17777","price":52.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/5BI9tyWLI-rcWDe1XciRC_9vrCflB0.png?v=1785834751","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-shopping-price-tracker-to-google-sheets-weekly","provider":"N8N Commerce","version":"1.0","type":"link"}