Connect Youtube API to Google Sheets in 5 easy Steps
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: Create a Google API Project and enable the YouTube Data API
The first step to get Youtube API 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.
On the next page, complete the project name field and then click the CREATE button. The project should now be created.
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:
Next, click the ENABLE button to finish the process:
Step 2: Obtain Your 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“.
An API key will then be generated and shown to you in a selectable field. Copy your key to your clipboard or notes:
Step 3: Install the Apipheny Google Sheets Add-on
To pull data from the Youtube API to Google Sheets easily and without writing any code, first install and open the Apipheny Google Sheets add-on.
Apipheny is a no-code API integrator for Google Sheets that you can use to make unlimited API requests, connect to unlimited APIs (including the Youtube API), save API requests, schedule API requests, and more. Click here if you want to learn more about Apipheny.
Install Apipheny by clicking the Install button on this page.
After you install the Apipheny app, open a new or existing Google Sheet.
Then, at the top of the page, click Add-ons > Apipheny > Import API and you’ll see the Apipheny app open as a sidebar on the right side of your screen.
We’re almost ready to import Youtube API into Google Sheets.
Step 4: Enter your Youtube API URL into the “API URL” field in the Apipheny app
Create and copy the 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>”.
In the Apipheny app, select the HTTP method (GET or POST) as required by your API endpoint.
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):
Step 5: Run the API endpoint request to import Youtube API into Google Sheets
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:
That’s it! With the Apiheny add-on we were able to import Youtube API data into Sheets without writing any scripts or code. It’s as easy as entering your Youtube API URL and clicking “Run”.
If you have any questions about pulling Youtube API into Google Sheets, you can email us or leave a comment down below.
- Coinmarketcap API
- Quickbooks API
- SurveyMonkey API
- Paypal API
- Github API
- Binance API
- Facebook Marketing API
- Facebook Graph API
- Hubspot API
- Trello API
- Asana API
- Harvest API
- Marketstack API
- CoinAPI
- Mailchimp API
- Typeform API
- Shopify API
- Foreign Exchange Rates API
- Google Search API
- Riot Games API
- Pipedrive API
- Email Finder API
- Wikipedia API
- OpenWeather API
- Remote Jobs API
- JSON API
- Discord API
- Flight API
- Twitch API
- Ahrefs API
- Twitter API
- POST Request
- Product Hunt API
- Zillow API
- Yelp API
- Drift API
- Reddit API
- Reddit Ads API
- JIRA API
- Slack API
- Instagram API
- Linkedin API
- Zendesk API
- BambooHR API
- Squarespace API
- Snapchat API
- TikTok API
- Stripe API
- REST API
- Klaviyo API
- Royale API
- Spotify API
- IMDB API
