Skip to content

On a schedule

Get a weekly email on your YouTube channel's numbers

Every week you get an email with your latest videos, their views and likes, and what changed since last time.

Runs
On a schedule
Apps
Gmail, YouTube
AI
Optional
Access
YouTube API key; Gmail gmail.send

Send this to your assistant

Create a ClickRuntime automation: every Monday, email me my channel's latest videos with views, likes and comments, and how much each grew since last week. Add a short AI summary of what's working.

Paste it into your assistant. It tells you what it will send or change before it runs live.

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

A small business publishes a video a week and wants to know whether it is worth the effort. YouTube Studio has the numbers, but nobody opens it. When the owner asks how the channel is doing, nobody can say.

A weekly email with the numbers and how they changed gives everyone an honest picture, and makes it easy to spot which kinds of video are working.

What you get out of it

  • Know how the channel is doing

    Views, likes and comments for each recent video, without opening YouTube Studio.

  • See the change, not just the total

    Each number shows how much it grew since last week, which is what tells you if a video is still finding viewers.

  • Spot what works

    With AI on, a short summary points out which topics or formats are doing better.

  • Easy to share

    Forward the email to your team or client, or send it to them directly.

How it works

What happens, step by step

  1. Every week, ClickRuntime fetches your channel's most recent videos and their views, likes and comments.

  2. It compares each number with what it saved last time.

  3. If AI is available, it adds a short summary of what is working.

  4. The report is emailed to you, and this week's numbers are saved for next time.

Before it runs live

  • Connect Google through your own Google app (a one-time, 10-minute setup), so it works with your own Gmail
  • Connect YouTube

What you get

RunsOn a schedule
Get a weekly email on your YouTube channel's numberstoday, 9:00Succeeded
Email · Your YouTube weekTutorials keep growing while vlogs level off. Pivot tables for beginners: 12,480 views (+2,310), 418 likes, 57 comments.

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.
  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

  • Run it at a different time, more or less often, or only on weekdays
  • Change what the AI looks for, or how it writes the result
  • Add another app, for example also send it to Slack
  • Combine it with other Gmail and YouTube steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.
daily_or_weekly_channel_performance_email.pyexample
import base64
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, http, credentials, ai, state

YT = "https://www.googleapis.com/youtube/v3"

def yt(path, **params):
    return http.get(f"{YT}/{path}", params={**params, "key": credentials.secret("YOUTUBE_API_KEY")}).json().get("items", [])

def api(name, version):
    return build(name, version, credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)

def send_gmail(to, subject, text):
    raw = base64.urlsafe_b64encode(f"To: {to}\r\nSubject: {subject}\r\nContent-Type: text/plain; charset=utf-8\r\n\r\n{text}".encode()).decode()
    api("gmail", "v1").users().messages().send(userId="me", body={"raw": raw}).execute()

UPLOADS = "UUxxxxxxxxxxxxxxxxxxxxxx"

@on_trigger
def run(event):
    ids = [i["contentDetails"]["videoId"] for i in yt("playlistItems", part="contentDetails", playlistId=UPLOADS, maxResults=15)]
    last, now, lines = state.get("stats") or {}, {}, []
    for v in yt("videos", part="snippet,statistics", id=",".join(ids)):
        s = v["statistics"]
        views, before = int(s.get("viewCount", 0)), last.get(v["id"], {}).get("views", 0)
        now[v["id"]] = {"views": views}
        lines.append(f"{v['snippet']['title']}: {views:,} views (+{views - before:,}), {s.get('likeCount', 0)} likes, {s.get('commentCount', 0)} comments")
    text = "\n".join(lines)
    try:
        text = ai.generate(text, system="In 3 sentences, say what's working on this channel.", max_output_tokens=200).text + "\n\n" + text
    except ai.AIError:
        pass
    send_gmail("you@example.com", "Your YouTube week", text)
    state.set("stats", now)
    return {"videos": len(lines)}

FAQ

Common questions

Does it need access to YouTube Analytics?
No. It uses the public view, like and comment counts, which only need an API key.
Can it send daily instead?
Yes. Daily works well while a new video is getting its first views; weekly suits the long run.
Can it report on several channels?
Yes. List the channels and each gets its own section.
What permissions does it need?
YouTube API key; Gmail gmail.send. Nothing else in your accounts is used.
Does it need AI?
No, but you can ask for an AI step (for example a summary). It then uses ClickRuntime's built-in AI allowance.
How many runs does it use?
One run each time it runs (on a schedule). Checks that find nothing to do and stop right away aren't counted.
Can I change how it works?
Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Set up “Get a weekly email on your YouTube channel's numbers” from your assistant

Copy the prompt above, or connect your assistant first. Free plan, no credit card.