Google Sheets
With Google Sheets, you can create, edit, and collaborate wherever you are
Integrate the Google Sheets API with the Zoom API
Setup the Google Sheets API trigger to run a workflow which integrates with the Zoom API. Pipedream's integration platform allows you to integrate Google Sheets and Zoom remarkably fast. Free for developers.
Popular Google Sheets and Zoom Triggers#
Emit new event each time a meeting is created where you're the host
Emit new event each time a meeting starts where you're the host
Emit new event each time a new recording completes for a meeting or webinar where you're the host
Emit new event each time a meeting ends where you're the host
Overview of Google Sheets#
Some examples of things you can build using the Google Sheets API include:
- A web app that lets users input data into a Google Sheet
- A script that automatically updates a Google Sheet with data from another
source - A tool that generates graphs and charts from data in a Google Sheet
- A service that sends data from a Google Sheet to another API or application
Connect Google Sheets#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
google_sheets: {
type: "app",
app: "google_sheets",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://www.googleapis.com/oauth2/v1/userinfo`,
headers: {
Authorization: `Bearer ${this.google_sheets.$auth.oauth_access_token}`,
},
})
},
})
Overview of Zoom#
Pipedream workflows allow you to run any Node.js code that connects to the Zoom API. Just create a new workflow, then add prebuilt Zoom actions (create a meeting, send a chat message, etc.) or write your own code. These workflows can be triggered by HTTP requests, timers, email, or on any app-based event (new tweets, a Github PR, Zoom events, etc).
Getting Started
- First, sign up for Pipedream at https://pipedream.com.
- Visit https://pipedream.com/accounts.
- Click the button labeled Click Here to Connect an App.
- Search for "Zoom" and select either Zoom or Zoom Admin (see the differences below):
This will open up a new window prompting you to authorize Pipedream's access to your Zoom account. Once you authorize access, you should see your Zoom account listed among your apps.
- Create a new workflow, add a new step, search for "Zoom" or "Zoom Admin". Once you've selected either app, you can choose to either "Run Node.js code" or select one of the prebuilt actions for performing common API operations.
- At this stage, you'll be asked to link the Zoom account you connected above, authorizing the request to the Zoom API with your credentials:
Zoom vs Zoom Admin app
Zoom users can be classified into two groups: non-admins and admins. Admins have account-level permissions that users do not, and Zoom has corresponding admin-level scopes that aren't relevant for normal users. Therefore, Pipedream exposes two apps — Zoom and Zoom Admin — to serve the two groups.
In the Zoom Marketplace, these apps are named Pipedream, and Pipedream for Zoom Admins, respectively.
Non-admins have permissions to manage standard Zoom resources in their account: meetings, webinars, recordings, and more. If you're a non-admin, you'll want to use the Zoom app.
Zoom admins have permissions to manage account-level resources, like users and reports. They can also manage webinars and meetings across their organization. If you're an admin and need to manage these resources via API, you'll want to use the Zoom Admin app.
The Zoom API docs on permissions provide detailed information on these permissions and their associated OAuth scopes.
Connect Zoom#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
zoom: {
type: "app",
app: "zoom",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.zoom.us/v2/users/me`,
headers: {
Authorization: `Bearer ${this.zoom.$auth.oauth_access_token}`,
},
})
},
})
Related Videos#
Community Posts#
