Labs: Google Sheets Integration

Shortcut Labs Beta Feature!

Shortcut Labs is available for any Organization size when you upgrade to a paid plan (Team, Business, or Enterprise). If you want access to our Google Sheets Integration and other Shortcut Labs beta initiatives, have an account Owner upgrade today!

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 Disabling the Google Sheets Integration

To enable the Google Sheets Integration navigate to your Account Settings <> Workspace Features <> Shortcut Labs (if you haven't upgraded to a paid plan you'll be prompted to). Once there, you can toggle any of our current beta programs on or off.

  • Once Labs is enabled, within your Shortcut account, navigate to your settings (initials or profile photo)
  • 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. 

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