Apify Facebook Ad Library Video Hook Transcription to Google Sheets

Turn Facebook video ads into structured transcripts in Google Sheets

This n8n workflow scrapes video ads from the Facebook Ad Library using Apify, transcribes each ad’s speech, extracts the first-3-seconds hook and CTA, and appends everything as one row per ad in Google Sheets—so you can analyze creative performance faster.

What this workflow does

• Run manually (manual trigger) to start the process whenever you need fresh data.
• Reads your Facebook Ad Library search URL and a maximum ad count to control what gets scraped and processed.
• Calls Apify’s Facebook Ads Library Scraper to fetch matching video ads from the search results (ensure your URL includes media_type=video).
• For each video ad, calls Apify’s Facebook Ads Transcript Scraper to download the video and extract:
  • Hook (first-3-seconds), CTA text
  • Full speech transcript
  • Duration and charge status
• Normalizes fields into a consistent column set.
• Appends one row per ad into your selected Google Sheets worksheet.

Use cases

• SaaS marketing teams comparing video ad messaging across competitors by analyzing hook and CTA patterns.
• Creative strategists building a transcript-driven library of top-performing claims and openings.
• Automation engineers running repeatable data collection workflows for ad research and reporting.

Technical details

• n8n nodes: Manual Trigger, Set, Sticky Note, HTTP Request, Google Sheets.
• Apify integration: Use an Apify API token with an HTTP Header Auth credential: Authorization: Bearer <YOUR_APIFY_TOKEN> for both Apify HTTP requests.
• Google Sheets: Connect your account and select the target spreadsheet + worksheet for the append step.