{"product_id":"n8n-apify-allegro-price-tracker-to-google-sheets","title":"n8n Apify Allegro Price Tracker to Google Sheets","description":"\u003ch3\u003eTrack Apify Allegro prices automatically—and keep a reliable history in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs the \u003cstrong\u003eApify Allegro Listings Scraper\u003c\/strong\u003e for a single Allegro.pl listing URL, then writes the \u003cstrong\u003ecurrent price\u003c\/strong\u003e and a \u003cstrong\u003erun-by-run price history\u003c\/strong\u003e into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, including baseline and price-change calculations plus a run log with recovery support.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts manually\u003c\/strong\u003e with your configured Allegro.pl listing URL (seller\/category\/search), item limit, charge cap, and target \u003cstrong\u003eGoogle Sheets spreadsheet ID\u003c\/strong\u003e (plus an optional \u003cem\u003eApify run ID\u003c\/em\u003e for recovery).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrepares the spreadsheet\u003c\/strong\u003e by reading existing tabs and creating required ones if missing, including a \u003cstrong\u003etemporary lock sheet\u003c\/strong\u003e to prevent concurrent imports.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads and validates tables\u003c\/strong\u003e (“current”, “history”, and “runs”) to ensure headers and key columns match the template before updating.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns (or resumes) Apify\u003c\/strong\u003e: either starts a new bounded Apify Actor run (using a \u003cstrong\u003emaxTotalChargeUsd\u003c\/strong\u003e cap) or loads an existing Apify run ID for recovery, then saves that run ID to the Google Sheets run log as a checkpoint.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls until completion\u003c\/strong\u003e, then fetches the dataset subject to a \u003cstrong\u003e1,000-row safety bound\u003c\/strong\u003e. Empty, all-invalid, or oversized results stop for inspection.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and deduplicates offers\u003c\/strong\u003e using Allegro offer ID (PLN only), calculates previous price plus \u003cstrong\u003eabsolute and percent change\u003c\/strong\u003e, and records an observation type.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites batch updates\u003c\/strong\u003e to “current” and “history”, removes the lock sheet, and outputs a run summary including the spreadsheet URL.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor price changes for a specific Allegro.pl listing without manual scraping.\u003c\/li\u003e\n  \u003cli\u003eMaintain an audit trail of each run in the “runs” log with recovery support.\u003c\/li\u003e\n  \u003cli\u003eAutomate retailer\/category\/search tracking where price volatility matters.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e Manual Trigger, \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, Sticky Note, \u003ccode\u003eHTTP Request\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Apify (Allegro Listings Scraper Actor) and Google Sheets (tabs, batch updates, run log checkpointing).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReliability features:\u003c\/strong\u003e spreadsheet locking, header validation, bounded result handling, and optional Apify run recovery via run ID.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46018991915187,"sku":"N8N-19551","price":26.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/mDfLSlWY6lwTUhtflyn_O_bKP8eQPG.png?v=1789376738","url":"https:\/\/buyflowscripts.com\/products\/n8n-apify-allegro-price-tracker-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}