This n8n workflow automates the process of collecting TikTok user profile and video statistics using RapidAPI, then logs the data into Google Sheets for analysis and reporting. Triggered on a schedule, the workflow reads a list of TikTok usernames from a Google Sheet and processes each user in batches.

The process begins with a scheduled trigger that initiates the workflow at predefined intervals. The Google Sheets node fetches usernames from a master list. A ‘Loop Over Items’ node iterates through each username, and for each, two HTTP requests are made to RapidAPI endpoints: one to retrieve user profile details (‘Fetch Profile’) and another to gather video view counts (‘Fetch Videos’).

Data retrieved from both API calls are then appended to separate Google Sheets: one for profile stats and another for video stats, effectively creating an automated dashboard to monitor TikTok influencers or competitors. This workflow is ideal for social media managers, marketing teams, or digital analysts who need to regularly track TikTok performance metrics across multiple users without manual effort.