Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite.
Navigate to the spreadsheet you want to integrate into Budibase. Copy the URL.
Add source button to add a datasource, and then select 'Google Sheets'.
You will then be prompted to sign-in with a Google account. This account should have permissions to view the spreadsheet you want to work with.
Allow Budibase to access your Google account.
If you are self-hosted, you will need to setup Google SSO
Once you have authenticated with Google, you will be asked to provide your Google Sheet URL
Once Budibase successfully connects to your Google Sheet, you can select which worksheets to import (or skip):
Header row needed
Your worksheets will need to have a header row to successfully import into Budibase.
Each sheet can be viewed and edited as a grid within the Budibase builder.
You can edit columns, add rows, edit rows and delete rows via the Grid interface. Changes made in Budibase will be reflected in that sheet of your Google spreadsheet.
To add a query, select your Google spreadsheet datasource, and click
Add query at the bottom of the configuration page.
Allows you to insert a row. You must provide the name of the sheet as well as a JSON payload to specify the column names and value.
The row number of the created entry will be returned on success.
Simply returns all the rows of a specified sheet. The transformer allows you to filter and map the data into the schema you desire.
Similar to Create in that you must provide a payload of data, however you must also provide a row index to be overwritten.
Row indexing starts from zero - the first row below the header row (usually the second row).
The same as Update, a sheet name and row index must be provided. That row will be deleted.
Rows will be shifted up after deletion.
Updated 3 months ago