I am trying to create a Google calendar event for the user who submits leave request on google form. When this form response is recorded in google sheets, I get the user email id and want to create a calendar event for them. Script creates event when I use my email id, but it gives null when I try to do the same for other user.

Here is the sample code:

CalendarApp.getCalendarById(email)
        .createAllDayEvent(
            'OOO - Out Of Office',
            startDate,
            endDate,
            {
              description: message,
              sendInvites: true,
            }); 

I received this error: Cannot read property "createAllDayEvent" of null

I googled this error, and someone suggested that subscribing to user's calendar may solve this issue. I used the following snippet to counter that:

var calendar = CalendarApp.getCalendarById(email);
  if(calendar == null){
    //user may not have access, auto-subscribe them.
    calendar = CalendarApp.subscribeToCalendar(email,{hidden:true,selected:false});
  }

But it is showing a new error stating: The calendar or calendar event does not exist, it was deleted, or the user doesn't have access to it

Any idea how we can make it work. Thank you.

CodePudding user response：

You can't do this on Form Response (at least not reliably).

To create an event in another user's calendar they must have changed their calendar settings to be available to the public and the Access Permissions must be set to 'Make changes to events'. More information about this can be read on this help page

If these settings aren't set by the user, you're out of luck creating events for them. In this case you have two options:

1. Create an OAuth2 Application which the user authenticates to allow the creation of Calendar events on their behalf (though this still can't be done on form submit)
2. Create an event on your calendar and send them an invitation using their email address. You can give them edit permissions to the event so that they have control of it as if it were in their calendar, though in this case they will have to accept the event invitation.