Use a Smartsheet Calendar with Google Calendar

If you want to integrate a Smartsheet calendar with a Google calendar, you have two options:

  • Publish to Google Calendar This option allows you to view dates created in Smartsheet in the Google calendar. Note, however, that it won’t allow you to add calendar items from Google to Smartsheet.
  • Overlay a Google Calendar in Smartsheet In Calendar view in Smartsheet, you can overlay a Google Calendar so that that you can compare tasks between the two calendars.

NOTE: This feature works with sheets only (it does not work with reports even when they’re displayed in Calendar view).

Before You Begin

  • You can publish or overlay up to 600 tasks (rows) per sheet. If you are working with more than 600 tasks, you may want to use the publish to iCal feature as an alternative. For more information, see Publish a Smartsheet Calendar to iCal.
  • You must be shared to the Smartsheet item with Editor-level permissions or above to use this capability.

Publish to Your Google Calendar
  1. Switch to Calendar View.

    Calendar View on toolbar

  2. Click Publish Calendar Publish to Google Calendar to open the Publish to a Google Calendar window.
  3. Switch the slider to ON and enter a name for the Google Calendar.

    Publish to a Google Calendar window
  4. Click OK.

All tasks from Smartsheet will appear in a new calendar in Google Calendar. When you add new tasks or change existing tasks in Smartsheet, the changes will be visible automatically in your Google Calendar.

NOTE: If you drag a Smartsheet task in Google to change its date, the change will not sync back to Smartsheet. However, you can use the link provided in the event details to make changes directly to the row.

Overlay a Google Calendar
  1. Switch to Calendar View.

    Calendar View on toolbar

  2. Click Calendar Overlay button Overlay Google Calendar to display the Overlay a Google Calendar window.
  3. Switch the slider to ON and select the Google calendar that you want to overlay.

    Overlay a Google Calendar
  4. Click OK.

Changes made in Google Calendar are reflected in your Smartsheet Calendar. Google Calendar items are read-only—they cannot be edited in Smartsheet.

NOTES:

  • If you're already logged in to your Google account in your current browser session, you will be asked to grant Smartsheet permission to use your Google credentials. If you're not logged in to Google already, you must provide your Google account information.
  • Your Google Calendar overlay is only visible to you—other collaborators on the sheet won't see your Google Calendar Overlay.
Was this article helpful?
YesNo