Automated Google Ads Campaign Performance Reporter

This n8n workflow automates the collection, analysis, and storage of Google Ads campaign data daily. It begins with a scheduled trigger every morning at 08:00, then pulls metrics on clicks, impressions, costs, and conversions for the previous day via Google Ads API. The data is split, merged, and processed to produce both campaign-specific metrics and aggregated totals. These insights are stored into Notion databases and Google Sheets for easy access and reporting. The workflow streamlines marketing analytics, ensuring consistent, hands-off reporting — ideal for digital marketing teams aiming for timely, centralized campaign performance data.