n8n Workflow: Track Mercado Libre Argentina Prices to Google Sheets

Track Mercado Libre Argentina (MLA) Prices to Google Sheets—Automatically

This 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.

What this workflow does

• Runs manually with your configured Mercado Libre Argentina search term, item limit, charge cap, and the target Google Sheets spreadsheet ID.
• Prepares your spreadsheet: reads the destination file, creates required tabs (Mercado Current, Mercado History, Mercado Runs), and adds a temporary lock sheet to prevent overlapping imports.
• Starts (or resumes) an Apify run using the FalconScrape Mercado Libre Listings Scraper, then records the Apify run ID in Mercado Runs.
• Polls Apify until the run succeeds and then fetches the completed dataset items.
• Filters and normalizes listings to valid MLA offers, keeping direct Mercado Libre URLs and ARS prices.
• Calculates changes by comparing each offer ID against the Mercado Current baseline to determine updates.
• Writes results back: updates Mercado Current, appends observations to Mercado History, updates Mercado Runs, removes the lock sheet, and outputs a run summary.

Use cases

• Monitor competitor pricing for products in Mercado Libre Argentina.
• Keep an audit trail of price changes for SaaS pricing research or procurement planning.
• Run scheduled price checks by simply triggering the workflow manually from n8n and storing results in Google Sheets.

Technical details

• Apify HTTP Request: starts a charge-capped actor run and polls until completion (optionally resumes via resumeRunId).
• Google Sheets OAuth2: creates/updates tabs and appends price history.
• n8n nodes: if, set, code, sticky note, HTTP Request, and manual trigger.