Quick overview
This workflow runs daily and pulls today’s performance metrics from all enabled Google Ads sub-accounts in an MCC, aggregates the results, and sends a formatted daily report to a WhatsApp number via an Evolution API HTTP endpoint.
How it works
- Runs every day at 19:00 on a schedule.
- Queries the Google Ads API to list all enabled, non-manager (sub) accounts under your MCC.
- Requests today’s cost, clicks, impressions, and conversions for each sub-account from the Google Ads API.
- Aggregates the metrics across accounts, calculates totals and CPAs where conversions exist, and formats a WhatsApp-ready text report.
- Sends the report to the specified WhatsApp number using an Evolution API sendText HTTP request.
Setup
- Create and connect a Google Ads OAuth2 credential in n8n and ensure your MCC has access to the sub-accounts you want to report on.
- Replace the placeholders for MCC ID and Google Ads developer token in the Google Ads HTTP requests.
- Set your Evolution API base URL/endpoint, instance name, API key, and the destination WhatsApp number (with country code) in the WhatsApp HTTP request node.