video

Export YouTube video engagement stats to Google Sheets

Alex Black

Alex Black

Overview

If you install the SyncWith Google Sheets Addon, you can then use the YouTube API to import a list of your channel's videos into Google Sheets, and then using that you can pull engagement statistics for each video including total counts of likes, comments, views and more!

Step 1: List your channel's videos

The key here is to find your channel ID, which you can find in the URL when you click "Your videos" in YouTube.
Paste in your channel ID to get a list of all your videos.

List videos by channel [YouTube]

Please fill in any necessary fields and click Run.

GET

Preview

View the API data, get a live Google Sheet dashboard

id.videoId
snippet.publishedAt
snippet.channelId
snippet.title
snippet.description
snippet.thumbnails
snippet.channelTitle
snippet.liveBroadcastContent
snippet.publishTime
         
         
         

Get a live Google Sheet

Export your data to a google sheet, with the SyncWith Addon, or download to CSV

Automatically updated

Add data sources

Build reports & dashboards

Step 2: Get statistics on each video

Next you can paste a single video ID in here, or multiple IDs separated by commas. Using the SyncWith Addon you could use cell references to run this request once for each video in the list from step 1, you could even use a formula to concatenate all the IDs into a comma separated value to get stats in a single call.

Get video statistics [YouTube]

Please fill in any necessary fields and click Run.

GET

Preview

View the API data, get a live Google Sheet dashboard

id
statistics.viewCount
statistics.likeCount
statistics.dislikeCount
statistics.favoriteCount
statistics.commentCount
      
      
      

Get a live Google Sheet

Export your data to a google sheet, with the SyncWith Addon, or download to CSV

Automatically updated

Add data sources

Build reports & dashboards