Track competitor Google Ads Transparency Center ads with Apify and Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 6 nodes and runs on a schedule (every week at 08:00). Along the way it connects Google Sheets and Apify (community).
How it runs
Trigger: On a schedule (every week at 08:00).
- Set the competitors to watch (Edit Fields (Set)): sets 3 fields: advertiserIds, maxAdsPerAdvertiser, region
- Fetch each advertiser's ads (Apify): run actor and get dataset (actors)
- Keep rows that are real ads (Filter): keeps only the items that match a condition
- Shape ad rows for the sheet (Code): runs custom JavaScript code
- Append this week's ads (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Fetch each advertiser's ads).
Nodes used (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Apify
@apify/n8n-nodes-apify.apify - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview No ad spy subscription and no agency retainer. Every week this reads the Google Ads Transparency Center for the advertisers you list and appends one row per ad to Google Sheets: advertiser, format, when it first ran, how long it has run, and a…