# Zoom API integration with Google Sheets Script Editor

**URL:** <https://devforum.zoom.us/t/zoom-api-integration-with-google-sheets-script-editor/36058>\
**Category:** API and Webhooks\
**Created:** [November 15, 2020, 2:43pm UTC](https://devforum.zoom.us/t/zoom-api-integration-with-google-sheets-script-editor/36058 "2020-11-15T14:43:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![eric4](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/eric4/32/18803_2.png) [@eric4](https://devforum.zoom.us/u/eric4)\
**Post date:** [November 15, 2020, 2:43pm UTC](https://devforum.zoom.us/t/zoom-api-integration-with-google-sheets-script-editor/36058/1 "2020-11-15T14:43:14Z")

</div>

**Description**  
We are a Zoom Authorized Reseller and we wanting to pull the Sub Accounts list into a Google Sheet so we can use the data and automate some of our sales process.

For now just getting authenticated with Google Sheet or visa versa via the Script Editor is a challenge.

My programming skills are very rusty and going to need some hand holding please…

**Error**  
The full error message or issue you are running into.

**Which App Type (OAuth / Chatbot / JWT / Webhook)?**  
Knowing the endpoint/s can help us to identify your issue faster. Please link the ones you need help/have a question with.

**Which Endpoint/s?**  
Knowing the API endpoint/s can help us to identify your issue faster. Please link the ones you need help/have a question with.

**How To Reproduce (If applicable)**  
Steps to reproduce the behavior:

1. Request URL / Headers (without credentials) / Body
2. See error

**Screenshots (If applicable)**  
If applicable, add screenshots to help explain your problem.

**Additional context**  
Add any other context about the problem here.

---

<div class="post-metadata">

**Author:** ![will.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/will.zoom/32/14417_2.png) [@will.zoom](https://devforum.zoom.us/u/will.zoom)\
**Post date:** [November 16, 2020, 10:27pm UTC](https://devforum.zoom.us/t/zoom-api-integration-with-google-sheets-script-editor/36058/2 "2020-11-16T22:27:58Z")

</div>

Hey @eric4,

Happy to help point you in the right direction!

If you’re interested in pulling sub account information, you can utilize this endpoint:[https://marketplace.zoom.us/docs/api-reference/zoom-api/accounts/accounts](https://marketplace.zoom.us/docs/api-reference/zoom-api/accounts/accounts)

To authenticate your request, you’ll need to first create a JWT app under the Zoom account whose sub accounts you’ll want to query (if you haven’t already).

You can follow the steps outlined in this article to create a JWT app in the Zoom Marketplace, in order to get these credentials:

> **[Zoom Developer - Technical Documentation and Reference](https://marketplace.zoom.us/docs/guides/getting-started/app-types/create-jwt-app)**
>
> Stoplight Hubs are the easiest way to generate API documentation, technical guides, tutorials, and more! Powered by Stoplight.io

After you create the app, you can generate the API key and Secret by following the steps here:

> **[Zoom Developer - Technical Documentation and Reference](https://marketplace.zoom.us/docs/guides/getting-started/app-types/create-jwt-app#credentials)**
>
> Stoplight Hubs are the easiest way to generate API documentation, technical guides, tutorials, and more! Powered by Stoplight.io

You can then use these credentials to authenticate your request with a JWT token.

Let me know if this helps!

Best,  
Will

---

<div class="post-metadata">

**Author:** ![eric4](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/eric4/32/18803_2.png) [@eric4](https://devforum.zoom.us/u/eric4)\
**Post date:** [November 17, 2020, 6:56am UTC](https://devforum.zoom.us/t/zoom-api-integration-with-google-sheets-script-editor/36058/3 "2020-11-17T06:56:32Z")

</div>

HI Will,

Andre is our “Dev guy” and helped me with the JWT, it works perfect, now difficult part is figuring out the for loops to populate the feedback/data into the Google sheet.

Regards

Eric de Jager | [eric@techsonic.co.za](mailto:eric@techsonic.co.za) | 081 488 2269

---

<div class="post-metadata">

**Author:** ![will.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/will.zoom/32/14417_2.png) [@will.zoom](https://devforum.zoom.us/u/will.zoom)\
**Post date:** [November 18, 2020, 6:00pm UTC](https://devforum.zoom.us/t/zoom-api-integration-with-google-sheets-script-editor/36058/4 "2020-11-18T18:00:14Z")

</div>

Hey @eric4,

Glad that this got you going in the right direction!

In regards to populating your google sheet with the API response, I might recommend checking out StackOverflow or Google for some quick help. For instance:

> **[API Tutorial For Beginners with Google Sheets and Apps Script](https://www.benlcollins.com/apps-script/api-tutorial-for-beginners/)**
>
> Connect Google Sheets to an API in this API Tutorial for Beginners, using Apps Script to retrieve data from third-parties and display it in Google Sheets.

Hope this helps!

Best,  
Will

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex016/uploads/zoomdeveloper/original/3X/6/1/614bdd549b610bbaa46ff934617683a02bdaa03c.png) [@system](https://devforum.zoom.us/u/system)\
**Post date:** [December 19, 2020, 4:00am UTC](https://devforum.zoom.us/t/zoom-api-integration-with-google-sheets-script-editor/36058/5 "2020-12-19T04:00:27Z")

</div>

Closed on December 19, 2020, 4:00am UTC

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
