{"product_id":"apify-amazon-electronics-deals-to-google-sheets-n8n","title":"Apify Amazon Electronics Deals to Google Sheets (n8n)","description":"\u003ch3\u003eApify Amazon Electronics deals → a live Google Sheets snapshot (with replay-safe history) for n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs FalconScrape’s \u003cstrong\u003e“Amazon Today’s Deals Scraper”\u003c\/strong\u003e via Apify, then writes a \u003cstrong\u003ebounded Amazon.com Electronics deals snapshot\u003c\/strong\u003e into Google Sheets—while maintaining a \u003cstrong\u003ecurrent view\u003c\/strong\u003e, a \u003cstrong\u003eper-run history log\u003c\/strong\u003e, and a \u003cstrong\u003erun ledger\u003c\/strong\u003e with recovery details.\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 and reads your inputs: target domain, maximum items, max Apify charge, destination Google Spreadsheet ID, and an optional Apify \u003cem\u003erun ID\u003c\/em\u003e to resume.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates configuration\u003c\/strong\u003e and prepares the destination spreadsheet by creating managed tabs plus a \u003cstrong\u003etemporary lock tab\u003c\/strong\u003e to prevent overlapping writes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads an Apify run for recovery\u003c\/strong\u003e (if a run ID is provided) or starts a new bounded run of FalconScrape’s Amazon Electronics deals scraper (\u003cstrong\u003eActor ID: ZcBW1sGJAcEXxBrej\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRecords checkpoint \u0026amp; polls for completion\u003c\/strong\u003e: saves the Apify run ID to the Google Sheets run log, then waits until the Actor run finishes successfully.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches and normalizes results\u003c\/strong\u003e from Apify, validates key fields (including \u003cstrong\u003eASINs\u003c\/strong\u003e and \u003cstrong\u003eproduct URLs\u003c\/strong\u003e), and classifies deals as baseline, new, refreshed, or replayed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites safely to Google Sheets\u003c\/strong\u003e: batch-writes the latest “current” deal rows, appends run observations to the history tab, updates the run ledger, and finally \u003cstrong\u003eremoves the lock tab\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eKeep an always-updated \u003cstrong\u003eAmazon Electronics deals\u003c\/strong\u003e sheet for sales enablement, procurement research, or internal monitoring.\u003c\/li\u003e\n  \u003cli\u003eRecover from failures by resuming from a specific Apify run ID and preserving an auditable run ledger.\u003c\/li\u003e\n  \u003cli\u003eBuild reporting on “new vs refreshed vs replayed” deal activity over time using the history tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Apify Actor (FalconScrape, \u003cstrong\u003eZcBW1sGJAcEXxBrej\u003c\/strong\u003e) and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e via OAuth2\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes used:\u003c\/strong\u003e manual trigger, if, set, code, sticky note, HTTP Request\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46132914421939,"sku":"N8N-20148","price":31.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/IwJLBPSpkMQs-Ce8NIFE-_vN2eOXKO.png?v=1790760098","url":"https:\/\/buyflowscripts.com\/products\/apify-amazon-electronics-deals-to-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}