Connect a sheet to Google Sheets

Every row added to a Rowbase sheet is written at the bottom of the Google Sheets tab you pick, and every edit rewrites that same row. Syncing goes from Rowbase to Sheets, never the other way.

Before you start

• You must be an administrator of the account.
• The Google Sheets file must already exist: Rowbase does not create one.
• Prepare a tab whose first row holds your headers. Rowbase reads it to suggest the column mapping.

Connect in three steps

1. Authorise your Google account. From Automations, click Connect Google. Rowbase asks for the right to write in the files you explicitly pick — never general access to your Drive.
2. Pick the file and the tab. The Google picker opens in your own session: you see all your files there, Rowbase only gets access to the one you choose.
3. Map the columns. Rowbase reads the first row of the tab and suggests a mapping by name. You adjust it column by column; a column left empty is not filled.

What is sent, and when

Only rows created after activation go to Sheets. That is the thing to remember:

• Rows already present when you activate the sync are not written. Use an export if you need to catch up on existing data.
• Editing a cell rewrites the row exactly where it was placed. A row created before activation has no known place, so its first edit appends it at the bottom of the tab.
• Deleting a row in Rowbase deletes the matching row in the tab, and pulls the ones below up, just like a deletion made by hand in the sheet.

Before rewriting or deleting a row, Rowbase reads the stored location back and checks that the value it wrote is still there. If somebody inserted or removed rows in the sheet meanwhile, the location no longer matches: the operation is refused and the log says so, rather than touching the wrong row. Reopen the row in Rowbase and edit it again once the sheet is back in order.

One sheet can feed several destinations: add as many syncs as you need. A given tab, however, can only receive one sync — two sources writing to the same place would interleave their rows.

How values are written

Rowbase sends the value as it appears in the grid, and lets Google read it as if it were typed in.

Type	What lands in the sheet
Text, long text	The text, as is
Number	The amount formatted with your language's symbol — €1,240.00 in English
Date	The date in your language's format — 03/12/2026 in English
Select	The label, without the colour
Checkbox	Yes or No
Email, URL	The text; Google keeps the clickable link

Numbers are sent with their currency symbol and checkboxes as words. If you use these columns in Sheets formulas, plan a conversion on the sheet side.

Reading the log

Every write leaves a trace in Automations.

• Success — the row was written or rewritten. The timestamp is the write, not the data entry.
• Retry — Google refused temporarily, usually a quota. Rowbase retries five times, pausing 10 s, 30 s, 1 min and 2 min.
• Failed — after five attempts, when the destination is no longer valid (file deleted, tab renamed, authorisation revoked), or when the row moved in the sheet. The error message is shown as is.

A failing sync is not paused automatically and no email is sent: check the log. Syncs of a Google account are paused, however, if you disconnect that account.

A sync's ⋯ menu lets you edit it — destination, tab, column mapping —, pause it or delete it. Deleting a sync does not touch the rows already written in the file.