Comment on page
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.
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.
Adding Google Sheets as a data source
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.
Please note that your file cannot be in xlsx format, as it will not be processed
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: