Ctrlk
Log inSign up

Google Sheets (Natoma)

Connect AI assistants to Google Sheets for spreadsheet management, data reading and writing through Natoma.

Early Access — This server is currently in early access. Features and configuration may change.

Type: Natoma Hosted

Source Type: Remote URL

Description: This connection enables AI-powered spreadsheet management, data reading and writing, and sheet automation through Natoma. Available tools are a subset of the Google Workspace Server.

Setup

Step 1: Enable the Google Sheets API

  1. Go to the Google Cloud Console.

  2. Make sure your target project is selected in the top project dropdown.

  3. In the left sidebar, navigate to APIs & Services > Library.

  4. Search for Google Sheets API and click on it.

  5. Click Enable.

You can also enable it directly: Google Sheets API

Some Sheets operations (such as listing and creating files) also require the Google Drive API. You may enable it alongside Sheets: Google Drive API

Step 2: Configure the OAuth Consent Screen

  1. In the Google Cloud Console, go to Google Auth Platform > Branding (or search "OAuth consent screen" in the top search bar).

  2. If the Auth Platform isn't set up yet, click Get Started and fill in the following:

    • App name: Google Sheets MCP Server

    • User support email: your email address — click Next

    • Audience: Select Internal — click Next

    • Contact email: your email address

  3. Agree to the Google API Services User Data Policy, then click Continue > Create.

  4. Click Data Access in the left menu, then click Add or Remove Scopes.

  5. In the panel that appears, scroll down to Manually add scopes and paste in both scopes (one per line):

  6. Click Add to Table, then Update, then Save.

If your use case requires creating or copying spreadsheet files in Drive, also add the Drive scopes listed in the tools table below.

Step 3: Create an OAuth 2.0 Client ID

  1. Go to Google Auth Platform > Clients > Create Client and select Web application as the application type.

  2. Name the application.

  3. In the Authorized redirect URIs section, click + Add URL and enter:

Use exactly this redirect URI — Natoma will not complete the OAuth flow if it doesn't match.

  1. Click Create and copy the Client ID and Client Secret.

Step 4: Configure the Connector in Natoma

  1. Log in to your Natoma workspace as an Admin and navigate to Apps, then search for Google Sheets (Natoma).

  2. Click + > Allow Personal Connections.

  3. In the connector configuration dialog, enter the following:

Field
Value

Server name

Google Sheets MCP (or any descriptive label)

OAuth Client ID

The Client ID from Step 3

OAuth Client Secret

The Client Secret from Step 3

  1. Save the connector. Natoma will initiate an OAuth consent flow to authorize access to your Google Sheets.

Last updated