TikTok Profile & Transcript Data Extractor to Google Sheets - n8n Workflow

Social Media Researchers: Users needing large datasets of TikTok creator statistics and video content.
Content Marketers: Professionals analyzing competitor content transcripts and performance metrics.
n8n Automation Experts: Developers seeking a robust n8n template for combining trigger nodes, API calls, and spreadsheet management.
Data Analysts: Anyone needing structured, automated extraction of public TikTok data.

For market analysis or content research, manually collecting detailed TikTok data is time-consuming and error-prone. This specialized n8n workflow solves this problem by providing a fully automated data pipeline. The n8n template starts by monitoring a Google Sheet for new TikTok video links. Once detected, the n8n node sequence automatically extracts the creator's username, utilizes the Dumpling AI service to fetch profile stats (followers, video counts, likes), and retrieves the complete video transcript. This reliable n8n workflow ensures high data accuracy and efficiency, allowing users to build extensive databases of social media intelligence without writing any custom code. Utilizing this n8n automation means your research database is always up-to-date.

This automation functions on a scheduled polling basis, starting with the Google Sheets n8n trigger.

1. Trigger: The 'Watch for New TikTok Links in Sheet' n8n trigger periodically checks the input spreadsheet for newly added video URLs.


2. Data Preparation: Upon receiving a new URL, the 'Extract Username from TikTok URL' n8n node uses a Regular Expression to isolate the creator's handle.


3. Profile Scraping: The 'Get TikTok Profile Data using Dumpling AI' n8n node uses the extracted username in an HTTP request to the Dumpling AI API to retrieve comprehensive profile metrics (follower count, video count, etc.).


4. Transcript Extraction: Concurrently, the 'Get TikTok Video Transcript using Dumpling AI' n8n node sends the original video URL to the API to pull the full text transcript.


5. Data Consolidation: Finally, the 'Save Profile Stats and Transcript to Google Sheet' n8n node gathers the data collected by the n8n workflow (username, stats, transcript) and appends it as a new, structured row in the output Google Sheet, completing the automated cycle of this n8n template.

To deploy this powerful n8n workflow, follow these setup steps:

1. Import: Copy the provided n8n workflow JSON and paste it into your n8n instance.


2. Google Sheets Credentials (Trigger): Click the 'Watch for New TikTok Links in Sheet' n8n trigger node. Authenticate your Google Sheets account (Google Sheets Trigger account) and select the specific spreadsheet document and sheet name you wish to monitor for new links.


3. Dumpling AI Credentials: This n8n workflow requires credentials for Dumpling AI. Set up a Generic HTTP Header Auth credential named 'n8n' (or similar) containing your Dumpling AI API key as a custom header or token. Apply these credentials to both 'Get TikTok Profile Data' and 'Get TikTok Video Transcript' n8n node steps.


4. Google Sheets Credentials (Output): In the 'Save Profile Stats and Transcript to Google Sheet' n8n node, link your standard Google Sheets OAuth2 API credentials and confirm the target spreadsheet ID and sheet name where results will be written.


5. Activation: Ensure all credentials are set, save the n8n workflow, and activate the n8n trigger to begin monitoring your sheet.

Watch for New TikTok Links in Sheet (Google Sheets Trigger): This n8n trigger node initiates the automation upon detecting a new row in a specified sheet (e.g., 'Videos'). It is the essential starting point for this automated n8n workflow.
Extract Username from TikTok URL (Set): A data manipulation n8n node that applies a regular expression (/@([^\/]+)/) to the input TikTok URL to accurately extract the creator's username required for the API lookups.
Get TikTok Profile Data using Dumpling AI (HTTP Request): This n8n node calls the Dumpling AI API (/get-tiktok-profile) using the extracted username to fetch key statistics like follower count, video count, and total hearts/likes. This is a critical component of the n8n workflow.
Get TikTok Video Transcript using Dumpling AI (HTTP Request): This n8n node calls the Dumpling AI API (/get-tiktok-transcript) using the original video URL provided by the n8n trigger to retrieve the full, clean transcript.

• Save Profile Stats and Transcript to Google Sheet (Google Sheets): The final n8n node uses the append operation to write the gathered profile statistics, the transcript, and the original video metadata back into the defined Google Sheet, concluding the data processing chain of this n8n template.