top menu gradient

End-user login with Google

MINTDATA™ provides third-party login functionality for you to authenticate and identify the users of your application. This solution has a number of advantages:
  • You don't have to securely manage passwords.
  • You don't need to implement authentication or protection against malicious login attacks.
  • Your users don't have to remember an extra username and password.

By using a third-party login for your end-users, the third-party takes care of all that responsibility. Your app waits for the end-user to go through authentication. Then the third-party sends your application the information about that end-user.

This section describes how to set up end-user login with Google.

Before you start, make sure you've got a Google Account.

Register your application as a client to Google

  1. Open a browser and go to

  2. Select or create a project.

  3. On the left, select Credentials, and then click Configure Consent Screen.

  4. For the User Type select External. Click Create.

  5. Fill out the Application name field, and then click Save at the bottom.

Create client credentials

  1. On the left, select Credentials, and then click Create Credentials > OAuth Client ID.

    The Create OAuth client ID dialog appears.

  2. In the Application type field, select Web application. The fields for a client of type Web application appear.

  1. Complete the Web application form as follows:

    • Under Name, leave the default value or type any name to help you identify the credentials in the Google console.
    • Under Authorized JavaScript origins, add the following URIs (might be different for the actual users):

    • Under Authorized redirect URIs, add the following URIs (might be different for the actual users):

  2. Click Create.

    The OAuth client created pop-up appears. Take note of the generated client ID and client secret.

Set up authentication on MINTDATA™

  1. In your organization's workspace on MintData, click on the workspace name in the top right corner, and then click on Settings.

  2. Click Authentication > Add Credentials. The Authentication dialog box appears.

  3. Complete the fields as follows:

    • In the Credentials name field, use any unique name. Make sure that google is selected next to this field.
    • In the Client Id and Client Secret fields, use the Google Client ID and Client Secret values.
    • In the Scopes field, enter the following:email profile openid
  4. Click Create Credentials.

Now that you created client credentials in your organization's space, you can use the credentials name (appOAuth2CredentialsName) in the MINTDATA™ third-party authentication functions:


How to use the client credentials in your application

To authenticate your end-users via Google and get the end-user info:

  1. In cell A1, user the DO function to run the functions in the range A2:A6:

    Copy to clipboard
  2. In cell A2, pass the credentials name and "google" to the LOGIN_WITH_3RD_PARTY function:

    Copy to clipboard

    If successful, this formula sends a login request to the Google server, which shows the Google login screen to the end-user and generates an access token, also known as a bearer token.

  3. In cell A3, enter "Authorization":

    Copy to clipboard
  4. In cell A4, use this formula to retrieve the bearer token returned in response to our login request:

    =?"Bearer " & GRAB(A2,"$..accessToken")
    Copy to clipboard
  5. In cell A5, use this formula to create a frame containing the Authorization header:

    Copy to clipboard
  6. Finally, in cell A6, retrieve the logged user info by sending the Authorization header to the OpenID endpoint:

    Copy to clipboard

    The GET function returns a frame that contains the user's name, email, and profile picture:

Now that you have the Google login set up, you can draw a nice-looking Sign-in with Google component, and then bind the onClick event to cell A1.

Once we click on Sign-in with Google, the Google login pop-up appears.

Now you can display the user info on the screen: