{"product_id":"apify-facebook-ad-library-video-hook-transcription-to-google-sheets","title":"Apify Facebook Ad Library Video Hook Transcription to Google Sheets","description":"\u003ch3\u003eTurn Facebook video ads into structured transcripts in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scrapes video ads from the \u003cstrong\u003eFacebook Ad Library\u003c\/strong\u003e using \u003cstrong\u003eApify\u003c\/strong\u003e, transcribes each ad’s speech, extracts the \u003cstrong\u003efirst-3-seconds hook\u003c\/strong\u003e and \u003cstrong\u003eCTA\u003c\/strong\u003e, and appends everything as one row per ad in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—so you can analyze creative performance faster.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRun manually\u003c\/strong\u003e (manual trigger) to start the process whenever you need fresh data.\u003c\/li\u003e\n  \u003cli\u003eReads your \u003cstrong\u003eFacebook Ad Library search URL\u003c\/strong\u003e and a \u003cstrong\u003emaximum ad count\u003c\/strong\u003e to control what gets scraped and processed.\u003c\/li\u003e\n  \u003cli\u003eCalls \u003cstrong\u003eApify’s Facebook Ads Library Scraper\u003c\/strong\u003e to fetch matching \u003cstrong\u003evideo ads\u003c\/strong\u003e from the search results (ensure your URL includes \u003ccode\u003emedia_type=video\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003eFor each video ad, calls \u003cstrong\u003eApify’s Facebook Ads Transcript Scraper\u003c\/strong\u003e to download the video and extract:\n    \u003cul\u003e\n      \u003cli\u003eHook (first-3-seconds), CTA text\u003c\/li\u003e\n      \u003cli\u003eFull speech transcript\u003c\/li\u003e\n      \u003cli\u003eDuration and charge status\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes fields\u003c\/strong\u003e into a consistent column set.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends one row per ad\u003c\/strong\u003e into your selected \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e worksheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS marketing teams\u003c\/strong\u003e comparing video ad messaging across competitors by analyzing hook and CTA patterns.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreative strategists\u003c\/strong\u003e building a transcript-driven library of top-performing claims and openings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e running repeatable data collection workflows for ad research and reporting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e Manual Trigger, Set, Sticky Note, HTTP Request, Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e Use an Apify API token with an HTTP Header Auth credential: \u003ccode\u003eAuthorization: Bearer \u0026lt;YOUR_APIFY_TOKEN\u0026gt;\u003c\/code\u003e for both Apify HTTP requests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e Connect your account and select the target spreadsheet + worksheet for the append step.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938219057331,"sku":"N8N-19027","price":26.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/qrPuAPr7WNifwmrdIUajj_15T9wDwo.png?v=1788340395","url":"https:\/\/buyflowscripts.com\/products\/apify-facebook-ad-library-video-hook-transcription-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}