Send an app's data to Google Sheets
Keep a spreadsheet up to date with an app's records, choose the columns, and see when it last synced.
A sheet sync keeps a Google spreadsheet up to date with the records of an app. It updates by itself whenever a record, a field or a stage changes, and it starts as soon as you create it.
- 1
Open Settings, then Integrations, and connect your Google account if you have not already.
- 2
In Google Sheets Sync, paste the spreadsheet link, then choose the app, the tab and the mode.
- 3
Under Columns, leave all columns on, or untick the fields you do not want in the sheet. The id column is always sent.
- 4
Press Create sheet sync.
Append or Upsert
Append adds new records at the bottom and never changes rows already in the sheet. Upsert keeps the sheet matching Vellumica: changed records are updated in place and deleted ones are removed. Columns you add in the sheet yourself are kept.
Dropdowns stay dropdowns
A dropdown field, and the stage of a workflow app, becomes a real dropdown in its sheet column, with the same choices. Multi-select fields stay plain text, because a sheet cell holds one choice.
See how it is doing
Each sync shows its state: Syncing now…, Last synced with the time, or Last sync issue with the reason. The list refreshes by itself, so you do not need to press anything.
Related guides
Need more help?
Our team is happy to help.