Daily Google Ads performance to Notion and Google Sheets

Description

This workflow automates the daily reporting of Google Ads campaign performance. It pulls click and conversion data from the Google Ads API, merges both datasets, and stores the results into Notion databases and Google Sheets.

It includes a campaign-level log and a daily performance summary. The workflow is triggered automatically every day at 08:00 AM, helping marketing teams maintain a consistent and centralized reporting system without manual effort.

---

How It Works

1. Scheduled Trigger at 08:00 AM The workflow begins with a Schedule Trigger node that runs once per day at 08:00.

2. Set Yesterday’s Date The Set node defines a variable for the target date (yesterday), which is used in the API queries.

3. Query Google Ads API – Clicks & Cost The first HTTP request pulls campaign-level metrics: - campaign.id, campaign.name - metrics.clicks, metrics.impressions, metrics.costmicros