Hi there, @artistry!

Could you share a little more information to help us understand how your Zap is set up? From what you’ve said it sounds like you’d like to:

Trigger a Zap from a new event in Google Calendar (are you triggering the Zap from a new event or using the Event Start trigger?)

Find the email addresses of people who have accepted the invitation

Send those email addresses to a field in Airtable (what kind of field is it? Do you need the email addresses as separate records or as one text field in the same record?)

Is that right? If we have a good picture of what you’re trying to do it’ll be easier for other people to chip in with a suggestion

Thanks @Danvers 

Yes. I’d like it to be on Event Start send a list of all Attendees that have the status “Accepted”

Hi @artistry 

For the trigger, GCal Event Start it will return the attendees as an array (aka line items).

For each attendee it will include a responseStatus field. (see screenshot)

You may need to use a Code step to filter for the “accepted” attendees.

Hi @artistry,

Depending on the Zapier plan you have and the data Zapier allows you to use, you may be able to create a loop to run through each attendee and grab the status of each email, and then update airtable accordingly.

Hope this gives you some ideas!

Happy Zapping!

@artistry 

Here’s the Looping app that @XRay Tech mentioned: https://zapier.com/apps/looping/integrations#triggers-and-actions

@artistry 
Just checking in to see if you still need help with this? 

Just popping in to summarize the answer here! :)

• The Event Start trigger for Google Calendar returns a list of attendees and their responses as line items.
• The responseStatus field contains details of whether the user has the status of accepted or not.
• A Code by Zapier step can be used to filter the list of attendees to return only those with an “accepted” status - Code (Javascript) Examples
• Alternatively, Looping by Zapier could be used to go through each email address in the line items supplied by Google Calendar and update Airtable accordingly. You can find out more about working with Looping by Zapier here: Loop your Zap actions