Zoom to Google sheet - Need registrants JOIN and Left time in sheet

[zaheer1001]

Hi Team
I was able to connect zoom Registrants to google sheet with help of one video on YT, but i want their timing JOIN LEFT to be updated there with the registration info. please guide me.

 

[Pabblymember11]

Hey @zaheer1001

You can refer to the following steps to configure your use case -

1. You need to set the webhook event in Zoom marketplace with "Participant Joined Meeting" and "Participant Left Meeting" and then capture the webhook response for the same.

2. Then you need to check the participant whether they entered or leave after attending with the help of "Lookup Spreadsheet Row" then you can pass the entered and leaving date accordingly.

3. Then you can select the filter of "Start Time" and "Leave Time" from the response received on Lookup Spreadsheet action step.

4. In the Registrant Left route, you need to use the "Google Sheets: Update" action step.