Links

Google Sheets connection setup

Start with creating an OAuth Client ID in Google Developer Console. Then, follow the below steps:
  1. 1.
    Create a new or choose an existing project.
  2. 2.
    Go to API & Services section.
  3. 3.
    Click ENABLE APIS AND SERVICES and enable Google Sheets API.
  4. 4.
    Click on Create credentials and choose to Create OAuth client ID.
  5. 5.
    Select Web Application.
  6. 6.
    Add Authorized redirect URI with value http://YOUR_IP_OR_DOMAIN/gsheet-oauth-callback
  7. 7.
    Click Create.
  8. 8.
    Set credentials in UI_BAKERY_GSHEET_CLIENT_ID and UI_BAKERY_GSHEET_CLIENT_SECRET variables.
  9. 9.
    Go to the OAuth consent screen and create it with an external type.
  10. 10.
    Publish your consent screen.