Template for TikTok, RapidAPI, and Google Sheets Services

Created by

Sk developer

Last update

Last update 17 hours ago

📊 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