I have a team of multiple people who are assigned to certain events. They are in a multiple select Field “Onsite Team” with options like: Judy (lead), Judy (asst), Ben (lead), Ben (asst), etc… where each person can be 1 of 2 roles and we have at least 2 ppl assigned for an event. Ex) EVENT X has Judy (lead) and Ben (asst).
What I want to automate:
Find EVENTS (records) for Judy that have her assigned, either as lead or asst, and create a Google Cal event for her (with info from Airtable like event address, start date, time, etc…)
If Airtable is updated (like date or time changes), I want it to automatically update the created Google Cal event.
If Judy is no longer assigned to that Event, I want her Google Cal event to delete.
Repeat for other team members.
What I’ve tried:
I’ve started using the Airtable automations feature but I haven’t been able to update events, just create them. I’ve also read multiple info docs, mostly on formulas, but it’s all Greek to me and I need a bit more help/explanation.
There is no way to accomplish #3 using Airtable’s native automations.
You also couldn’t do a “Find Records” without writing a script (or external automation) as well, although you could potentially trigger #1 in a different way.
You mentioned both Zapier and my personal favorite automation tool Integromat — I would advise against using Zapier because it is more expensive but less powerful & less customizable than Integromat.
What you want to do would likely take several hours to setup — If you have a budget for your project and you’d like to hire an expert Airtable consultant & Integromat Expert+ Partner to help you create this, please feel free to contact me through my website: