> ## Documentation Index
> Fetch the complete documentation index at: https://www.klavis.ai/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Setting Up Google Sheets OAuth App

> Complete guide to creating and configuring a Google Sheets OAuth application

## Prerequisites

* Google account

## Step 1: Create a Project

1. Visit [https://console.cloud.google.com/home/dashboard](https://console.cloud.google.com/home/dashboard) and select the project dropdown at the top.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/step1_box.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=182c3fdb71df87049007a32724ba8757" alt="Google Cloud project dropdown" width="1298" height="652" data-path="images/knowledge-base/google_sheets_oauth_app/step1_box.png" />

2. Click **New Project**.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/step2_new_project.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=dad793698cb7b95c3b9c569b15f718f8" alt="Google Cloud new project button" width="1298" height="652" data-path="images/knowledge-base/google_sheets_oauth_app/step2_new_project.png" />

3. Enter the project details and click **Create**.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/step3_create.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=6d6b10f1aed86e3074f3a92c24541573" alt="Google Cloud create project form" width="1298" height="652" data-path="images/knowledge-base/google_sheets_oauth_app/step3_create.png" />

4. Select your newly created project.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/step4_select_project.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=703c3a58874cdab8407703750a5d1dd2" alt="Google Cloud select project" width="1298" height="652" data-path="images/knowledge-base/google_sheets_oauth_app/step4_select_project.png" />

5. Go to **APIs & Services**.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/step5_apis_and_services.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=e832bb53ed9398cac1da7e5a562745d5" alt="Google Cloud APIs & Services menu" width="1298" height="652" data-path="images/knowledge-base/google_sheets_oauth_app/step5_apis_and_services.png" />

6. Click **Enable APIs and Services**.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/step6_enable_api_services.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=b07db094e0054ba4276504eb8b308872" alt="Enable APIs and Services button" width="1298" height="652" data-path="images/knowledge-base/google_sheets_oauth_app/step6_enable_api_services.png" />

7. Search for and select **Google Sheets API**.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/step7_select_sheets.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=3ea355115461836727d16f5fcd26ae64" alt="Search Google Sheets API" width="1302" height="656" data-path="images/knowledge-base/google_sheets_oauth_app/step7_select_sheets.png" />

8. Click **Enable**.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/step8_enable.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=f6759a48388d245c3d4776f9321eeda8" alt="Enable Google Sheets API" width="1302" height="656" data-path="images/knowledge-base/google_sheets_oauth_app/step8_enable.png" />

9. Go back to **APIs & Services** and select **OAuth consent screen**.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/step9_oauth_screen.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=d92c5e5ee87ad04e5eb94e21f90ecbd8" alt="OAuth consent screen menu" width="1302" height="656" data-path="images/knowledge-base/google_sheets_oauth_app/step9_oauth_screen.png" />

10. Enter the required information and save.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/step10_info.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=38a9b491cbcec0cfeb9c1e19681ce47f" alt="OAuth consent screen form" width="1298" height="652" data-path="images/knowledge-base/google_sheets_oauth_app/step10_info.png" />

11. Go to **Credentials** in APIs & Services and click **Create Credentials**.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/step11_CreateCredentials.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=41c0a49b5c675de42caf1dc309c06f66" alt="Create credentials button" width="1298" height="652" data-path="images/knowledge-base/google_sheets_oauth_app/step11_CreateCredentials.png" />

12. Select **OAuth Client ID**.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/step12_OAuthClientID.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=3e61342ce5edb9ce102d4ff47e070deb" alt="OAuth Client ID selection" width="1298" height="652" data-path="images/knowledge-base/google_sheets_oauth_app/step12_OAuthClientID.png" />

13. Choose **Web Application** and enter the required details.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/step13_WebApplication.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=b7ccd77513feb989db4fdacb9914a8e0" alt="Web application OAuth settings" width="1298" height="652" data-path="images/knowledge-base/google_sheets_oauth_app/step13_WebApplication.png" />

14. Add redirect URLs:
    `https://api.klavis.ai/oauth/gsheets/callback`
    Then click **Create**.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/step14_redirect_uri.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=281db00fd8c502fed6122fba222f05e3" alt="Add redirect URIs" width="1302" height="656" data-path="images/knowledge-base/google_sheets_oauth_app/step14_redirect_uri.png" />

15. Your **Client ID** and **Client Secret** will be displayed.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/step15_credentials.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=60842101b71b208c39ed04c0b88d3a28" alt="OAuth credentials screen" width="1298" height="652" data-path="images/knowledge-base/google_sheets_oauth_app/step15_credentials.png" />

## Step 2: Request Scopes

<Note>
  Klavis Google Sheets MCP Server uses the following OAuth scopes:
  `https://www.googleapis.com/auth/drive`
</Note>

1. Go to **OAuth consent screen**.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/scope1_oauth.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=fc8c8df91f760fe6689fe5d85a561fa4" alt="OAuth consent screen" width="1298" height="652" data-path="images/knowledge-base/google_sheets_oauth_app/scope1_oauth.png" />

2. Click **Data Access**.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/scope2_data_access.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=e1a09fea29a78f4d5671e42eb5a12f89" alt="Data access settings" width="1298" height="652" data-path="images/knowledge-base/google_sheets_oauth_app/scope2_data_access.png" />

3. Click **Add or Remove Scopes**.

<img src="https://mintcdn.com/klavisai/WUyJFoTOOKq1g0EB/images/knowledge-base/google_sheets_oauth_app/scope3_add_scopes.png?fit=max&auto=format&n=WUyJFoTOOKq1g0EB&q=85&s=268e5035ee1475e06cf54736e9b06bb4" alt="Add or remove scopes" width="1298" height="652" data-path="images/knowledge-base/google_sheets_oauth_app/scope3_add_scopes.png" />

4. Enter the needed scopes and click **Update**.

<Check>
  You have successfully created a Google Sheets OAuth application! You now have your Client ID and Client Secret ready for integration with Klavis AI.
</Check>

## (Optional) Step 3: White Labeling

<Note>
  White labeling allows you to customize the OAuth experience with your own branding instead of Klavis AI's.
</Note>

If you want to use your own Google Sheets OAuth application with custom branding:

1. **Configure White Labeling**: Go to [https://www.klavis.ai/home/white-label](https://www.klavis.ai/home/white-label)
2. **Add Your Credentials**: Enter your Google Sheets **Client ID** and **Client Secret** from Step 1.
3. **Set Redirect URI**: Use `https://api.klavis.ai/oauth/gsheets/callback` or your custom callback URL.
4. **Initiate OAuth**: Use your client ID when starting the OAuth flow:

   <CodeGroup>
     ```javascript without SDK theme={null}
     // Example: Initiating Google Sheets OAuth with white-label
     const authUrl = `https://api.klavis.ai/oauth/gsheets/authorize?instance_id=${instanceId}&client_id=${yourClientId}`;
     window.location.href = authUrl;
     ```

     ```typescript TypeScript SDK theme={null}
     import { Klavis } from "@klavis/sdk";

     const klavis = new Klavis({
       apiKey: "YOUR_API_KEY"
     });

     // Example: Initiating Google Sheets OAuth with white-label
     const oauthUrl = await klavis.mcpServer.getOAuthUrl({
       serverName: Klavis.McpServerName.Gsheets,
       instanceId: instanceId,
       clientId: yourClientId,
       // redirectUri: YOUR_REDIRECT_URI,
       // scope: "YOUR_SCOPES", 
     });

     window.location.href = oauthUrl;
     ```

     ```python Python SDK theme={null}
     import webbrowser
     from klavis import Klavis
     from klavis.types import McpServerName

     klavis = Klavis(api_key="YOUR_API_KEY")

     # Example: Initiating Google Sheets OAuth with white-label
     oauth_url = klavis.mcp_server.get_oauth_url(
         server_name=McpServerName.GSHEETS,
         instance_id=instance_id,
         client_id=your_client_id,
         # redirect_uri="YOUR_REDIRECT_URI",
         # scope="YOUR_SCOPES"
     )

     # Open OAuth URL in user's default browser
     webbrowser.open(oauth_url)
     ```
   </CodeGroup>

<Tip>
  For detailed white labeling implementation and code examples, see our [OAuth & White Labeling guide](/auth/white-label).
</Tip>

## Resources

* [Klavis OAuth & White Labeling Guide](/auth/white-label)
* [Klavis White Label Dashboard](https://www.klavis.ai/home/white-label)
