Fetch full Google Ads account audit data as merged JSON

Quick Overview

This workflow runs manually to pull a full Google Ads account audit (campaigns, ad groups, keywords, search terms, ads, negatives, audiences, and assets) via the Google Ads API for a defined date range, and returns a single merged JSON object you can export or use in downstream steps.

How it works

1. Starts when you manually execute the workflow.
2. Loads the Google Ads customer ID, developer token, and reporting date range values used in the API requests.
3. Queries the Google Ads API (searchStream) for campaign performance and configuration for the selected date range.
4. Queries the Google Ads API for ad groups, keywords (including quality score fields), and the top search terms by spend within the date range.
5. Queries the Google Ads API for ads (including RSA headlines/descriptions and approval status), campaign-level negative keywords, and ad group audience criteria.
6. Queries the Google Ads API for campaign assets (such as call, callout, and sitelink assets) and merges all datasets into one JSON payload grouped by section.

Setup

1. Create a Google Ads OAuth2 connection in n8n with access to the target Google Ads customer ID.
2. Get your Google Ads developer token from your Google Ads Manager account and set it in the workflow’s environment values.
3. Set the customer ID (no dashes) and adjust DATE_FROM and DATE_TO expressions or use fixed dates to control the audit reporting period.