Apify Amazon Electronics Deals to Google Sheets (n8n)

Apify Amazon Electronics deals → a live Google Sheets snapshot (with replay-safe history) for n8n

This n8n workflow runs FalconScrape’s “Amazon Today’s Deals Scraper” via Apify, then writes a bounded Amazon.com Electronics deals snapshot into Google Sheets—while maintaining a current view, a per-run history log, and a run ledger with recovery details.

What this workflow does

• Starts manually and reads your inputs: target domain, maximum items, max Apify charge, destination Google Spreadsheet ID, and an optional Apify run ID to resume.
• Validates configuration and prepares the destination spreadsheet by creating managed tabs plus a temporary lock tab to prevent overlapping writes.
• Loads an Apify run for recovery (if a run ID is provided) or starts a new bounded run of FalconScrape’s Amazon Electronics deals scraper (Actor ID: ZcBW1sGJAcEXxBrej).
• Records checkpoint & polls for completion: saves the Apify run ID to the Google Sheets run log, then waits until the Actor run finishes successfully.
• Fetches and normalizes results from Apify, validates key fields (including ASINs and product URLs), and classifies deals as baseline, new, refreshed, or replayed.
• Writes safely to Google Sheets: batch-writes the latest “current” deal rows, appends run observations to the history tab, updates the run ledger, and finally removes the lock tab.

Use cases

• Keep an always-updated Amazon Electronics deals sheet for sales enablement, procurement research, or internal monitoring.
• Recover from failures by resuming from a specific Apify run ID and preserving an auditable run ledger.
• Build reporting on “new vs refreshed vs replayed” deal activity over time using the history tab.

Technical details

• Integrations: Apify Actor (FalconScrape, ZcBW1sGJAcEXxBrej) and Google Sheets via OAuth2
• Workflow nodes used: manual trigger, if, set, code, sticky note, HTTP Request