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
- Go to Integrations and choose Google Sheets.
- Press Connect, choose your Google account and allow.
- 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).