Connect the Google Sheets API

• ✓ Values
• ✓ Spreadsheets & tabs
• ✓ File access
• ✓ Token refresh
• — Webhooks (Poll via the values tools)

spreadsheets_

list · metadata · create · add tab

values_

read · append · update · clear

batch_

bulk multi-range writes

OAuth scopes requested

• Read & write your spreadsheets
• Access only files you create with or open in Modiva (drive.file)
• Create new spreadsheets and tabs

# Add Modiva's MCP server to your agent
{
  "mcpServers": {
    "modiva": {
      "url": "https://mcp.modiva.ai",
      "headers": { "Authorization": "Bearer $MODIVA_MCP_KEY" }
    }
  }
}

# Then connect Google Sheets and call its tools, e.g.
accounts_list(provider="google-sheets")

How do I connect the Google Sheets API with Modiva?

Create a Modiva account, generate an MCP key, and connect Google Sheets from your dashboard. Modiva runs the full OAuth flow and stores the encrypted token for you — no client secrets in your code.

What can I do with the Google Sheets API through Modiva?

Read, write, append and bulk-update Google Sheets data, and create new spreadsheets for exports and logs. You get 10 typed tools grouped by resource (spreadsheets_, values_, batch_), callable over REST or the MCP server.

Do I need to handle OAuth or token refresh myself?

No. Modiva handles the Google Sheets OAuth handshake, token storage (envelope-encrypted) and automatic refresh. You call a single unified endpoint.

Can an AI agent use the Google Sheets API?

Yes — that is the point. Modiva exposes Google Sheets as Model Context Protocol (MCP) tools, so agents like Claude, Cursor or your own app can read and act on Google Sheets through one endpoint.