I figured out a solution. I’m using Zapier to create the Google calendar event. Google has 2 types of links to calendar events:
First link (called HTML Link) is available in Zapier, but does not have the ability for user to save to calendar when sent over SMS. User has to copy the event to their calendar, which is easy to miss and clunky.
Second link is not available in Zapier. If you go to the calendar event in Google Calendar, there is an option to “Publish Event”. This provides a link, which has a “Save” button. I was able to deconstruct this URL and rebuild in Zapier - combination of hard-coded text that is always the same + event ID (available in Link 1, use Zapier Formatter to extract) + a field called “Organizer Email” which is basically the ID for the calendar.
Adalo-Zapier Integration: New Adalo record triggers Zapier
Zapier-Google Calendar Integration: Creates Google Calendar Event with details from Adalo record.
Zapier Formatter: Use truncate to extract Event ID from Google Calendar HTML Link.
Zapier-Twilio Integration: In the SMS message build Publish Event link - below, replacing [EVENT ID] and [ORGANIZER EMAIL] aka calendar ID. You can text this link to users, which will open the event with a “Save” button.
https://calendar.google.com/event?action=TEMPLATE&tmeid=[EVENT ID]&tmsrc=[ORGANIZER EMAIL]