In today’s business environment, remote work and online meetings have become the norm
You likely find yourself regularly participating in web meetings with clients or internal teams. But have you ever found yourself spending too much time figuring out who to share data with, or where that data is stored?
Especially when it comes to meetings with clients, remote offices, or employees working from home, it’s easy to lose track—and finding meeting recordings or summaries can become time-consuming.
That’s why in this article, we’ll show you how to integrate Zoom with Google Sheets to automatically collect and manage your meeting information efficiently. No programming skills are required—we’ll also walk you through an easy setup method using a no-code tool.
Recommended for
Anyone looking to improve workflow efficiency using Zoom and Google Sheets
Those who are already managing Zoom data in Google Sheets
Those who want to enhance data accuracy by linking Zoom with Google Sheets
For those who want to try it right away
This article introduces a simple integration method using the no-code tool Yoom. Even non-engineers can set it up easily—no complex settings or operations needed.
You can start immediately using the template linked below. Give it a try and see how smooth data management can be!
When the meeting ends on Zoom, retrieve the recording information and add it to Google Sheets.
Do you feel that integrating apps is a bit of a hurdle? Typically, integrating two apps like Zoom and Google Sheets requires some initial setup and system familiarity. However, with Yoom, you can easily integrate apps without any coding! What are the benefits of Yoom that differ from traditional integrations?
・Easy Setup
Yoom is designed to be intuitive, so you can easily set it up without any programming knowledge. This means that even non-engineers can quickly achieve integration.
・Flexible Customization
Yoom offers a variety of templates. By copying a template, even beginners can easily create flows. Additionally, flows can be flexibly customized to meet user needs. With many apps available for integration, you can create the optimal integration for your workflow.
How to Create a Zoom and Google Sheets Integration Flow
Step 1: Register/Login to Yoom and Register Apps
First, access the official Yoom website and create an account. You can start with a free plan. If you already have an account, please log in. Yoom Account Creation Page ※Please refer to this for basic Yoom operations. Getting Started with Yoom
Once you can log in to your Yoom account, register the apps you will use. 1) Click "Register My Apps" and select "Create New". 2) Select the app you want to register (in this case, Zoom and Google Sheets) and log in with the account you will use.
3) Once registered, an icon will appear in My Apps. Check if the icons for Zoom and Google Sheets are displayed.
Step 2: Select a Template
This time, we are creating a flow to 【Add recording information to Google Sheets when a meeting ends on Zoom】. After a Zoom meeting ends, meeting information is automatically retrieved and aggregated into Google Sheets. This eliminates the hassle of data sharing and makes data management very easy. If you can manage it with a single Google Sheet, anyone who wants to check the record content can access it immediately at that time, eliminating the need to ask someone or wait. Additionally, you can add an action to "Notify via chat" to this flow, allowing you to customize it to your liking.
When the meeting ends on Zoom, retrieve the recording information and add it to Google Sheets.
Step 3: Setting Up Integration Between Zoom and Google Sheets
0)Prepare a spreadsheet in advance to accumulate data. In this flow, we will aggregate Zoom meeting information into Google Sheets, so it is necessary to prepare a spreadsheet to compile the information beforehand. The information that can be extracted through Zoom integration is as follows.
1)Copy the template and open it from My Projects. Click on the template icon introduced earlier. By copying the template, you can easily create a flow without having to build it from scratch. 2)Click "Edit" in the upper right corner. The title is filled in to make the content of the flow easy to understand. Details can also be changed. Modify it to make it easier to use.
3)Click "App Trigger: When Meeting Ends".
4)Select "When Meeting Ends" as the trigger action and click "Next".
5)Select the trigger interval, enter the email address of the target Zoom account, click "Test", and if the test is successful, click "Save".
6)Return to the flow and click the icon for "Integrate with App: Get Meeting Recording Information".
7)Select "Get Meeting Recording Information" as the action and click "Next".
8)Enter the user's email address and meeting ID. Click "Test", and if the test is successful, click "Save". *In the output, the content in the image below was extracted. This item can be automatically accumulated in the spreadsheet.
9)Return to the flow and click the icon for "Operate Database: Add Record".
10)Select "Add Record" as the execution action and fill in the "Database Integration" items. If the app is registered, you can select the spreadsheet ID and tab name from the candidates. Specify the table range for the target spreadsheet. Once you have entered the information, click "Next".
11)You can select the Zoom output information linked earlier from the candidates. Embed while entering and click "Save".
12)This completes the flow of [When a meeting ends in Zoom, retrieve the recording information and add it to Google Sheets].
Step 4: Testing and Verification
13)Finally, switch the trigger to "ON", activate the flow bot, and check if it operates correctly once.
When the meeting ends on Zoom, retrieve the recording information and add it to Google Sheets.
Other Automation Examples Using Zoom and Google Sheets
In addition to the integrations introduced, various automations can be achieved by utilizing the APIs of Zoom and Google Sheets.
If you find something interesting, please give it a try!
Automation Examples Integrating Zoom and Google Sheets
After a meeting ends on Zoom, you can summarize the audio data using AI and add it to Google Sheets. Additionally, when a row is added in Google Sheets, it is possible to create a meeting on Zoom or add users through integration.
Add a user to Zoom when a row is added in Google Sheets.
■Notes ・Please integrate with both Zoom and Box with Yoom. ・The AI operation for OCR or transcribing audio is only available in the Team Plan and Success Plan. If you are on the Free Plan or Mini Plan, the operations set in the flow bot will result in an error, so please be careful. ・Paid plans such as the Team Plan and Success Plan offer a 2-week free trial. During the free trial, you can use restricted apps and AI features (operations). ・The maximum downloadable file size is 300MB. Depending on the app's specifications, it may be less than 300MB, so please be careful. ・For details on the file size that can be handled by triggers and each operation, please refer to the following. https://intercom.help/yoom/en/articles/9413924 ・Triggers can be set to activate at intervals of 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. ・Please note that the shortest activation interval varies depending on the plan.
■Overview Isn't creating meeting minutes after a Zoom meeting a task that requires a lot of effort—watching the recording, transcribing, summarizing, and managing files? By using this workflow, once a Zoom meeting ends, it will automatically transcribe and summarize the recording, convert the minutes into a PDF, and save it to Google Drive. By automating the entire process, you can eliminate the burden of creating minutes and spend your time on more important work.
■Who we recommend this template for - Those who feel that transcribing recordings and creating minutes for every Zoom meeting is time-consuming - Managers who want to speed up sharing of meeting content and improve team productivity - Those who want to automate manual minute creation and focus on core tasks
■Notes - Please note that available actions vary depending on your Zoom plan. - As of now, the following actions are available only on paid Zoom plans. - When a meeting has ended - Get meeting recording information (only recordings that exist in the cloud can be retrieved) - For details, please refer to the following: https://intercom.help/yoom/en/articles/9550398 - You can choose the trigger run interval from 5, 10, 15, 30, or 60 minutes. - The minimum run interval differs depending on your plan. - The maximum downloadable file size is 300 MB. Depending on the app specifications, it may be less than 300 MB. - For details on the file sizes that can be handled by the trigger and each operation, please refer to the following: https://intercom.help/yoom/en/articles/9413924 - AI operations for OCR or speech-to-text are available only with the Team plan and Success plan. In the Free or Mini plan, operations configured in flowbots will result in errors. - Paid plans such as the Team plan and Success plan offer a two-week free trial. During the free trial, you can use restricted apps and AI features (operations). - In the "Issue Document" action, you can set any storage location in Google Drive.
■ Overview This flow transcribes, summarizes the recording, and saves the minutes as a PDF to OneDrive after the Zoom meeting ends. With Yoom, you can easily achieve this flow without programming by linking between apps.
■ Recommended for: - Those who are taking time to create minutes from Zoom meeting recordings - Those who want to automate transcription and summarization of recordings to streamline minute creation - Those who manage minutes in OneDrive
■ Notes - Please link Yoom with Zoom and OneDrive respectively. - AI operations for OCR or audio transcription are features available only in the Team Plan and Success Plan. Operations set in FlowBot in the Free Plan or Mini Plan will result in an error, so please be careful. - You can take advantage of a 2-week free trial for paid plans like the Team Plan and Success Plan. During the free trial, you can use apps and AI features (operations) that are restricted. - The maximum file size for download is up to 300MB. Depending on the app specifications, it may be less than 300MB, so please be aware. - For details on file size handling in triggers and each operation, refer to the link below. https://intercom.help/yoom/ja/articles/9413924 - Microsoft365 (formerly Office365) has plans for home use and general corporate use (Microsoft365 Business), and if you are not enrolled in the general corporate plan, authentication may fail. - Triggers can be set to select activation intervals of 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. - Please note that the shortest activation interval varies depending on the plan.
■Overview This is a flow to automatically share the recording link via Outlook after obtaining the participant list when a webinar ends in Zoom. With Yoom, you can easily achieve this flow without the need for programming, as it allows for integration between apps.
■Recommended for ・Those who manually obtain recording information and contact participants via Outlook after a Zoom webinar ends ・Sales or customer support personnel who want to speed up follow-ups after webinars ・Those who frequently hold training or customer-oriented online seminars and want to reduce communication errors with participants ・Those who feel burdened by the increasing frequency of webinars and participants, and the extraction of participant lists and communication tasks
■Notes ・Please integrate Zoom and Outlook with Yoom. ・To obtain Zoom recording information, the data must be cloud recorded. ・Cloud recording is limited to specific Zoom plans, so please be aware. For details, please refer to the link below. https://intercom.help/yoom/ja/articles/9550398 ・Microsoft365 (formerly Office365) has home plans and general business plans (Microsoft365 Business), and if you are not subscribed to the general business plan, authentication may fail. ・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. ・Please note that the shortest trigger interval varies depending on the plan.
■Overview This is a flow to retrieve the participant list and share the recording link via Gmail after a Zoom webinar ends. With Yoom, you can easily achieve this flow without programming, as it allows integration between apps.
■Recommended for ・Those who manually retrieve recording information and contact participants via Gmail after a Zoom webinar ends ・Sales or customer support personnel who want to quickly follow up after a webinar ・Those who frequently hold training or customer-oriented online seminars and want to reduce communication errors with participants ・Those facing challenges with the increasing frequency of webinars and participants, and the burden of extracting participant lists and communication tasks
■Notes ・Please integrate Zoom and Gmail with Yoom. ・To retrieve Zoom recording information, data must be cloud recorded. ・Cloud recording is limited to specific Zoom plans, so please be aware. For details, please refer to the link below. https://intercom.help/yoom/ja/articles/9550398 ・Operations between "repeating the same process" are only available in the Team Plan and Success Plan. In the case of the Free Plan and Mini Plan, the operations and data connections set in the flow bot will result in errors, so please be careful. ・Paid plans such as Team Plan and Success Plan offer a 2-week free trial. During the free trial, you can use restricted apps and features (operations). ・Triggers can be set to activate at intervals of 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. ・Please note that the shortest activation interval varies depending on the plan.
■Overview Are you manually notifying stakeholders in Discord every time a new row is added to a list managed in Google Sheets? This routine task is not only time-consuming but also prone to missed or delayed notifications. With this workflow, when a row is added in Google Sheets, it automatically sends a message to the specified Discord channel, streamlining information sharing.
■Who we recommend this template for ・Those who manually copy updates from Google Sheets to Discord each time ・Those who want to speed up information sharing within the team and strengthen real-time collaboration ・Those who want to prevent missed or delayed notifications caused by manual work and improve operational accuracy
■Notes ・Connect Yoom with both Google Sheets and Discord. ・You can set the trigger interval to 5, 10, 15, 30, or 60 minutes. ・The shortest trigger interval varies depending on your plan.
Overview Are you manually sending notifications to Slack every time you update information managed in Google Sheets? Such routine reporting tasks not only require effort but can also lead to errors such as delayed or missed notifications. By using this workflow, you can use row additions in Google Sheets as a trigger to automatically send a message to a specified Slack channel, streamlining information sharing.
Who this template is recommended for - Those who report each update made in Google Sheets to their team on Slack - Those who want to prevent human errors such as notification time lags and missed reports caused by manual work - Those who want to automate information-sharing processes within a team or department and improve operational efficiency
Notes - Please connect Yoom with both Google Sheets and Slack. - For the trigger, you can choose a run interval of 5, 10, 15, 30, or 60 minutes. - Please note that the minimum run interval varies by plan.
■Overview The "Sync to Google Sheets when a record is created in Airtable" workflow is a business workflow aimed at improving data management efficiency. When new data is added to Airtable, the same information is automatically reflected in Google Sheets as well, eliminating the effort of manual data entry and enabling centralized management of the latest information. This makes information sharing across the team smoother and improves the accuracy of operations.
■Recommended for - Those who manage data using both Airtable and Google Sheets - Staff who spend time on manual data transfers - Team leaders who want to maintain data consistency and up-to-dateness - Business owners considering workflow automation - Those who want to simplify data integration across multiple SaaS apps
■Notes - Please connect Yoom with both Airtable and Google Sheets. - For the trigger, you can choose a run interval of 5, 10, 15, 30, or 60 minutes. - Please note that the minimum run interval varies by plan. - Airtable output can be obtained via JSONPath. For how to obtain it, please refer to the following: https://intercom.help/yoom/en/articles/9103858
■Overview This is a flow to issue a document and save it to Google Drive when a row in Google Sheets is updated. With Yoom, you can easily connect apps without programming.
■Recommended for 1. Those who manage data with Google Sheets ・If you manage data such as customer information using Google Sheets but find it cumbersome to issue documents manually
2. Companies that use Google Drive for file storage and sharing ・If you use Google Drive regularly and want to utilize it for saving and sharing invoices ・If you want to automate but don't know where to start
■Notes ・Please connect both Google Sheets and Google Drive with Yoom. ・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. ・Please note that the shortest trigger interval varies depending on the plan. ・Branching is a feature (operation) available in plans above the mini plan. In the case of the free plan, the operation of the flow bot set will result in an error, so please be careful. ・Paid plans such as the mini plan offer a 2-week free trial. During the free trial, you can use apps and features (operations) that are subject to restrictions.
You can automatically aggregate Zoom meeting information into Google Sheets. This eliminates the need for manual data entry that was previously required. This allows for time savings in data entry and reduces human errors such as duplication or omissions. Particularly for companies or teams that frequently hold meetings, efficient information management can lead to significant operational efficiency improvements.
2. Centralized Data Management and Analysis
It is possible to collectively manage the meeting information aggregated in Google Sheets. With data consolidated in one place, data analysis becomes easier. For example, you can quickly analyze the frequency of meetings or participant attendance rates, and use the results for smooth decision-making or quickly derive proposals for business improvements. This can be a significant advantage, especially for project managers or team leaders.
Conclusion
By integrating Zoom with Google Sheets, automatic aggregation of meeting information and centralized data management have been achieved! The hassle of data sharing is eliminated, and managing data aggregation and searches has become very easy. Additionally, automation reduces the likelihood of duplication or omissions due to human processes, and improvements in operational efficiency can be expected.
With Yoom, you can easily set up integrations without programming knowledge. As introduced in this article, even beginners can easily attempt app integration by copying templates and creating flows! Everyone is encouraged to integrate apps that suit their business and promote various operational efficiencies!
When the meeting ends on Zoom, retrieve the recording information and add it to Google Sheets.
While exploring ways to improve operational efficiency in a small to medium-sized enterprise in a region with limited human resources, we discovered Yoom. I was amazed at how much efficiency could be achieved by implementing Yoom, something I had casually wished for. Even without any knowledge or experience in systems or programming, our operations have significantly transformed, and I am writing to share this experience with many others who might feel the same way.
.avif)
