Google Sheets

Connecting Google Sheets and UI Bakery

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.

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:

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:

Last updated