Template for TikTok, RapidAPI, and Google Sheets Services

Description

📊 TikTok Account Monitoring Automation

This n8n workflow automates the daily process of fetching TikTok account analytics using the TikTok API and logging the results to Google Sheets.

It helps marketing teams, social media managers, and influencer agencies track video performance and audience growth across multiple TikTok usernames without manual effort.

🔁 Workflow Summary

⏰ Trigger via Schedule
The workflow runs automatically every day (or any custom interval), ensuring data is consistently updated without manual input.

📥 Sheet 1 – Read TikTok Usernames
A Google Sheet stores the list of TikTok usernames you want to monitor.
✅ Example Columns:
username
category
priority
notes

🔁 Loop Through Each Username
Each username is processed individually in a loop to make separate API calls and avoid data conflicts.

📡 Fetch Analytics via RapidAPI
The following TikTok API endpoint is used:
POST https://tiktok-api42.p.rapidapi.com/videos_view_count.php
You get per-user stats like:
Number of videos
Total views
Recent video views
This endpoint is highly stable and works without TikTok login or auth.

📤 Sheet 2 – Append Analytics Results
Fetched data is logged in another Google Sheet for performance tracking.
✅ Example Columns:
username
total_videos
total_views
average_views
fetch_date
category

📦 Sheet 3 – Log API History or Errors
A third sheet stores logs of API fetch status, failures, or skipped usernames for debugging.
✅ Example Columns:
username
status (e.g., success, failed, skipped)
message
timestamp

🔐 RapidAPI Notes

You must have an API key from TikTok API
All requests are made to https://tiktok-api42.p.rapidapi.com
The main endpoint in use is:
POST https://tiktok-api42.p.rapidapi.com/videos_view_count.php
Each request uses POST with params like username, region, number
The response is JSON and easy to parse in n8n workflows

📌 Optional Extensions (Same API, More Insights)

This same TikTok API also supports other advanced endpoints that can be added to enrich your workflow:

| Endpoint Name | Functionality |
|---------------------------|------------------------------------------------------------------|
| User Profile Data | Get bio, profile image, followers, likes, etc. |
| User Account Stats | Extract detailed user metrics (likes, comments, shares) |
| User Audience Stats | Know where their followers are from and gender split |
| Historical Data | Track historical performance trends (useful for growth charts) |
| HashTags Scraper | Find trending or related hashtags used by the user |
| Related User Info | Suggest accounts similar to the one queried |
| Videos Views Counts | Already used to get view stats for multiple videos |

Each of these can be added using HTTP Request nodes in n8n and plugged into the same sheet or separate ones.

✅ Benefits

🔄 Fully Automated: No manual copy-paste or login required
📊 Centralized Analytics: Track all creators or clients in one dashboard
📈 Performance Insights: Daily growth visibility with historical tracking
📤 Data Export Ready: Stored in Google Sheets for easy share/report/export
🔧 Scalable & Flexible: Add hashtags, followers, or audience demographics

🧠 Use Cases

Influencer Agencies** tracking clients' TikTok growth daily
Brands running UGC Campaigns** who want to monitor video traction
Analysts** building dashboards from Sheet-to-DataStudio/Looker
Marketers** analyzing viral trends or creators across niches

📌 Final Note

This workflow is extendable. You can:
Merge multiple endpoints per user
Schedule it weekly or monthly
Send email summaries
Push to Slack or Google Data Studio

> API Used in this workflow:
> TikTok API