Send weekly Databox paid ads performance reports to Slack and email

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