Templates / Monitor and analyze competitor Facebook ads with Apify, GPT-4o, Gemini, and Google Sheets

Monitor and analyze competitor Facebook ads with Apify, GPT-4o, Gemini, and Google Sheets

Unknown

by Ahmed Salama ✓ · 277 views · created 2026-01-29 · Market Research, AI Summarization

Unknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 21 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, OpenAI, Dropbox and Google Gemini and 1 more.

How it runs

Trigger: Manually, when you click “Execute workflow”.

  1. Run an Actor and get dataset (Apify): run actor and get dataset
  2. Filter: keeps only the items that match a condition
  3. Detect Ad Creative Type (Switch): routes items into 2 branches
  4. Loop Over Video Ads (Loop Over Items (Split in Batches)): loops over the items in batches
  5. Loop Over Image Ads (Loop Over Items (Split in Batches)): loops over the items in batches
  6. Loop Over Text Ads (Loop Over Items (Split in Batches)): loops over the items in batches
  7. Download Video (HTTP Request): calls an HTTP API
  8. Scrape Facebook Ad Library (Apify) (HTTP Request): calls an HTTP API
  9. Output Text Summary (OpenAI): uses OpenAI
  10. Upload a file (Dropbox): uses Dropbox

…plus 10 more steps. See the full node list below.

Services it uses

Google SheetsOpenAIDropboxGoogle GeminiApify (community)

Before you upgrade to n8n 3.0

We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).

  • Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Run an Actor and get dataset).

Nodes used (11)

From the author

Categories Marketing Intelligence, Ad Operations, Competitive Research, Creative Analysis Build a Facebook Ad Intelligence Pipeline with Apify, AI, and Google Sheets This workflow creates an end-to-end Facebook Ad Intelligence pipeline that automatically…

Excerpt from Ahmed Salama's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.