Weekly TikTok content brief in Notion

By General Input

Every Sunday evening, mine the last 30 days of your TikTok posts, draft 5 fresh video ideas, and drop them into Notion with a Slack heads-up.

Integrations

  • TikTok
  • Notion
  • Slack Bot

Type

Agentic Task

Categories

  • Marketing

Build me an agent workflow that produces a weekly TikTok content brief in Notion, grounded in what actually worked on my own account.

Trigger: a cron schedule that runs every Sunday at 6pm in the creator's local time. One run per week.

Integrations: TikTok (to read my posts and stats), Notion (to write the brief), Slack Bot (to send the heads-up).

On each run, the agent should do the following:

1) Pull my TikTok posts from the last 30 days. Use TikTok List Videos to page through my recent uploads (filter or stop once the created time is older than 30 days), then use TikTok Query Videos to fetch full details for each video ID, including caption, hashtags, view count, like count, comment count, share count, and duration. Compute an engagement rate per post (likes + comments + shares) divided by views.

2) Mine the data for patterns. Identify the top quartile of posts by views and by engagement rate. Look for recurring hooks in captions (opening lines, question openers, list frames), hashtag clusters that appear across high-view posts, topics or formats that overperformed, and topics or formats that underperformed. Note the sample size honestly, if the creator only posted a few times, say so.

3) Draft 5 fresh video briefs for next week. Each brief has: a working title, a one-sentence hook, a three-bullet outline of what happens in the video, 3 to 6 suggested hashtags, and a one-line note on which past-post pattern it is riffing on (e.g. 'riffs on the question-opener hook from your top post about X'). The five briefs should feel varied, not five copies of the same idea.

4) Write the brief to Notion. Use Notion Create a Page under a parent page or database the creator picks (something like 'TikTok Content Briefs'). The new page title should include the date range, e.g. 'Week of Mon DD'. The page body starts with a short 'What worked and what did not' preamble (3 to 6 sentences summarizing the patterns from step 2), then the 5 briefs as clearly separated sections. Return the new page URL.

5) Send a Slack heads-up. Use Slack Bot Send a Message to a channel or DM the creator picks. Keep it tight: a two-line teaser (e.g. one line naming the biggest insight from this week, one line teasing one of the brief titles) and a link to the new Notion page. No wall of text in Slack, the Notion page is where the substance lives.

Configuration the creator should be able to set on install: the TikTok account, the Notion parent page/database ID, the Slack destination (channel or DM), and optionally the schedule and the lookback window (default 30 days).

Guardrails: if TikTok returns fewer than 3 posts in the window, still run but say so in the preamble and widen implicitly to the last 60 days for that run only. If Notion write fails, do not send the Slack message, surface the error instead. Never invent post metrics, only use numbers TikTok returned.

Related prompts

Explore more prompts
A brand asset library your marketing team actually searchesTurn Mailjet email clicks into ranked HubSpot follow-upsClean out the Looker dashboards and Looks nobody opensLiveKit live operations console for room moderationWake up dormant Keap leads with a researched reasonLiveChat coverage board for planning next week's shiftsPhone routing control panel for LiveKit voice agentsLinkedIn Ads budget pacing dashboard for every client accountGive your team Looker numbers without buying more seatsPause marketing emails to escalated customers, then restore them