Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Capabilities

Who can use this capability

  • Editor
  • Admin
  • Owner

Use a Smartsheet Calendar with Google Calendar

The Smartsheet app allows you to integrate a Smartsheet calendar with a Google calendar.

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 created in Smartsheet in your Google calendar.
     

    This feature won’t let you add calendar items from Google to Smartsheet.

  • Overlay a Google Calendar: Add a Google Calendar to a Smartsheet calendar. Use the Calendar View in a sheet to compare the tasks in your Google calendar with your Smartsheet calendar.

 

These features only work with sheets. They do not work with reports even when you are in the Calendar View.

 

You can publish or overlay 600 tasks (rows) per sheet. If you’re working with more than 600 tasks, you can use the Publish iCal feature as an alternative.

Publish to Your Google Calendar

  1. Switch to Calendar View.

    This image shows the button to change to calendar view.

  2. Click the 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.

    This image shows publishing to a google calendar request.
  4. Click OK.

All tasks from the sheet appear in your Google Calendar as a calendar with the name you entered. When you add new tasks or change existing tasks in the sheet, the changes show automatically in the Google Calendar.

 

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 in the event details to make changes directly to the row.

 

Overlay a Google Calendar

  1. Switch to Calendar View.
  2. Click 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.

    Note: 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.



    This image shows the overlay options for a google calendar.

  4. Click OK.

The Google Calendar events appear on your sheet. The sheet reflects the changes you make in Google Calendar. 

The Google Calendar items are read-only, so you cannot edit them in Smartsheet.

Your Google Calendar overlay is visible only to you. Other collaborators on the sheet won't see it.

 

 

Was this article helpful?
YesNo