How to connect Gigasheet to Claude Cowork

Trusted by teams atAWSGleanZoomAirtable

30 min · no commitment · see it on your stack

Gigasheet logo
Claude Cowork logo
divider

Introduction

Cowork is Anthropic's AI agent for knowledge work. Think of it as Claude Code for everything else. It works autonomously with your computer, local files, and applications to accomplish complex tasks.

This guide walks you through the easiest and most secure way to connect your Gigasheet account to Cowork via Composio Connect, enabling it to list all columns in your sales dataset, download export URL for last week's data, apply saved filter to monthly report sheet, and more such actions on your behalf without compromising your account security.

Also integrate Gigasheet with

Connecting Gigasheet to Claude Cowork

1. Open Customize

In Claude Desktop, click Customize in the left sidebar, then select Connectors and click the + icon at the top.

Claude Desktop connectors screen with Add custom connector selected

2. Add the Composio MCP server

Click Add custom connector and paste in the Composio MCP server URL:

bash
https://connect.composio.dev/mcp
Add custom connector dialog with Composio MCP server URL

3. Authorize in your browser

Click Connect. You'll be redirected to a browser window where you can authorize Composio to continue.

Composio authorization screen for Claude Cowork

4. Connect your Gigasheet account

Back in Cowork, ask the agent to connect to Gigasheet or give it any Gigasheet-related task.

For example, ask Cowork to:

  • "List all columns in your sales dataset"
  • "Download export URL for last week's data"
  • "Apply saved filter to monthly report sheet"

It will prompt you to authenticate and authorize access.

That's it. Composio's tools are now available in Cowork, and your Gigasheet account is ready to use.

What is Claude Cowork?

Claude Cowork is Anthropic's agent for general knowledge work. It can use your computer, files, and connected applications to complete longer-running tasks across your work tools.

With Composio Connect, Cowork can securely access apps like Gigasheet through MCP without you sharing account credentials directly with the agent.

What is the Gigasheet MCP server, and what's possible with it?

The Gigasheet MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Gigasheet account. It provides structured and secure access to your big data spreadsheets, so your agent can perform actions like retrieving datasets, applying filters, exporting data, managing sheets, and integrating with connector sources on your behalf.

  • Dataset retrieval and inspection: Instantly fetch metadata or details for any dataset or sheet, such as column names, types, and structure, so you can quickly understand and analyze your data.
  • Automated data export and download: Direct your agent to initiate data exports and retrieve download links for processed datasets, streamlining big data extraction directly to your tools or workflows.
  • Smart filtering and template application: Apply saved filter templates to sheets or retrieve available filter templates, enabling rapid, repeatable data curation without manual setup.
  • Sheet and folder management: Effortlessly delete sheets or folders—including recursive deletions—so you can keep your workspace organized and clutter-free.
  • Connector and integration management: List and manage connector connections to keep all your external data sources in sync with Gigasheet, making data aggregation seamless and automated.

Supported Tools & Triggers

Tools
Delete sheet or folder by handleTool to delete a sheet or folder by handle.
Get Client State Current VersionTool to fetch the current client-state version metadata for a sheet.
Get Connector ConnectionsTool to list connector connections.
Get Dataset by HandleTool to get dataset metadata.
Get Dataset ColumnsTool to list all column metadata (IDs, names, types) for a dataset.
Get Dataset Export Download URLTool to retrieve the download URL for an exported dataset.
Get Dataset ViewsTool to list all views associated with a specific dataset.
Get Docs Formulas FunctionsTool to retrieve all supported formula functions.
Apply Filter Template On SheetTool to fetch a saved filter template's model for a given sheet.
Get Filter TemplatesTool to retrieve all saved filter templates.
Generate New HandleTool to generate a new unique dataset handle.
Get User Autofill InfoTool to fetch autofill info for the authenticated user.
Get Authenticated User InfoTool to fetch the authenticated user's details.
Append Rows to Sheet by NameTool to append rows to a sheet by column names.
Initiate Dataset ExportTool to initiate an export of a dataset.
Insert Blank Row in DatasetTool to insert a blank row with null values into a dataset.
Rename Columns to UniqueTool to rename all columns in a dataset to unique names.
Save Current ViewTool to persist the current view in a Gigasheet dataset.
Get Filtered Row IndexTool to retrieve the filtered-set row index for a given unfiltered row number.
Combine Files by NameTool to combine multiple files by a shared column name.
Export Gigasheet to S3Tool to export Gigasheet data to AWS S3.
Import from S3Tool to import data from AWS S3 into your Gigasheet Library.
Request API AccessTool to request access to the Gigasheet API.
Unroll Delimited ColumnTool to explode a column containing delimited data into multiple rows.
Upload from URLTool to upload data to Gigasheet from a specified URL.
Set Dataset Client State VersionTool to set the client state version of a dataset.
Update cell by column name and rowTool to update a cell in a dataset by specifying column name and row number.
Share fileTool to share a Gigasheet file with specified recipients.
Create/Update Filter TemplateTool to create or update a saved filter template.

How to build Gigasheet MCP Agent with another framework

FAQ

What are the differences in Tool Router MCP and Gigasheet MCP?

With a standalone Gigasheet MCP server, the agents and LLMs can only access a fixed set of Gigasheet tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from Gigasheet and many other apps based on the task at hand, all through a single MCP endpoint.

Can I use Tool Router MCP with Claude Cowork?

Yes, you can. Claude Cowork fully supports MCP integration. You get structured tool calling, message history handling, and model orchestration while Tool Router takes care of discovering and serving the right Gigasheet tools.

Can I manage the permissions and scopes for Gigasheet while using Tool Router?

Yes, absolutely. You can configure which Gigasheet scopes and actions are allowed when connecting your account to Composio. You can also bring your own OAuth credentials or API configuration so you keep full control over what the agent can do.

How safe is my data with Composio Tool Router?

All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your Gigasheet data and credentials are handled as safely as possible.

Used by agents from

Context
Letta
glean
HubSpot
Agent.ai
Altera
DataStax
Entelligence
Rolai
Context
Letta
glean
HubSpot
Agent.ai
Altera
DataStax
Entelligence
Rolai
Context
Letta
glean
HubSpot
Agent.ai
Altera
DataStax
Entelligence
Rolai

Never worry about agent reliability

We handle tool reliability, observability, and security so you never have to second-guess an agent action.