# Google Sheets

Connect Shortcut with Google Sheets for real-time Story data updates and custom analytics with your BI tools.

## Overview

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 time zone 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.

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

## Data Integrity Guidelines

To ensure proper data accuracy:

**Don't:**

* Rename the sheet/tab (You may create additional sheets/tabs)
* Delete or reorder columns
* Add new columns
* Change cell values
* 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

> 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 export Workspace data to CSV.

## Enabling the Google Sheets Integration

To enable the Google Sheets Integration, navigate to **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.

1. Select **Integrations**
2. Select **Google Sheets**
3. **Authorize** with Google
4. 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

Navigate to **Integrations > Google Sheets** and toggle off the integration to disconnect the Google Sheet from your Workspace.