{"product_id":"transcribe-google-ads-videos-to-google-sheets-apify-n8n","title":"Transcribe Google Ads Videos to Google Sheets (Apify + n8n)","description":"\u003ch3\u003eTranscribe Google Ads video ads into Google Sheets—automatically (Apify + n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls video ads from the \u003cstrong\u003eGoogle Ads Transparency Center\u003c\/strong\u003e, transcribes each video (including a first-3-seconds hook), and appends one structured row per ad into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—so you can analyze messaging at scale.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual start:\u003c\/strong\u003e You run the workflow on demand.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKick off scraping in Apify:\u003c\/strong\u003e The workflow sends your provided Google Ads Transparency Center URL (advertiser or domain) and a \u003cstrong\u003emax ad count\u003c\/strong\u003e to Apify to start a Google Ads scraping run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWait for results:\u003c\/strong\u003e n8n polls the Apify run until it reaches a finished state and retrieves the dataset ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtract video metadata + transcription:\u003c\/strong\u003e It passes the dataset ID to a second Apify actor to extract video ad details and generate a \u003cstrong\u003ehook\u003c\/strong\u003e and \u003cstrong\u003efull transcript\u003c\/strong\u003e for each video.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrite to Google Sheets:\u003c\/strong\u003e The workflow formats \u003cstrong\u003eone spreadsheet row per ad\u003c\/strong\u003e, including duration, language, transcript word count, video URL, and transcription status, then sorts results so \u003cstrong\u003etranscribed and longer ads appear first\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppend to your sheet:\u003c\/strong\u003e It appends rows to the selected Google Sheets spreadsheet and sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild a repeatable \u003cstrong\u003eGoogle Ads video transcript\u003c\/strong\u003e dataset for competitive ad review and creative analysis.\u003c\/li\u003e\n  \u003cli\u003eAudit messaging quality by screening transcripts and tracking \u003cstrong\u003etranscription status\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eMonitor all advertisers behind a \u003cstrong\u003eTransparency Center domain\u003c\/strong\u003e by pointing the workflow at the domain.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration via HTTP Request\u003c\/strong\u003e (using \u003cem\u003eAuthorization: Bearer YOUR_APIFY_TOKEN\u003c\/em\u003e)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e credential\/connection with an append step to the target sheet\u003c\/li\u003e\n  \u003cli\u003eUses n8n nodes\/actions including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, `sticky note`, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eYou update the \u003cstrong\u003eTransparency Center URL\u003c\/strong\u003e and \u003cstrong\u003emaxAds\u003c\/strong\u003e in the Config step before running\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950094147763,"sku":"N8N-19158","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/RQ_VB0NNGTxBtUygKrB6l_AgsJSl4o.png?v=1788513332","url":"https:\/\/buyflowscripts.com\/products\/transcribe-google-ads-videos-to-google-sheets-apify-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}