Skip to content

Connect Claude to Google Sheets

Connect Claude to Google Sheets: 1. Sign in to ApexGenius and connect Google Sheets. 2. Add the ApexGenius connector. 3. Start using Google Sheets in Claude.

Connect Google SheetsSee the setup

1,000 free credits · No card required

How to connect Google Sheets to Claude

  1. 1Sign in to ApexGenius and connect Google Sheets
  2. 2Add the ApexGenius connector to Claude
  3. 3Start using Google Sheets in Claude

FirstConnect Google Sheets to ApexGenius

ThenConnect ApexGenius to Claude

Google Sheetsapexgenius.ai/connections/google_sheets1 of 4

Connect Google Sheets. Google Sheets shows as connected in ApexGenius.

Then ask Claude:

Find the available Google Sheets read tools. Do not open or change a spreadsheet.

Written setup, step by stepShow

Before you start

  • An account with permission to use the Google Sheets resources you intend to connect.

1. Connect Google Sheets to ApexGenius

  1. Open Google Sheets in Connections. Choose Connect, or Add connection when offered. Give the connection a name if prompted. If Gateway setup pending appears, contact ApexGenius support before continuing.
  2. Choose the account and review access. Sign in to the Google account that has access to the intended resources. Review the permissions Google requests, then return to ApexGenius.
  3. Review the connected account and resources. Find Allowed resources on the connection page or its Tools tab. Choose Refresh and enable only the connected Sheets account. Resource selection does not add permissions to the Google account.
  4. Check the connection. Use Test connection or Check again and read the reported status. Add an AI agent from the AI agents page, choose Read only for the first test, and try the question below.
    The actual Google Sheets connection page in ApexGenius, showing its saved connection status.
    This captured Google Sheets connection reports ready. Check your own connection and its latest validation before using tools.Open full-size image (opens in a new tab)
Connect Google Sheets →

2. Connect ApexGenius to Claude

Use this server address when adding the connection:

https://server.autom8.pro/mcp
  1. Open Claude Settings, then Connectors, then Add custom connector.
  2. Enter ApexGenius and the MCP URL above. Choose Connect.
  3. Approve it in your browser, then turn it on in chat or Cowork.
  4. When ApexGenius asks what this AI client may use, choose Read only for the first test, or Custom to limit it to the tools you need.
  5. Start a new conversation and select ApexGenius from the available tools before asking for live data.
Official Claude setup instructions ↗

Watch the connection

7-second loop · Silent, with captions

Read the steps Follow along at your own pace

1. Open Connectors

Claude Desktop Connectors settings with the Add menu at the top and an ApexGenius example in the connector table.
Open Settings, then Connectors. Choose Add at the top; an existing installation appears in the table like this example.Open full-size image (opens in a new tab)

2. Add ApexGenius

Claude Desktop Add custom connector form filled with the ApexGenius name and remote MCP server URL.
Choose Add custom connector, enter the two live values above, and choose Continue. No client id or secret belongs in this form.Open full-size image (opens in a new tab)

3. Review permissions

Claude Desktop ApexGenius connector details showing the remote server URL and Tool permissions heading.
After approval, open ApexGenius from Connectors to review its URL and tool permissions. This capture is an existing configured example.Open full-size image (opens in a new tab)

3. Verify one safe read

Find the available Google Sheets read tools. Do not open or change a spreadsheet.

Find the available Google Sheets read tools. Do not open or change a spreadsheet.

Compare the returned account and resource with Google Sheets. Check the connection status separately from the result of the first read.

What Claude can do in Google Sheets

6 operations. Read looks things up and changes nothing. Write changes Google Sheets and runs only when that tool is enabled.

Read2 operations

Looks things up. Changes nothing.

Read

  • get_spreadsheetRead a spreadsheet’s tabs and settings, with cell data and comments if you ask.
  • get_valuesRead the values in a range, such as Sheet1!A1:D20.

Write4 operations

Changes Google Sheets. Runs only when enabled.

Edit

  • update_valuesSet the values in a range.
  • update_formulasSet the formulas in a range.
  • insert_dimensionInsert rows or columns.
  • update_spreadsheetChange a spreadsheet in bulk: tabs, formatting, filters, charts and comments. It can also delete rows and tabs.

You choose what Claude can use

When you approve Claude, pick Full access, Read only, or Custom. Read only allows the Read operations and nothing else. Custom picks apps and tools one by one.

Limits in Google Sheets

  • · The connected Google account decides which spreadsheets can be read and changed.
  • · Bulk updates can delete rows and tabs. Read the range first and ask for the exact change.
  • · Enabled writes run immediately. Turn a tool off to block calls.
  • · Disconnecting stops future access. It does not undo a change; use the spreadsheet’s version history.

What it looks like in Claude Cowork

An illustrative read-only request and response. Your results come from the account and dates you choose.

How the route works
Claude
Claude CoworkApexGenius MCP route
List the tabs in the spreadsheet I name. Do not change it.
ApexGenius
Working with ApexGenius1 tool search · 1 read
RequestList the tabs
Account scopeAuthorized connections checked
apex_search_toolsGoogle Sheets read · Find Google Sheets toolsComplete
apex_call_write_toolget_spreadsheet · Read the spreadsheetComplete
Claude

Illustrative example: four tabs, Leads, Pipeline, Q3 and Notes. Nothing was changed.

Read-only route
Claude Cowork

Try asking

“List the tabs in the spreadsheet I name. Do not change it.”

“What were total sales by region last month in the sales sheet?”

“Which rows in the leads sheet have no email?”

“Add this week’s numbers as a new row in the tracker sheet.”

More connections like this one

One ApexGenius account covers every pair below. Connect an app once and each agent you allow can use it.

Claude with other apps

Questions people ask first

How do I connect Google Sheets?

Open Google Sheets in ApexGenius Connections, choose Connect, and sign in with the Google account that can open your spreadsheets.

Which spreadsheets can my AI read?

Any spreadsheet the connected Google account can open. Give your AI the link, or let it find the file with Google Drive.

Can my AI change a spreadsheet?

Yes. It can update values, formulas, rows and formatting. Enabled writes run immediately. Turn a tool off to block calls.

Can my AI create a new spreadsheet?

Not with the Sheets tools. Connect Google Drive, which can create a new spreadsheet.

Will this list of tools change?

Google publishes the Sheets MCP tools, and ApexGenius reads Google’s live list on every search. This page shows the list as of its review date.

Connect Google Sheets to Claude today

Start free

1,000 free credits. No card required. Disconnect any time.