Send weekly Databox paid ads performance reports to Slack and email
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.
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Date & Time
n8n-nodes-base.dateTime - MCP Client Tool
@n8n/n8n-nodes-langchain.mcpClientTool - AI Agent
@n8n/n8n-nodes-langchain.agent - Code
n8n-nodes-base.code - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
What it does
Stop spending hours manually pulling paid ads data. This workflow connects to Databox via MCP, auto-discovers every connected paid platform, fetches 6 key metrics, and delivers a consolidated weekly report to Slack and email - every Monday at 9 AM, completely hands-free. Who's it for - Performance marketers managing campaigns across multiple platforms - Marketing managers who need a weekly cross-platform overview - Agencies automating paid ads reporting for clients How it works 1. Schedule Trigger fires every Monday at 9 AM 2. AI Agent connects to Databox via MCP and discovers all connected paid platforms (Google Ads, Facebook Ads, LinkedIn Ads, TikTok Ads, and 6 more) 3. Fetches Spend, Clicks, CPC, CTR, Impressions, and Conversions for this week and last week 4. Calculates week-over-week changes and formats two outputs - a Slack summary and a color-coded HTML email 5. Delivers both simultaneously Requirements - Databox account with at least one paid ads platform connected (free plan works) - OpenAI API key (or Anthropic) - Slack account - Gmail account How to set up 1. Click Databox MCP Tool - set Authentication to OAuth2 and authorize 2. Add your OpenAI API key to the Chat Model node 3. Connect Slack and update the channel ID in the Send to Slack node 4. Connect Gmail and set the recipient address in the Send Email node 5. Activate - your first report arrives next Monday