TikTok Keyword Trend Tracker: API Direct → Sheets + Slack Alerts

Track TikTok keyword trends automatically—log them to Google Sheets and alert Slack when videos go viral

This n8n workflow searches TikTok every morning for recent videos matching your keyword via API Direct, appends new results to Google Sheets, and sends a Slack breakout alert whenever a video’s play count meets or exceeds your configurable viral threshold.

What this workflow does

• Runs on a daily schedule to scan TikTok for freshness.
• Uses your settings for the target TikTok keyword and the viral play-count threshold.
• Searches TikTok for the last 24 hours of videos using API Direct.
• Prevents duplicate logging by tracking seen URLs from previous active runs—so only new videos are recorded.
• Appends each new video to a Google Sheets trend log with: date, author, title, url, plays, likes, shares, comments.
• Triggers a Slack message for any newly found video whose plays are >= the viral threshold.

Use cases

• SaaS operators monitoring competitive keywords for emerging content themes.
• Marketing teams tracking performance signals and getting instant Slack alerts for potentially viral posts.
• Automation engineers using API Direct + Sheets + Slack to build a repeatable TikTok keyword trend pipeline.
• Content researchers maintaining a structured archive of trending videos and engagement metrics.

Technical details

• API Direct: API key credential required for the “Search TikTok videos” step.
• Google Sheets: OAuth connection to append rows to your selected spreadsheet/sheet.
• Slack: credential connection and channel selection for breakout alerts.
• n8n nodes used: if, set, code, slack, plus a sticky note for guidance.
• Workflow behavior: scheduled morning runs; seen-video memory persists between runs after activation.

Ready to react to TikTok keyword trends in real time? Install this n8n automation to keep Google Sheets updated and turn viral play-count spikes into immediate Slack notifications.