Skip to content
ClickRuntime

Connect Google Sheets to YouTube

A Google Sheet is where many creators plan their videos, track what is published and keep lists of channels to watch. YouTube is where the work goes live. Connecting them turns the sheet into a publishing queue and a running record, so nobody copies titles, links and numbers between the two by hand.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and YouTube

Publishing queues, comment reports, playlist summaries and channel tracking, run from the sheet you already plan in. These are ready-made starting points. Anything else you can describe works too.
DailyAI

Publish the next video from your sheet's queue

Each day the next ready video in your sheet is uploaded to YouTube with an AI-written title and description, and its row is marked published.

See how it works
WeeklyAI

Get a weekly report on what your YouTube viewers say

Comments on your recent videos are collected into a sheet, and every week you get an email on what viewers liked, asked and complained about.

See how it works
DailyAI

Summarise new videos in a playlist every day

Each day, new videos added to a playlist you follow are summarised in a sheet, and you get a short email with the list.

See how it works
Daily

Keep a sheet of new videos from channels you follow

A sheet keeps a running list of every new upload from the channels you watch, and Slack gets a daily digest.

See how it works
Hourly

Upload Drive videos to YouTube at the time in your sheet

Videos you have put in Drive go up to YouTube at the date and time you set in a sheet, and the row is updated with the link.

See how it works
DailyAI

Keep your YouTube titles and tags in line with a sheet

Your videos' titles, tags and visibility follow rules you keep in a sheet, and every change is logged.

See how it works
On a schedule

Log daily YouTube channel stats to Google Sheets

One row per channel per day records subscribers, total views and video count, with the change since the day before.

See how it works
On a schedule

Export YouTube video stats to Google Sheets

Every Sunday night a Videos tab is rewritten with every upload on the channel: title, publish date, duration, views, likes, comments and link.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Sheets and YouTube, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets and YouTube automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and YouTube in your own words, with your conditions, other apps or an AI step, and 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.

For example, ask your assistant

Every day, log new YouTube comments to my sheet and only highlight the row in a Priority column when the AI thinks the comment is a business or sponsorship inquiry.

Each week, compare every video's views to its first-week average in my sheet and flag any older video that is suddenly getting twice its normal traffic.

Use cases

Why people connect Google Sheets and YouTube

How the two apps work together

  • The script checks the sheet every few minutes for rows marked ready and uploads or updates the matching YouTube video.
  • YouTube does not send webhooks for new comments or stats, so those are collected on a schedule, such as daily.
  • Results like video IDs, links and status are written back to the same row so the sheet stays the source of truth.

  • Creators plan uploads in a content calendar sheet

    Title, description, tags and publish date live in a Google Sheet, and the video is published or scheduled when its row is marked ready. The editor and the channel owner work from the same list.

  • Marketing teams track video performance weekly

    Views, watch time, likes and comment counts for each video are written to a sheet every week. The team can chart growth and compare videos without exporting from YouTube Studio.

  • Agencies report on several client channels

    Each client's channel stats are pulled into its own tab, ready to share. Account managers stop copying numbers by hand before monthly calls.

  • Community managers review comments in bulk

    New comments are logged to a sheet with an AI label for question, praise or complaint. Someone can work through the questions column and reply from YouTube.

More apps

Google Sheets, YouTube and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Weekly YouTube stats in Sheets and Slack

Every Monday, add last week's views and watch time for each of my YouTube videos to my Channel Stats sheet and post the top three videos in #marketing on Slack.

Upload Drive videos listed in a sheet

When a row in my Upload Queue sheet is marked ready, take the video file from the Drive link in that row and upload it to YouTube as unlisted with the title and description from the sheet.

Announce scheduled videos on X

When a video in my content sheet goes public on YouTube, post the title and link on X using the short caption from the sheet's Caption column.

Setup

Connect Google Sheets and YouTube once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

YouTube

Video / Social

  1. In Google Cloud Console, enable the YouTube Data API v3 for your project.
  2. Under Credentials, create an API key and restrict it to the YouTube Data API. In the ClickRuntime dashboard, save it as a secret on Connections & secrets.
  3. For channel actions, set up the OAuth consent screen with the https://www.googleapis.com/auth/youtube scope, then create a Web OAuth client with the redirect URI https://clickruntime.com/oauth/callback.
  4. In the ClickRuntime dashboard, open Connections, choose YouTube and enter your OAuth client ID and secret, then authorise your channel.

FAQ

Questions about connecting Google Sheets and YouTube

How does ClickRuntime get access to my YouTube channel?
You connect your Google account in your ClickRuntime dashboard and approve YouTube access. Automations that only read public videos can use a YouTube API key instead.
Is there a limit on uploads?
YouTube gives each project a daily quota, which by default allows around six uploads a day. Reading videos and comments uses far less, so tracking and reports are rarely affected.
Does it need access to all my Drive files?
No. It uses the Sheets permission for the spreadsheet you name, plus YouTube access for your channel.
Can several people work from the same sheet?
Yes. Anyone who can edit the sheet can add videos to the queue or read the reports, without a YouTube login.
Will it overwrite my notes in the sheet?
No. It only writes to the columns you name, such as status or video link, and leaves the rest alone.
Can it update videos that are already on my channel?
Yes. The script can read existing videos into the sheet and change titles, descriptions or tags when you edit the row, as long as you own the channel.
How often are the stats refreshed?
As often as you schedule it, every 5 minutes or slower. YouTube Analytics data itself usually lags by a day or two, so a daily run is normally enough.
Does the sheet need specific column names?
No fixed layout is required. Tell your assistant which columns hold the title, description and status, and the script uses those.

Related pages

Keep exploring

Tell your assistant what Google Sheets and YouTube should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude