This n8n workflow automates the process of monitoring a Google Sheet for new TikTok video links, extracting the creator’s username, fetching profile statistics, and retrieving the video’s transcript. It then records all relevant information back into the same sheet for easy data management. The workflow integrates Google Sheets for data input/output, Dumpling AI for TikTok data extraction, and uses HTTP requests for API interactions.

The process begins with a trigger when a new TikTok URL is added to a Google Sheet. It then parses the URL to extract the username using a regex match. This username is sent to Dumpling AI to retrieve profile details such as follower count, total videos, likes, and following count. Simultaneously, another API call fetches the video’s transcript from Dumpling AI. Finally, all collected data, including the video link, username, profile statistics, and transcript, are appended to the Google Sheet, enabling automated data collection and analysis.

This workflow is ideal for content creators, marketing teams, or researchers looking to monitor TikTok content performance and analyze transcripts without manual effort, ensuring accurate and timely data updates.