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

Sorry,



I have been busy this week ... Please, try with this file... Remember to change email addresses



Best Regards


Hi German,



Thanks, but shortly after my last post, without doing anything in prod, Google started recognizing the RSVP with the OoB ICS file we had in prod. So strange. I'm thinking this was a Google problem after all.



Thank you for all of your help with this.


Hello German,

 

I am trying to create a Meeting invite in GMail from SN.
I tried to create a payload myself after referring to this post. Below is the code:-

payLoadGmail : function(gr){
var sDate = this._formatDate(gr.u_start_date);
var eDate = this._formatDate(gr.u_end_date);

var GPayload = "";
GPayload+= "BEGIN:VCALENDAR";
GPayload+= "PRODID:-//Google Inc//Google Calendar 70.9054//EN";
GPayload+= "VERSION:2.0";
GPayload+= "CALSCALE:GREGORIAN";
GPayload+= "METHOD:REQUEST";
GPayload+= "BEGIN:VEVENT";
GPayload+= "DTSTART:" + sDate + "\r\n";
GPayload+= "DTEND:" + eDate + "\r\n";
GPayload+= "DTSTAMP:" + this._formatDate(new GlideDateTime().getValue()) + "\r\n";
GPayload+= "ORGANIZER;CN=Full Name:mailto:abc@abc.com";
GPayload+= "UID:orprgbsiga8otk1g04fcvlfais@google.com";
GPayload+= "ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE;CN=https://devxxxxx@servicenowdevelopers.com;X-NUM-GUESTS=0:mailto:xxxxxx@gmail.com";
GPayload+= "CREATED:" + this._formatDate(new GlideDateTime().getValue()) + "\r\n";
GPayload+= "DESCRIPTION:View your event at https://www.google.com/calendar/event?action=VIEW&eid=b3Jwcmdic2lnYThvdGsxZzA0ZmN2bGZhaXMgcmJlZW1hbkBpcnZpbmVjb21wYW55LmNvbQ&tok=MjcjaXNhYmVsbGVlQGlydmluZWNvbXBhbnkuY29tYTc0NDdiYzU3Y2RjOWIwNGI3NjM2NGM5YTcyNjhhN2RhZjc0ZDIwNw&ctz=America/Los_Angeles&hl=en.";
GPayload+= "LAST-MODIFIED:" +this._formatDate(new GlideDateTime().getValue()) + "\r\n";
GPayload+= "LOCATION:TBD";
GPayload+= "SEQUENCE:0";
GPayload+= "STATUS:CONFIRMED";
GPayload+= "SUMMARY:Test";
GPayload+= "TRANSP:OPAQUE";
GPayload+= "END:VEVENT";
GPayload+= "END:VCALENDAR";

gs.log("Payload for google calendar "+GPayload,"Payload for google calendar");

var att = new GlideSysAttachment();
att.write(gr, "Google_Meeting_Invite[" + new GlideDateTime().getValue() + "].ics", 'text/calendar', GPayload);

But i am not receiving any email in my google mail account. For testing, i also sent it to an outlook account, where i received the mail with the attachment link. However, i try open it says operation failed.

Kindly provide inputs/help on this.

Thanks in Advance!!!

Robert Beeman
Kilo Sage

Sometimes Google formats it like this as well (without the nice calendar graphic). I'm not sure what determines the differences.


plain_add_to_calendar.jpg


Hi there.



I am facing a somewhat similar issue here where I am unable to view the detailed meeting invite sent by Outlook to Google mail.


However the software I am using is different from yours. We are using Outlook at work and due to the complications in syncing outlook calendar on phone, I integrated my company email onto gmail and send outlook calendar to my gmail (send to myself) to ease this complication.



Previously, when i forward a outlook calendar invite to my gmail, I was able to view the 'Add to calendar with the RSVP within gmail platform. I recently made some changes to the settings in both outlook and gmail and now all invites from outlook appears with only the ics attachment.



I've spent the whole day trying to fix this. Do you think you can possibly help me out with this?


As a temporary solution, I have resorted to importing/exporting cvs outlook calendar onto gmail calendar. This is a manual task but I would prefer to resort to the earlier setting.