Transcribe Google Ads video creatives with Apify and Google Sheets
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 AI workflow has 20 nodes and runs on a schedule (every week at 08:00) (plus 1 other trigger). Along the way it connects Groq Chat Model, Google Sheets and Gmail.
How it runs
Trigger: On a schedule (every week at 08:00) (plus 1 other trigger).
- Config (Edit Fields (Set)): sets 4 fields: advertiserDomains, region, maxAdsPerDomain…
- Domains, one per item (Code): runs custom JavaScript code
- Loop over advertisers (Loop Over Items (Split in Batches)): loops over the items in batches
- Only creatives we have not seen before (Remove Duplicates): removes duplicate items
- Scrape the Transparency Center (HTTP Request): calls an HTTP API (POST)
- Any new ads? (If): checks a condition and branches into true / false
- Scrape finished? (If): checks a condition and branches into true / false
- Break the ad script down (Information Extractor): extracts structured fields from text with AI, with model: Groq Chat Model
- Transcribe the video ads (HTTP Request): calls an HTTP API (POST)
- Wait for the scrape (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 (14)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Remove Duplicates
n8n-nodes-base.removeDuplicates - No Operation, do nothing
n8n-nodes-base.noOp - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Gmail
n8n-nodes-base.gmail
From the author
Quick overview Every Monday this workflow transcribes the new YouTube video ads each brand is running in Google's Ads Transparency Center, has an AI break the script down, appends them to a Google Sheet and emails you the week's breakdown. How it works 1. A…