Daily Social Blade refresh for your Notion creator tracker
Every morning, refresh every row in your Notion creator tracker with the latest Social Blade subscribers, growth, grade, and earnings, then recap in Slack.
Notion
Social Blade
SlackMarketingOperationsData SyncResearch & MonitoringDaily DigestsBuild me a code workflow that runs on a daily cron schedule (default 8am in my local timezone) and keeps my Notion Creator Tracker database in sync with the latest Social Blade numbers, so the team always opens Notion to a fresh dashboard.
Trigger: cron, once per day.
Step 1. Use the Notion Query a Data Source operation to read every row in my Creator Tracker database. Each row carries a platform value (one of YouTube, TikTok, Instagram, Twitch, Twitter, or Facebook) and a handle or channel ID. The database ID and the property names should be configurable inputs on the workflow.
Step 2. Loop over the rows. For each row, branch on the platform value and call the matching Social Blade operation with the row's handle and the default history window:
- YouTube rows: Get YouTube Channel Statistics
- TikTok rows: Get TikTok Profile Statistics
- Instagram rows: Get Instagram Profile Statistics
- Twitch rows: Get Twitch Channel Statistics
- Twitter rows: Get Twitter Profile Statistics
- Facebook rows: Get Facebook Page Statistics
Check the Social Blade response envelope and only treat status.success === true as a successful lookup. If a lookup fails, capture the row and the error message and keep going (don't fail the whole run).
Step 3. For each successful lookup, use the Notion Update a Page operation on that row to overwrite these property values from the Social Blade payload:
- Subscribers or followers (total)
- 30 day growth percentage
- Social Blade grade
- Estimated monthly earnings (use the midpoint of Social Blade's low/high range)
- Last refreshed timestamp (now)
Step 4. After the loop, use Slack Send a Message to post a single recap to my ops channel (channel ID is a configurable input) summarizing:
- How many creators were refreshed successfully
- How many had a 30 day growth drop greater than 10 percent (list them by name and platform)
- Any rows that failed to refresh and why
- The current Social Blade credit balance (read info.credits.available from the last successful response) so the team notices before we run dry
Configurable inputs: cron time, Notion database ID, Notion property names (platform, handle, subscribers, growth, grade, earnings, last refreshed), Slack channel ID, and the percent drop threshold for the alert list (default 10).
What does this prompt do?
- Reads every creator row in your Notion Creator Tracker database, including the platform and the channel handle on each row.
- Pulls the latest Social Blade numbers for each one, covering YouTube, TikTok, Instagram, Twitch, Twitter, and Facebook.
- Writes the fresh subscriber count, 30 day growth, Social Blade grade, estimated monthly earnings, and a last refreshed timestamp back onto the same row.
- Posts a single Slack recap to your ops channel with how many creators were refreshed, who dropped more than 10 percent in 30 days, and how much credit is left on your Social Blade account.
What do I need to use this?
- A Notion workspace with a Creator Tracker database that has a platform field and a handle or channel ID field for each row.
- A Social Blade Business API account with credits available.
- A Slack workspace and a channel where the daily recap should be posted.
How can I customize it?
- Change the time of day the refresh runs, or move it to a few times a week instead of daily.
- Pick a different Slack channel for the recap, or send it to multiple channels.
- Adjust the 30 day drop threshold that flags a creator as falling, or add other red flag rules like grade changes.
FAQs
Which platforms does this support?
Do I need a paid Social Blade account?
What does my Notion database need to look like?
Can I change the time it runs?
What if a creator's handle changes?
Related templates
When your flight moves, your calendar times get corrected automatically and you get a Slack note naming the meetings you're about to miss.
Every 15 minutes, forwarded phishing reports get traced back to the server that really sent them, with a verdict in Slack and the worst senders reported.
Every weekday at 7am, sign in to the tender portals you track, filter new notices against your bid criteria, and open a deal for the ones worth chasing.
Every Monday, rank the week's matches by expected demand, put the big ones on your venue calendar, and post a rota-ready summary to Slack.
Every Monday, last week's survey answers and support conversations become one themed report in Notion, with the top five themes posted to Slack.
Every Tuesday we pull your best new reviews, draft social captions, email testimonials and product page quotes, then stage them in Notion for approval.
Stop hand updating your creator dashboard.
Connect Notion, Social Blade, and Slack once, and Geni keeps your Creator Tracker fresh every morning.