Use Smartsheet Calendar with Google Calendar

Integrating Smartsheet Calendar with Google Calendar keeps your tasks and events in sync, so you can manage all your deadlines in one place.

Who can use this?

Plans:

  • Pro
  • Business
  • Enterprise

Permissions:

  • Editor
  • Admin
  • Owner

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

You can integrate the Smartsheet calendar with Google Calendar in two ways:

  • Publish to Google Calendar: View dates you create in Smartsheet directly in your Google Calendar; changes made in Google Calendar don’t sync back to Smartsheet.
  • Overlay a Google Calendar: Add a Google Calendar to a Smartsheet calendar and use Calendar View to compare tasks between the two. When using this feature, consider the following:
    • This is only available in sheets; reports are out of scope. 
    • The Google Calendar items are read-only; you can't edit them in Smartsheet.
    • Your Google Calendar overlay is visible only to you; other collaborators don't see it.

You can publish or overlay 600 rows per sheet. If you work with more than 600 rows, use the Publish iCal feature as an alternative.

Publish to Your Google Calendar

  1. Switch to Calendar View.
  2. Select Publish to a Google Calendar icon  Publish Calendar. The Publish to a Google Calendar dialog appears.
  3. Switch the slider to ON and enter a name for the Google calendar.
    Smartsheet Calendar with Google Calendar
  4. Select OK.

All tasks from the sheet appear in Google Calendar under your chosen name. Any new tasks or updates you make in the sheet are automatically synced to Google Calendar.

If you drag a Smartsheet task in Google to change its date, the change doesn't sync back to Smartsheet. However, you can use the link in the event details to make changes directly to the row.

Overlay a Google Calendar

  1. Switch to Calendar View.
  2. Select the Overlay a Google Calendar icon Calendar Overlay button. The Overlay a Google Calendar dialog appears.
  3. Switch the slider to ON and select the Google calendar to overlay onto your sheet.

Google may ask you to grant Smartsheet permission to use your Google credentials if you're already logged in to your Google account. Otherwise, you must provide your Google account information.

Smartsheet Calendar with Google Calendar
  1. Select OK.

The Google Calendar events appear on your sheet, and your changes in the Google Calendar are synced back to your sheet.