Google Sheets Integration

Our Google Sheets integration allows for real-time updates of Shortcut data to be sent to a Google Sheet. Once set up, any updates that happen in your Shortcut Workspace will be dynamically updated in your Google Sheet. The timezone for the Google Sheets integration is based off of the workspace's UTC offset.

Your Google Sheet integration can be linked to any BI tool that ingests Google Sheets, allowing you to visually model your Shortcut data and unlock custom analytics in real-time. 

To ensure proper data accuracy:

  • Don't rename the sheet/tab (You may create additional sheets/tabs)
  • Don't delete or reorder columns
  • Don't add new columns
  • Don't change cell values
  • Don't use the "Filter" feature to re-sort, filter, or hide rows

You may:

  • Hide columns
  • Create new sheets that cross-reference for any additional sorting or filtering needs

Note: the integration re-syncs to the specific Story, it does not re-sync the entire Worksheet each time.

The data that is sent from Shortcut to Google is the same data represented when you manually integrate Workspace data to CSV

Currently, you can only have one Google Sheet per Workspace.

Enabling the Google Sheets Integration

To enable the Google Sheets Integration navigate to your Integrations <> Google Sheets Integration (if you haven't upgraded to a paid plan you will need to do so in order to access the integration). 
  • Select Integrations
  • Select Google Sheets
  • Authorize with Google
  • Yahtzee - you're done!

We'll create a new Google Sheet with a live connection to your Shortcut data. Each row will contain rich Story data and all changes within Shortcut will override the existing information for that particular element within the Google Sheet. The sheet is private to you, but you can share it with a wider audience as you see fit. 

Disabling the Google Sheets Integration

  • Select Integrations
  • Select Google Sheets
  • Remove Authorization

Building custom reports with your Google Sheet integration? Share it with the Shortcut community and see what others are building in our Shortcut Forums!


Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request