Scheduled TikTok Analytics Reporting via RapidAPI to Google Sheets - n8n Workflow

• Social media managers requiring automated daily reports.


• Marketing agencies tracking client or competitor TikTok performance.


• Data analysts needing scheduled metric collection using a powerful n8n node setup.


• Users looking for advanced social media reporting n8n templates.

This expert n8n workflow template solves the challenge of manually monitoring large sets of TikTok profile metrics. By leveraging a scheduled n8n trigger, it automatically reads a list of target usernames from a Google Sheet, uses RapidAPI via the HTTP Request n8n node to fetch real-time follower counts, likes, and total video views, and then consolidates all this crucial data into a designated Google Sheet log. This efficient n8n workflow structure ensures reliable, hands-off data collection for competitor analysis or client reporting. Utilizing this n8n template allows users to maintain a historical database of key TikTok statistics effortlessly.

The process begins with the Schedule Trigger, an essential n8n trigger node that initiates the entire n8n workflow template execution based on a defined time interval.

1. Read Input: The initial Google Sheets n8n node reads the list of TikTok usernames from a specified input spreadsheet.


2. Iterate: The Loop Over Items n8n node splits the retrieved list, processing each username individually.


3. Fetch Profile Data: For each username, the Fetch Profile n8n node (an HTTP Request) calls the RapidAPI userprofile.php endpoint to retrieve metrics like total likes, video count, and follower/following counts.


4. Log Profile Stats: The Profile Stats Google Sheets n8n node immediately appends this profile data, along with the current date, back to a results sheet.


5. Fetch Video Data: Next, the Fetch Videos n8n node calls the RapidAPI viewcount.php endpoint to get deeper video metrics, such as total views and total posts.


6. Log Video Stats: Finally, the Videos Stats Google Sheets n8n node appends this detailed video information to the sheet, completing the cycle for the current username before the Loop Over Items node proceeds to the next profile.

To deploy this automated n8n workflow, follow these steps:

1. Import: Copy the provided n8n workflow JSON and paste it into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Credentials Setup:

1. Sheet Configuration: Configure the 'Google Sheets' n8n node to point to the Document ID and Sheet Name containing your list of TikTok usernames.


2. Destination Sheets: Configure the 'Profile Stats' and 'Videos Stats' n8n node instances to point to your desired output spreadsheet where the analytics should be logged.


3. Activation: Set the Schedule Trigger interval and activate the n8n workflow.

Schedule Trigger (n8n trigger): Initiates the entire n8n workflow on a recurring schedule, ensuring automated execution.
Google Sheets (Read): Reads the input data. Key configuration involves specifying the Document ID and Sheet Name containing the list of TikTok usernames to analyze.
Loop Over Items (n8n node): Essential utility node that processes the input sheet data row by row, ensuring independent API calls for each username.
Fetch Profile (HTTP Request n8n node): Sends a POST request to tiktok-api42.p.rapidapi.com/userprofile.php. Key Configuration: Uses an expression ={{ $json.username }} to dynamically input the username from the loop and requires the x-rapidapi-key header.
Profile Stats (Google Sheets n8n node): Appends collected profile data (likes, followers, videos) to the output spreadsheet. It uses expressions to map data points like {{ $json.userProfile.followerCount }} directly from the previous n8n node output.
Fetch Videos (HTTP Request n8n node): Sends a POST request to tiktok-api42.p.rapidapi.com/viewcount.php to fetch total video statistics. Key Configuration: Uses the RapidAPI host and key, similar to the Fetch Profile n8n node.

• Videos Stats (Google Sheets n8n node): Appends the video-specific metrics (total views, total posts) to the destination sheet, finalizing the data logging step of this n8n workflow iteration.