Automate weekly Meta Ad reports with Claude AI, GoMarble MCP & Google Slides
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 13 nodes and runs on a schedule (every week at 08:00). Along the way it connects MCP Client, Google Drive, Anthropic Chat Model and Gmail. It also calls slides.googleapis.com over HTTP.
How it runs
Trigger: On a schedule (every week at 08:00).
- Ad Account (Edit Fields (Set)): sets 1 field: accountName
- Report Prompt (Edit Fields (Set)): sets or maps fields
- AI Agent: runs an AI agent, with model: Anthropic Chat Model; 1 tool (GoMarble MCP)
- Validate slide output (Code): runs custom JavaScript code
- Create Presentation (HTTP Request): calls slides.googleapis.com (POST)
- Merge Presentation Info (Edit Fields (Set)): sets 2 fields: presentationId, slides
- Format Slides Data (Code): runs custom JavaScript code
- Build Presentation (HTTP Request): calls an HTTP API (POST)
- Download file (Google Drive): download
- Send Email (Gmail): uses Gmail
Services it uses
HTTP calls to: slides.googleapis.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- AI Agent
@n8n/n8n-nodes-langchain.agent - Schedule Trigger
n8n-nodes-base.scheduleTrigger - MCP Client Tool
@n8n/n8n-nodes-langchain.mcpClientTool - Google Drive
n8n-nodes-base.googleDrive - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Gmail
n8n-nodes-base.gmail - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code
From the author
This automation workflow transforms Meta advertising data into executive ready presentation decks, eliminating manual report creation while ensuring stakeholders receive consistent performance insights. It generates professional Google Slides presentations…