Google Sheets to Calendar Event with Invites

[Taelormb]

Hello everyone,

I’m trying to create Google Calendar events from a Google Sheet using Make. The process works for single-attendee events, but I’m running into an error when I try to invite multiple guests listed in a single cell.

My Goal: I want to create a Google Calendar event and invite multiple people whose emails are all in one cell of a Google Sheet, like this: email1@example.com``, ``email2@example.com``, ``email3@example.com.

My Setup:

• Google Sheet: I have a column named Guests that contains the email addresses.

• Make Scenario: I’m using the Google Sheets “Watch New Rows” module to trigger the scenario, and then the Google Calendar “Create an Event” module.

  I keep receiving the error message pictured no matter what function I put in the Attendees - Email field in the google calendar event. The scenario works when their is one email in a cell, but not with two separated by a comma.

  Could anyone help me figure out the correct function or method to properly parse the guest list from a single cell so I can invite multiple people to the event?

  Any help would be greatly appreciated!

  

[Mike_Xander]

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.