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

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

Ready for 3.0

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

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

Nodes used (9)

Google DriveOpenAIGoogle Sheets

What it does

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 generates detailed analysis with rewritten versions. The system processes text, image, and video ads using different AI models, providing strategic intelligence for PPC agencies and marketers. Built to be sold as a premium service for $2,000+, this tool combines web scraping, multi-modal AI analysis, and competitor intelligence into one powerful automation. Benefits - Complete Competitive Intelligence - Analyze competitor strategies across all ad formats (text, image, video) - Multi-Modal AI Analysis - Uses GPT-4 Vision for images and Gemini for video content understanding - Automated Ad Rewriting - Generates inspired variations of successful competitor ads - Quality Filtering - Targets high-performing advertisers with significant page likes - Scalable Processing - Handle hundreds of competitor ads with detailed strategic analysis - Premium Service Potential - Easily sold to agencies and marketers for $2,000+ implementations How It Works Facebook Ad Library Scraping: - Connects to Facebook's public ad library through Apify's specialized scraper - Searches for active ads using customizable keywords and targeting parameters - Extracts comprehensive ad data including creative assets, targeting info, and engagement metrics - Filters results to focus on high-quality advertisers with substantial page followings Intelligent Content Routing: - Automatically categorizes ads into text-only, image-based, or video content types - Routes each ad type to specialized processing pipelines optimized for that content format - Ensures appropriate AI models are used for each type of creative analysis - Maintains data integrity while processing different content formats simultaneously Advanced Video Analysis Pipeline: - Downloads video ads directly from Facebook's content delivery network - Uploads videos to Google Drive for temporary storage and processing - Initiates Gemini AI video upload sessions for multi-modal analysis - Uses Gemini's advanced video understanding to generate detailed content descriptions - Processes video narrative, visual elements, messaging strategy, and target audience insights Image and Text Processing: - Analyzes image ads using GPT-4 Vision for comprehensive visual content understanding - Processes text-only ads using GPT-4 for messaging strategy and copywriting analysis - Identifies key persuasion techniques, target demographics, and messaging frameworks - Generates detailed competitive intelligence reports for each ad format Strategic Intelligence Generation: - Creates comprehensive summaries analyzing competitor messaging strategies and target audiences - Generates rewritten ad copy that captures successful elements while avoiding direct copying - Produces recreation prompts for images and videos that can be used with AI generation tools - Organizes all insights in structured Google Sheets database for easy analysis and reporting Required Setup Configuration Apify Integration: - Sign up for Apify account and obtain API key - Replace <your-apify-api-key-here> in "Run Ad Library Scraper" node - Customize Facebook Ad Library search URLs with your target keywords and regions AI Service Configuration: - OpenAI API: Set up for text analysis and image understanding with GPT-4 Vision - Gemini API: Configure for advanced video content analysis and description - Replace <your-gemini-api-key-here> in all Gemini-related nodes Google Services Setup: - Google Drive: Configure OAuth for temporary video storage during Gemini processing - Google Sheets: Create results database with proper column structure for ad intelligence storage Facebook Ad Library Search Configuration: Customize the search parameters in the Apify scraper Google Sheets Database Structure: Create a

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.