# Connect Google Sheets

Connect Google Sheets so a Metric goal tracks one spreadsheet cell that your team updates.

Connect Google Sheets when a number lives in a sheet someone updates by hand. Brev reads only the files you pick.

## What you get from Google Sheets {#what-you-get}

- A Metric goal that follows one cell.
- A point on the goal's chart each time the cell changes.

## Connect Google Sheets {#connect}

1. In Settings, click **Connections**, then type Google Sheets in **Search connections**.
2. On its row, click **Connect**. The row may say Operator access: auto-track uses that same connection.
3. Sign in with Google and approve access.

> **Tip: Success check**
>
> The Google Sheets row shows a **Connected** badge.

## Track a Google Sheets cell {#track}

A new Google Sheets connection tracks through [Describe a value](https://help.brev.io/connecting-an-integration/#agent-built-auto-track), where you say the number you want in words. The item picker below appears only on a Google Sheets connection made before that change.

1. Open a Metric goal and click **Auto-track**. Under **Ready to track**, pick Google Sheets.
2. If the dialog opens on **Describe a value in Google Sheets**, say what to measure, check the preview and today's value, then click **Connect**. That finishes the task. Otherwise, continue with the next step.
3. Pick the spreadsheet in the Google file picker.
4. Under **Select a sheet**, pick the tab and click **Continue**.
5. Pick the **Column** and **Row**. The preview shows the cell's value.
6. Next to **Connect**, pick how often to refresh: Every 30 minutes (the default), Hourly, Every 4 hours, Daily or Weekly. Then click **Connect**.

![The Auto-track menu open on a goal: apps under Connect to track, with Request access beside the ones Brev can't track yet.](https://help.brev.io/doc-assets/screenshots/auto-track-a-goal-open-auto-track.png)

> **Tip: Success check**
>
> The goal shows the Google Sheets icon on its connection, and its value updates without a check-in from you.

## After you connect Google Sheets {#what-happens-next}

Brev reads the value at the frequency you picked. At Every 30 minutes, it reads every 30 minutes from 7 AM to 7 PM on weekdays (Sydney, New York or San Francisco time). Otherwise, it reads every 4 hours.

- To read it now, click the refresh icon on the goal's connection. An unchanged value adds no check-in.
- To see what it reads, hover over the connection or click its gear. The gear also changes the frequency.
- You can still add your own check-ins, for example to explain a change.

If the preview says the cell isn't a number, see [spreadsheet common issues](https://help.brev.io/integrations-docs-spreadsheets/#troubleshooting).

---

Use Brev from Claude, ChatGPT or Cursor with the Brev MCP server, https://mcp.brev.io/mcp: [set it up](https://help.brev.io/connect-ai-assistant/).