Update a Smartsheet row date automatically when a Google Calendar event is moved

Question

Hi all,

I'm trying to link Google Calendar events to specific rows in a sheet so that when an event is rescheduled in Google Calendar, the date on the matching Smartsheet row updates automatically.

From what I can see, the native integration doesn't cover this. Publishing a sheet to Google Calendar is one way (Smartsheet to Google), so dragging an event in Google doesn't change the row. The Google Calendar overlay in Calendar View displays events alongside the sheet but doesn't update a date column on a specific row.

The approach I'm considering is storing the Google Event ID in a column on each row, then using an automation to watch for event updates, find the row by Event ID and overwrite the date. Options I'm weighing:

* Zapier, Make or Power Automate (updated event trigger, then search rows by Event ID, then update row)
* A two-way sync connector such as Unito or InfoSpark
* Google Apps Script with an installable calendar trigger and the Smartsheet API

For anyone who has set this up:

* Which route has been most reliable for you?
* Any gotchas with all-day vs timed events or time zones (I'm in the UK, so GMT/BST) causing dates to land a day out?
* Is there a native option I've missed?

Thanks in advance!

msmariaa · Answer

Hi @Paul Newcome

Thanks I have been able to try something with App Scripts

Paul Newcome · Answer

You are definitely going to need something third party whether that be the options you mentioned above, the API, or the premium add-on Bridge.

The Smartsheet Calendar View does not accommodate times though. It will only show each row on the date (or dates if you select start and stop dates). To work the time and time zones in, you would want a formula in the Primary Column that concatenates the details into a single string in this column that includes the times and time zone.