On the Ninth Day of Partnerships, Integrations, and Other Good Things, Shortcut brings to you: Google Sheets. This spreadsheet program is cool enough to get at least nine ladies up and dancing. For these spreadsheet lovers, today’s integration has (half of) their names written all over it. Because it’s just called Sheets. Sheets is the fresher, younger, hipper sibling to spreadsheets.
For the spreadsheet enemies and haters: maybe now is the time, with this integration, that you’ll learn to actually love breaking down populated data in fields, who knows?
The beauty of the Shortcut + Google Sheets integration is that you can get real-time updates of Shortcut data to be sent to a connected Google Sheet. So, any updates that happen in your Shortcut Workspace will be dynamically updated to this connected Google Sheet. The data sent from Shortcut to Google is the same data that's captured from your Workspace when you export to CSV.
What about the functionality? Here you go👇
Once your Shortcut Story data is loaded into Google Sheets, you can use trusty Pivot Tables, logic, formulas, macros, and more to create charts and even custom dashboards. The world is truly yours to own, because here’s what you can build:
Have a field day accessing these fields in your data
Epic fields:
Milestone fields:
Visualize your Shortcut data in Google Sheets
Enable the Google Sheets Integration
First, have your account Admin or Owner navigate to the Workspace Features > Shortcut Labs > and then toggle on the Google Sheets Integration. Then have an account Admin or Owner navigate to Select Integrations > Select Google Sheets > Authorize with Google. That’s it!
With automatic updates, let the Integration do the heavy lifting
Once connected, we'll create a new Google Sheet with a live connection to your Shortcut data. Each row will contain rich Story data and new changes will override existing info in real-time. The sheet is private to you, but you can share it with a wider audience as you see fit.
Connecting your data to Sheets enables you to build custom charts, reports, and dashboards to drive insights into what's going well (and not well, so you can fix it!). It's also great for sharing progress with the leadership team.
Check out this article in the Help Center for a more thorough guide to setting up this integration. Also, take a look at this presentation by Guru’s Matt Sheaffer from April to see how his team used the Google Sheets Integration to build out an internal Customer Pain Score and dashboard. Now, it’s time for the ladies to dance, maybe even three Sheets to the wind, because it’s the holiday season.