Google Sheets

The Sheets MCP server is available only through the Google Workspace Developer Preview Program, so the Google Cloud project must be registered in it. Use a Google Cloud project where you can enable services, grant project IAM roles, configure the Google Auth platform, and create OAuth credentials. You normally need Service Usage Admin or Owner to enable the APIs and Project IAM Admin to grant access. Each person who will connect needs access to the intended spreadsheets. Before setup, have the application or security owner configure prompt and response screening for malicious content or prompt injection.

Sign in to the Google Cloud console. In the console toolbar, use the resource selector to choose the project registered in the Developer Preview Program. Keep the same project selected throughout setup.

Join the Google Workspace Developer Preview Program

1. Open developers.google.com/workspace/preview.
2. Review the Developer Preview Program Terms with the application or security owner.
3. Click Apply to join the Developer Preview Program.
4. In the application form, enter the requested Google Workspace account and Google Cloud project information.
5. Agree to the terms only with organizational approval.
6. Submit the form with the visible or equivalent submission control.
7. Wait for Google’s project-registration confirmation at the submitted email address. Google says this should complete within a couple of days.

Use the registered project for every Google Cloud step that follows.

Enable the Google Sheets APIs

1. Open APIs & Services > API Library.
2. In Search for APIs & Services, enter Google Sheets API.
3. Open Google Sheets API.
4. Click Enable. If the service is already enabled, leave it enabled.
5. Reopen APIs & Services > API Library.
6. In Search for APIs & Services, enter Google Sheets MCP API.
7. Open Google Sheets MCP API.
8. Click Enable. If the service is already enabled, leave it enabled.

Grant MCP Tool User access

1. Go to IAM.
2. Confirm that the same project is selected.
3. Click Grant access.
4. In New principals, enter the Google Account email address of a person who will connect through the Speakeasy AI Control Plane.
5. Click Select a role.
6. Search for MCP Tool User.
7. Select MCP Tool User.
8. Click Save.
9. Repeat these steps for every person who will connect.

Configure the OAuth consent screen

Google does not allow you to remove the OAuth consent screen after you configure it. Before continuing, confirm that you are working in the correct project.

1. Open Google Auth platform > Branding.
2. If Google Auth platform not configured yet appears, click Get Started.
3. Under App Information, enter Sheets MCP Server in App name.
4. In User support email, select a monitored email address. Obtain the correct value from the application or security owner if needed.
5. Click Next.
6. Under Audience, select Internal if every connecting user belongs to the project’s organization. Otherwise, select External.
7. Click Next.
8. Under Contact Information, enter a monitored Email address.
9. Click Next.
10. Under Finish, review the Google API Services User Data Policy with the application or security owner.
11. If the owner approves the policy, select I agree to the Google API Services: User Data Policy.
12. Click Continue.
13. Click Create.

If the Google Auth platform was already configured, retain the approved Branding and Audience settings.

14. Open Data Access.

15. Click Add or Remove Scopes.

16. Under Manually add scopes, paste these four URLs:

    https://www.googleapis.com/auth/drive.readonly
    https://www.googleapis.com/auth/drive.file
    https://www.googleapis.com/auth/spreadsheets.readonly
    https://www.googleapis.com/auth/spreadsheets

17. Click Add to Table.

18. Click Update.

19. Click Save.

20. If you selected an External audience in Testing, open Audience.

21. Under Test users, click Add users.

22. Enter each connecting user’s email address.

23. Click Save.

An External audience in Testing supports up to 100 test users. Each authorization expires seven days after consent. When it expires, the user must complete browser authorization again.

Create the OAuth client

1. Open Google Auth platform > Clients.

2. Click Create client.

3. In Application type, select Web application.

4. In Name, enter a recognizable name such as Speakeasy AI Control Plane.

5. Under Authorized redirect URIs, click + Add URI.

6. In URIs, enter this value:

   https://ai.speakeasy.com/mcp/remote_login_callback

Before you click Create, prepare an approved secret store. The next dialog displays a client secret that can be copied only once.

7. Click Create.

This opens OAuth 2.0 client created.

Copy the OAuth credentials

1. In OAuth 2.0 client created, copy the Client ID to your approved secret store.
2. Under Client secrets, copy the Client secret to the same store.

If you miss the one-time Client secret, delete it and create a new one before continuing.

Keep both values available, then add the server in the Speakeasy AI Control Plane.

Add the server in Speakeasy

1. In the Speakeasy AI Control Plane sidebar, under MCP Gateway, select MCP.

2. Click Add new to open Add MCP server.

3. Choose Hosted remotely.

4. On New remote MCP server, paste this URL into MCP server URL:

   https://sheetsmcp.googleapis.com/mcp/v1

5. Leave User session issuer at its default.

6. Click Verify connectivity.

7. Under Identity, select User Identity. The page preselects No Identity for this server, so change it.

8. If Guardrails appears, leave it off.

9. Click Save.

Speakeasy saves the server as Disabled and says to finish setup in Settings > Identity. This is expected; the next section completes it.

Connect your credentials

1. Open the server’s Settings and find the Identity section.

2. Confirm that User Identity is selected.

3. In Choose an identity provider, confirm that the preselected provider is Google (https://accounts.google.com/). If another provider is shown, open the picker, search in Search identity providers…, and choose the Google provider. A provider badged Will be created is created when you save.

4. Choose Manual.

5. In Client ID, paste the Client ID from Copy the OAuth credentials.

6. In Client secret, paste the Client secret from the same section. Google requires it even though the field says “Optional”.

7. Open Advanced. In Scope, enter this value on one line:

   https://www.googleapis.com/auth/drive.readonly https://www.googleapis.com/auth/drive.file https://www.googleapis.com/auth/spreadsheets.readonly https://www.googleapis.com/auth/spreadsheets

   Do not leave Scope blank. A blank value requests every scope the server advertises, including full Drive access, which the consent screen does not grant.

8. Click Save.

9. Open Settings > Danger Zone > Server Availability and turn on Enable MCP server so it shows Enabled.

When a person first uses the server, Google’s browser authorization prompt appears. They must sign in with an account granted MCP Tool User. If the app’s audience is External and in Testing, the account must also be listed under Test users.

This guide covers setup only. For anything beyond it — billing, tool behavior, limits — see Google’s Sheets MCP documentation.