Scrape TikTok Profile & Transcripts to Google Sheets via Dumpling AI

This n8n workflow is designed for marketers, researchers, and content analysts to automate monitoring of TikTok influencers. It triggers on new video URLs added to a Google Sheet, extracts the username via RegEx, fetches comprehensive profile data (followers, likes, videos) and full video transcripts using Dumpling AI, then appends everything back to the sheet for seamless tracking.

Key benefits include eliminating manual profile checks and video watching, enabling scalable trend analysis, performance reporting, and outreach segmentation. It's ideal for agencies managing creators or tracking viral content without constant TikTok logins.

Setup is straightforward: connect Google Sheets for the trigger, input your Dumpling AI API key for the scraper agents ('get-tiktok-profile' and transcript tools), and the workflow runs automatically on new rows. Supports high-volume data extraction with no coding required, saving hours weekly on research tasks.

Use cases span competitive analysis, influencer benchmarking, content ideation from transcripts, and building databases for sales pitches. Robust error handling and data enrichment make it a powerhouse for business intelligence in social media.