{"product_id":"n8n-workflow-track-coupang-option-prices-in-google-sheets","title":"n8n Workflow: Track Coupang Option Prices in Google Sheets","description":"\u003ch3\u003eTrack Coupang Option Price Changes Automatically in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow manually scrapes Coupang listing option prices via an Apify Actor and records the latest prices, full price history, and run checkpoints in Google Sheets—so you can monitor option price movements over time without manual checking.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eBuilt for controlled, charge-capped scraping runs, the workflow:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003eRuns when you execute it manually, reading inputs such as the \u003cstrong\u003esearch keyword\u003c\/strong\u003e, \u003cstrong\u003emax items\u003c\/strong\u003e, \u003cstrong\u003emax Apify charge\u003c\/strong\u003e, and the target \u003cstrong\u003eGoogle Sheets spreadsheet ID\u003c\/strong\u003e (with an optional \u003cstrong\u003eApify resume run ID\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003eValidates configuration and confirms access to the specified Google Sheets spreadsheet.\u003c\/li\u003e\n  \u003cli\u003eCreates (if missing) three tabs: \u003cstrong\u003e“Coupang Current”\u003c\/strong\u003e, \u003cstrong\u003e“Coupang History”\u003c\/strong\u003e, and \u003cstrong\u003e“Coupang Runs”\u003c\/strong\u003e, plus a temporary lock sheet to prevent overlapping writes.\u003c\/li\u003e\n  \u003cli\u003eResumes the specified Apify run or starts a new charge-capped run of \u003cstrong\u003eApify “FalconScrape Coupang Listings Scraper”\u003c\/strong\u003e, then logs the run ID to \u003cstrong\u003e“Coupang Runs”\u003c\/strong\u003e as a checkpoint.\u003c\/li\u003e\n  \u003cli\u003ePolls Apify until the run succeeds, downloads the completed scraped dataset, and normalizes\/deduplicates offers by product-and-option ID.\u003c\/li\u003e\n  \u003cli\u003eCalculates \u003cstrong\u003eprice deltas\u003c\/strong\u003e versus the previous observation for the same option, updates \u003cstrong\u003e“Coupang Current”\u003c\/strong\u003e, and appends observations to \u003cstrong\u003e“Coupang History”\u003c\/strong\u003e, writing the final status back to \u003cstrong\u003e“Coupang Runs”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eRemoves the lock sheet and outputs a run summary (added\/updated\/rejected rows and price changes), including a link to the spreadsheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor Coupang option pricing for specific search terms and detect meaningful increases\/decreases.\u003c\/li\u003e\n  \u003cli\u003eMaintain an auditable price history for competitive analysis or operational tracking.\u003c\/li\u003e\n  \u003cli\u003eRun scheduled or on-demand “spot checks” using Apify resume support to handle interruptions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, \u003cstrong\u003eManual Trigger\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eApify HTTP Request\u003c\/strong\u003e (start\/resume, poll, download dataset) and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (create tabs, write current\/history\/checkpoints)\u003c\/li\u003e\n  \u003cli\u003eRequires an \u003cstrong\u003eApify API credential\u003c\/strong\u003e configured in n8n for the Apify HTTP Request steps\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46154088153267,"sku":"N8N-20049","price":13.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/n6rtzBY0FmbDJGl5kA7Ls_S9wMrhud.png?v=1790933568","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-track-coupang-option-prices-in-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}