> For the complete documentation index, see [llms.txt](https://guides.tability.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://guides.tability.io/docs/become-a-tability-power-user/integrations/google-sheet.md).

# Google Sheet

You can connect Tability to Google Sheets to automatically pull metrics from Google Sheets without having to switch context.

Once you add Google Sheets as a data source for an outcome/Key Result, Tability can:

* Pull the most recent value of the metric when you open the check-in form.
* Automatically sync your metric while the plan is active (Premium subscription only).

## Privacy

Tability's use and transfer of information received from Google APIs to any other app will adhere to[ Google API Services User Data Policy](https://developers.google.com/terms/api-services-user-data-policy#additional_requirements_for_specific_api_scopes), including the Limited Use requirements.

## How to enable the integration

### **Step 1. Upgrade to the Plus or Premium subscription**

You'll need to have a *Plus subscription* to use Google Sheets as a data source and automatically pull the metric value in the UI for your check-ins.

You'll need to have a *Premium subscription* to enable the sync.

### Step 2. Connect your Google account to Tability

You will need to connect your personal Google account to Tability to use this integration.

<figure><img src="https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2FPl9Kd0C4BQgmGQi1XOnV%2Fimage.png?alt=media&amp;token=04c4b5d4-051e-4ed3-b4f5-3070af5502c1" alt=""><figcaption></figcaption></figure>

1. Go to your personal integration page by clicking on your avatar and then **Personal integrations**
2. Connect to Google

Once connected, the integration panel should look like the picture below 👇

![](https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2F5cKGcYxdqAyFPinuLKHt%2Ffile-P4KKLvJX6r.png?alt=media\&token=07034f5a-6047-4fee-8226-60d295fb47c8)

## How to add a data source to an outcome of Key Result

Once Google is connected, you will be able to use it as a data source for your outcomes/KRs.

### **Step 1. Open up your edit panel of your outcome/KR**

![](https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2FKR9nZnKw6qYogqMG3mvw%2Ffile-bZLSr0JQOb.png?alt=media\&token=89a55e57-058d-4b2d-989b-fc91821b0b83)

Click on "Edit" to open up the Edit panel of any outcome/KR in your workspace.

### **Step 2. Select Google Sheets as a data source**

![](https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2F9zlwbo8Hedd7WfxKhm1G%2Ffile-SMr5nF2Sch.png?alt=media\&token=33b93eac-d5d5-4706-a881-e83847132b97)

Go to the "Data source" tab and select Google Sheets.

### **Step 3. Select the spreadsheet, sheet and cell**

![](https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2F2cnwOxeuaEwZ2UP5OCfY%2Ffile-boJJIbpodv.png?alt=media\&token=b05246a2-8854-4f3d-a364-c711f42362bf)

Use the dropdowns and fields to select the cell that contains the data to pull from.

### **Step 4. Save your connection**

Click on "Save & preview" to complete the connection.

Tability will retrieve the current value for that metric and your screen should look like this 👇

![](https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2FdIBmwyICiVIGOtIe55Vm%2Ffile-e71pVGJ4aO.png?alt=media\&token=9d836740-7944-4c3d-88a4-4144c6fcd121)

You can now toggle the option to Enable auto-sync of your metric if you're on a Premium subscription.

Tability will retrieve the value of your metric from Google Sheets every other day, and will create a check-in on behalf of the owner of the outcome/KR.

The first data sync should happen within 1h of enabling this option.

## How to use the data source in your check-ins

![](https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2FtMQNJZIIlkIpiaZCnoP7%2Ffile-oz99rNyaxc.png?alt=media\&token=bf961bf1-330b-4403-8a2e-5f0823fd9739)

It's all automatic! Once an outcome/KR is connected to a data source, Tability will automatically pull the current value whenever you open up the check-in modal.