Hi ​@helphilt,

Welcome to the Community.

If a Zap didn’t add all attendees to an Excel sheet, check Zapier's Zap History for errors, consider rate limiting by connected apps, or note Excel's limitations with simultaneous edits. Switching to Google Sheets can resolve simultaneous edit issues, or using Zapier's Digest tool can batch attendee data to avoid rate limits and editing conflicts.

I hope this helps! Let me know if you have any other questions.

Hi thanks so much for this. Can you explain how I should use the digest tool in this, please? 

Hi ​@helphilt 

I expect Jammer was thinking that you could use Digest to compile a list of attendees into a digest then when the digest is released have it’s contents added into a single spreadsheet row. You can learn more about how to use Digest here: Compile data in a digest in Zaps.

That said, if the New Participant Joined Webinar or Meeting trigger is failing to trigger on each new attendee then I don’t think using a digest would solve things. That trigger is an instant trigger so the Zap should be triggering for each set of attendee information that Zoom sends us. 

Can you search the Zap’s history for each attendee name to see whether they all triggered the Zap? That will help to narrow down whether the issue is that the Zap is triggering but failing to add the row in some cases, or whether it’s failing to trigger for some attendees. 

And can you confirm whether there are any differences between the attendees that were added to the spreadsheet and those that weren’t added—could some have joined without logging into a Zoom account perhaps?

Also, is this happening consistently or have there been some meetings where all the attendees were added to the spreadsheet successfully?

Looking forward to hearing from you on this!

Hi Sam! For tonight’s meeting, we are missing 2 names once again. I searched one of the missing names and this error appeared!
 
So it must be a case of excel not allowing that many line items update at once. Do you know a workaround for this?

We just want to capture who attended the meeting on zoom so that we can email them the resources one day later. Thanks for your help again.
 

I clicked ‘help me fix it’ and AI suggested I add a delay before the ‘add new row to excel’ action. So I added a 1 minute delay between the zoom and the excel to test in tomorrow’s meeting. Not sure if this will help!

Hi Sam, sorry, one last thing. Is there an alternative if we do not have access to a google account to use google sheets? Thanks!

Thanks for checking on that ​@helphilt—that error helps to make the cause of the issue clearer! 

It appears the Zap is triggering for each meeting attendee at around the same time and that’s causing too many Excel actions to be run at the same time—resulting in that new error you’re seeing. If you replay that errored Zap run it should be able to go through successfully now.

To avoid this happening again, you’ll want to ensure that the Delay action you added is a Delay after queue action as that puts everything in a queue so that they are run one at a time. You can learn more about that here: Delay after queue

Hope that helps. Please do keep us in the loop on how it goes with tomorrow’s meeting, want to make sure this gets sorted! 

Thanks, Sam. That helps a lot. So the below is my new workflow. I changed my delay to delay after queue and put in 1 minute. Do I need to change all delays to delay after queue or is it okay if the latter delays stay as they are (1 day delays)?

I am testing it at another event today, excited to see does this help. 
 

Glad my suggestion was helpful, ​@helphilt! 

The second Delay action would indeed need to remain as a Delay For action to ensure the Send Email action is run a day later. So what you’ve done in that screenshot looks perfect!  

Excited to hear how it goes and hope the event goes well today!