Scrape TikTok Profile & Transcript with Dumpling AI and Save to Google Sheets

Description

Who is this for?

This workflow is built for marketers, researchers, and content analysts who need to monitor TikTok content, analyze user data, or track trends across influencers. It's useful for agencies that manage creators or want to keep an organized record of profile performance and video content for reporting or outreach.

What problem is this workflow solving?

Instead of manually checking TikTok profiles or watching videos to understand performance or content, this workflow automates everything. It extracts both profile statistics and full video transcripts, then logs them in Google Sheets for easy access, filtering, and segmentation.

What this workflow does

The automation watches for new TikTok video URLs added to a Google Sheet. When a new row is detected:

It extracts the username from the URL.
Sends the username to Dumpling AI to get full profile data (followers, likes, videos).
Sends the video URL to Dumpling AI to extract the full transcript.
Appends all this information back into the same sheet.

Everything happens automatically after a new URL is added to the sheet.

Setup

Google Sheets Trigger
Connect your Google account and select the spreadsheet where TikTok links will be added.
The workflow will trigger on each new row.
Example sheet column: USERNAME Video

Extract Username
This Set node uses RegEx to extract the username (handle) from the TikTok video URL.
No need to change anything unless TikTok URL formatting changes.

Dumpling AI Profile Scraper
Go to Dumpling AI
Sign in and retrieve your API key
Create an agent using the get-tiktok-profile endpoint
Paste your API key into the httpHeaderAuth field in n8n

Dumpling AI Transcript Scraper
Also uses Dumpling AI
Make sure the endpoint get-tiktok-transcript is enabled in your Dumpling account
Connect using the same API key

Save to Google Sheets
The final node appends data back to your original Google Sheet
Required columns: USERNAME Video, Username, Follower count, Following Count, heart count, Video Count, Transcript

How to customize this workflow to your needs

Add a filter node to only save profiles with a minimum follower count
Add sentiment analysis for the transcript using OpenAI
Connect Airtable or Notion instead of Google Sheets
Use GPT to summarize or classify transcripts for research

⚠️ Notes

Requires a Dumpling AI account and API key
Make sure Google Sheets API is connected and has the correct permissions
TikTok usernames must start with @ for RegEx to work