Analyze Meta ads daily with Google Gemini and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 18 nodes and runs on a schedule (every day at 06:00) (plus 1 other trigger). Along the way it connects Gmail, Google Sheets, Google Gemini Chat Model and Facebook Graph API.
How it runs
Trigger: On a schedule (every day at 06:00) (plus 1 other trigger).
- Set Configuration (Edit Fields (Set)): sets 2 fields: Ad Account ID, Email
- Get Ad Insights - Ad Level (Facebook Graph API): uses Facebook Graph API
- Get Config (Edit Fields (Set)): sets 2 fields: Ad Account ID, Email
- Get Ad Insights - Campaign Level (Facebook Graph API): uses Facebook Graph API
- Split Ad Data (Split Out): splits a list into separate items
- Send Error Email (Gmail): uses Gmail
- Split Campaign Data (Split Out): splits a list into separate items
- Save Ad Data (Google Sheets): append
- Structure Data Hierarchy (Code): runs custom JavaScript code
- Filter: keeps only the items that match a condition
…plus 4 more steps. See the full node list below.
Services it uses
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 (12)
- Edit Fields (Set)
n8n-nodes-base.set - Gmail
n8n-nodes-base.gmail - Code
n8n-nodes-base.code - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Sheets
n8n-nodes-base.googleSheets - Split Out
n8n-nodes-base.splitOut - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Facebook Graph API
n8n-nodes-base.facebookGraphApi - Filter
n8n-nodes-base.filter - Error Trigger
n8n-nodes-base.errorTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Analyze Meta ads with Gemini and Google Sheets Stop manually exporting CSVs and start automating your marketing insights. This workflow is designed for Marketing Agencies, Freelancers, and Media Buyers who want to keep a daily pulse on their Meta…