Transcribe Google Ads Videos to Google Sheets (Apify + n8n)

Transcribe Google Ads video ads into Google Sheets—automatically (Apify + n8n)

This n8n workflow pulls video ads from the Google Ads Transparency Center, transcribes each video (including a first-3-seconds hook), and appends one structured row per ad into Google Sheets—so you can analyze messaging at scale.

What this workflow does

• Manual start: You run the workflow on demand.
• Kick off scraping in Apify: The workflow sends your provided Google Ads Transparency Center URL (advertiser or domain) and a max ad count to Apify to start a Google Ads scraping run.
• Wait for results: n8n polls the Apify run until it reaches a finished state and retrieves the dataset ID.
• Extract video metadata + transcription: It passes the dataset ID to a second Apify actor to extract video ad details and generate a hook and full transcript for each video.
• Write to Google Sheets: The workflow formats one spreadsheet row per ad, including duration, language, transcript word count, video URL, and transcription status, then sorts results so transcribed and longer ads appear first.
• Append to your sheet: It appends rows to the selected Google Sheets spreadsheet and sheet.

Use cases

• Build a repeatable Google Ads video transcript dataset for competitive ad review and creative analysis.
• Audit messaging quality by screening transcripts and tracking transcription status.
• Monitor all advertisers behind a Transparency Center domain by pointing the workflow at the domain.

Technical details

• Apify integration via HTTP Request (using Authorization: Bearer YOUR_APIFY_TOKEN)
• Google Sheets credential/connection with an append step to the target sheet
• Uses n8n nodes/actions including if, set, code, `sticky note`, HTTP Request, and Google Sheets
• You update the Transparency Center URL and maxAds in the Config step before running