TubeSub to Sheets: YouTube Subscription Exporter

At GAS LAB, we plan and develop automation tools and AI tools that require no programming knowledge and can be used immediately.

Many YouTube users 'subscribe' to specific channels, keeping them updated with their favorite content as it's released.

As time passes, the number of channels you're subscribed to on YouTube can increase. Some may wish to export and list all their subscribed channels at once. Unfortunately, YouTube does not have a native feature to export a list of subscribed channels. Thus, to check your list of subscribed channels, you must manually look at your 'Subscribed Channels' and list them out in Excel or a spreadsheet if you want to manage them that way.

Having an automatic list of your subscribed channels, making them viewable at a glance, can be very helpful for organizing and analyzing your subscriptions.

This need led us to develop a tool that allows you to export a list of your YouTube subscriptions to Google Sheets!

TubeSub to Sheets: YouTube Subscription Exporter

This tool, using your Google Account, can export a list of your subscribed YouTube channels to Google Sheets.

But it doesn't just export a list of channel names. The tool also extracts a range of data, such as the channel's URL, its thumbnail image, its creation date, and other basic information about the channel. Additionally, it can pull quantifiable data useful for analysis, such as the number of videos, view count, and subscriber count.

The data from your list of subscribed channels is exported to Google Sheets, making it easy to do keyword searches, filter and sort numerical data, add new columns for notes or categories, and add analytic metrics using functions. You can also easily share the data with others.

This tool is a one-time purchase. You can use it on any OS (Mac, Windows, etc.) as long as you can access Google Sheets.

The tool is designed to be extremely simple to use. It's fully operable with simple clicks. So, even if you've only ever used a spreadsheet software like Excel or Google Sheets a little, you'll find it easy to use.

If you want to list your subscribed YouTube channels, analyze your subscriptions, or share your subscriptions with others, this tool is highly recommended.

Three features of TubeSub to Sheets

For detailed tool specifications, please refer to the following usage guide page.

・How to Use TubeSub to Sheets

1.Automatically fetches and outputs a list of your YouTube subscribed channels

• This tool can automatically fetch and output a list of YouTube channels that you have subscribed to using your own account via the YouTube API.
• The list of subscribed channels that can be fetched and output includes not only basic information about the channel such as channel name and channel creation date, but also quantitative data useful for analysis such as total number of video views, number of video posts, and number of channel subscribers.

2.Outputs data to Google Sheets, making analysis, processing, and sharing convenient!

• The output destination for the YouTube subscribed channel list data fetched by this tool is "Google Sheets".
• Therefore, you can easily analyze, process, and share the data.
• Also, by using the functions of Google Sheets, you can also output the data in Excel or CSV file format.

3.Simple specifications make it easy to use even for beginners!

• The usage of this tool is very simple and suitable for beginners.
• Basically, it's a tool that can be operated with a click, so if you have experience using spreadsheet software such as Excel or Google Sheets, you can easily use it.
• There's no need to worry about complicated API settings.

How to Use the TubeSub to Sheets

1: Copy the Purchased Tool (in Google Sheets format)

2: Run 'Output subscribed channels' from the 'Menu'

3:Complete!

The data that can be output by this tool are the following items.

• Channel Name
• Channel ID
• Channel URL
• Thumbnail
• Thumbnail URL
• Description
• Published at (GMT)
• Video Count
• View Count
• Subscriber Count
• Hidden Subscriber Count Setting
• Acquisition time(GMT)

Notes on Using This Tool

• A Google account is required to use this tool.
• This tool uses the YouTube Data API to retrieve information. In some cases, information may not be able to be retrieved temporarily, or retrieval may fail. Please note this in advance.
• There is also a limit on information retrieval per day. Please understand these risks in advance.
  • Reference: YouTube Data API Overview
• We cannot be held responsible for any problems that occur through the use of this tool. Please test and understand how to use it before using it.
• This tool has a processing time limit (about 6 minutes). If the processing time is exceeded, there may be cases where data retrieval and output cannot be completed. Please note this in advance.
• The copyright of the tool and the program belongs to GAS LAB. Unauthorized copying, resale, distribution, sharing of the source code is strictly prohibited.
• This tool has an "Authentication/Permission Process" the first time it is used. Please proceed with authentication/permission using the following article as a reference.
  • Reference: Process guide when Running Google Apps Script for the First Time
• The specifications of this tool may change, be updated, or information may become unobtainable or inoperable due to changes in the specifications of the YouTube Data API. Please note this in advance.

Q&A

Q. How can I ask about how to use the TubeSub to Sheets?

Please note that support is only provided for those who are part of the "GAS LAB Premium Membership". Support is not provided for those who only purchased this tool. Your understanding is appreciated.