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
Send list of people who have accepted a Google Calendar event to Airtable
Best answer by SamB
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
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+12- Zapier Staff
- 3731 replies
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- Zapier Orchestrator & Solution Partner
- 34020 replies
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- Zapier Solution Partner
- 65 replies
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- Zapier Orchestrator & Solution Partner
- 34020 replies
Here’s the Looping app that
+11- Zapier Solution Partner
- 2446 replies
Just checking in to see if you still need help with this?
+11- Community Manager
- 9676 replies
- Answer
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.