Weekly TikTok competitor digest with content ideas

Every Monday at 8am, run an agent workflow that produces a weekly creative intelligence digest for my marketing team based on what is working on TikTok in our category.

Use Apify's Run Actor Synchronously and Get Dataset Items operation against a TikTok scraper Actor (clockworks/tiktok-scraper is a good default, but make the Actor configurable) to pull the past week of TikTok videos from a configured list of competitor handles and category hashtags. The handle list, hashtag list, and the lookback window should all be configurable inputs at the top of the workflow so they are easy to edit without touching the agent instructions.

From the returned videos, filter to ones that clear an engagement bar. Default thresholds: at least 50,000 views, a like-to-view ratio of at least 5%, and a publish date within the last 7 days. These thresholds should also be configurable. Derive engagement rate from playCount, diggCount, commentCount, and shareCount on each video.

For the filtered videos, reason about what made the top performers work: hook style (question, bold claim, pattern interrupt, storytime, etc.), format (talking-head, voiceover, trend remix, demo, skit), pacing, on-screen text, and theme. Roll those observations into a short, plain-English summary of the week's pattern.

Post the digest to a configured Slack channel using the Slack Bot Send a Message operation. The digest should include: the top five videos as bulleted permalinks with the creator handle, view count, and a one-line quoted hook for each; a quick breakdown of which formats dominated this week; and three concrete content ideas the team could try this week, each tied to a hook, a format, and the source TikTok that inspired it. Keep the message visual and skimmable using Slack's mrkdwn formatting.

For every suggested content idea, also use Notion's Create a Page operation to add a row to a content backlog database the user picks at setup. Each row should populate fields for hook, format, source video URL, view count, and engagement rate.

If the scraper returns nothing or every video falls below the engagement bar, still post a short Slack message saying the week was quiet so the team knows the workflow ran, and do not create empty Notion rows in that case.