Facebook Ad Library Scraper with n8n, Apify, OpenAI & Sheets

Scrape Facebook Ad Library ads, analyze creatives with OpenAI, and log results to Google Sheets (n8n + Apify)

Get a hands-on workflow that pulls recent Facebook Ad Library ads using Apify, filters for high-like advertisers, then uses OpenAI (Vision + text) to generate strategic analysis and rewritten ad copy—automatically appending everything to Google Sheets for your review.

What this workflow does

• Manual start: You run the workflow manually when you want to pull fresh ad data.
• Fetch ads via Apify: The workflow sends your keyword, country, status, and limit to an Apify Facebook Ad Library scraper actor to retrieve recent ads and their details.
• Filter by advertiser engagement: It removes ads from advertisers whose Facebook page likes fall below your configured minimum.
• Route by creative type: Depending on what creative fields are present, each ad is processed as video/image or text-only.
• Analyze + rewrite with OpenAI:
  • Video/image ads: Uses OpenAI Vision to describe the creative (video cover frame or image), then generates a structured strategic analysis and rewritten ad copy.
  • Text-only ads: Generates the same structured strategic analysis and rewritten ad copy from the scraped ad data.
• Append to Google Sheets: Each ad’s analysis and rewritten copy is added to a spreadsheet so you can track findings over time.

Use cases

• Competitive research for SaaS marketing teams using Facebook Ad Library signals.
• Creative inspiration pipelines: convert scraped ads into structured insights and rewrite drafts.
• Ongoing ad monitoring by keyword/country with results stored in Google Sheets.

Technical details

• Apify via HTTP Request using API token (HTTP Header Auth)
• OpenAI credentials for vision + chat models (vision + text processing mode)
• n8n nodes: set, filter, switch, sticky note, http request, google sheets

Ideal for n8n users and automation engineers who want an end-to-end workflow for Facebook ad scraping, OpenAI creative analysis, and Sheets-based tracking.