Gigasheet MCP for AI Agents

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Gigasheet MCP or direct API to import datasets, analyze records, enrich data, and generate big data reports through natural language.
Trusted by
AWS
Glean
Zoom
Airtable
GET STARTED FOR FREEGET A DEMO

30 min · no commitment · see it on your stack

Gigasheet Logo
Gradient Top
Gradient Middle
Gradient Bottom
divider

Try Gigasheet now

Enter a prompt below to test the integration in our Tool Router playground. You'll be redirected to sign in and try it live.

Supported Tools

Tools
Append Rows to DatasetAppends rows to an existing Gigasheet dataset using column letters as keys.
Append Sheet from Another SheetTool to append data from a source sheet to a target sheet by matching column names.
Apply HTTP EnrichmentTool to apply generic HTTP enrichment to a Gigasheet dataset.
Calculate Enrich Expected CreditsCalculate expected credits for a user-defined HTTP enrichment operation.
Cancel HTTP Enrichment TaskTool to cancel a running enrichment task.
Check Connector Source AvailabilityTool to check if a source of the given type is available.
Combine FilesTool to combine multiple files into a new file.
Copy FileTool to copy a file in Gigasheet.
Count Dataset Deduplication ResultsTool to count how many duplicates will be removed and how many rows remain when deduplicating.
Count Dataset GroupsTool to count the number of groups matching certain criteria in a Gigasheet dataset.
Count Dataset RowsCounts rows in a Gigasheet dataset matching specified filter criteria.
Count Dataset ActivitiesTool to get total activity count on a given Gigasheet dataset.
Create AI Chat QueryAI analysis assistant for Gigasheet datasets.
Create Dataset Column CommentTool to add a comment to a column in a Gigasheet dataset.
Add Comment to CellTool to add a comment to a specific cell in a Gigasheet dataset.
Create Conditional Label ColumnTool to add a label column to a Gigasheet dataset with values based on conditional filters.
Create Formula ColumnTool to create a new column based on a formula input in a Gigasheet dataset.
Edit Formula ColumnTool to edit a formula column in a Gigasheet dataset.
Create Formula PreviewTool to calculate a formula preview on a Gigasheet dataset and return sample results with involved column values.
Create Iterator ColumnTool to add an iterator column to a Gigasheet dataset based on current filters and order.
Create Dataset LiveshareTool to create a new liveshare for a Gigasheet dataset.
Create Dataset ViewTool to create a new view for a Gigasheet dataset with a specified name and client state version.
Explode JSON ColumnTool to explode JSON data in a column into separate columns.
Create File AggregationTool to retrieve ungrouped aggregated values for a Gigasheet file.
Create Blank FileTool to create an empty file in your Gigasheet Library.
Create Files DirectoryTool to create a new folder in your Gigasheet Library.
Create Cross-File LookupCreates a cross-file lookup to enrich data by matching values between two sheets.
Send MCP Request to Sheet AssistantTool to interact with Gigasheet Sheet Assistant via the Model Context Protocol (MCP) over HTTP.
Split ColumnTool to split a column into multiple columns based on a separator.
Delete Sheet Assistant LogsTool to delete Sheet Assistant chat history for a specific sheet.
Delete columns by nameTool to delete multiple columns from a Gigasheet dataset by their column names.
Delete Connector SourceTool to delete a connector source for the authenticated user.
Delete Dataset CommentTool to delete a comment from a cell in a Gigasheet dataset.
Delete Rows Not Matching FilterDeletes rows in a Gigasheet dataset that do NOT match the specified filter criteria.
Delete Duplicated Rows from DatasetTool to delete duplicated rows from a Gigasheet dataset based on specified columns and sort model.
Delete Rows from DatasetTool to delete selected rows from a Gigasheet dataset.
Delete Rows Matching FilterTool to delete rows in a Gigasheet dataset that match a specified filter.
Delete dataset viewTool to delete a specific view from a Gigasheet dataset.
Delete dataset live shareTool to delete a live share of a Gigasheet dataset.
Delete sheet or folder by handleDeletes a Gigasheet sheet or folder by its unique handle identifier.
Delete column from sheetTool to delete a single column from a Gigasheet sheet by its column identifier.
Delete Filter TemplateTool to delete a saved filter template by its unique handle.
Delete multiple columns from fileTool to delete multiple columns from a Gigasheet file.
Filter File RowsTool to retrieve rows from a Gigasheet file matching specified filter criteria.
Generate Dataset DescriptionGenerates an AI-powered description for a Gigasheet dataset.
Get Sheet AI Chat HistoryTool to retrieve AI chat history for a sheet.
Get Cell CommentsTool to get comments for a specific cell in a Gigasheet dataset.
Get Client State Current VersionRetrieves the current client-state version and timestamp for a specified sheet.
Get Connector Connection ParametersTool to get connection parameters for a specific connector.
Get Connector Connection ParametersTool to retrieve connection parameters for a specific connector type.
Get Connector ConnectionsTool to list connector connections.
Get Connector SourcesTool to retrieve information about connected data sources for the user.
Get Connector Source ParametersTool to get parameters required for a specific connector source type.
Get Dataset Column CommentsTool to get comments for a specific column in a dataset sheet.
Get Dataset by HandleRetrieves comprehensive metadata for a specific dataset in Gigasheet.
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 Liveshare CSVTool to retrieve CSV data from a Gigasheet liveshare.
Get Dataset NoteTool to retrieve a dataset's note by handle.
Get Dataset Organization PermissionsTool to retrieve organization file permissions for a dataset.
Get Dataset Version MetadataRetrieves metadata about a dataset at a specific version.
Get Dataset ViewsTool to list all views associated with a specific dataset.
Get Dataset Operation StatusTool to get information about the last operation on a dataset.
Get Dataset ActivityTool to get the list of write actions on a given dataset sheet.
Get Dataset View MetadataTool to retrieve view metadata for a specific view within a dataset.
Get Docs Formulas FunctionsTool to retrieve all supported formula functions.
Get Enrich Task StatusTool to get status for a user-defined HTTP enrichment task.
Apply Filter Template On SheetTool to fetch a saved filter template's model for a given sheet.
Get Filter TemplatesRetrieves all saved filter templates from GigaSheet.
Get Filter Template by HandleRetrieves details of a specific saved filter template by its unique handle.
Generate New HandleTool to generate a new unique dataset handle.
Get Library FilesTool to retrieve all datasets and files in the user's Gigasheet library.
Get Library Files in DirectoryRetrieves all library files with file permissions in a given directory.
Get Library Home Page FilesTool to retrieve suggested recent files for the home page.
Get Library PathTool to retrieve the chain of parent directories for a file or folder in Gigasheet.
Get TICIntel NPI Public ProfileTool to retrieve public NPI (National Provider Identifier) profile from TICIntel database.
Get TIC Intel StatesTool to list available TIC Intel states from Gigasheet.
List Cities by StateTool to retrieve a list of cities for a given US state code from the TICIntel dataset.
List Providers by CityTool to retrieve a list of healthcare providers in a specific city and state from the TicIntel dataset.
Get User DetailsRetrieves detailed information about the authenticated user in Gigasheet.
Get User Enrichment CreditsTool to get the current user's enrichment credit information.
Get User MetadataTool to retrieve metadata for the authenticated user.
Get User Autofill SuggestionsRetrieves autofill suggestions for the authenticated user, including team members and previously used share recipients.
Get User Space UsedTool to get the amount of space used by the current user in bytes.
Get Authenticated User InfoTool to fetch the authenticated user's details.
List Billing PlansTool to list available Gigasheet billing plans.
List Dataset CommentsTool to get all comments in a dataset sheet.
List Dataset LivesharesTool to list all liveshares for a specific Gigasheet dataset.
List All DatasetsTool to retrieve all datasets owned by the user at any folder depth.
List Datasets by HandleTool to list files and datasets in a given Gigasheet location.
List Library ExportsTool to list exports owned by the current user, regardless of location.
List Shared Files by HandleTool to retrieve all files with permissions shared with the user in a specific directory location.
Move file or folder to directoryTool to move a file or folder into a folder or to the root of your Library.
Update User MetadataTool to update user metadata in Gigasheet.
Generate AI FormulaTool to generate Excel-style formulas using AI based on natural language queries.
Cast Column Data TypeTool to change a column's data type in a Gigasheet dataset.
Change Column CaseTool to change the case of a column to Uppercase, Lowercase, Capitalized, or Proper.
Clean Company NameTool to clean company names by stripping common business suffixes (Inc.
Combine ColumnsTool to combine multiple columns into a single new column with a separator.
Append Rows to Sheet by NameAppends one or more rows to a Gigasheet dataset using column names as keys.
Generate Dataset Assistant TipsTool to generate AI-powered tips for analyzing a dataset.
Initiate Dataset ExportInitiates an asynchronous export job for a Gigasheet dataset.
Find and Replace in DatasetTool to find and replace values in specified columns of a Gigasheet 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 ViewSaves the current view state of a Gigasheet dataset and returns a view handle.
Select columns by nameTool to select specific columns from a Gigasheet dataset by name, keeping only those columns in the specified order.
Extract Domain from URL ColumnTool to extract domain from a URL column in a Gigasheet dataset.
Filter File Rows by Column NameFilter rows in a Gigasheet file by column names and return matching results.
Get Filtered Row IndexMaps an unfiltered row number to its position in the filtered result set.
Filter File with Stream ProgressFilter data from a Gigasheet file with real-time streaming progress updates.
Save Exported FileSaves a file state with applied filters and grouping to create an exported version.
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 Access to FileTool to request access to a Gigasheet file.
Request API AccessRequest API access by sending a notification to Gigasheet support team.
Trim Column WhitespaceTool to trim leading and trailing whitespace from all values in a column.
Unroll Delimited ColumnTool to explode a column containing delimited data into multiple rows.
Upload Raw Data DirectTool to upload raw data directly to Gigasheet using byte array contents.
Upload from URLTool to upload data to Gigasheet from a specified URL.
Preview HTTP EnrichmentTool to preview a generic HTTP enrichment on a Gigasheet dataset before executing it on all rows.
Set Dataset Client State VersionApplies or restores a specific client state version to 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.
Opt out of shared fileTool to remove your access from a file that has been shared with you.
Create/Update Filter TemplateTool to create or update a saved filter template.
Rename Columns by NameTool to rename columns in a Gigasheet dataset using their current names.
Rename FileTool to rename a file in Gigasheet.
Reset Client State to DefaultResets the client state of a sheet to the default state.
Reset User PasswordTool to trigger password reset for the authenticated user.
Search Dataset ActivityTool to search the history of write actions performed on a Gigasheet dataset.
Search LibraryTool to search through the Gigasheet file library by file metadata.
Send Invite EmailsTool to send email invitations to join Gigasheet.
Set Aggregate Filter ModelTool to set the aggregate filter model in the client state of a sheet.
Set Client State AggregationsSets aggregations in the client state of a sheet.
Set Client State Column StateTool to set column state in the client state of a sheet.
Set Client State Filter ModelTool to set the filter model in the client state of a sheet.
Set Client State Group ColumnsTool to set group columns in the client state of a sheet.
Set Client State Sort ModelSets the sort model for a sheet's client state.
Set Client State Visible ColumnsTool to set visible columns in the client state of a sheet.
Set Dataset Client StateSets the client state of a dataset using a state object.
Set Dataset Column CurrencyTool to set currency format for a dataset column.
Set Dataset NoteTool to set or update a note on a dataset in Gigasheet.
Update Dataset CellTool to update a single cell value in a Gigasheet dataset by column letter and row number.
Update Dataset ViewTool to update the client state of a specified view.
Upsert Rows in DatasetTool to upsert rows in an existing Gigasheet dataset.
Validate Dataset FormulaTool to validate a formula expression against a dataset.
Validate Files CombineTool to validate a combine files request and return all errors that might appear.
Validate Files Combine by NameTool to validate a combine by name request before executing it.
Python
TypeScript

Install Composio

python
pip install composio claude-agent-sdk
Install the Composio SDK and Claude Agent SDK

Create Tool Router Session

python
from composio import Composio
from claude_agent_sdk import ClaudeSDKClient, ClaudeAgentOptions

composio = Composio(api_key='your-composio-api-key')
session = composio.create(user_id='your-user-id')
url = session.mcp.url
Initialize the Composio client and create a Tool Router session

Connect to AI Agent

python
import asyncio

options = ClaudeAgentOptions(
    permission_mode='bypassPermissions',
    mcp_servers={
        'tool_router': {
            'type': 'http',
            'url': url,
            'headers': {
                'x-api-key': 'your-composio-api-key'
            }
        }
    },
    system_prompt='You are a helpful assistant with access to Gigasheet tools.',
    max_turns=10
)

async def main():
    async with ClaudeSDKClient(options=options) as client:
        await client.query('List all columns in dataset handle 12345')
        async for message in client.receive_response():
            if hasattr(message, 'content'):
                for block in message.content:
                    if hasattr(block, 'text'):
                        print(block.text)

asyncio.run(main())
Use the MCP server with your AI agent

Why Use Composio?

AI Native Gigasheet Integration

  • Supports both Gigasheet MCP and direct API based integrations
  • Structured, LLM-friendly schemas for reliable tool execution
  • Rich coverage for reading, writing, and querying your Gigasheet data

Managed Auth

  • Built-in OAuth handling with automatic token refresh and rotation
  • Central place to manage, scope, and revoke Gigasheet access
  • Per user and per environment credentials instead of hard-coded keys

Agent Optimized Design

  • Tools are tuned using real error and success rates to improve reliability over time
  • Comprehensive execution logs so you always know what ran, when, and on whose behalf

Enterprise Grade Security

  • Fine-grained RBAC so you control which agents and users can access Gigasheet
  • Scoped, least privilege access to Gigasheet resources
  • Full audit trail of agent actions to support review and compliance

Use Gigasheet with any AI Agent Framework

Choose a Framework you want to connect Gigasheet with

Frequently Asked Questions

Do I need my own developer credentials to use Gigasheet with Composio?

Yes, Gigasheet requires you to configure your own API key credentials. Once set up, Composio handles secure credential storage and API request handling for you.

Can I use multiple toolkits together?

Yes! Composio's Tool Router enables agents to use multiple toolkits. Learn more.

Is Composio secure?

Composio is SOC 2 and ISO 27001 compliant with all data encrypted in transit and at rest. Learn more.

What if the API changes?

Composio maintains and updates all toolkit integrations automatically, so your agents always work with the latest API versions.

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.

Get started for freeGet a demo↗