Sheets Sync

Google Sheets collaboration

The Sheets Sync tab lets you export statements to Google Sheets for collaborative editing, then import changes back into the system.

Connecting your Google account

Before using Sheets Sync, connect your Google account:

  1. Click Account in the sidebar bottom
  2. Select Google Integration from the dropdown
  3. Follow the OAuth flow to grant access

The system needs permissions to create and edit Google Sheets on your behalf. If you’re not connected, the Sheets Sync tab will prompt you to connect first.

Exporting to Google Sheets

With Google connected, the export form appears:

  1. Schema Type – Select which schema type’s statements to export
  2. Locales – English is always included. Optionally add German, French, Spanish, or other languages
  3. Sheet Name – Auto-generated with the current date, or customize it
  4. Folder ID – Optionally specify a Google Drive folder ID to place the sheet in

Click Export to create the spreadsheet. The system creates a snapshot of the exported data for tracking changes later.

Round-trip editing workflow

The export/import cycle works like this:

  1. Export statements to a new Google Sheet
  2. Share the sheet with your team for review and editing
  3. Team members edit text directly in the spreadsheet
  4. When done, come back to Sheets Sync and use the import validation to check what changed
  5. Execute the import to sync changes back into the database

The system compares the current sheet contents against the export snapshot to detect what was added, modified, or deleted.

Import validation

Before applying changes from a Google Sheet, the system validates:

  • Column structure matches the expected schema
  • Required fields are present
  • Text values are valid
  • Changes are diffed against the original export snapshot

Review the validation results and confirm before executing the import.