Quick overview
Quick overview This workflow runs weekly to scrape TikTok search results with Bright Data, calculates which hashtags and sounds outperform each topic’s median engagement, uses OpenAI GPT-5.6 to infer the content format from top captions, logs results to Google Sheets, and posts a ranked digest to Slack. How it works Runs weekly on a schedule and loads the topic list and thresholds (posts per topic, minimum plays, lift, and cooldown) from a central configuration. Triggers a Bright Data TikTok discovery scrape for each topic, then polls the Bright Data progress endpoint until the snapshot is ready (or times out). Downloads the scraped posts and computes per-post engagement rate, then aggregates results by hashtag and by sound and keeps only groups that beat the topic’s median engagement by the configured lift and have enough posts. Reads previously logged tags from Google Sheets and filters out any tag/sound that was reported within the cooldown window. Uses OpenAI GPT-5.6 to extract a content format, angle, and topics from the captions of each tag’s best-performing posts, then ranks the final list and generates a short strategy brief. Appends one row per selected hashtag/sound to Google Sheets and posts a formatted ranked digest (with metrics and best-post links) to the configured Slack channel. Setup Add a Bright Data API key as an HTTP Header Auth credential (Authorization: Bearer YOUR_KEY). Connect OpenAI (Chat) credentials for the GPT-5.6-terra model used to extract formats and write the brief. Connect Google Sheets credentials and create a spreadsheet with a "Tags" sheet, then set the Google Sheets URL in the configuration. Connect Slack credentials and set the target channel name in the configuration. An n8n automation workflow template by Daniel Shashko.
Daniel Shashko
web
free
Others in the same category, ranked by how often they are opened.
