# Google Sheets

> SUBLAKE Docs · Integrations · https://sublake.com/docs/google-sheets

Keep a Google Sheet of your jobs, or of your invoices, that keeps itself up to date.

## What it keeps

- **Jobs sheet** — one row per job: its Sublake ID, status, number, title, customer, service address, value, and when it was created, completed, cancelled and last changed. A job deleted in SUBLAKE is marked deleted in its row.
- **Invoices sheet** — one row per invoice: its Sublake ID, status, number, title, customer, payment state, currency, total, paid, balance, due date, and when it was sent and last changed. A payment updates its invoice's row.

Each row is updated in place when the record changes. Amounts are numbers the sheet can add up, and times are in your business's time zone. Only what changes after you switch a sheet on is written — never your history.

## Where the sheet is

SUBLAKE makes each sheet in your Google Drive when you switch it on (**Sublake — Jobs**, **Sublake — Invoices**), and the Google Sheets sheet in **Integrations** opens it. Sort it, filter it, add your own columns, move or rename SUBLAKE's, rename the tab: SUBLAKE finds each of its columns wherever you put it, finds each row by its Sublake ID, and writes only in its own columns.

## What SUBLAKE can and can't do in your Drive

It asks Google for one permission: to see and change only the files you use with SUBLAKE. It can open the sheets it made, and nothing else in your Drive.

## Connect

1. Go to **Integrations** and choose **Google Sheets**.
2. Press **Connect**, choose your Google account and allow.
3. Back in SUBLAKE, switch on the **Jobs sheet** or the **Invoices sheet** and press **Save**. SUBLAKE makes the sheet.

## When something needs you

If Google refuses — the sheet was deleted or moved to the bin, or your Drive is full — it waits under **Recent activity** in Google's own words. Fix the cause and press **Set up again**: SUBLAKE makes a new sheet if the old one is gone, adds back any of its columns that were deleted, and writes everything that was waiting. **Retry** sends one record again, and **Dismiss** lets one go without writing it.

## Disconnect

SUBLAKE stops updating your sheets and gives up its sign-in. Your sheets stay in your Drive. What you switched on is kept for when you connect the same Google account again, and SUBLAKE then catches your sheets up with the records that changed while it was disconnected (the 500 most recent, from the last 90 days).
