AI Facebook ad spy tool with Apify, OpenAI, Gemini & Google Sheets

by Nick Saraev ✓ · 5,917 views · created 2025-06-27 · Market Research, Multimodal AI

What this workflow does

This AI workflow has 24 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Drive, OpenAI and Google Sheets. It also calls api.apify.com and generativelanguage.googleapis.com over HTTP.

How it runs

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

1. Run Ad Library Scraper (HTTP Request): calls api.apify.com (POST)
2. Filter: keeps only the items that match a condition
3. 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. Analyze Image (OpenAI): analyze (image)
9. Output Text Summary (OpenAI): uses OpenAI
10. Upload Video to Drive (Google Drive): uses Google Drive

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

Services it uses

Google DriveOpenAIGoogle Sheets

HTTP calls to: api.apify.com, generativelanguage.googleapis.com

Before you upgrade to n8n 3.0

Nodes used (9)

• Manual Triggern8n-nodes-base.manualTrigger
• Switchn8n-nodes-base.switch
• Filtern8n-nodes-base.filter
• Waitn8n-nodes-base.wait
• HTTP Requestn8n-nodes-base.httpRequest
• Google Driven8n-nodes-base.googleDrive
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• OpenAI@n8n/n8n-nodes-langchain.openAi
• Google Sheetsn8n-nodes-base.googleSheets

From the author

AI Facebook Ad Spy Tool with Apify, OpenAI, Gemini & Google Sheets Categories: Competitive Intelligence, Marketing Automation, AI Analysis This workflow creates a comprehensive Facebook ad spy tool that scrapes competitor ads from Facebook's ad library and…

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