Is it possible to create a Zap or Zaps that will bring in attendane records from Zoom (First, Last, email address), meetings attended (e.g. meeting id, meeting date, meeting name), and total time spent in each meeting (aggregated not multiple times) per user per meeting into a Google Sheet?
Best answer
Looking to download Zoom meeting attendance data
Best answer by JoelJBest answer by JoelJ
Hi All,
Here are the steps I followed to get this going in the interim. Assuming intermediate experience with Zapier here.
Steps
Setup a Webhook trigger in Zapier and get the Webhook URL
With admin permissions, create a webhook only app in Zoom Webinar instance (https://marketplace.zoom.us/develop/create)
Enter the required information need and navigate to the “Feature” section and setup the “Event Subscription” with the required information
Next, enter the Zapier webhook URL from step 1 into the “Event notification endpoint URL” field in Zoom.
Also, add the event types for which the webhook should fire, which in this case would be “joined Webinar”
Activate the app as account level app and “intent to publish” as no, unless you want the app to be listed on the Zoom Marketplace.
Next, setup a test webinar and have someone join as an attendee. Post this, go back into Zapier and the “Catch Hook” should be able to pull up the test attendee under the “test trigger” step.
Regards,
Joel
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Expert
- 30957 replies
Hi
These are the available triggers for Zoom via their Zap app:https://zapier.com/apps/zoom/integrations#triggers-and-actions
+9- Architect
- 1348 replies
Hey
The Zapier–Zoom integration isn't able to see a list of attendees after a meeting or webinar ends. I've added your vote to our request for this feature, so we'll keep you posted if this becomes possible in the future.
Right now, it's possible to see when someone *registers* for a webinar, and then add their registration info to Google Sheets, to create a new row for each new registrant: https://zapier.com/apps/google-sheets/integrations/zoom/67545/generate-google-sheets-rows-for-new-zoom-registrants
^ but this kind of workflow wouldn't be able to confirm which webinar registrants did or didn't attend.
I’m super keen for this feature too. We run regular events on zoom, and want to track attendance across time. The only way to do this is to manually login and download each event’s report. But for hundreds of events, that isn't feasible. Is there no way to automatically pull attendance data of normal events using Zapier or some other API?
+11- Zapier Staff
- 2115 replies
Hi
I’ve added your vote to the list as well. In the meantime, you could check out the Zoom API docs here (https://marketplace.zoom.us/docs/api-reference/zoom-api/meetings/pastmeetingparticipants) to learn more about getting past meeting participants. You can explore using JSON Web Tokens: https://marketplace.zoom.us/docs/api-reference/using-zoom-apis.
Like other Webinar Software, the feature of Webinar Attendee and Webinar Missed Triger is necessary to connect zoom with Email software through Zapier. I request Zoom authority to think about it.
+6- Zapier Staff
- 177 replies
Hey
Thanks for the feedback here, were you wanting to be added to the notification list for the feature request as well?
I’d be happy to add your vote, but wanted to make sure you wanted to be included in that list.
I’d love to collaborate with anyone who’s up for trying to figure out how to make this work with a generic Zap and Zoom’s API (thanks for the handy links,
+11- Community Manager
- 7487 replies
Hey
Yes please,
Hi
JoelJ wrote:
Hi
Hi
+11- Community Manager
- 7487 replies
Hey
Happy to confirm that I’ve added your votes to the feature request. We’ll email you directly as soon as it’s possible!
Hi All,
Here are the steps I followed to get this going in the interim. Assuming intermediate experience with Zapier here.
Steps
Setup a Webhook trigger in Zapier and get the Webhook URL
With admin permissions, create a webhook only app in Zoom Webinar instance (https://marketplace.zoom.us/develop/create)
Enter the required information need and navigate to the “Feature” section and setup the “Event Subscription” with the required information
Next, enter the Zapier webhook URL from step 1 into the “Event notification endpoint URL” field in Zoom.
Also, add the event types for which the webhook should fire, which in this case would be “joined Webinar”
Activate the app as account level app and “intent to publish” as no, unless you want the app to be listed on the Zoom Marketplace.
Next, setup a test webinar and have someone join as an attendee. Post this, go back into Zapier and the “Catch Hook” should be able to pull up the test attendee under the “test trigger” step.
Regards,
Joel
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.