How to connect the Youtube API to Google Sheets

You can use the Youtube API to get analytics data from Youtube into Google Sheets using the Apipheny app. Let’s go step-by-step through the process of getting API data from Youtube into a Google Sheet.

Step 1.) Install and open the Apipheny add-on for Google Sheets

Apipheny is an API connector for Google Sheets. You can use Apipheny to connect your Google Sheets to unlimited API data sources, make unlimited API requests, and more. There is a 30 day free trial included.

1.) Install Apipheny by opening the following link on desktop and then clicking the Install button in the Google Marketplace: https://apipheny.io/install

2.) After you’ve installed Apipheny, open a Google Sheet and then click on the Extensions dropdown in the menu at the top.

In the dropdown list you should see Apipheny. Click Apipheny then click Import API to open the Apipheny sidebar in your Google Sheet.

open apipheny

Tip: you can open a new Google Sheet by entering this URL in your browser: sheet.new

Step 2.) Create a Google API Project and enable the YouTube Data API

The next step to get Youtube API data into Google Sheets is to go to the Google API Console at https://console.developers.google.com/ and create a project by clicking the CREATE PROJECT button.

Youtube API Create Project Google Sheets

On the next page, complete the project name field and then click the CREATE button. The project should now be created.

Youtube API New Project

To enable the YouTube Data API for Google Sheets, go to https://console.developers.google.com/apis/dashboard and click the ENABLE APIS AND SERVICES button.

In the API Library, search for YouTube Data API and select it:

Youtube data API Google Sheets

Next, click the ENABLE button to finish the process:

Enable Youtube API Google Sheets

Step 3.) Obtain an API Key from Google APIs

The next step we need to take to connect the Youtube API is to go to https://console.developers.google.com/apis/credentials and click on the “+ CREATE CREDENTIALS” button and then choose “API key“.

Youtube API key Google Sheets

An API key will then be generated and shown to you in a selectable field. Copy your key to your clipboard or notes:

API key Youtube

Step 4.) Enter your API request in Apipheny

In the Apipheny app, select the HTTP method (GET or POST) as required by your API endpoint.

Then copy and paste your Youtube API URL into the API URL field in the Apipheny app, followed by any GET parameters you need for your query.

Some of these parameters are required, so make sure to add them for your request to work properly. For instance, many endpoints require you to provide the value snippet for the part parameter. And for authenticated requests, you’ll need your API key for the key parameter.

Use this format after the URL: ?part=snippet&key=your_API_key

For example, let’s consider the search URL, for which a valid configuration could look like this:

https://www.googleapis.com/youtube/v3/search?part=snippet&q=music&key=your_API_key

The URL contains the required part and key parameters, as well as a specific query parameter, q, holding the search term. For this query, you would choose GET as the method (chosen by default):

Youtube API URL in Google Sheets

Step 5.) Run the API request

Lastly, click the Run button at the bottom of the Apipheny app and wait for the API data results to be fetched and added to your Google Sheet:

Import Youtube API

That’s it! With the Apiheny add-on we were able to import Youtube API data into Sheets without writing any scripts or code.


API Tutorials



API Knowledge

What is an API?
What is an API URL?
What are parameters?
What is an endpoint?
What is an API key/token?
What is basic authentication?
What are headers?
What is a GET request?
What is a POST request?