How to integrate Google Sheets with Zoom to create a meeting in Zoom when a row is added in Google Sheets
How to Integrate Applications
・
2025-04-17
How to integrate Google Sheets with Zoom to create a meeting in Zoom when a row is added in Google Sheets
a.fukuyama
When working in sales or planning, you might suddenly have a meeting scheduled. Using Zoom is very convenient when connecting members from multiple departments or different locations for a meeting. If you can automatically create a Zoom meeting based on the information added to a Google Spreadsheet, it saves the hassle of setting up and is efficient.
Yoom allows you to achieve such convenient integration without any coding. This article will detail the benefits of integrating Google Spreadsheets with Zoom and how to easily do it without any specialized knowledge.
Please try it out using this article as a reference!
Benefits of Integrating Google Spreadsheets with Zoom
1. Improved Work Efficiency
By integrating Google Spreadsheets with Zoom, meeting setups are automated, which can reduce the time spent on configurations. If you share the Google Spreadsheet within your team, anyone can easily set up meetings, so even those unfamiliar with Zoom operations can feel at ease. This leads to faster work processes, allowing you to allocate time for other tasks.
2. Prevention of Mistakes
When setting up meetings manually, there is a tendency to accidentally enter the wrong time or schedule multiple meetings at the same time. However, by simply entering information into a Google Spreadsheet, meetings are accurately set up, which can help prevent these human errors.
[About Yoom]
How to Create a Google Spreadsheet and Zoom Integration Flow
Now, let's introduce the steps to integrate Google Spreadsheets with Zoom using Yoom without any coding. The flowbot we will create this time is "Create a meeting in Zoom when a row is added in Google Spreadsheet."
Even if you can't program, you can easily set it up. Try this convenient template from the link below.
Preparation
Preparing in advance can make the work go smoothly.
Free Registration and Login to Yoom
Yoom is a tool that allows you to implement app integration without coding. Please create an account from the Yoom Free Registration Page and start with the free plan. You can register in 30 seconds!
Please log in to the registered account.
App Integration
1. Integrate Google Sheets and Zoom apps. Select the app from "New Connection" in My Apps.
2. Log in with the account you will use.
・For Google Sheets, select any account on the following screen and log in.
・For Zoom, enter "Client ID, Client secret" on the following screen and register a new account. For more details, please see here.
3. Once integrated, an icon will appear in My Apps.
Copy Template
1. Click "Try it" from the template link below.
2. Select any workspace from the list of workspaces.
3. You have successfully copied the template you will use!
STEP1 Setting Up Google Spreadsheet
1. Click on "When a row is added" in the app trigger.
2. On the page to select the linked account and action, change to any title and select "When a row is added" as the trigger action.
Click Next.
3. On the app trigger API connection settings page, configure the following items. ※ Spreadsheet ID and Sheet ID can be selected from the options. ※ Enter the column name manually for the table range and the column with unique values.
・Trigger interval: Select any time from 5 minutes, 10 minutes, 15 minutes, 30 minutes, 60 minutes ※ The selectable time varies depending on the plan. ・Spreadsheet ID ・Sheet ID ・Table range (start) ・Table range (end) ・Column with unique values ※ Be sure to enter a unique column. If values are duplicated, it may not work correctly.
Click Test.
Once you confirm "Test Successful", click Save.
STEP2 Setting Up Zoom
1. Click on "Create Meeting" to link with the app.
2. On the page to select the linked account and action, change to any title and select "Create Meeting" as the action.
Click Next.
3. On the API connection settings page, configure the following items.
Utilize the output so that the information on Google Spreadsheet is reflected! ※ Items marked as "required" must be set.
・Email address ・Topic ・Date ・Start time ・Meeting duration
Click Test.
Once you confirm "Test Successful", click Save.
STEP3 Setting Up Google Spreadsheet
1. Click on "Update Record" to operate the database.
2. On the database linking page, change to any title and select "Update Record" as the execution action.
Next, set up the database linking.
・Spreadsheet ID: Select any spreadsheet name from the options ・Spreadsheet tab name: Select any tab name from the options ・Table range: Enter the table range manually
Click Next.
3. On the detailed settings page for database operations, configure the following items.
① Conditions for the record you want to update ※ Set conditions with items that do not overlap with others to specify the record to update.
② Values of the record after update ※ Use the output to input the items to be updated.
Click Test.
Once you confirm "Test Successful", click Save.
The flowbot setup is complete.
Finally, turn on the trigger to ensure the flow is active!
Other Examples of Automation Using Google Spreadsheet and Zoom
Yoom offers many other examples of automation using Google Spreadsheet and Zoom, so here are a few introductions.
1. This flow adds a user to Zoom when a new row is added in Google Spreadsheet. In departments with many user registrations, this can significantly save working time.
2. This is a flow for adding registrants to a Zoom webinar when a new row is added in Google Sheets. It is expected to prevent manual input errors and duplicate registrations.
This is a flow that retrieves records from Google Sheets where the date matches today and sends a batch notification to Slack every day. For those who manage their schedules with spreadsheets, it ensures that you won't accidentally forget your plans, making it very convenient.
Summary
This time, we explained the benefits of integrating Google Sheets with Zoom and how to automatically schedule meetings on Zoom. By using this integration, it seems possible to reduce the time spent preparing for meetings and improve work efficiency.
Yoom offers many other convenient features. For example, you can create customized workflows tailored to your business, such as automatic notifications to chat tools and document creation.
Please try the free plan first! You can easily get started from this page. Take advantage of the abundant templates and experience various features!
The person who wrote this article
a.fukuyama
I was an office worker until the end of March this year!
Currently, I'm writing a blog as a member of Yoom.
Conventional RPA can only automate simple repetitive tasks, and the setup process was very complicated. With “hyperautomation,” which combines various technologies such as AI, API, RPA, and OCR, it is possible to automate many tasks that could not be realized until now more easily than before.
Most tools simply connect one app to another, leaving the complex tasks to you. Yoom goes much further: From document creation and browser automation to OCR and generative AI, Yoom handles it all seamlessly in one platform.
Why settle for basic integrations? Streamline your entire workflow with Yoom’s powerful hyperautomation.
.avif)
.avif)
.avif)
.png)
.avif)
