Gigasheet MCP server

Connect Gigasheet to Claude, ChatGPT, Cursor, Claude Code, Codex, Gemini, GitHub Copilot and any other MCP client, for your whole team. Metorial adds security, governance, and tracing, and gives everyone one Magic MCP URL to connect.

What you can do with the Gigasheet MCP server

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Use the list files tool in Gigasheet
  • Use the manage file tool in Gigasheet
  • Use the modify rows tool in Gigasheet
  • Use the export sheet tool in Gigasheet
  • Use the find and replace tool in Gigasheet
  • Use the share file tool in Gigasheet

Supported Tools

list_files

List Files

List files and folders in your Gigasheet library. Can list files at the root level, within a specific folder, shared files, or search the library by name.

manage_file

Manage File

Perform file management operations on a Gigasheet file or folder. Supports renaming, copying, moving, deleting, and combining files.

modify_rows

Modify Rows

Add, update, or delete rows in a Gigasheet sheet. Supports appending new rows, inserting blank rows, updating individual cells, upserting rows, deleting specific rows, or deleting rows matching/not matching a filter.

export_sheet

Export Sheet

Create an export of a Gigasheet sheet, optionally with filters and groupings applied. The export is asynchronous — this tool returns the export handle which can be used to check status and download the result.

find_and_replace

Find and Replace

Search for values in a sheet and replace them with new values. Optionally scope the operation to a specific column and control matching behavior.

share_file

Share File

Share a Gigasheet file with other users via email, or create a live share link that produces CSV data. Supports setting permissions and managing live shares.

manage_columns

Manage Columns

Perform column operations on a Gigasheet sheet. Supports renaming, deleting, combining, splitting, changing data types, changing string case, trimming whitespace, extracting domains from URLs, and exploding JSON or delimited columns.

create_sheet

Create Sheet

Create a new sheet in Gigasheet. You can create a blank sheet with optional column headers, upload data from a URL, or upload raw data directly. Also supports creating folders for organization.

filter_data

Filter Data

Query and filter data in a Gigasheet sheet. Supports filtering with complex filter models (AND/OR conditions, regex, wildcards), sorting, pagination, grouping, and aggregations. You can also use a saved filter by its handle.

get_sheet

Get Sheet Details

Retrieve detailed information about a Gigasheet sheet including its metadata, columns, and structure. Useful for understanding a sheet before performing data operations.

run_formula

Run Formula

Execute a formula on a Gigasheet sheet to create a new calculated column. Supports validating and previewing formulas before execution. Use the AI formula builder to help construct complex formulas from natural language.

download_export

Download Export

Prepare a downloadable CSV export. The export must have finished processing. Optionally checks the export status before downloading.

get_activity

Get Activity History

Retrieve the audit and activity history for a Gigasheet sheet. Shows actions performed on the dataset, with support for searching through activity logs.

deduplicate_rows

Deduplicate Rows

Detect and remove duplicate rows from a Gigasheet sheet. You can first count duplicates before deleting, and optionally scope duplication detection to specific columns.

manage_saved_filters

Manage Saved Filters

List, create, update, or delete saved filters in Gigasheet. Saved filters store reusable filter logic that can be applied to any sheet.

cross_file_lookup

Cross-File Lookup

Perform a VLOOKUP-style operation across two sheets. Joins data from a lookup sheet into the target sheet based on matching column values. Columns from the lookup sheet are added to the target sheet where matches are found.

manage_views

Manage Views

Create, list, update, delete, or convert named views on a Gigasheet sheet. Views save specific filter, sort, grouping, and aggregation configurations that can be reapplied. Views can also be converted to linked sheets.

manage_comments

Manage Comments

Add, retrieve, or delete comments on a Gigasheet sheet. Supports both column-level and cell-level comments.

enrich_data

Enrich Data

Enrich sheet data using built-in or custom enrichment providers. Built-in providers include email validation and geolocation. Custom HTTP enrichments allow calling external APIs to enrich data. Enrichments consume credits.

ai_assistant

AI Assistant

Chat with Gigasheet's AI assistant about a sheet's data. The assistant can answer questions about the data, provide insights, and help with analysis. Also supports retrieving and clearing chat history.

list_exports

List Exports

List exports owned by the current user, including export handles and processing states. Pass an export handle to download_export once its state is processed.

get_current_user

Get Current User

Get the authenticated Gigasheet user and detailed account information.

Connect Gigasheet to your AI client

Every client uses the same Magic MCP URL, and so does any other MCP client. Add it once and sign in with SSO.

  1. Enable Gigasheet in Metorial. In your Metorial portal, enable the Gigasheet MCP server and sign in with the account that owns the data. Access stays governed by your team policies.
  2. Add a custom connector. Open Customize, then Connectors. Select Add, then Custom, then Web.
  3. Paste your Metorial MCP URL. Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>) and continue.
  4. Sign in. Select Add and sign in to load Gigasheet tools.

Run Gigasheet through the Metorial gateway

One governed layer for every app your agents reach, not a separate connector per tool.

  • Give Gigasheet and every other app to your whole team through one MCP gateway, behind your SSO.
  • Scope which teams and agents can use Gigasheet tools with role-based access control, and trace every call.
  • Prefer to run it yourself? Metorial is open source and self-hostable.

More integrations teams use with Gigasheet

Notion

Create, read, update, and archive pages and databases in a Notion workspace. Manage blocks (paragraphs, lists, headings, embeds, etc.) within pages. Query databases with filters and sorts across rich property types including text, numbers, dates, selects, relations, and formulas. Search across pages and databases by title. Add and read comments on pages and blocks. Upload files to pages. Manage workspace users and retrieve user profiles.

Google Sheets

Create, read, and update spreadsheets and their cell data. Read and write values to individual cells, ranges, or multiple ranges using A1 notation or named ranges. Apply cell formatting including text styles, backgrounds, borders, number formats, and conditional formatting. Manage sheets (tabs) within a spreadsheet—add, delete, copy, rename, and reorder them. Create and manage embedded charts, pivot tables, filter views, data validation rules, protected ranges, named ranges, and merged cells. Perform batch operations to apply multiple updates atomically.

GitHub

Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.

Salesforce

Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Resolve site users to numeric Person/Group LookupId values. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Retrieve site properties and search for sites across Microsoft 365.

Airtable

Create, read, update, and delete records in Airtable bases and tables. Manage base schemas including creating tables and fields. Filter records using formulas, sort by fields, and scope queries to specific views. Upsert records to find, create, or update in a single call. Upload attachments to records, read and write record comments, list accessible bases, and receive real-time base change events through webhooks.

Technical notes for Gigasheet

Upload, manage, and manipulate large-scale spreadsheet datasets (CSV, JSON, log files) in the cloud. Create, copy, rename, move, and delete sheets and folders. Modify data at cell, row, and column levels including formulas, column splitting, type changes, and find-and-replace. Build complex filters with AND/OR logic, regex, and wildcards. Aggregate and group data like pivot tables. Create and manage named views. Export datasets with optional filters applied and download via pre-signed URLs. Share files with configurable permissions and create live shareable links. Enrich data using built-in providers (email validation, geolocation) or custom HTTP enrichments. Detect and delete duplicate rows. Perform cross-file lookups (VLOOKUP-style joins). Connect to external databases and data warehouses for import/export. Interact with data via an AI chat assistant and AI formula builder. Add and manage comments on cells and columns. Retrieve audit and activity history for datasets. Manage users, teams, and API keys.

Frequently asked questions

Common questions about connecting Gigasheet to AI agents with Metorial.

  1. How many tools does the Gigasheet MCP server have?
    The Gigasheet MCP server exposes 22 tools, including List Files, Manage File, Modify Rows. Each one is governed and traced through Metorial.
  2. Gigasheet exposes tools your agents call on demand; it does not publish event triggers yet. Everything still runs through one governed MCP URL.
  3. Any MCP client, including VS Code, Windsurf, Zed, OpenCode and Grok. Each one reaches the Gigasheet MCP server through the same Metorial URL.
  4. Use role-based access control to decide which teams, users, and agents can use Gigasheet and which of its tools they can call.
  5. Yes. Metorial is open source, so you can run the Gigasheet MCP server yourself or use the hosted gateway.

Connect Gigasheet to production AI agents

See how Metorial gives your team governed access to Gigasheet, with tracing and security controls built in.