Weekly TikTok competitor digest for marketing teams

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.

Additional information

What does this prompt do?

Each Monday, pulls the past week of TikTok videos from your competitor handles and category hashtags.
Ranks the top videos by views, engagement, and recency, then breaks down what made them work (hook style, format, pacing, on-screen text, theme).
Posts a Slack digest with the top five videos, a quoted hook for each, the format breakdown, and three content ideas your team can try this week.
Saves every suggested idea to a Notion content backlog with hook, format, source video link, view count, and engagement rate filled in.

What do I need to use this?

An Apify account (used to scrape TikTok with a public TikTok scraper).
A Slack workspace where the digest should be posted.
A Notion workspace with a content backlog database the workflow can write to.
A list of competitor TikTok handles and category hashtags you want to watch.

How can I customize it?

Change when it runs. The default is every Monday at 8am, but you can pick any cadence.
Adjust your engagement bar. Minimum views, like-to-view ratio, and how recent a video must be are all editable.
Add or remove competitor handles and category hashtags as your tracking list evolves.
Pick which Slack channel gets the digest and which Notion database the ideas land in.

Frequently asked questions

Do I need to know how to code to use this?

No. You describe what you want and the workflow author builds it for you. Once it is set up, the digest just lands in Slack every Monday and new ideas show up in your Notion backlog.

Can I track more than a handful of competitors?

Yes. You can add as many handles and hashtags as you want. Just remember that more accounts means more scraping, which can affect your Apify cost.

Can I change the engagement filter?

Yes. The minimum view count, the like-to-view ratio, and the recency window are all configurable. Loosen them to see more videos, tighten them to focus on the breakout hits.

What does the Notion backlog look like?

Each suggested content idea becomes a new row in the database you choose, with fields for hook, format, source video link, view count, and engagement rate.

What happens on quiet weeks when nothing clears the bar?

You still get a short Slack note saying the week was quiet so you know the workflow ran. No empty rows get added to Notion.