Track YouTube Subscribers in Google Sheets

Youtube Subscribers tracker in Google Sheet - free template

Imagine effortlessly tracking the subscriber count of any YouTube channel, whether it's your own or your competitors', directly within a Google Sheet. This simple yet powerful tool combines the flexibility of Google Sheets with the automation capabilities of Apps Script to deliver daily subscriber updates right to your spreadsheet. No more manual checks or third-party tools – just automated report at your fingertips. Whether you're a content creator monitoring your youtube channel growth, a marketer analyzing competitor trends, this solution provides a streamlined way to stay informed about YouTube channel subscriber numbers.

Agnes Bungsy

Before running the script:

  1. Replace YOUR_CHANNEL_ID with your actual YouTube channel ID.

  2. Enable the YouTube Data API:

    • In your Google Sheet, go to "Tools" > "Script editor".

    • In the script editor, go to "Resources" > "Advanced Google services".

    • Turn on the YouTube Data API v3.

  3. Set up a daily trigger:

    • In the script editor, go to "Triggers" > "Add Trigger".

    • Choose getSubscriberCount as the function to run.

    • Set the events to "Time-driven".

    • Choose "Day timer" and select the time you want the script to run daily.

Explanation:

  • This script uses the YouTube.Channels.list method from the YouTube Data API to fetch your channel's statistics.

  • It retrieves the subscriberCount from the API response.

  • Then it appends the current date and time along with the subscriber count to your Google Sheet.

  • The daily trigger ensures that this script runs automatically every day at your chosen time.

Note:

  • This script requires authorization to access your YouTube data. When you run it for the first time, it will ask for your permission.

  • The subscriberCount returned by the YouTube API is an approximate value.

  • If you encounter any errors, make sure you have correctly enabled the YouTube Data API and that your channel ID is correct.

  • You can customize the sheet name and the formatting of the output in the script.

  • For more advanced use cases like tracking subscribers over time or analyzing subscriber growth, you can modify the script to store and manipulate the data in your Google Sheet.

This script provides a basic framework for pulling your daily YouTube subscriber count into Google Sheets. You can further enhance it to fit your specific needs and reporting requirements.