Google Sheets

We do not recommend using Google Sheets as the Production database due to Google API limitations of the number of requests per minute per data source. If you have a large database and require stable performance, we recommend using another database instead.

Configuration

To connect your Google Sheets, follow the instruction below:

1. On the Data sources page, click Connect, and select Google Sheets in the Data sources list.

2. Specify the data source name and add the link to your sheet.

Make sure that the data in Google Sheets is structured and each column has a name. This will allow UI Bakery to recognize types of columns and data and present it in a correct way.

Also make sure that your file is NOT in the .xlsx format as it will not be processed by UI Bakery.

1. Next, select the Permissions type - Read and write or Read only.

2. Click Connect to Google Sheets to authorize the access. You'll be prompted to the Google Authorization page where you need to allow UI Bakery access to your Google Sheets. ❗Do NOT miss this step as the connection won't be established without it❗

3. Once you've authorized the access, click Test connection to check whether the data source can be connected, and then click Connect Datasource to complete the setup.

Usage

When the connection with Google Sheets is established, you can start managing your data. The following action types are supported with this data source:

• SQL Query
• Load Table
• Load Row
• Create Row
• Bulk Create Rows
• Update Row
• Delete Row

You can run the action and make sure the data is loaded in the Result tab.

After that, you might also want to transform or map your data and display it in a component. Check out the following pages for more information👇

Data mapping & transforming

Bind data to UI