Connect Google Sheets

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 #

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

Connect Google Sheets #

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.

Track a Google Sheets cell #

A new Google Sheets connection tracks through Describe a value, 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.

After you connect Google Sheets #

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.