YouTube API to Google Sheets

Google Apps Script
Interested in purchasing this script? Contact me

  • Key highlights

  • Pull YouTube data using the YouTube Data API
  • Collate data into Google Sheets
  • Collect new data, avoid duplicating old data
  • Pull YouTube channel metadata
  • Loop through and get all playlists and videos
  • Easy configuration by end user

Summary

The project involved pulling information about YouTube channels and their videos and playlists, using the YouTube Data API. A Google Apps Script was built to take an arbitrary number of channel IDs, get their metadata, and then iterate through their videos and playlists and get their own metadata. All information is to be pulled into a Google Sheet.

Easy to use

An instructions tab guides the user on how to configure the Google Apps Script. The instructions show the various data elements pulled for channels, videos, and playlists.

The script can run on a timer, pulling data periodically, or manually via a custom menu item.

Configurable script execution

A configuration sheet is included in the spreadsheet where the user can specify important information for the script. The user supplies the names of the sheets that will house channel, video, and playlist information.

The user supplies the various data elements they want to pull for channels, videos, and playlists. These will appear as metadata columns inside the output sheet.

Finally, the user also enters the series of YouTube channel IDs that the script will run through. This makes it easy to change the data that gets pulled out of the API and where it is stored.

YouTube channel data

When the script runs, it pulls the channel IDs from the Configuration sheet and supplies in this sheet the metadata for each channel.

The metadata is determined based on the columns that the user entered in the Configuration sheet.

YouTube video data

For each channel ID in the configuration tab, the script pulls all the uploaded videos. It then displays the video metadata based on the columns specified in the Configuration sheet.

The script makes subsequent API calls to fetch more videos using "nextPage" tokens, similar to how search result pages work.

The script ensures that each video shows up only once. To improve performance, the script stops pulling video information the moment it encounters an older video that was previously pulled and stored in this sheet.

YouTube playlist data

For each channel ID in the configuration tab, the script pulls all of the channel's playlists. It then displays the playlist metadata based on the columns specified in the Configuration sheet.

The script makes subsequent API calls to fetch more playlists using "nextPage" tokens, similar to how search result pages work.

The script ensures that each playlist shows up only once. To improve performance, the script stops pulling playlist information the moment it encounters an older playlist that was previously pulled and stored in this sheet.

Technologies and libraries in project
Google Apps Script
Google YouTube Data API
Google Sheets
Interested in purchasing this script? Contact me
RELATED CASE STUDIES

This Google Apps Script pulls daily stock quotes from the Yahoo Finance API. It stores the data in a Google Sheet for historical look-ups. The script updates a summary sheet by calculating today's price change in dollars and percentage.

This project involves parsing addresses in a Google Sheet along with their metadata. A Google Apps Script is launched via a custom menu. It creates a sidebar with a Google Map, converts the addresses into lat/long data points, centers the map according to the addresses, and displays the addresses as markers on the map.

Address metadata is shown when the user hovers over the marker. The map can be viewed in full-screen mode.

The client needed a Chrome extension, which his team would use to mark their website pages for scraping. A Google Apps Script accepts the extension's page requests, scrapes the web page, and saves the data in a Google Doc based on a template.

This Google Apps Script queries the Twitter API, pulling data about tweets and followers into a Google Sheet, which is synched with a Google Data Studio report.

This project embeds a Calendly form on a Google Apps Script web app page. Calendly can be pre-filled with data if the user is a returning customer. When the user completes the registration, a Calendly webhook calls the web app end point, which updates a Google Sheet with the registration data.

This Google Apps Script looks for new IP addresses that are entered in a Google Sheet. The script validates each IP address, triggers a call to a Geo lookup API, and updates a different sheet with geographical data, such asa city, state, and internet service provider.

This Google Apps Script pulls new entries from a Google Sheet in real-time. It uses a Zapier webhook to insert new to-do tasks into an Asana project. The payload includes a mix of standard and custom Asana fields. The script updates the sheet with Zapier IDs to eliminate duplicate inserts.