📊 Automated meta ads analysis with Gemini AI, ScrapingFlash, and Google Sheets
⚡ 1,411 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
This workflow acts as your personal AI-powered analyst for Meta Ads.
It’s pretty straightforward:
- First, it grabs a list of Facebook Ad Library URLs you want to check out from a Google Sheet.
- Then, it automatically scrapes the active ads from those pages.
Here’s the cool part: it sends each ad’s image and text to Google Gemini, which analyzes it like an expert marketer would.
Finally, Gemini’s full analysis—we’re talking strengths, weaknesses, actionable suggestions, and a performance score—gets dropped neatly into another Google Sheet for you.
Set up steps
You should be ready to roll in about 5 minutes. There are no complex configurations, you just need to:
- Connect your accounts: The workflow has placeholders waiting for your credentials for Google (for Sheets and the Gemini API) and ScrapingFlash.
- Link your Google Sheets: Just point the first Google Sheets node to the sheet with your URLs, and tell the last node where you want to save the results.
All the nitty-gritty details and expressions are explained in the sticky notes inside the workflow itself!
🔗 Nodes Used
Google Sheets, HTTP Request, Schedule Trigger, Basic LLM Chain, Structured Output Parser, Google Gemini Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File