{"product_id":"track-meta-ads-prices-in-google-sheets-with-n8n","title":"Track Meta Ads \u0026 Prices in Google Sheets with n8n","description":"\u003ch3\u003eTrack Competitor Meta Ad Products (Names + Prices) Directly in Google Sheets with n8n\u003c\/h3\u003e\n\u003cp\u003eWant to monitor what competitors are promoting on Facebook and keep pricing up to date automatically? This n8n workflow runs on demand to discover competitor Facebook pages, collect their active Meta ads, scrape the advertised product details via Apify, and then \u003cstrong\u003eappend or update product rows in Google Sheets\u003c\/strong\u003e by product ID.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual trigger (on demand):\u003c\/strong\u003e Start a competitor research run whenever you need fresh data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFind competitor Facebook pages:\u003c\/strong\u003e Uses \u003cstrong\u003eApify’s Facebook Search Scraper\u003c\/strong\u003e to search configured `categories`, `locations`, and a `resultsLimit` for your market.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetch active ads:\u003c\/strong\u003e Aggregates discovered page URLs and runs \u003cstrong\u003eApify’s Facebook Ads Library Scraper\u003c\/strong\u003e to pull active ads for those pages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtract product links:\u003c\/strong\u003e Extracts and aggregates product URL links found in the ad cards.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrape product info \u0026amp; pricing:\u003c\/strong\u003e Uses \u003cstrong\u003eApify’s E-commerce Scraping Tool\u003c\/strong\u003e to scrape each product page for name, description, price, currency, and an ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdate Google Sheets:\u003c\/strong\u003e Appends or updates one row per product in Google Sheets using the scraped product \u003cstrong\u003eID as the unique key\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operators\u003c\/strong\u003e monitoring competitor campaigns for pricing changes and promoted products.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eeCommerce teams\u003c\/strong\u003e tracking which products rivals advertise on Meta and capturing current price points.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e setting up a repeatable n8n workflow for competitor research and reporting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e Manual Trigger, Aggregate, Sticky Note, Google Sheets, and Apify nodes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integrations:\u003c\/strong\u003e Facebook Search Scraper, Facebook Ads Library Scraper, and E-commerce Scraping Tool.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCredentials:\u003c\/strong\u003e Add an \u003cstrong\u003eApify API token\u003c\/strong\u003e credential and a \u003cstrong\u003eGoogle Sheets OAuth\u003c\/strong\u003e credential.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSheet mapping:\u003c\/strong\u003e Ensure your columns include Product name, ID, Description, Price, and Currency (the workflow maps “Product name ” and “Currency ” with trailing spaces).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45905412227251,"sku":"N8N-18757","price":64.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/B6-Q1PjAaDlYitORdpC3k_MdGzORJ2.png?v=1787821334","url":"https:\/\/buyflowscripts.com\/products\/track-meta-ads-prices-in-google-sheets-with-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}