📊 Analyze Meta Ad Library Video Ads with Gemini and store results in Google Sheets
⚡ 2,364 views · 📊 Market Research & Insights
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
Meta Ads Analyzer
This n8n template builds an automated system to scrape, analyze, and extract insights from Meta advertising content. The workflow uses AI to perform deep analysis of video ads and organize the results in a structured format.
How it works
- The workflow connects to Facebook’s Ad Library to scrape video ads based on a specified page ID.
- Videos are filtered by reach and processed through Google’s Gemini AI to analyze their content.
- Each video is systematically analyzed for its hook, transcript, advertising format, concept, and narrative structure.
- Results are processed through an AI agent that structures the data into standardized fields.
- All analysis is saved to a Google Sheet for easy access and further processing.
How to use Once you’ve set up your Credentials and configured the output:
- Configure the Google Sheets connection for data output.
- Specify the Meta Ad Library URL you want to analyze.
- Adjust the maximum number of ads to scrape and analyze based on your needs.
- Click “Test Workflow” to start the analysis process.
Requirements
- Apify account (for Meta Ad Library scraping)
- Google Gemini
- Google Sheets
Customizing this workflow
- Modify the AI prompts in the Settings node to extract different information from the videos.
- Adjust the output formats in the AI Agent and Structured Output Parser nodes.
- Change the Google Sheets mapping to match your desired output structure.
- Increase the number of ads analyzed for more comprehensive research.
🔗 Nodes Used
Google Sheets, HTTP Request, Filter, AI Agent, Structured Output Parser, Google Gemini Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File