Transcribe Google Ads video creatives with Apify and Google Sheets

Description

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
A Schedule Trigger fires weekly. One Config node holds the domains, region, ads per domain and the recipient.
It loops over the domains: each Transparency Center page is scraped on Apify, then that run's dataset goes straight to the Google Ads Video Transcript Scraper.
Remove Duplicates drops every creative seen in an earlier execution, so a weekly run only reports new ads. Nothing new means no email is sent.
An Information Extractor breaks each new ad down: hook type, promise, proof, CTA and script structure.
Google Sheets appends a row per ad; Gmail sends a digest counting transcribed and silent ads separately.

Setup
Create an HTTP Header Auth credential (name Authorization, value Bearer YOUR_APIFY_TOKEN) and select it on the three HTTP Request nodes.
Add a Groq credential on the chat model node - a drop-in swap for OpenAI or Anthropic.
Connect Google Sheets and Gmail, then set your domains, region and recipient in Config.

Requirements
An Apify account, a chat model account and a Google account.
Transcription is charged only when a transcript is delivered; music-only ads are uncharged and still reach the sheet with their status.

Customization
Point it at advertiser names instead of domains, or change the region.
Send the digest to Slack instead of Gmail.

Additional info
YouTube and Google Ads performance marketers who would rather read competitor scripts than watch them.