Monitor TikTok competitors with Scavio AI, Google Sheets, and Gmail alerts

How it works

Every 6 hours, reads competitor TikTok usernames from a Google Sheet. Resolves each username to a TikTok profile and fetches the 5 most recent posts via the Scavio API. Compares fetched posts against the last known video ID to detect new content. Logs every new post to a Posts tab with description, views, likes, comments, shares, and a direct TikTok link. Sends a Gmail alert summarizing what each competitor just posted. Saves sec_user_id and last_video_id back to the Competitors tab so the next run picks up where it left off.

Set up steps

Install the Scavio community node (n8n-nodes-scavio) from Settings > Community Nodes. Get a free Scavio API key at dashboard.scavio.dev -- 250 credits/mo on the free tier. Create a Google Sheet with two tabs: Competitors -- columns: username, sec_user_id, last_video_id. Add one TikTok username per row (without @). Leave sec_user_id and last_video_id blank; they are auto-populated. Posts -- columns: username, description, views, likes, comments, shares, link, detected_at. Open each Google Sheets node, attach your Google Sheets OAuth2 credential, and select your spreadsheet and tab. Open the Alert new posts Gmail node and set sendTo to your email address. Attach your Scavio API credential to the Get Profile and Get Latest Posts nodes. Activate the workflow.

Categories

Marketing, Social Media, TikTok, Competitor Analysis

Cost

Each competitor uses 2 Scavio API credits per run (1 profile lookup + 1 posts fetch). Running 5 competitors every 6 hours uses ~20 credits/day, fitting comfortably within the free tier of 250 credits/month.