What This Workflow Does
This automation eliminates the tedious manual process of creating weekly Meta Ads performance reports. Marketing teams often spend hours each week extracting data, analyzing metrics, and formatting presentations - time that could be better spent optimizing campaigns.
The workflow automatically pulls your Meta Ads data, processes it through Claude AI for intelligent insights, formats the results using GoMarble MCP's visualization tools, and generates a polished Google Slides presentation ready for executive review - all without manual intervention.
How It Works
1. Data Extraction from Meta Ads
The workflow begins by connecting to your Meta Ads account through the API, pulling key performance metrics for your selected campaigns, ad sets, and ads. It gathers data on impressions, clicks, conversions, spend, and other critical KPIs.
2. AI-Powered Analysis with Claude
Raw data gets sent to Claude AI which identifies trends, highlights significant changes, and provides narrative explanations for performance fluctuations. Claude adds contextual insights that transform numbers into actionable business intelligence.
3. Visualization with GoMarble MCP
The analyzed data then flows into GoMarble MCP which automatically generates professional charts, graphs, and visual representations of your advertising performance. This step ensures data is presented in the most impactful way.
4. Slide Deck Creation in Google Slides
Finally, the workflow populates a Google Slides template with the visualized data and AI-generated insights, creating a complete presentation deck with consistent branding, proper formatting, and executive-friendly layouts.
Pro tip: Schedule this workflow to run automatically every Monday morning so reports are ready before your weekly marketing meeting.
Who This Is For
This automation is ideal for digital marketing agencies, ecommerce businesses, and in-house marketing teams running Meta Ads campaigns. It's particularly valuable for:
- Marketing managers who need to report performance to executives
- PPC specialists managing multiple client accounts
- Growth teams that need to share results across departments
- Businesses scaling their ad spend who need better reporting
What You'll Need
- An active Meta Ads account with campaigns running
- Access to Claude AI (API key)
- GoMarble MCP account
- Google Slides template prepared
- n8n instance to host the workflow
Quick Setup Guide
- Download the JSON template file
- Import into your n8n instance
- Connect your Meta Ads account credentials
- Configure your Claude AI API key
- Set up GoMarble MCP integration
- Link your Google Slides template
- Test with a small date range before full automation
Key Benefits
Save 5-10 hours per week by eliminating manual report creation. What used to take a full workday now happens automatically overnight.
Improve decision-making with AI-powered insights that spot trends and opportunities human analysts might miss in raw data.
Ensure consistency in reporting format and quality, eliminating human error in data transfer and presentation building.
Scale reporting effortlessly across multiple accounts, campaigns, or clients without proportional increase in work.
Deliver professional presentations that impress stakeholders with polished visuals and clear narratives.