Multiple Attendees for Automated Calendar Invite via Sheets

Question

I hitting an error when I try to add multiple attendees via my spreadsheet. It works with one but when I try comma-separate to include multiple attendees it throws an error:

Error GoogleJsonResponseException: API call to calendar.events.insert failed with error: Invalid attendee email. createNewEventWithMeet @ Code.gs:34

Link

function createNewEventWithMeet() {

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("Calendar_Events");
  var last_row = sheet.getLastRow();
  var data = sheet.getRange("A2:E" + last_row).getValues();
  var cal = CalendarApp.getCalendarById("[email protected]");

  for(var i = 0;i< data.length;i++){

    var event_name = data[i][0];
    var start_time = data[i][1];
    var end_time = data[i][2];
    var event_description = data[i][3];
    var attendees_event = data[i][4];

//.setVisibility(CalendarApp.Visibility.PRIVATE);

  const mst = "-06:00";
  const calendarId = "[email protected]";
  const resource = {
    start: { dateTime: start_time+mst },
    end: { dateTime: end_time+mst },
    attendees: [{ email: attendees_event }],
    conferenceData: {
      createRequest: {
        requestId: "[email protected]",
        conferenceSolutionKey: { type: "hangoutsMeet" },
      },
    },
    summary: event_name,
    description: event_description,
  };
  const res = Calendar.Events.insert(resource, calendarId, {
    
    conferenceDataVersion: 1,
  });

  
  var googleMeet_Link = res.hangoutLink;
  
  console.log(res);
  }
}

I've tried to create multiple columns to split it out but I cannot seem to make it work.

Wicket · Accepted Answer · 2025-07-28 20:39:23Z

0

The Event Resource requires a valid email address for each attendee.

From the code in the question,

var attendees_event = data[i][4];

attendees: [{ email: attendees_event }],

You should extend the code to split the values of data[i][4], then add one {email: value} to attendees for each value resulting from the split.

One way to do this is to change the above-referred code lines with the following:

var attendees_event = data[i][4].split(",");

attendees: attendees_event.map(attendee => ({email: attendee})),

edited Jul 28 at 20:39

answered Jul 28 at 19:33

Wicket

39.4k9 gold badges81 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

J Bardo Jul 28 at 21:01

That worked PERFECTLY! One thing that I'd like to add, if it's easy enough. Everytime it runs it also re-creates the previous invites from old rows. I could autohide those rows or maybe put an "x" in a column for the ones that have already been created. Or is there a better way within that script?

Wicket Jul 29 at 13:43

@JBardo , it depends on whether you need to track the events created in the spreadsheet and how the event data is entered.

J Bardo Jul 29 at 14:34

It would be nice to have the spreadsheet be the running log of all events created. I linked the spreadsheet in the initial comment and that's how I had planned to log in event data

Collectives™ on Stack Overflow

Multiple Attendees for Automated Calendar Invite via Sheets

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related