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
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets
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
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets