Analyze Meta ads creatives with Google Vision & Video Intelligence APIs
Ready for 3.0What this workflow does
This workflow has 26 nodes and runs on a schedule (every day at 09:00). Along the way it connects Facebook Graph API and Google Sheets. It also calls vision.googleapis.com and videointelligence.googleapis.com over HTTP.
How it runs
Trigger: On a schedule (every day at 09:00).
- Set Campaign ID (Edit Fields (Set)): sets 1 field: campaign_id
- Get Active Ads (Facebook Graph API): uses Facebook Graph API
- Split Out: splits a list into separate items
- Is it a Video? (If): checks a condition and branches into true / false
- Get Video Source URL (Facebook Graph API): uses Facebook Graph API
- Has image_url? (If): checks a condition and branches into true / false
- Download Video File (HTTP Request): calls an HTTP API
- Download Image File (HTTP Request): calls an HTTP API
- Set (Error Row) (Edit Fields (Set)): sets 11 fields: error_type, error_message, campaign_id…
- Video to Base64 String (Extract from File): extracts data from a file (binary to propery)
…plus 15 more steps. See the full node list below.
Services it uses
HTTP calls to: vision.googleapis.com, videointelligence.googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Facebook Graph API
n8n-nodes-base.facebookGraphApi - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Split Out
n8n-nodes-base.splitOut - Code
n8n-nodes-base.code - Extract from File
n8n-nodes-base.extractFromFile - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait
From the author
This workflow transforms your Meta Ads creatives into a rich dataset of actionable insights. It's designed for data-driven marketers, performance agencies, and analysts who want to move beyond basic metrics and understand the specific visual and textual…