{"product_id":"apify-google-sheets-fb-ad-hook-cta-extractor-via-n8n","title":"Apify + Google Sheets: FB Ad Hook \u0026 CTA Extractor via n8n","description":"\u003ch3\u003eExtract FB Video Ad Hooks \u0026amp; CTAs into Google Sheets—using Apify + n8n\u003c\/h3\u003e\n\u003cp\u003eRun this n8n workflow on demand to scrape a competitor’s active Facebook video ads via \u003cstrong\u003eApify\u003c\/strong\u003e, transcribe them, extract the \u003cstrong\u003efirst-3-seconds hook\u003c\/strong\u003e and \u003cstrong\u003eCTA\u003c\/strong\u003e, then append a clean \u003cstrong\u003eone-row-per-ad\u003c\/strong\u003e teardown table to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts when manually tested\u003c\/strong\u003e: you trigger the workflow to begin a fresh run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your inputs\u003c\/strong\u003e: provides a competitor \u003cem\u003eFacebook Ad Library search URL\u003c\/em\u003e (or a Facebook Page URL) and a \u003cem\u003emaximum number of ads\u003c\/em\u003e to process (maxAds).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns the Apify scraper\u003c\/strong\u003e: launches an \u003cstrong\u003eApify Facebook Ads Library\u003c\/strong\u003e scraping run for the competitor and polls Apify until completion.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches transcripts + ad metadata\u003c\/strong\u003e: sends the scraper run’s \u003cstrong\u003edataset ID\u003c\/strong\u003e to an \u003cstrong\u003eApify Facebook Ads Transcript Scraper\u003c\/strong\u003e to return transcript, hook, CTA, and metadata.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses and ranks results\u003c\/strong\u003e: calculates transcript word\/character counts, sorts ads (prioritizing \u003cem\u003etranscribed\u003c\/em\u003e and \u003cem\u003elonger videos\u003c\/em\u003e), and formats a single structured row per ad.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends to Google Sheets\u003c\/strong\u003e: writes the teardown rows into the selected spreadsheet and sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup requirements\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCreate an \u003cstrong\u003eApify API token\u003c\/strong\u003e and add an HTTP Header Auth credential using \u003ccode\u003eAuthorization: Bearer \u0026lt;YOUR_APIFY_TOKEN\u0026gt;\u003c\/code\u003e, selecting it for all Apify HTTP requests.\u003c\/li\u003e\n  \u003cli\u003eConnect \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, then choose the target spreadsheet and sheet for the append step.\u003c\/li\u003e\n  \u003cli\u003eUpdate the competitor URL and \u003cstrong\u003emaxAds\u003c\/strong\u003e in the configuration step before running.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRapid competitor creative teardown: collect hooks and CTAs from active FB video ads into a shared Google Sheet.\u003c\/li\u003e\n  \u003cli\u003eSaaS growth ops research: compare messaging patterns across ads by extracting the first 3 seconds and calls to action.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers’ workflow benchmarking: demonstrate an end-to-end Apify → n8n → Google Sheets pipeline.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n + integrations)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eApify: \u003cstrong\u003eFacebook Ads Library scraper\u003c\/strong\u003e + \u003cstrong\u003eFacebook Ads Transcript Scraper\u003c\/strong\u003e, using dataset ID handoff and Apify polling.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938178130099,"sku":"N8N-19044","price":4.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/cm4pv01FmRYkL7Lot3i4T_fdLKL6I7.png?v=1788339946","url":"https:\/\/buyflowscripts.com\/products\/apify-google-sheets-fb-ad-hook-cta-extractor-via-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}