Google Sheets

We do not recommend using Google Sheets as a 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 a stable performance, we recommend using any database instead.

Configuration

Go to Datasources - Connect - Google Sheets. Specify the name of the data source and insert the link to your sheet. Select Permissions type: Read-Write or Read Only.

Authorize the access by pressing Connect to Google Sheets. You’ll be prompted to the Google Authorization page, where you need to allow UI Bakery access to your Google Sheet. ‼️ Please do not miss this step as the connection would not be established without it.

Once you’ve authorized the access, click Connect Datasource.

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

Please note that your file cannot be in xlsx format, as it will not be processed

Usage

When the connection with Google Sheets is established, you can start managing your data**.** Create an action using one of the following types to access your data:

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

Run the Action. Take a look at the Results section to make sure the data is loaded. After that, you might want as well to:

• Transform or map your data.
• Add a Component to display it.