With YT Tracker, you can export public real-time YouTube video/channel analytics to Google sheet. All you have to do is pasting the video/channel ID to the first column of the sheet, YT Tracker will do the rest.

YT Tracker is fast 🚀 as it uses YouTube Data APIs to pull data. A test run proved it exports 1000 video details in approximately 57 seconds. You can paste video/channel IDs in bulk to the sheet to pull the data.

You can also export stats of all the videos from a channel to a sheet in descending order of upload time.

With the help of a config, you can update the metrics on a set schedule automatically in the background. YT Tracker supports auto-update every 1/2/5/10/24 hours. You can get the updated numbers using Sheets API. 

With an option to disable, you can auto-refresh the metrics whenever you open the sheet. You can pick the list of parameters you want to export to the sheet. You can choose to abbreviate the counts.

🏆 Some use cases:
-----------------------------
If your work involves YouTube video/channel analytics, you will be much productive with YT Tracker.
- Your own or competitor's channel analytics.
- View all thumbnails of the tracked videos in one place.
- Subscriber counter using scheduled update configuration.

📃 List of fields YT Tracker can export:
-----------------------------
Following video stats,
Title, Description, Channel Name, Channel ID, Published on, Thumbnail, (Standard, Max Res, Medium, Default, High quality) thumbnail URL, Duration, Is Licensed, Is Live now, Live Viewers, Live Start Time, Live End Time, Live Scheduled Start Time, Live Scheduled End Time, Caption Available, Tags, number of views, likes, dislikes, comments.

Following channel metrics,
Title, Description, Published on, Thumbnail, (Medium, Default, High quality) thumbnail URL, number of videos, views, subscribers.

🎁 Features:
-----------------------------
➤ Export stats of any public YouTube video/channel.
➤ All exported data is in real-time.
➤ Refresh numbers periodically automatically in the background.
➤ Export all videos uploaded by any particular channel to a sheet.
➤ Refresh data on demand.
➤ Abbreviate counts with a config.
➤ Pick and export the data fields you are interested in.
➤ Auto-refresh the sheet data on open, with an option to disable via config.

🔐 Needed permissions explained:
-----------------------------
➤ View your YouTube account
This is the least sensitive permission the add-on must have to fetch any public YouTube data. YT Tracker doesn’t fetch any personal YouTube data.

➤ See, edit, create and delete your spreadsheets in Google Drive
As the metrics are exported to a spreadsheet, this permission is needed. YT Tracker doesn’t delete or create any spreadsheet.

➤ Connect to an external service
YT Tracker makes requests to the developer’s backend to check if you are a premium user.

➤ Allow this application to run when you are not present
Auto-refresh on open feature needs this permission to work. YT Tracker won’t ever run on its own in the background when the sheet is closed.

➤ Display and run third-party web content in prompts and sidebars inside Google applications
If you want premium features, payment can be made within the sheet. To run PayPal in the sidebar,  this permission is required. 

🤔 How to use:
-----------------------------
1. After installing, select Extensions → YT Tracker → Track YouTube Videos/Channels.
2. Wait for a few seconds. A sheet will be generated with a template.
3. Add video IDs/channel IDs to the first column of the sheet to start tracking.

💫 Premium:
-----------------------------
YT Tracker is free to use with some limitations in its functionality. However, you can upgrade to premium to use it without any limitations. 

For example, you can only add 25 videos for statistics in the videos sheet and 10 channels in the channels sheet in the free version.

Select Extensions → YT Tracker → Buy Premium to unlock premium features.

ℹ️ Resources
-----------------------------
YouTube video - https://youtu.be/1V34z9tOxxE
Documentation for the product - https://syncwithtech.com/yt-tracker/docs

🙋 Feature Requests
-----------------------------
I constantly work to improve the add-on. If you want any new features, feel free to drop a mail at [email protected].