Turn your YouTube, TikTok and Skool stats into a weekly report

Every week, pulls your YouTube, TikTok and Skool numbers, tracks growth, and emails you an AI-written performance report.

How the work actually flows

A straight line. Runs once per each platform youtube tiktok skool.

Pattern: Sequence (1) ยท Multiple Instances without Synchronization (12)

flowchart TD trig(["runs every Sunday"]):::trigtime s0[["pull stats from platforms"]]:::mi s1["compare to last week's numbers"]:::task s2["AI writes performance report"]:::task s3["email weekly report"]:::svc trig --> s0 s0 --> s1 s1 --> s2 s2 --> s3 out[/"weekly cross-platform growth report"/]:::out pay{{"clear view of what content works"}}:::pay s3 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepAn outside serviceRuns once per itemResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
Social Media ManagementEmail AutomationSpreadsheet & Database OpsReporting & Analytics
Connects
YouTubeTikTokSkoolAirtableGmailOpenRouter

The problem it solves

You post content across YouTube, TikTok, and your Skool community, but checking growth across three dashboards every week eats into time you could spend creating. It's easy to lose track of which videos actually moved the needle. Without a clear weekly snapshot, you're guessing at what's working.

Who it fits

Content creators, agencies, and community managers who track growth across multiple platforms.

How it works

  1. Runs automatically every Sunday
  2. Pulls your latest follower counts and video stats from YouTube, TikTok, and Skool
  3. Compares this week's numbers to last week's to calculate growth
  4. AI reviews your video transcripts and stats to explain what performed well and why
  5. Emails you a formatted report and saves the data for next week's comparison
What you get

Growth trends you spot before rivals do

You get a weekly snapshot that shows how your YouTube, TikTok and Skool audiences are growing and what content is working.

What you get

A weekly emailed report showing your growth and an AI explanation of what content performed best.

What you need

YouTube, TikTok, and Skool accounts, an Airtable account, a Gmail account, and an OpenRouter API key.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Post once and publish automatically across nine social platforms

Publish one piece of content to nine social networks at once instead of posting to each one by hand.

Advanced

Publish one video to Instagram, TikTok, and YouTube at once

Drop a video in Google Drive and the automation writes an AI description and posts it to three platforms at once.

Advanced

Repurpose viral reels into AI avatar videos and post everywhere

Finds trending reels, rewrites them for your brand, creates an AI avatar video, and posts it to every major platform.

Advanced

Publish new videos to Instagram, TikTok, and YouTube automatically

New videos dropped in Google Drive get AI-written captions and are posted to Instagram, TikTok, and YouTube automatically.

Advanced
Back to the AI Playbook