Note: If the token/key that you generate has an expiration time, you will need to complete this same process again to get a new token when the old one expires. your_refresh_token – Should be replaced with the value of the refresh_token field from the previous command’s response.redirect_URL – This must be the redirect URL that you entered while creating your developer application.encoded_string – This is a value obtained by base64-encoding a string consisting of the client ID and the client secret you generated previously, in Step 2, in the App Credentials section, separated by a colon (“:”).You’ll need to fill in a few parts here as well: Refreshing the access token can be done with the following command: curl -X POST -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" The refresh_token may be used to get a new access token when that hour is up. The response access_token may be used in order to access the Zoom API for up to one hour. Click Apipheny then click Import API to open the Apipheny sidebar in your Google Sheet. In the dropdown list you should see Apipheny.
There is a 30 day free trial included.ġ.) Install Apipheny by opening the following link on desktop and then clicking the Install button in the Google Marketplace: Ģ.) After you’ve installed Apipheny, open a Google Sheet and then click on the Extensions dropdown in the menu at the top. You can use Apipheny to connect your Google Sheets to unlimited API data sources, make unlimited API requests, and more. Step 1.) Install and open the Apipheny add-on for Google SheetsĪpipheny is an API connector for Google Sheets.
In this tutorial, we’ll show you how to connect the Zoom API to Google Sheets in 6 steps: We can use the Zoom API to import data from Zoom into Google Sheets. Zoom is a cloud-based video conferencing service you can use to virtually meet with others, either by video, audio, or both. How to connect the Zoom API to Google Sheets