SyncWith

Sync marketing data to Google Sheets and Looker Studio

Export YouTube video engagement stats to Google Sheets

Alex Black

Aug 13, 2021

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.

Endpoint

GET

Authentication

part

channelId

type

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]