Log TikTok Hashtag Performance to Google Sheets Every Day
An n8n workflow that tracks the hashtags you care about on TikTok, records daily view counts and top videos to Google Sheets, and builds a growth chart over time — so marketers can prove which hashtags actually move views instead of guessing.
- 1
Define your hashtag list
A
Schedule Triggerat hour7starts the run, feeding aSetnode (or a lookup from a config sheet) that holds your tracked hashtags as an array. Keeping the list in one place makes it easy to add or remove tags without editing logic. - 2
Loop and scrape each hashtag
An
Item Listsnode splits the array, then anHTTP Requestruns an Apify TikTok hashtag actor per tag, returning the current view total and the top videos for that hashtag. - 3
Flag your own videos
A
Codenode checks the top videos' authors against your username and sets ayour_videos_in_topcount. It also computes the day-over-day view delta using yesterday's value stored in workflow static data. - 4
Shape the daily row
A
Setnode builds a clean row: date, hashtag, total views, daily delta, and how many of your videos rank in the top. Structured columns make the sheet chart-ready straight away. - 5
Append and chart
A
Google Sheetsnode appends each hashtag's row. Add a pivot or a line chart grouped by hashtag once, and you get a living performance dashboard that finally answers 'which hashtags are worth using?' with data.
Frequently asked questions
Which hashtags should I track?
A mix: your branded hashtag, 2–3 niche hashtags you post under, and 1–2 aspirational big ones you want to break into. Tracking a small focused set gives cleaner trend lines than dumping in twenty. You define the list once in a Set node or a config sheet.
Is the view count exact?
It's TikTok's own displayed hashtag view total, scraped via an Apify actor, so it matches what you see in-app. Treat the day-over-day delta as the signal — absolute totals include everyone's videos, but the daily change tells you whether a hashtag's momentum is rising or fading.
Can I see which of MY videos ranked under a hashtag?
Yes — the actor returns the current top videos for each hashtag. The workflow flags any whose author matches your username, so you can see when your content is breaking into a hashtag's top posts, which is a strong reach signal worth doubling down on.
Turn Every New YouTube Upload into an Email Newsletter Automatically
An n8n workflow that detects each new YouTube video, has Claude write a short, click-worthy email around it, and sends the campaign through your newsletter tool — so your subscribers hear about every upload the moment it goes live, with zero manual writing.
Free recipe
Auto-Optimize YouTube Video Descriptions and Tags for SEO with AI
An n8n workflow that reads each new video's transcript, has Claude write an SEO-optimized description, timestamped chapters and keyword tags, and saves the package to Google Sheets for a quick paste into YouTube Studio — turning throwaway descriptions into a search-traffic engine.
Free recipeAutomatically Log Daily YouTube Analytics to Google Sheets
An n8n workflow that pulls yesterday's views, watch time and subscriber change from the YouTube Analytics API every morning and appends them to a Google Sheet — giving creators a growing dashboard of channel performance without ever opening YouTube Studio.