Google Sheets connection setup

The on-premise version of UI Bakery needs additional configuration to be able to work with Google Sheets datasource

  1. Create a new Google Cloud Console project or choose an existing one

  2. Configure the OAuth Consent Screen with User Type = External and Publishing Status = Production

  3. Go to the API & Services section

  4. Click ENABLE APIS AND SERVICES and enable Google Sheets API

  5. Click on Create credentials and choose User Data

  6. Select Web Application in the OAuth Client ID section

  7. Add Authorized redirect URI with value https://YOUR_DOMAIN_OR_LOCALHOST/gsheet-oauth-callback (make sure to put the same domain as in the UI_BAKERY_APP_SERVER_NAME variable)

  8. Click Create

  9. Put credentials in UI_BAKERY_GSHEET_CLIENT_ID and UI_BAKERY_GSHEET_CLIENT_SECRET variables

  10. Restart your UI Bakery instance with docker compose up -d

Last updated

Was this helpful?