​
Setting Up Google Sheets for OAuth

​
Step 1: Create a Google Project

  1. Sign in to Google Cloud Console: Visit the Google Cloud Console and sign in using your Google account credentials.
  2. Create New Project: Click on “Select a project” > “New Project”.
  3. Enter Project Details: Provide a name for your project (e.g., “valmi-io”) and click “Create”.
  4. Enable Sheets API: In the dashboard, navigate to “APIs & Services” > “Library”. Search for “Google Sheets API” and enable it for your project.
  1. OAuth Consent Screen: In the Google Cloud Console, navigate to “APIs & Services” > “OAuth consent screen”.

Google Sheets Consent Screen

  1. User Type: Choose the appropriate user type for your application (Internal or External).
  2. Application Name: Enter the name of your application (e.g., “valmi.io”).
  3. Scopes: Add the required OAuth scopes for your integration:
    • https://www.googleapis.com/auth/userinfo.profile
    • https://www.googleapis.com/auth/userinfo.email
    • https://www.googleapis.com/auth/spreadsheets
  4. Authorized Domains: Add your application’s domain to the authorized domains list.
  5. Save: Click “Save” to save the OAuth consent screen settings.

​
Step 3: Create OAuth Client ID

  1. Credentials: In the Google Cloud Console, navigate to “APIs & Services” > “Credentials”.
  2. Create Credentials: Click “Create credentials” > “OAuth client ID”.

Google Sheets Create Credentials

  1. Application Type: Select “Web application” as the application type.
  2. Authorized Redirect URIs: Add the redirect URI where Google will send users after authorization. Use the following format: https://your-host/api/oauth2/redirect/google.

Google Sheets Create OAuth

  1. Save: Click “Save” to create the OAuth client ID.
  2. Copy Client ID and Client Secret: Your Client ID and Client Secret will be displayed. Copy them for use in valmi.io.

​
Step 4: Configure Google Sheets OAuth in valmi.io

  1. Access Configuration: In your application, navigate to the sidebar and select “CONFIGURE APPS”.

Configure Apps Selection

  1. Select Google Sheets OAuth Application: Find the Google Sheets OAuth application from the list of available applications and select it.

Google Sheets Selection

  1. Enter Credentials: Provide the Google Client ID and Client Secret that you obtained earlier into the input fields.

Google Sheets OAuth Configuration

  1. Save Configuration: Click “Save” or “Update” to save the configuration.