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.
What this workflow does
This AI workflow has 8 nodes and runs on a schedule (cron 0 9 * * 1). Along the way it connects MCP Client, Slack, Gmail and OpenAI Chat Model.
How it runs
Trigger: On a schedule (cron 0 9 * * 1).
- Get Current Date (Date & Time): formats or calculates dates
- Paid Ads Reporting Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (Databox MCP Tool)
- Parse AI Output (Code): runs custom JavaScript code
- Send to Slack (Slack): uses Slack
- Send Email (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
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
From the author
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…