Track Meta Ads & Prices in Google Sheets with n8n

Track Competitor Meta Ad Products (Names + Prices) Directly in Google Sheets with n8n

Want 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 append or update product rows in Google Sheets by product ID.

What this workflow does

• Manual trigger (on demand): Start a competitor research run whenever you need fresh data.
• Find competitor Facebook pages: Uses Apify’s Facebook Search Scraper to search configured `categories`, `locations`, and a `resultsLimit` for your market.
• Fetch active ads: Aggregates discovered page URLs and runs Apify’s Facebook Ads Library Scraper to pull active ads for those pages.
• Extract product links: Extracts and aggregates product URL links found in the ad cards.
• Scrape product info & pricing: Uses Apify’s E-commerce Scraping Tool to scrape each product page for name, description, price, currency, and an ID.
• Update Google Sheets: Appends or updates one row per product in Google Sheets using the scraped product ID as the unique key.

Use cases

• SaaS operators monitoring competitor campaigns for pricing changes and promoted products.
• eCommerce teams tracking which products rivals advertise on Meta and capturing current price points.
• Automation engineers setting up a repeatable n8n workflow for competitor research and reporting.

Technical details

• n8n nodes: Manual Trigger, Aggregate, Sticky Note, Google Sheets, and Apify nodes.
• Apify integrations: Facebook Search Scraper, Facebook Ads Library Scraper, and E-commerce Scraping Tool.
• Credentials: Add an Apify API token credential and a Google Sheets OAuth credential.
• Sheet mapping: Ensure your columns include Product name, ID, Description, Price, and Currency (the workflow maps “Product name ” and “Currency ” with trailing spaces).