Automated Weekly Meta Ad Performance Summary Deck Generation using AI and Google Slides - n8n Workflow

Ideal Users

Digital Marketing Agencies: Users needing to automate high-frequency, standardized client reports.
Performance Marketing Managers: Professionals looking to eliminate manual data fetching and slide creation time.
n8n Automation Specialists: Users seeking advanced examples of integrating LLM agents, data tools (GoMarble), and complex API calls (Google Slides Batch Update) within a single n8n workflow.
Businesses using Anthropic Claude: Organizations leveraging advanced AI models for business intelligence and document generation.

The manual compilation of weekly marketing performance reports is time-consuming and prone to human error. This sophisticated n8n workflow solves this by establishing a zero-touch reporting pipeline. This solution leverages the power of n8n to connect real-time Meta Ad performance data (via the GoMarble Marketing Cloud Proxy, or MCP) with Anthropic's Claude AI. The AI is directed via a highly specific system message to act as a senior performance marketing analyst, generating exactly five structured slides (Executive Summary, KPIs, Top Performers, etc.). This powerful n8n template then uses direct Google Slides API calls to programmatically build the presentation deck, including complex elements like metric tables, and delivers it via the Gmail n8n node. This represents one of the most robust n8n templates available for high-quality, zero-touch reporting.

This powerful n8n workflow begins execution every Monday morning.

1. Schedule Trigger: The process starts with the Schedule Trigger n8n trigger, set to run weekly at a specified time (e.g., Monday 8 AM).


2. Data Setup: The Ad Account and Report Prompt n8n node set dynamic variables (like the account name) and construct the detailed prompt, explicitly instructing the AI agent on its persona, goal, and the exact five-slide JSON structure required.


3. AI Analysis & Tool Use: An AI Agent is invoked, connected to the Anthropic Chat Model (Claude). Critically, this agent uses the GoMarble MCP tool to fetch live Meta Ads metrics (Spend, ROAS, Conversions) for the last 7 days.


4. Validation and Parsing: The Validate slide output n8n node (a code node) is essential for flow stability. It parses the AI's raw JSON output, cleans up any extraneous text or markdown fences, and guarantees that a structured set of exactly five slides is passed to the next stage, providing fallback content if parsing fails.


5. Presentation Creation: The Create Presentation n8n node uses an HTTP Request to call the Google Slides API, generating a new, empty presentation file.


6. Slide Formatting: The Format Slides Data n8n node (another code node) takes the AI-generated slide content and dynamically constructs a large Google Slides Batch Update API request. This step includes logic to create slides, insert titles and body text, and specifically generate and populate a metrics table for the 'Channel KPIs' slide.


7. Build and Deliver: The Build Presentation n8n node executes the Batch Update, populating the entire slide deck instantaneously. The Google Drive Download file n8n node retrieves the completed presentation file, and the Gmail Send Email n8n node attaches the report and delivers it to the marketing recipients, concluding this highly automated n8n workflow.

To deploy this comprehensive n8n workflow, follow these steps:

1. Import the n8n workflow: Copy the provided JSON and import it directly into your n8n instance.


2. Set Credentials: You will need to set up credentials for the following services:

1. Configure Input Nodes: Edit the Ad Account n8n node to specify the name of the ad account being reported on.


2. Review Prompt: Review the Report Prompt n8n node to fine-tune the AI's instructions or change the targeted recipients in the final Send Email n8n node.


3. Activate: Set the n8n trigger schedule and activate the n8n workflow.

Schedule Trigger (n8n trigger): Initiates the entire n8n workflow every Monday at 8 AM.
Ad Account / Report Prompt (Set n8n node): Used to inject configuration variables (like the account name) and the highly detailed prompt instructing the Claude model how to perform its analysis and structure its final JSON output.
Anthropic Chat Model / AI Agent (n8n node): The core intelligence engine. The Agent manages the process, utilizing the Anthropic LLM and integrating the external GoMarble MCP tool to pull Meta Ads data.
GoMarble MCP (n8n node): Acts as a data retrieval tool for the AI, securely fetching weekly performance metrics from the Meta Ads API.
Validate slide output (Code n8n node): A critical component of this n8n template. It rigorously ensures the AI's output is valid JSON and contains exactly five required slide objects, guaranteeing stability for downstream API actions.
Create Presentation (HTTP Request n8n node): Calls the Google Slides API to provision a new presentation file, capturing the necessary ID for subsequent updates.
Format Slides Data (Code n8n node): Translates the AI's structural JSON into the required Google Slides Batch Update JSON array, including complex logic for creating a 2x10 metrics table on the KPI slide.
Build Presentation (HTTP Request n8n node): Executes the large batch update request, programmatically filling the presentation with titles, text, and data tables.
Download file (Google Drive n8n node): Downloads the finalized Google Slide presentation.
Send Email (Gmail n8n node): Attaches and sends the completed weekly report deck to the specified email address.