n8n Apify Allegro Price Tracker to Google Sheets

Track Apify Allegro prices automatically—and keep a reliable history in Google Sheets

This n8n workflow runs the Apify Allegro Listings Scraper for a single Allegro.pl listing URL, then writes the current price and a run-by-run price history into Google Sheets, including baseline and price-change calculations plus a run log with recovery support.

What this workflow does

• Starts manually with your configured Allegro.pl listing URL (seller/category/search), item limit, charge cap, and target Google Sheets spreadsheet ID (plus an optional Apify run ID for recovery).
• Prepares the spreadsheet by reading existing tabs and creating required ones if missing, including a temporary lock sheet to prevent concurrent imports.
• Loads and validates tables (“current”, “history”, and “runs”) to ensure headers and key columns match the template before updating.
• Runs (or resumes) Apify: either starts a new bounded Apify Actor run (using a maxTotalChargeUsd cap) or loads an existing Apify run ID for recovery, then saves that run ID to the Google Sheets run log as a checkpoint.
• Polls until completion, then fetches the dataset subject to a 1,000-row safety bound. Empty, all-invalid, or oversized results stop for inspection.
• Normalizes and deduplicates offers using Allegro offer ID (PLN only), calculates previous price plus absolute and percent change, and records an observation type.
• Writes batch updates to “current” and “history”, removes the lock sheet, and outputs a run summary including the spreadsheet URL.

Use cases

• Monitor price changes for a specific Allegro.pl listing without manual scraping.
• Maintain an audit trail of each run in the “runs” log with recovery support.
• Automate retailer/category/search tracking where price volatility matters.

Technical details

• n8n nodes used: Manual Trigger, if, set, code, Sticky Note, HTTP Request.
• Integrations: Apify (Allegro Listings Scraper Actor) and Google Sheets (tabs, batch updates, run log checkpointing).
• Reliability features: spreadsheet locking, header validation, bounded result handling, and optional Apify run recovery via run ID.