Oct 11, 2018 11:07 AM
Hello! Is it possible to use airtable + zapier to find 1 email address (out of many) on a google calendar invite and match that to a record on the airtable people list? Ideally, the end result is that within Airtable, I can see when I last had an appointment with someone on my “people” list based on calendar events.
Oct 11, 2018 01:38 PM
Regarding your ideal result, you can create a table to track contacts and another table to track interactions. These tables would be connected, so that every interaction would be assigned a contact. Then, on the contacts table, you can pull the recent contact in through a roll-up field, using the MAX(values) function. This is the quickest way to track your most recent appointment with someone on your contacts table.
I’m not sure exactly how this ties into Zapier, given your unique workflow. You can establish an API connection to Google Calendar and Airtable using Zapier. Furthermore, you can build a filter in your zap that only proceeds in the case of a specific email address being present. I’m not sure how you’re looking to tie that into your end result, but everything you’ve described here is possible.
Hope this helps!
Oct 11, 2018 02:36 PM
I think I see what you’re trying to do - to go through the attendees associated with a calendar entry and if found record it in the database (maybe as an Activity record)?
In this case I would recommend you try Integromat to do the integration - I don’t think Zapier can do this yet although it’s also a great tool!
Integromat allows you to capture new calendar entries and then iterate through all the attendees and perform some actions. This could be to search Airtable and update or create records - it should even be able to delete things wif a calendar entry is deleted I think.
I hope this helps?
Oct 16, 2018 05:21 PM
hi @Ally_Warson, it sure is possible. here’s how you would do that:
Google Calendar - new event (or what ever you choose)
Airtable (AT) find record
Only continue if:
Step 2:Fields Email = exists
AT Update record
Hope that helps.
Oct 18, 2018 08:12 AM
The problem with using Zapier for this is that Calendar will return multiple attendees for a meeting and these need to be looped through so that a note can be made against each (perhaps in several Activity records for example).
In this particular use case, Integromat has built in functionality to process steps for each meeting attendee.
Hope this helps?
Oct 21, 2018 06:06 PM
Are you available for a project…
I need help setting up my corporate data bases, blocks, using other apps, slack, drive, google mail
Just let me know
Oct 22, 2018 09:21 AM
Very cool. Thank you Julian. How would you do this with Integromat?
Oct 22, 2018 11:46 PM
In Integromat, you first use a Watch Events Calendar app and then an Iterate Attendees - and steps you add after this will be actioned for each attendee of the calendar event. This could be adding or updating Airtable records etc…
Oct 22, 2018 11:53 PM
I will have availability shortly (I am tied up for until late next week). In the meantime, could I suggest you send me an email at email@example.com with a little more detail about what you are trying to achieve and a little about your business?
If you’d like to book an online meeting with me then you can at the following link:
and you can find out more about me at:
I look forward to hearing from you!
Oct 24, 2018 09:30 AM
Great thank you!
What formula should I use within the “Search records” module, to find the name of the attendee, I read their docs but it is not very clear to me…
Oct 30, 2018 10:13 AM
Following up on this. Thanks!
Nov 02, 2018 03:56 AM
Back in the office now - if I understand what you’re asking, the search would probably be by email and the formula would be something like: