Building on YouTube APIs in the cloud with Google Apps Script
- Dynamically update a spreadsheet containing watch-time statistics for all of your channel's videos, with all the flexibility and power of Google Sheets to sort and slice that data
- Create a live dashboard or scheduled email report about your channel's performance
- Handle channel management tasks such as scheduling automatic bulletins or changing the visibility of a large number of videos from private to public
- Automate playlist rotation without having to maintain a server or keep a computer for the sole purpose of running a script
For functions that require OAuth 2.0 authorization, there’s no authorization code to write and no token management to deal with. Once your script is ready, just click “Run” and Google Apps Script will present you with an authorization dialog. Once you select the channel you want to authorize, the script will have all of the permissions it needs to operate on your behalf, running in the background at scheduled intervals if you so desire.
To get started, browse to Google Drive. Click “Create” and then choose “Script”. This will open a new browser tab to the Google Apps Script editor. Name your project and click on “Resources” and select “Advanced Google Services”: