I’m looking to take a calendar event from google and put it into Airtable and finding success. but I want to be able to have it return the email addresses of ONLY the users that have accepted the invitation. How is the best way to go about that?
Best answer by SamB
View original
+12
Hi there,
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
Yes. I’d like it to be on Event Start send a list of all Attendees that have the status “Accepted”
+14
Hi
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.
+4
Hi
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! 👍
+14
Here’s the Looping app that
+10
Just checking in to see if you still need help with this?
+11
Just popping in to summarize the answer here! :)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
