# 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="/files/ujtCmX3QcsDrehZxVu8d" 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 👇

![](/files/RTiswwnhNFOWuLV8rctV)

## 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**

![](/files/DNmMRUeu4l5wgOzggwys)

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**

![](/files/0pKKjmQ1tZe3rFW59TlL)

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

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

![](/files/FktVXef5nRpOCNjuxTl4)

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 👇

![](/files/rILAXlf0DZSd2ckmlen1)

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

![](/files/DnjKVO7ZFxR1BvVreGdr)

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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://guides.tability.io/docs/become-a-tability-power-user/integrations/google-sheet.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
