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.
Integrations
Notion
Social Blade
Slack
Type
Categories
- Marketing
- Operations
Build 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 it does
- 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 you’ll need
- 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 to 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.
Use cases
- Data Sync
- Research & Monitoring
- Daily Digests
