The on-premise version of UI Bakery needs additional configuration to be able to work with Google Sheets datasource
Google requires using https:// as the scheme of Authorized redirect URI for Production apps.
Also, redirect URI must contain a top private domain and should end with a public top-level domain (such as .com or .org). The only exception is localhost (for testing the connection locally).
If your UI Bakery instance is using a custom domain name — please ensure to put it in the UI_BAKERY_APP_SERVER_NAME variable.
If you don't have a private domain yet (e.g. just deployed your instance on AWS) but want to test the Google Sheets connection — you can use 3rd-party service nip.io for testing purposes. Just replace dots with dashes and append ".nip.io" to your static IP address like 192-168-1-250.nip.io