Skip to main content

I’m trying to create a Zap that connects GCal to Airtable. This was one of the recommended Zaps. Here’s what I need to do: 

1). Someone accepts my calendar invite.
2). I look for the calendar invite acceptee in Airtable, searching for by email.
3). If there’s a matching email record in Airtable, I want to update an Airtable field that says “Mtg Accepted”. 
4). If no matching email record in Airtable, do nothing. 

I can set all this up, except in the Gcal to Zapier sync, you can see that Zapier is pulling both my email address (the calendar invite sender) and the recipient email address (calendar invite acceptee). 

How do I just search in Airtable for the acceptee email? Because, obviously searching in Airtable for both of our email addresses won’t match anything. 

My thought is to write a search formula that parses out the sender email, but I can’t seem to get the search function correct. 

Any help would be greatly appreciated! Thanks in advance. 

Hi @JD_PMf360 

Good question.

There are a few different approaches…

  1. Looping followed by a Filter step.
  2. Ask AI (ChatGPT/OpenAI) to isolate the email address for you.
    1.  

  3. You could use a Code step to filter out your email address.

 


Reply