Analyze Meta Ad Library Video Ads with Gemini & Google Sheets

This n8n workflow automates the extraction and deep analysis of video advertisements from Facebook's Meta Ad Library. It begins by scraping ads based on a specified page ID using Apify, filtering them by reach metrics to focus on high-impact content. Each video is then processed through Google's Gemini AI, which performs comprehensive analysis including identifying hooks, generating transcripts, determining ad formats, concepts, and narrative structures.

The analyzed data is refined by an AI agent that standardizes outputs into structured fields for consistency and usability. Results are seamlessly appended to a Google Sheets document, enabling easy access, sharing, and further processing like reporting or visualization.

Ideal for marketers, agencies, and researchers, this workflow provides competitive intelligence on ad performance and creative strategies. Benefits include time savings on manual review, scalable analysis of hundreds of ads, and actionable insights to optimize campaigns. Customize prompts and output mappings to tailor for specific industries or metrics.