Youtube Channel Statistics

This Google Apps Script pulls data from a Youtube channel's public video data to Google Sheets.

Table of Contents

• Introduction
• Instructions
• Authorization
• Script Explanation

Introduction

This script is used to retrieve and display public video data of a Youtube channel. The script gets the channel URL In column A2 as input and fetches all the video details from that channel, such as video title, publish date, views, comments, likes and the thumbnail of the video. In addition, the subscriber count and total number of videos for the channel are also fetched. The script outputs all the data to the Google Sheet.

Instructions

• Open a Google Sheet.
• Input the Channel Url in column A2.The URL should be in this format: https://www.youtube.com/channel/CHANNEL_ID.
• Click on the "Tools" menu, then select "Apps script"
• Copy and paste the code from this repository to the Apps script.
• Save the project with a name of your choice.
• Update the apiKey variable in the getVideosFromChannel and getVideoDetails functions with your own API key. You can get an API key from the Google Cloud Console. Click here
• Click on run to manually execute the script or set a trigger to run the script once there's an edit.

How to find a Channel's Id ?

Search any video of that channel and click on the that

Click on the channel name

Copy the highlighted part, which is channel's Id

Authorization

When running the script for the first time, you will need to grant permissions to the script to access your Google account and Youtube data. The script will ask for permission to:

• View and manage your spreadsheets in Google Drive
• View and manage your YouTube account

Script Explanation

The script starts with defining a function updateChannelData. The updateChannelData function uses several other functions to extract the data from the channel's public video data, format it, and then output it to the Google Sheet.

The clearSheet(sheet) function clears all the existing conditional formatting rules and content of a sheet except for cell A2. if a new Channel Url is inputted, it clears the previous data.

The getVideosFromChannel function gets the playlist ID for the channel and then fetches the video details of the videos in the playlist using the Youtube Data API. The getVideoDetails function takes a video ID and returns the details of the video, including title, views, likes, dislikes, etc.

The extractChannelIdFromUrl function extracts the channel ID from the URL provided. The getChannelProfileAnalytic function gets the channel's public profile data, including the subscriber count and total number of videos.

The design function is used to design the output sheet.

The updateChannelData function then populates the sheet with the required data.

Finally, the updateChannelData function calls the design function to format the output.

Link to the sheet click here