Opening messages directly in Gmail

Showcase Tips and Hacks
1

Hi all,

I was looking for a way to be able to open any emails that were synced to a table in my doc. I came up with the following workaround:

  1. Create a button with the “Open hyperlink” action
  2. For the URL, use this formula:

CONCATENATE("https://mail.google.com/mail/u/0/#inbox/",thisRow.Email.Id)

Hope that helps.

Regards,

Shaheed

8 Likes
2

Interesting! Thanks @Shaheed_Fazal. I’m trying to figure out a way to have someone accept or decline a Google Calendar invite, do you think this would work doing this?

3

Perhaps not directly but if in the similar way to the GMail task I posted, you find out what the event ID is you could navigate to the page directly:

https://calendar.google.com/calendar/r/eventedit/LONGID

I have not tried this but let me know if it works.