How to Connect Zoom Analytics to Google Sheets Using Zapier

Quick summary

This demo shows how to connect Zoom analytics to Google Sheets using a Zapier automation that automatically logs meeting data to a spreadsheet each time a Zoom meeting ends. No coding is required — the entire Zap setup is completed through Zapier's visual editor in a few guided steps.

Steps

1. Navigate to the left-side panel and click Create.
2. Choose Zaps from the list of options.
3. Tap the Trigger tab to start the integration process.
4. Search for Zoom and select it from the recommended matches.
5. Click the Trigger Event menu to open available trigger options.
6. Select New Meeting Ended as the trigger event.
7. Tap Sign In and log into your Zoom account.
8. Click Continue to proceed.
9. Specify the Meeting Type and Trigger Scope you wish to monitor.
10. Click Continue to run your input and test the Trigger.
11. Choose the specific record you wish to connect and tap Continue With Selected Record.
12. Search for Google Sheets and choose it as the Action app.
13. Tap the Action Event menu to view available options.
14. Choose Create Spreadsheet Row or Create Spreadsheet Column.
15. Click Sign In and log into your Google account.
16. Click Allow to accept terms and grant the necessary permissions.
17. Fill out the input fields with the required information one by one.
18. Choose the column where you wish to create a new row and click the Add button.
19. Select the Zoom analytics data you wish to track; repeat steps to add more rows.
20. Tap Continue to publish and enable the integration.
21. Your Zoom analytics will now be automatically recorded to your Google Sheets spreadsheet after every meeting ends.