Update Gcal event when record changes without resetting RSVP's

The behavior of Google Calendar is that it will lose people’s RSVP status if you change the event’s date or time. (It won’t lose the RSVP status if you just change the event title or description.)

If you are simply updating the event title or description, but you are updating it in such a way where you are re-sending it all the attendees again, my guess is that it is overwriting the old attendees with the new (same) attendees again. So I would try updating it in such a way where you don’t send the attendees to Google with the update.

Thanks, Scott! In my situation, the date and time are not changing, however someone new is added to the list of attendees. It works like this:

1. Someone new fills out a form in Airtable


2. Their email addresses is automatically added to a formula field that collects the email addresses of everyone who needs to be invited to the event.


3. The automation grabs from that field when it is changed and updates the event.

I ran a little test and confirmed that simply changing the list of attendees in a normal (non Airtable) event does not cause this to happen, even if I delete all attendees and re-add them all. I would have expected Airtable to simply paste in the list of email addresses to the attendee field and call it a day, but something else must be happening.

Any other ideas?

Right, Airtable is overwriting the old list of attendees with your new list of attendees. It isn’t just adding the new person to the event, it is replacing the old list with the new list.

It also warns about this behavior in the Airtable automation screen for the attendees field: “Setting this field will replace existing attendees rather than only add new ones.”

So if you’re only using Airtable’s native automations, there is no way to simply add new attendees by using Airtable’s native automations.

If you’re looking for a no-code way of doing this, your best bet would probably be to use the Google Calendar modules of Make.

You can see in the screenshot below that it gives you the option of appending attendees (i.e. adding attendees) instead of replacing attendees. You would toggle this setting to “Yes” to add new attendees.

However, you’re going to end up with a similar problem unless you restructure something — either on the Airtable side or the Make.com side. If you send the same exact email address once again to the same Google Calendar Event, Google will STILL reset the RSVP status of that person — even if you have turned on the “append” function.

Currently, you’re still sending an entire batch of email addresses to Google, so you’re still sending the same email addresses over & over again. So you’ll want to setup your Airtable base to only send the new email addresses. Or, you can setup a complex scenario in Make to compare which email addresses you’ve already sent, and eliminate those from sending to Google again.

So the only way to get the behavior that you want is the following:

1. Turn on the “append” function in the Google Calendar module.
   
   AND
   


2. Only send brand new email addresses to the event.

So #1 can be solved by using Make.com. But for #2, you’ll have to solve that on either the Airtable side or the Make side of things.

Also, if you’re comfortable with programming code, you can also get this “append” functionality by using the datafetcher.com extension or by writing your own Javascript code.

Any suggestions on how to only send brand new emails via Airtable or Make? I've been working through testing options within Make, I assumed it was a filter but I can't seem to get it to work. Other options within Airtable would be greatly appreciated