Zoom is a cloud-based video conferencing service you can use to virtually meet with others, either by video, audio, or both. We can use the Zoom API to import data from Zoom into Google Sheets. In this tutorial, we’ll show you how to connect the Zoom API to Google Sheets in 6 steps:
To pull data from the Zoom API into Google Sheets, 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, save API requests, schedule API requests, and more.
1. Install Apipheny by opening the following link on desktop and then clicking the Install button on the page: https://apipheny.io/install
2. After you’ve installed Apipheny, open a Google Sheet and then click on the Add-Ons or Extensions option in the top menu. In the Add-ons menu, you should see Apipheny.
Click Apipheny > Import API to open the Apipheny sidebar in your Google Sheets:
In the card corresponding to the OAuth app type, click the Create button:
Complete the App Name field, choose the Account-level app type, and then click the Create button:
Complete the Redirect URL for OAuth field, then click the Continue button:
Complete the Basic Information section for your app, then click the Continue button:
Choose any features you need for the app and then click the Continue button:
In the Scopes section, choose any scopes you need for the app by clicking the +Add Scopes button:
After you have added the scopes you need, click the Done button:
You’re finished with this step, you can now move on to Step 3.
In the Local Test section, click the Install button, then Continue:
On the next screen, click the Authorize button:
The browser will now navigate to the redirect URL that you provided earlier. One query parameter (code) will be added to your browser’s address bar, at the end of this redirect URL. The code parameter is a single use login code that we will now use to acquire a refreshable access token:
Next, open up a command prompt window for Windows OS or a terminal for Mac OS and compose the following curl command:
curl -X POST https://zoom.us/oauth/token -H "Authorization: Basic encoded_string" -H "Content-Type: application/x-www-form-urlencoded" -d "grant_type=authorization_code&code=your_code&redirect_uri=your_redirect_URL"
Note: For Mac OS you may need to use single quotes ( ' ) instead of double quotes ( " ).
You’ll need to fill in a few parts:
The response access_token may be used in order to access the Zoom API for up to one hour. The refresh_token may be used to get a new access token when that hour is up. Refreshing the access token can be done with the following command:
curl -X POST https://zoom.us/oauth/token -H "Authorization: Basic encoded_string" -H "Content-Type: application/x-www-form-urlencoded" -d "refresh_token=your_refresh_token&grant_type=refresh_token&redirect_uri=redirect_URL"
You’ll need to fill in a few parts here as well:
In this section, we’ll show you how to browse the Zoom API documentation to find an API URL and endpoint that retrieves the specific information you need from your Zoom account. If you already know your whole API URL, or you want to use the same example URL as us, just skip to Step 5.
First, open the Zoom API documentation page: https://marketplace.zoom.us/docs/api-reference/
The menu on the left contains general information about the Zoom API and a list of grouped API endpoints:
An example endpoint group is Accounts. This endpoint group contains 14 endpoints.
In this case, we will describe the List sub accounts endpoint, which lists all the sub accounts that have been created by a master account:
The documentation for this endpoint contains its HTTP method and URL path, a short description of the endpoint’s purpose, the account prerequisites, the necessary scopes, the authorizations used by the endpoint, the accepted path parameters, and the responses it can return:
If you want some specific data from your Zoom account, look through the documentation to determine if an endpoint exists for that data.
All API calls to the Zoom API should be made using the https://api.zoom.us/v2/ base domain. All endpoints and parameters would be appended to this base domain.
Okay, now we’re in the home stretch. Go back to your Google Sheet and make sure that the Apipheny add-on is open on the “Import” tab. With the Import Tab open, enter these details into the add-on:
API URL: In Step 4, we explained how you can find the Zoom API endpoint that you need. Now copy the complete API URL into the Apipheny add-on, where it says API URL Path, followed by any GET parameters required for your query.
For this example, we are using the Users endpoint, which lists users on your account. The corresponding URL for this endpoint is:
Headers: In the Headers of the Apipheny add-on section, add one row with the following key and value:
Header Key: Authorization Value: Bearer your_token
The last step is to click the Run button at the bottom of the Apipheny add-on and then your Zoom data will be imported into your Google Sheet.
After making a successful request to the Zoom API, try querying a different Zoom API endpoint, or try using one of the more advanced features in the Apipheny add-on, such as:
Constant Contact API
Facebook Graph API
Facebook Ads API
Google SERP API
Linkedin Ads API
Product Hunt API
Reddit Ads API
Riot Games API