TikTok to Google Sheets, searchable UGC insights
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
flowchart LR
subgraph sg0["Form: Submit TikTok URL + Product Info Flow"]
direction LR
n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/form.svg' width='40' height='40' /></div><br/>Form: Submit TikTok URL + Pr.."]
n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Dumpling AI: Get TikTok Tran.."]
n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Format: Clean VTT Captions"]
n3@{ icon: "mdi:robot", form: "rounded", label: "GPT-4: Extract Pain Points &..", pos: "b", h: 48 }
n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/aitransform.svg' width='40' height='40' /></div><br/>Parse: Separate Insights (pa.."]
n5@{ icon: "mdi:database", form: "rounded", label: " Google Sheets: Log Insights..", pos: "b", h: 48 }
n6@{ icon: "mdi:robot", form: "rounded", label: "GPT-4: Rewrite Transcript as..", pos: "b", h: 48 }
n7@{ icon: "mdi:brain", form: "rounded", label: "GPT-4: Used in Research Agent", pos: "b", h: 48 }
n8@{ icon: "mdi:brain", form: "rounded", label: "GPT-4: Used in Rewrite Agent", pos: "b", h: 48 }
n9@{ icon: "mdi:wrench", form: "rounded", label: "🧠 LangChain Tools (for Agents)", pos: "b", h: 48 }
n10@{ icon: "mdi:wrench", form: "rounded", label: "🧠 LangChain Tools (for Agent..", pos: "b", h: 48 }
n2 --> n3
n2 --> n6
n8 -.-> n6
n7 -.-> n3
n9 -.-> n3
n1 --> n2
n10 -.-> n6
n3 --> n4
n0 --> n1
n6 --> n5
n4 --> n5
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n3,n6 ai
class n7,n8 aiModel
class n9,n10 ai
class n5 database
class n1 api
class n2 code
classDef customIcon fill:none,stroke:none
class n0,n1,n2,n4 customIcon
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
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
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.
- Add and open Capture TikTok URL & Product.
- Set Form Title to
TikTok Scraper. - Under Form Fields, ensure the fields are
Tiktok Video URL,Keyword, andProduct. - 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.
- Open Dumpling AI Transcript Fetch and set URL to
=https://app.dumplingai.com/api/v1/get-tiktok-transcript. - Set Method to
POSTand enable Send Body. - Under Body Parameters, set videoUrl to
{{ $json['Tiktok Video URL'] }}. - Under Options → Response, set Response Format to
textand Output Property Name tobody. - 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.
- Open Clean VTT Caption Text and set Mode to
runOnceForEachItem. - Paste the provided JavaScript into JS Code to strip timestamps and return
transcript. - Confirm the parallel routing: Clean VTT Caption Text outputs to both GPT-4 Insight Extraction and GPT-4 Marketing Rewrite in parallel.
- In GPT-4 Insight Extraction, keep the Text prompt that references
{{ $('Capture TikTok URL & Product').item.json['Keyword '] }}and{{ $json.transcript }}. - 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 }}. - Open GPT-4 Model for Research and set Model to
gpt-4o-mini. - Credential Required: Connect your openAiApi credentials in GPT-4 Model for Research.
- Open GPT-4 Model for Rewrite and set Model to
gpt-4o-mini. - Credential Required: Connect your openAiApi credentials in GPT-4 Model for Rewrite.
- 🧠 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.
- Open Split Insight Sections and keep the provided JS Code and Instructions to extract pain points, outcomes, triggers, and quotes.
- Open Update Sheets with Insights and set Operation to
appendOrUpdate. - Set Document to the file named
TikTok URLand Sheet toSheet1(gid=0). - 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 }}
- Video URL →
- Set Matching Columns to
Video URLso rows update on the same TikTok link. - 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.
- Click Execute Workflow and submit the Capture TikTok URL & Product form with a valid TikTok URL, keyword, and product.
- Verify Dumpling AI Transcript Fetch returns a
bodyfield and Clean VTT Caption Text outputs atranscript. - Confirm the parallel branch completes: GPT-4 Insight Extraction and GPT-4 Marketing Rewrite both return outputs.
- Check Update Sheets with Insights for a new or updated row that includes insights and the rewritten script.
- Toggle the workflow to Active so the form trigger runs in production.
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
About 30 minutes if your keys and sheet are ready.
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.
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.
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.
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.
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.
If you self-host, there’s no execution cap (it mostly depends on your server and your API limits).
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.