🔓 Unlock all 10,000+ workflows & prompts free Join Newsletter →
✅ Full access unlocked — explore all 10,000 AI workflow and prompt templates Browse Templates →
Home n8n Workflow
January 22, 2026

TikTok to Google Sheets, searchable UGC insights

Lisa Granqvist Partner Workflow Automation Expert

You find a TikTok that perfectly explains what customers want. Then you lose it in a pile of tabs, half-copied notes, and a transcript that’s basically unusable.

This TikTok Sheets automation hits product marketers first, but copywriters and founders feel it too. You get clean transcripts, real pain points, and a ready-to-post draft saved in Google Sheets without doing the messy parts by hand.

Below, you’ll see how the workflow turns one TikTok URL into structured UGC insights your whole team can search, reuse, and build campaigns from.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: TikTok to Google Sheets, searchable UGC insights

The Problem: TikTok research turns into copy-paste chaos

UGC research should be quick: find a good video, capture what the creator said, pull out the “why this worked,” and move on. In reality, it turns into a scavenger hunt. TikTok transcripts are inconsistent, your notes live in five places, and by the time you want to write, you’re rewatching the same clip again just to find one quote. Worse, the insights stay trapped in someone’s personal doc, so nobody can reuse them next week when you need fresh hooks.

It adds up fast. Here’s where it breaks down in day-to-day work.

  • Copying captions or auto-transcripts usually produces messy text, which means you spend more time cleaning than learning.
  • Pain points and outcomes get written in different formats by different people, so the “insight library” becomes impossible to search.
  • Great direct quotes get lost because nobody logs them consistently when the deadline is close.
  • You end up rewriting the same TikTok into a post from scratch, even though the raw ingredients were already there.

The Solution: Turn TikTok URLs into structured, searchable insights

This workflow starts with a simple form submission where you paste a TikTok URL and add two bits of context: a keyword and your product name. n8n sends that link to Dumpling AI to pull the transcript, then cleans the caption file (VTT) into readable plain text. Next, GPT‑4 analyzes the transcript like a research assistant: it extracts pain points, desired outcomes, triggers (the “what made them look for a solution”), and standout direct quotes worth swiping. Finally, GPT‑4 rewrites the core idea into a social-ready post that positions your product as the solution, and everything gets logged into Google Sheets as one neat row.

The workflow begins when you submit the TikTok URL. From there, transcript extraction and cleanup run automatically, then the AI agent splits the insights into clear sections. In the end, Google Sheets becomes your searchable UGC database, complete with a fresh draft you can publish or hand off for editing.

What You Get: Automation vs. Results

Example: What This Looks Like

Say you review 10 TikToks a week for UGC research. Manually, it’s often about 30 minutes per video: grab a transcript (10 minutes), clean it (5 minutes), summarize pain points and outcomes (10 minutes), then draft a post (5 minutes). That’s roughly 5 hours weekly. With this workflow, you paste the URL and context (about 2 minutes), wait for processing (often a few minutes), and your sheet row is ready. You get most of that time back, and the insights are organized from day one.

What You’ll Need

  • n8n instance (try n8n Cloud free)
  • Self-hosting option if you prefer (Hostinger works well)
  • Google Sheets to store transcripts, insights, and drafts.
  • Dumpling AI for TikTok transcript extraction.
  • OpenAI API key (get it from your OpenAI dashboard).

Skill level: Intermediate. You’ll connect accounts, add API keys, and edit a few prompts, but you won’t be writing “real code” unless you want to tweak the transcript cleaning.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A form submission kicks things off. You submit the TikTok URL, a keyword (what you’re researching), and your product name so the rewrite can stay on-message.

The transcript gets fetched and cleaned. n8n calls Dumpling AI to retrieve captions, then converts the VTT caption format into plain text you can actually read and search.

GPT‑4 extracts research-grade insights. The AI agent pulls out pain points, desired outcomes, triggers or motivating events, plus interesting direct quotes that make great hooks and proof points.

A second GPT‑4 pass writes the draft. It rewrites the core message as a social post that positions your product as the solution, then n8n logs everything into Google Sheets in a consistent set of columns.

You can easily modify the prompts and output sections to match your brand voice, or to produce longer “creative briefs” instead of short posts. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Form Trigger

This workflow starts with a form submission that captures the TikTok URL and product details.

  1. Add and open Capture TikTok URL & Product.
  2. Set Form Title to TikTok Scraper .
  3. Under Form Fields, ensure the fields are Tiktok Video URL, Keyword , and Product .
  4. Leave Options as default unless you want to customize the form behavior.

Tip: The field labels include trailing spaces in Keyword and Product . Keep them exactly as shown so the expressions resolve correctly.

Step 2: Connect the Transcript Fetch Service

Pull the TikTok captions using Dumpling AI and store the raw VTT text in the response body.

  1. Open Dumpling AI Transcript Fetch and set URL to =https://app.dumplingai.com/api/v1/get-tiktok-transcript.
  2. Set Method to POST and enable Send Body.
  3. Under Body Parameters, set videoUrl to {{ $json['Tiktok Video URL'] }}.
  4. Under Options → Response, set Response Format to text and Output Property Name to body.
  5. Credential Required: Connect your httpHeaderAuth credentials.

Step 3: Set Up Transcript Cleaning and Parallel AI Analysis

Clean the VTT captions and run two AI analyses in parallel for insights and marketing rewrite.

  1. Open Clean VTT Caption Text and set Mode to runOnceForEachItem.
  2. Paste the provided JavaScript into JS Code to strip timestamps and return transcript.
  3. Confirm the parallel routing: Clean VTT Caption Text outputs to both GPT-4 Insight Extraction and GPT-4 Marketing Rewrite in parallel.
  4. In GPT-4 Insight Extraction, keep the Text prompt that references {{ $('Capture TikTok URL & Product').item.json['Keyword '] }} and {{ $json.transcript }}.
  5. In GPT-4 Marketing Rewrite, keep the Text prompt that references {{ $('Capture TikTok URL & Product').item.json['Keyword '] }}, {{ $('Capture TikTok URL & Product').item.json['Product '] }}, and {{ $json.transcript }}.
  6. Open GPT-4 Model for Research and set Model to gpt-4o-mini.
  7. Credential Required: Connect your openAiApi credentials in GPT-4 Model for Research.
  8. Open GPT-4 Model for Rewrite and set Model to gpt-4o-mini.
  9. Credential Required: Connect your openAiApi credentials in GPT-4 Model for Rewrite.
  10. 🧠 Agent Tools Hub and 🧠 Agent Tools Hub 2 are tool sub-nodes for the agents—if you add credentials for tools later, attach them to the parent agents (GPT-4 Insight Extraction and GPT-4 Marketing Rewrite), not the tool nodes.

⚠️ Common Pitfall: If the transcript is empty, Clean VTT Caption Text returns transcript: null. This can lead to low-quality AI output, so verify the TikTok video has captions.

Step 4: Configure Insight Parsing and Google Sheets Output

Parse the AI insight sections and append/update a Google Sheet with both insights and rewritten script.

  1. Open Split Insight Sections and keep the provided JS Code and Instructions to extract pain points, outcomes, triggers, and quotes.
  2. Open Update Sheets with Insights and set Operation to appendOrUpdate.
  3. Set Document to the file named TikTok URL and Sheet to Sheet1 (gid=0).
  4. Under Columns → Mapping, confirm the field mappings:
    • Video URL{{ $('Capture TikTok URL & Product').item.json['Tiktok Video URL'] }}
    • New Script{{ $json.output }}
    • Pain points{{ $('Split Insight Sections').first().json.painPoints}}
    • Desired outcomes{{ $('Split Insight Sections').first().json.desiredOutcomes }}
    • Original Transcription{{ $('Clean VTT Caption Text').item.json.transcript }}
    • Interesting direct quotes{{ $('Split Insight Sections').first().json.quotes}}
    • Triggers or motivating events{{ $('Split Insight Sections').first().json.triggers }}
  5. Set Matching Columns to Video URL so rows update on the same TikTok link.
  6. Credential Required: Connect your googleSheetsOAuth2Api credentials.

Step 5: Test and Activate Your Workflow

Run a manual test to confirm the transcript fetch, AI outputs, and sheet updates work end-to-end.

  1. Click Execute Workflow and submit the Capture TikTok URL & Product form with a valid TikTok URL, keyword, and product.
  2. Verify Dumpling AI Transcript Fetch returns a body field and Clean VTT Caption Text outputs a transcript.
  3. Confirm the parallel branch completes: GPT-4 Insight Extraction and GPT-4 Marketing Rewrite both return outputs.
  4. Check Update Sheets with Insights for a new or updated row that includes insights and the rewritten script.
  5. Toggle the workflow to Active so the form trigger runs in production.
🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

  • Dumpling AI credentials can expire or need specific permissions. If things break, check your Dumpling dashboard key settings first.
  • If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
  • Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Frequently Asked Questions

How long does it take to set up this TikTok Sheets automation automation?

About 30 minutes if your keys and sheet are ready.

Do I need coding skills to automate TikTok Sheets automation?

No. You’ll mainly connect accounts and paste in API keys. The only “code” is optional if you want to change how captions are cleaned.

Is n8n free to use for this TikTok Sheets automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs (often a few cents per run) and Dumpling AI usage.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this TikTok Sheets automation workflow for Notion instead of Google Sheets?

Yes, and it’s one of the easiest upgrades. You keep the same transcript fetch and GPT‑4 analysis, then swap the “Update Sheets with Insights” step for a Notion (or Airtable) create-page step. Common customizations include changing the rewrite tone, adding extra fields like “hook ideas,” and generating image prompts to pair with the draft.

Why is my Google Sheets connection failing in this workflow?

Usually it’s OAuth permissions or the spreadsheet/tab ID changed. Reconnect Google Sheets in n8n, confirm the exact sheet ID and tab name in the Google Sheets node, then run a single test item to validate writes. If it still fails, check if the Google account you connected actually has edit access to the file.

How many TikTok videos can this TikTok Sheets automation automation handle?

If you self-host, there’s no execution cap (it mostly depends on your server and your API limits).

Is this TikTok Sheets automation automation better than using Zapier or Make?

It can be, especially if you want the “research agent” behavior: cleaning text, extracting multiple insight sections, then writing a draft, all in one run. n8n is more comfortable with branching logic, merging outputs, and swapping models (GPT‑4, GPT‑4o‑mini, or alternatives) without turning your bill into a surprise. Zapier or Make are fine for simple “URL in, row out” logging, but they get clunky once you’re doing multi-step AI processing. If you’re deciding between tools for your team, Talk to an automation expert and get a recommendation based on volume and budget.

Once this is running, TikTok research stops being “inspiration you can’t find later” and becomes an actual system. The workflow handles the repetitive stuff, so you can focus on the message that converts.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

×

Use template

Get instant access to this n8n workflow Json file

💬
Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Launch login modal Launch register modal