{"product_id":"n8n-workflow-track-mercado-libre-argentina-prices-to-google-sheets","title":"n8n Workflow: Track Mercado Libre Argentina Prices to Google Sheets","description":"\u003ch3\u003eTrack Mercado Libre Argentina (MLA) Prices to Google Sheets—Automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scrapes current Mercado Libre Argentina search results via an Apify actor, extracts each listing’s ARS price, and logs it into Google Sheets—keeping a live snapshot, a per-run price history, and a run ledger for reliable recovery.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually\u003c\/strong\u003e with your configured Mercado Libre Argentina search term, item limit, charge cap, and the \u003cstrong\u003etarget Google Sheets spreadsheet ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrepares your spreadsheet\u003c\/strong\u003e: reads the destination file, creates required tabs (\u003cem\u003eMercado Current\u003c\/em\u003e, \u003cem\u003eMercado History\u003c\/em\u003e, \u003cem\u003eMercado Runs\u003c\/em\u003e), and adds a temporary \u003cstrong\u003elock sheet\u003c\/strong\u003e to prevent overlapping imports.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts (or resumes) an Apify run\u003c\/strong\u003e using the \u003cstrong\u003eFalconScrape Mercado Libre Listings Scraper\u003c\/strong\u003e, then records the Apify run ID in \u003cem\u003eMercado Runs\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls Apify\u003c\/strong\u003e until the run succeeds and then fetches the completed dataset items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters and normalizes listings\u003c\/strong\u003e to valid MLA offers, keeping direct Mercado Libre URLs and \u003cstrong\u003eARS prices\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates changes\u003c\/strong\u003e by comparing each offer ID against the \u003cem\u003eMercado Current\u003c\/em\u003e baseline to determine updates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results back\u003c\/strong\u003e: updates \u003cem\u003eMercado Current\u003c\/em\u003e, appends observations to \u003cem\u003eMercado History\u003c\/em\u003e, updates \u003cem\u003eMercado Runs\u003c\/em\u003e, removes the lock sheet, and outputs a run summary.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor competitor pricing for products in \u003cstrong\u003eMercado Libre Argentina\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eKeep an audit trail of price changes for SaaS pricing research or procurement planning.\u003c\/li\u003e\n  \u003cli\u003eRun scheduled price checks by simply triggering the workflow manually from n8n and storing results in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify HTTP Request\u003c\/strong\u003e: starts a charge-capped actor run and polls until completion (optionally resumes via \u003cem\u003eresumeRunId\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e: creates\/updates tabs and appends price history.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, \u003cem\u003eHTTP Request\u003c\/em\u003e, and \u003cem\u003emanual trigger\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46154086056115,"sku":"N8N-20050","price":60.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/OG3Ib8YfaSw_hxd63-mF3_O9QiUQiu.png?v=1790933545","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-track-mercado-libre-argentina-prices-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}