How to obtain recording information and add it to a Google Spreadsheet after a Zoom meeting ends

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.

Execution Time
Topic
Meeting Duration (minutes)
Download URL
Shareable URL
Viewing Passcode

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.

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.

‍

Example of Automation Using Zoom

Notify the Recording URL to Chat Tools When a Zoom Meeting Ends

Automatically notify the recording URL to Slack, Discord, etc., when a Zoom meeting ends.

‍

After a Zoom meeting ends, transcribe and summarize the recording, and save the minutes as a PDF in cloud storage

After a Zoom meeting ends, transcribe and summarize the recording, and automatically save the minutes as a PDF to Google Drive, OneDrive, etc.

‍

After a Zoom Webinar Ends, Obtain the Participant List and Share the Recording Link via Email

After a Zoom webinar ends, obtain the participant list and automatically share the recording link via Gmail or Outlook.

‍

Automation Example Using Google Sheets

Notify Chat Tools When a Row is Added in Google Sheets

Automatically notify tools like Slack or Discord when a row is added in Google Sheets.

Add the content registered in the database to Google Sheets

Automatically add the content registered in Airtable, Salesforce, etc., to Google Sheets.

‍

Issue documents based on Google Sheets information

Automatically create documents such as DocuSign and Google Docs based on the content registered in Google Sheets.

Benefits of Integrating Zoom with Google Sheets

1. Automatic Aggregation of Meeting Information

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!