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.
GCal to Airtable: How do I craft this Search Function to just isolate the calendar acceptees?
Userlevel 1
- Beginner
- 2 replies
Userlevel 7
+14
- Certified Zapier Expert
- 24344 replies
-
13 June 2023
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.