Scrape TikTok profile & transcript with Dumpling AI and save to Google Sheets
This workflow automatically monitors Google Sheets for new TikTok links and uses Dumpling AI to extract comprehensive creator profiles and video transcripts. It eliminates manual data entry by logging follower counts, engagement metrics, and full text directly back into your spreadsheet for easy analysis. Ideal for marketing teams and researchers, it transforms social media URLs into organized, actionable insights instantly.
Run this with your team's AIWhat This Recipe Does
This automation transforms the way marketing teams conduct competitive research and content analysis on TikTok. By integrating Dumpling AI with Google Sheets, this workflow automatically extracts comprehensive profile data and full video transcripts from any TikTok account you specify. Instead of manually watching videos and transcribing hooks or captions, your team can now populate a centralized database with structured intelligence in seconds. The system captures essential metrics and textual content, providing a clear view of what resonates with audiences in your niche. This process eliminates the tedious manual labor involved in influencer vetting and trend tracking, allowing your strategists to focus on high-level creative decisions. By housing all this data in Google Sheets, you create a searchable repository of industry insights that can be shared across your organization to inform paid social campaigns, organic content planning, and brand positioning. This tool is essential for any business looking to scale their social media presence through data-driven decision-making rather than guesswork.
What your team gets
Forms and dashboards, so it is not a script only one person understands
Runs on your schedule in the cloud, so it does not stop when a laptop closes
Endpoints, so the rest of your stack can trigger the same work
Google Sheets connected for the team, not per person
How It Works
- 1
Open the recipe and connect your accounts
Connect Google Sheets once, in your team cloud, and nobody has to do it again on their own machine
- 2
Tell your own agent what is different about your process
Claude, ChatGPT, Cursor, whichever your team already uses. It adapts the recipe to how you actually work
- 3
Run it, then leave it running
It lives in your team cloud, so it keeps going after you close the laptop and every teammate's AI can use it
Who Uses This
- Content strategists who need to analyze viral scripts and hooks to improve their own video performance and engagement rates.
- Influencer marketing managers who require deep-dive data on potential brand partners to verify content quality and audience alignment before outreach.
- Market researchers tracking competitor activity to identify emerging trends and shifts in consumer sentiment across the TikTok landscape.
Frequently Asked Questions
What information is extracted from the TikTok profiles?
The automation retrieves detailed profile metadata and full video transcripts, allowing you to analyze both the creator's reach and the specific messaging used in their content.
Do I need to know how to code to use Dumpling AI?
No. This automation handles the technical communication with Dumpling AI. You only need to provide your API key and input the TikTok URLs into your designated Google Sheet.
How does the automation start running?
The workflow is powered by a Google Sheets trigger. As soon as you add a new TikTok URL or update a specific row in your spreadsheet, the automation begins the scraping process automatically.
Can I use the transcripts for content repurposing?
Yes. By capturing full transcripts in Google Sheets, you can easily use AI tools or writers to turn TikTok content into blog posts, newsletters, or LinkedIn updates.
Coming from n8n?
This recipe uses nodes like GoogleSheetsTrigger, Set, HttpRequest, GoogleSheets and 1 more. On Runwork, you don't need to learn n8n's workflow syntax. Describe what you want to your own AI agent in plain English.
Based on n8n community workflow. View original
Related Recipes
Automated YouTube video scheduling & AI metadata generation 🎬
The YouTube Content Intelligence automation transforms how marketing teams monitor and leverage video content. By automating the extraction and processing of YouTube data, this workflow eliminates the manual effort required to track competitors, monitor brand mentions, or gather industry insights. It systematically fetches video details, handles high volumes of data through intelligent batching, and removes duplicates to ensure your dataset remains clean and actionable. Instead of spending hours browsing channels and manually logging information, your team receives a structured feed of intelligence ready for analysis. This automation allows you to stay ahead of market trends, identify high-performing content patterns, and react to new video releases in real-time. By bridging the gap between raw video data and business strategy, you can optimize your content production and competitive positioning with data-driven precision.
Retweet cleanup with scheduling for X/Twitter
Maintaining a professional and focused brand presence on X requires a curated feed that highlights your original insights rather than a cluttered history of old retweets. The Automated Retweet Cleanup for X Accounts allows businesses and personal brands to automatically purge shared content after it has served its purpose. By scheduling regular cleanups, you ensure that your profile remains streamlined and relevant to new followers who are auditing your expertise. This automation systematically scans your account, identifies retweets based on your specific criteria, and removes them without requiring manual oversight. Beyond just tidying your timeline, the workflow includes error handling and Slack notifications to keep you informed of the process. This tool is essential for marketing teams who want to maintain a high-signal-to-noise ratio on social media while protecting their brand's long-term digital footprint.
Extract and merge Twitter (X) threads using TwitterAPI.io
The Twitter Thread Fetcher is a specialized automation designed to solve the problem of fragmented social media content. Instead of manually copying and pasting individual tweets from a long thread, this automation systematically extracts every post in a sequence and merges them into a single, cohesive document. This is particularly valuable for content marketers and researchers who need to archive high-performing social content or repurpose Twitter insights for other platforms like blogs, newsletters, or internal knowledge bases. By automating the retrieval process, businesses can save significant time and ensure that no part of a valuable discussion or announcement is lost. The automation handles the technical complexity of connecting to the Twitter API and restructuring the data, providing a clean, ready-to-use text output that preserves the original narrative flow of the thread.
Auto-post breaking news content using Perplexity AI to X (Twitter)
Maintaining a consistent and authoritative presence on social media is essential for brand growth, yet manually scouring the web for relevant news is a significant time sink. This automation bridges the gap between information gathering and content distribution by leveraging Perplexity AI to research current events and automatically drafting and posting updates to X (Twitter). Instead of spending hours each morning looking for industry trends, this workflow proactively identifies timely topics based on your specific criteria and shares them with your audience. By automating the research-to-publication pipeline, businesses can ensure they remain at the forefront of industry conversations without diverting resources from high-level strategy. This system transforms your social media profile into a real-time information hub, increasing engagement and establishing your brand as a thought leader in your niche. The result is a streamlined marketing operation that delivers consistent value to followers while operating entirely in the background.
Run this with the AI your team already uses
Your agent adapts it, your team cloud keeps it running, and everyone's AI can find it.
Open this recipe in Runwork