Log competitor Google Ads transparency snapshots to Google Sheets with Apify
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 18 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Configuration (Edit Fields (Set)): sets 4 fields: spreadsheetId, baselineOnEmptyScope, maxTotalChargeUsd…
- Validate configuration (Code): runs custom JavaScript code
- Read saved ads (Google Sheets): read (sheet)
- Start Actor (HTTP Request): calls an HTTP API (POST)
- Wait: waits 5 seconds
- Get run (HTTP Request): calls an HTTP API
- Check run status (Code): runs custom JavaScript code
- Run finished (If): checks a condition and branches into true / false
- Get HEALTH (HTTP Request): calls an HTTP API
- Get TARGETS (HTTP Request): calls an HTTP API
…plus 6 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This workflow runs daily (or manually) to snapshot Google Ads Transparency results for a single competitor domain via the Apify Google Ads Transparency Scraper, validates the run output, and upserts ad records into a Google Sheets “Ads” tab to…