Google Sheets to Calendar Event with Invites

How To
, ,
3

Sounds like the issue is that Google Calendar’s “Attendees – Email” field in Make doesn’t accept a single comma-separated string—it needs an array of individual email values. When there’s only one email in your cell, it works because it’s already just a single string.

To fix it, you can split that cell value into separate items before passing it to the Calendar module:

  1. Add a Text Parser → Split module (or use the Array aggregator if you prefer) after your Google Sheets trigger.

  2. Split the “Guests” field by , (or , if you have spaces). This will turn "email1@example.com, email2@example.com, email3@example.com" into an array like:

  3. Map that resulting array to the “Attendees – Email” field in your Google Calendar “Create an Event” module.

That way, each attendee gets passed in separately and Google Calendar won’t reject the list.