Meeting Invite (ICS) with RSVP to Google Gmail/Calendar

Robert Beeman
Kilo Sage

We have just recently switched our domain from Outlook/Exchange to Google Apps. In Outlook, our meeting invites that come from OoB Changes worked just fine. Once we switched to Google, our users were just receiving a blank email with an attached ICS file that Gmail wouldn't parse. We have an older instance and I found that the change.calendar.integration email template had this line with a variable that resolved to nothing.

PRIORITY:${priority}

I checked a clean personal developer instance, and I saw that they now hardcode it to this:

PRIORITY:3

After I changed that line on our template, Gmail now parses it, but it just has an "Add to Calendar" option instead of a "Yes, No, Maybe" RSVP.

Current State:

Add_to_calendar.jpg

We noticed that without the RSVP, the invite does not get recognized on iPhones as a meeting request so it doesn't get automatically added to users' calendars. We are trying to get the Yes, No, Maybe options from an RSVP like this:

Desired State:

Yes_no_maybe.jpg

We are using the OoB change.calendar.integration template, which is:

BEGIN:VCALENDAR

PRODID:-//Service-now.com//Outlook 11.0 MIMEDIR//EN

VERSION:2.0

METHOD:REQUEST

BEGIN:VEVENT

ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:${to}

ORGANIZER:MAILTO:${from}

DTSTART:${dtstart}

DTEND:${dtend}

LOCATION:${location}

TRANSP:OPAQUE

SEQUENCE:${sys_mod_count}

UID:${number}

DTSTAMP:${dtstamp}

DESCRIPTION:${description}

SUMMARY:${summary}

PRIORITY:3

X-MICROSOFT-CDO-IMPORTANCE:${priority}

STATUS:CONFIRMED

CLASS:PUBLIC

END:VEVENT

END:VCALENDAR

Has anyone got this to work properly with Google specifically?

15 REPLIES 15

As an experiment, I copy and pasted the ICS file from Google into my change.calendar.integration template and created a Change to test. So I am and sending their own ICS file back all hardcoded. It reverted to the blank email with just a download link to the ICS file. It didn't parse it at all.


Try to put the original one, but with "PARTSTAT=NEEDS-ACTION" parameter at   ATTENDEE line


I tried to add to Outlook the file you created with google, and it is not valid...



Interesting...


I tried again, with a little more care, and I had to delete two additional spaces at each line, and now it's working as expected, so, there seems to be the problem. Please, be carefull with the line formatting!



find_real_file.png


I see what you mean about the two extra characters. I removed them and tried emailing it again. It came out like this...google_test.jpg



Why does it keep changing?