Apify Instagram Reel Transcripts to Google Sheets (n8n)

Turn Instagram Reel transcripts into Google Sheets rows—automatically (with n8n + Apify)

This n8n workflow pulls recent Instagram Reel transcripts for a given creator handle using the Apify Instagram Reel Transcript Scraper, then appends one structured row per Reel into Google Sheets—including hook, transcript, language, duration, caption, and charging status.

What this workflow does

• Manual trigger: Start the workflow whenever you need fresh data.
• Configure extraction: Set instagramHandle, maxReels, and whether to includeOnScreenText.
• Call Apify actor API: Uses an HTTP request with your Apify token to retrieve the creator’s latest Reels, including transcripts and metadata.
• Filter response: Keeps only Reel items and removes the run summary row from the results.
• Normalize fields: Maps URL, hook, transcript, on-screen text (if enabled), language, duration, caption, and charge status into a consistent row format.
• Append to Google Sheets: Writes the cleaned Reel rows to your selected spreadsheet and sheet.

Use cases

• Track competitor or customer content by collecting Reel transcripts for analysis in spreadsheets.
• Build a searchable repository of Instagram video text for content review, reuse, or QA.
• Monitor posting patterns by pulling transcript + duration + language into Google Sheets.
• Maintain lightweight reporting dashboards for SaaS teams that need up-to-date Reel text data.

Technical details

• n8n nodes: Manual Trigger, if, set, sticky note, HTTP Request, Google Sheets.
• Apify integration: Create an Apify token and set HTTP header auth as Authorization: Bearer <YOUR_APIFY_TOKEN>.
• Google integration: Connect your Google account and choose the target spreadsheet and sheet in the Google Sheets append step.
• Cost note: A 10-reel test is about $0.15 on the free plan (first 3 minutes of each reel are included, then additional video time may affect pricing).