Ai Facebook Ad Spy Tool With Apify, Openai, Gemini & Google Sheets 5417 – n8n Workflows – Free Template

What This Workflow Does

The AI Facebook Ad Spy Tool is an automated workflow that scrapes competitor advertisements from Facebook’s public ad library and analyzes them using artificial intelligence. It identifies high-performing ads, extracts key insights, and organizes the data for strategic marketing analysis and competitive intelligence gathering.

How It Works

This workflow operates through a multi-step process that combines web scraping, data filtering, and AI analysis:

• A manual trigger initiates the workflow when you’re ready to analyze ads
• The httpRequest node connects to Apify to scrape Facebook’s ad library based on your specified search terms
• A filter node removes low-quality advertisers by excluding pages with fewer than 1000 likes
• A switch node routes different ad types to appropriate processing paths
• The wait node adds delays to prevent rate limiting and ensure smooth operation
• OpenAI analyzes ad content to extract winning angles, headlines, and targeting strategies
• Results are organized and saved to Google Sheets for easy review and tracking
• Backup copies are stored in Google Drive for archival purposes

Use Cases

• E-commerce Marketing: Analyze competitor product ads to identify trending offers, promotional angles, and effective product photography styles used by successful sellers
• SaaS Lead Generation: Study how software companies advertise their solutions to understand messaging frameworks, value propositions, and audience targeting strategies
• Local Service Businesses: Monitor local competitor ads to spot seasonal promotions, service bundles, and geographic targeting approaches that drive conversions
• Content Creator Growth: Research how similar creators promote their content and courses to identify popular hooks, call-to-action formats, and audience engagement tactics
• Brand Reputation Management: Track how competitors position their brands and discover market opportunities by analyzing their advertising narratives and customer pain point messaging

Nodes Used

• stickyNote: Provides workflow documentation and setup instructions
• manualTrigger: Starts the workflow when you manually execute it
• switch: Routes ads to different processing paths based on content type or other criteria
• filter: Removes low-engagement advertisers by filtering out pages with fewer than 1000 likes
• wait: Adds delays between requests to prevent rate limiting and API blocking
• httpRequest: Connects to Apify or similar services to scrape Facebook ad library data
• googleDrive: Stores backup copies of collected ad data and analysis results
• splitInBatches: Divides large datasets into manageable chunks for efficient processing
• @n8n/openAi: Analyzes ad copy, headlines, and strategies using GPT models
• googleSheets: Organizes and displays results in a spreadsheet for easy analysis and sharing

Prerequisites

• An n8n instance (self-hosted or cloud) with access to HTTP requests
• An Apify account with API credits for Facebook ad library scraping
• OpenAI API key for GPT-powered ad analysis and insights
• Google account with access to Google Sheets and Google Drive
• Basic knowledge of Facebook’s ad library and advertising terminology
• Clear understanding of which competitors or industries you want to analyze

Difficulty Level

Intermediate to Advanced: This workflow requires knowledge of external API integrations (Apify and OpenAI), basic data filtering logic, and familiarity with Google Workspace automation. While the individual nodes are straightforward, setting up proper API authentication and configuring search parameters requires technical competency. Beginners can use it with provided templates, but modifications demand experience with workflow automation.

This workflow template is shared under the n8n fair-code license. Free to use and modify.