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
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
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
Adding a Load Table action step
Run the Action. Take a look at the Results tab to make sure the data is loaded. After that, you might want as well to: