Scrape TikTok profile transcript with Dumpling AI and save to
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 tren...
🔌 Nodes & Integrations Used (3)
📖 Implementation & Setup Guide
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`
2. **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.
3. **Dumpling AI Profile Scraper** - Go to [Dumpling AI](https://app.dumplingai.com/) - 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
4. **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
5. **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
---
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Scrape_TikTok_profile_transcript_with_Dumpling_AI_and_save_to.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Social Media & Content Workflows
View All in Social Media & Content →AI Auto-Tagging for WordPress Posts
Production-ready n8n automation template for AI Auto-Tagging for WordPress Posts built by AhiXLight. Seamlessly connects Lm Chat Open Ai, Output Parser Autofixing, Output Parser Structured with 32 configured nodes.
AI Auto-Tagging for WordPress Posts
Production-ready n8n automation template for AI Auto-Tagging for WordPress Posts built by AhiXLight. Seamlessly connects Lm Chat Open Ai, Output Parser Autofixing, Output Parser Structured with 32 configured nodes.
AI Image Caption Generator Overlay
Production-ready n8n automation template for AI Image Caption Generator Overlay built by AhiXLight. Seamlessly connects Lm Chat Google Gemini, Output Parser Structured, Edit Image with 16 configured nodes.
AI Image Caption Generator with Overlay
Production-ready n8n automation template for AI Image Caption Generator with Overlay built by AhiXLight. Seamlessly connects Lm Chat Google Gemini, Output Parser Structured, Edit Image with 16 configured nodes.