📊 Send weekly Databox paid ads performance reports to Slack and email
⚡ 718 views · 📊 Market Research & Insights
💡 Pro Tip — Since TikTok doesn’t have a public API, getting data usually means fragile HTTP scraping. ScraperNode is a community node that gives you clean JSON for TikTok profiles, videos, and comments — drop it into your workflow and skip the parsing.
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
🔗 Nodes Used
Slack, Gmail, Schedule Trigger, AI Agent, OpenAI Chat Model, MCP Client Tool
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File