Automate Weekly Meta Ad Reports with Claude AI & Google Slides

This n8n workflow streamlines Meta advertising reporting by extracting campaign data through GoMarble MCP, leveraging Anthropic's Claude AI for intelligent analysis and actionable insights, and automatically building polished Google Slides decks. Scheduled to run weekly (or customizable to daily/monthly), it eliminates manual data compilation, chart creation, and report formatting, saving marketing teams hours of repetitive work.

Key benefits include consistent, executive-ready reports with KPIs, performance trends, and AI-generated recommendations, ensuring stakeholders receive timely insights for data-driven decisions. It integrates seamlessly with Google Drive, Slides, and Gmail for presentation storage and direct delivery, reducing errors and enhancing client communications.

Ideal use cases: Digital ad agencies managing multiple client campaigns, in-house marketing teams tracking ROI, or e-commerce businesses monitoring ad spend efficiency. Prerequisites include GoMarble MCP API access, Anthropic account, and Google credentials; setup takes 15-20 minutes with guided steps for triggers, prompts, and accounts.