Send weekly Databox paid ads performance reports to Slack and email

Description

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

Schedule Trigger fires every Monday at 9 AM
AI Agent connects to Databox via MCP and discovers all connected paid platforms (Google Ads, Facebook Ads, LinkedIn Ads, TikTok Ads, and 6 more)
Fetches Spend, Clicks, CPC, CTR, Impressions, and Conversions for this week and last week
Calculates week-over-week changes and formats two outputs - a Slack summary and a color-coded HTML email
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

Click Databox MCP Tool - set Authentication to OAuth2 and authorize
Add your OpenAI API key to the Chat Model node
Connect Slack and update the channel ID in the Send to Slack node
Connect Gmail and set the recipient address in the Send Email node
Activate - your first report arrives next Monday