n8n Workflow: Track Google Ads Transparency Creatives to Sheets

Automatically track competitors’ Google Ads creatives in Google Sheets—every Monday

This n8n workflow pulls live ads from the Google Ads Transparency Center using Apify, then appends one spreadsheet row per ad into Google Sheets, including dates, creative links, and a “long runner” flag.

What this workflow does

• Runs on a schedule: the workflow is set to execute every Monday morning.
• Targets specific advertisers: you define the competitor advertiserIds (AR… codes from adstransparency.google.com URLs), with optional region and maxAdsPerAdvertiser.
• Fetches live ads via Apify: it uses the Apify “google-ads-transparency-api” actor to retrieve the current ads for each advertiser.
• Filters to actual ads: it keeps only items confirmed as ads.
• Formats spreadsheet rows: each ad is converted into a Sheets-ready row—timestamps become dates, and creatives that have been running for 90+ days are flagged with a long runner indicator.
• Appends data to Sheets: the formatted rows are added to your chosen spreadsheet document and worksheet tab.

Use cases

• Competitive PPC monitoring: track how competitors’ creative and messaging evolve over time.
• Marketing QA & compliance visibility: maintain a dated record of ads sourced from the Google Ads Transparency Center.
• SaaS operator reporting: quickly surface “long runner” creatives for review and creative refresh planning.

Technical details

• n8n scheduling (runs every Monday)
• Apify integration: uses Apify credentials in n8n to call the google-ads-transparency-api actor
• Google Sheets: OAuth authentication to append rows to a specific spreadsheet and worksheet
• Workflow nodes: set, code, filter, sticky note, google sheets, apifyn8n-nodes-apify

Setup checklist

• Add your Apify API token as Apify credentials in n8n.
• Connect Google Sheets OAuth and select the target spreadsheet + sheet tab.
• Update advertiserIds, and optionally adjust maxAdsPerAdvertiser and region.