MYFRESHTOOLS
50% OFF
YouTube › Google Sheets

How to Connect YouTube to Google Sheets (No Code Required)

There's no one-click sync, but there are three reliable routes. Pick the one that matches your data.

Published 18 November 2026 · 7 min read
Quick answer
There is no built-in live connection between YouTube and Google Sheets. For your own analytics, use YouTube Studio's Advanced mode and export straight to Google Sheets. For playlist or video data from any public playlist, export it with YouTube Playlist Export and import the file into Sheets. For a sheet that refreshes itself, you need Apps Script and the YouTube Data API.

People want YouTube data in Sheets for very different jobs: a watch list for a class, a content calendar, a sponsor report, a tracker of competitor uploads. Searching "connect YouTube to Google Sheets" mostly turns up half-working formulas.

This guide sorts the options by the kind of data you need, walks through each one, and is honest about which ones break.

Pick a route

Four ways to get YouTube data into Sheets

RouteBest forEffortRefreshes itself?
Studio export to SheetsYour own channel's analyticsLowNo
CSV/Excel export, then importPlaylists, channel uploads, any public dataLowNo
Apps Script + YouTube APIA sheet that updates on a scheduleHigh (code)Yes, with a trigger
IMPORTXML formulasNothing reliableLowBreaks often
Your analytics

Option 1: Send Studio analytics straight to Sheets

Open YouTube Studio → Analytics → Advanced mode

Advanced mode gives you a table you can group by video, date, traffic source or country.

Set the range and add metrics

Choose the date range and add the columns you need, such as watch time or impressions.

Export → Google Sheets

Click the download icon and pick Google Sheets. A new spreadsheet opens in your Drive with the table, chart data and totals on separate tabs.

This is the only no-code way to get private metrics into Sheets. It only works for channels you manage, and it's a one-off copy. Full steps are in how to export YouTube Analytics.

Playlists and videos

Option 2: Import a CSV or Excel export

For a playlist (yours or anyone's), the route is export first, import second. Done by hand, that means copying every title and link from the playlist page into the sheet, which is fine for 10 videos and painful for 300.

Export the playlist to CSV or Excel

Use an exporter so you get one row per video with consistent columns.

In Google Sheets, choose File → Import → Upload

Drop the file in. For a CSV, set separator detection to automatic.

Choose where it goes

Pick "Insert new sheet" to keep each snapshot on its own tab, or "Replace current sheet" to refresh an existing one.

Build on top

Add a status column, filter by channel, sum durations or sort by views. Your added columns stay if you import new data on a separate tab and use lookups.

A simple pattern that scales: keep one "master" tab with your own notes, keyed on video ID, and import each fresh export into its own dated tab. A lookup pulls the latest views into the master tab, and nothing you typed gets overwritten.

Automated

Option 3: Apps Script and the YouTube API

If the sheet must update itself, open Extensions → Apps Script, add the YouTube Data API advanced service, and write a function that reads the videos you care about and writes rows to the sheet. Then add a time-driven trigger (daily, hourly) to run it.

Know the cost before you build

Apps Script calls count against your own Google project's YouTube quota, and you maintain the script when a field or limit changes. It's worth it for a long-running tracker, overkill for a one-time list.
The trap

Why IMPORTXML usually fails on YouTube

Formulas like =IMPORTXML(url, "//title") read the raw HTML of a page. YouTube builds most of its page with JavaScript after loading, so the formula often returns nothing, a cookie banner, or a value that changes when YouTube changes its markup. It may work for one cell today and show #N/A tomorrow. Don't build a report on it.


The tool

How MyFreshTools helps

What the tool does

YouTube Playlist Export turns one playlist into CSV, Excel, JSON and other formats, with durations, view, like and comment counts, publish and added dates, tags, descriptions and thumbnails. For many playlists at once, use Bulk Playlist Export, which gives one combined file or an Excel workbook.

Who it's for

  • Teachers and students turning a course playlist into a checklist.
  • Creators and marketers building reports in Sheets.
  • Anyone who wants a dated copy of a playlist they can sort and filter.

How to use it

Paste a playlist link

Or connect YouTube (read-only) to pick one of your own, including private ones.

Choose CSV or Excel

Both import cleanly into Google Sheets.

Import into Sheets

File → Import → Upload, then pick a new tab or replace the current one.

Requirements and limits

  • A free account is needed, and each export costs 1 credit.
  • The free plan exports part of the playlist; paid plans export every video.
  • It produces files, not a live connection. Sheets won't update on its own.
  • Private playlists need Connect YouTube (read-only) or a temporary switch to Unlisted.
  • Scheduled exports that email you a CSV are available on paid plans.
In practice

Examples

A course checklist for a class

A teacher exports a 60-video lecture playlist, imports it into Sheets, and adds a checkbox column and a 'week' column. Students copy the sheet and tick off each lecture; total duration is a simple SUM of the duration column once it's in seconds.

A weekly competitor tracker

An analyst imports a competitor's upload playlist into a new tab every Monday. A lookup on video ID compares this week's views with last week's, so the growth of each video is one column, with no script to maintain.

A self-updating view counter

A developer needs view counts refreshed every morning for a dashboard. That's the one case where Apps Script earns its keep: a short function reads the video IDs from column A, fetches statistics and writes them back on a daily trigger.

When it doesn't work

Troubleshooting

SymptomLikely causeFix
Everything lands in column ASeparator not detectedRe-import with "Detect automatically" or "Comma"
Durations look like datesSheets auto-formatted themFormat the column as plain text or Duration
Long video IDs lose leading charactersAuto-format turned them into numbersTurn off "Convert text to numbers" on import
IMPORTXML returns #N/AYouTube renders with JavaScriptUse an export or Apps Script instead

Frequently asked questions

No official live sync exists. YouTube Studio can send an analytics report to Sheets once, and Apps Script can call the YouTube API, but neither keeps a sheet updated on its own without a script and a trigger.

Yes. Export the playlist to CSV or Excel, then use File → Import in Google Sheets. Each video becomes a row with its title, channel, duration, views and link.

Only with Apps Script calling the YouTube Data API on a time trigger. Formula-based scraping with IMPORTXML is unreliable because YouTube pages are built with JavaScript.

No. An import is a snapshot. Re-export and re-import (choosing 'Replace current sheet') when you want fresh numbers, and keep the old tab if you want to compare.

A script you write runs under your own Google account, so it's as safe as the code in it. Only paste scripts you understand, and use read-only access unless the script needs to change something.

The takeaway

Studio covers your private analytics, a file export covers playlists and videos, and Apps Script covers automation. Skip the formulas; they're the one route that keeps breaking.

Related MyFreshTools tools