Send daily Google Ads performance reports to WhatsApp via Evolution API

Description

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.