Google Sheets

Use Google Sheets when you want Budibase to read and write sheet data directly.

Budibase works best with simple tabular sheets. Make sure the first row contains headers.

Before you start

Make sure you have:

• A Google account with access to the spreadsheet
• A Google Sheet URL
• A header row in each worksheet you want to use
• Consistent column names that Budibase can use as field names

Avoid merged cells, multi-row headers, and heavily formatted report-style sheets. Budibase works best when each worksheet behaves like a table: one header row followed by data rows.

Connect the sheet

1. Open the Data tables link
2. Add a datasource and select Google Sheets
3. Sign in with a Google account that can access the spreadsheet
4. Paste the Google Sheet URL
5. Select the worksheets to import
6. Save the datasource

Work with sheet data

Each worksheet appears as a grid in Budibase.

You can:

• View rows in the builder
• Add, edit, and delete rows
• Use the sheet as a form schema
• Use row actions such as Save Row

Add a query

Use a query when you need to create, read, update, or delete rows from a sheet.

1. Open the Google Sheets datasource
2. Click Add query
3. Choose the operation you need
4. Provide the sheet name
5. Add the row data or row index required by the query

Query types

Create

Insert a new row by providing the sheet name and a JSON payload of column names and values.

Read

Return all rows from a sheet. Use a transformer if you need to filter or reshape the data.

Update

Update an existing row by providing the sheet name, row index, and new values. Row indexes start at zero for the first data row below the header.

Delete

Delete a row by providing the sheet name and row index. Rows below the deleted row shift up.

Troubleshooting

If Budibase cannot read the sheet:

• Confirm the signed-in Google account can open the spreadsheet
• Check that the sheet URL is correct
• Confirm the worksheet has a header row
• Use exact worksheet and column names in queries
• For self-hosted installations, confirm Google SSO is configured

Notes

• Your sheet must have a header row
• Self-hosted installations need Google SSO configured
• Use exact sheet and column names to avoid import errors