Gigasheet MCP in Claude Code

export GIGASHEET_API_KEY='YourTokenHere'

claude mcp add --transport http gigasheet https://api.gigasheet.com/mcp --header "X-GIGASHEET-TOKEN: ${GIGASHEET_API_KEY}" -s user

Test:

Close and reopen Claude Code. Ask it to query a sheet with a prompt like: 

query Gigasheet https://app.gigasheet.com/spreadsheet/CMS-Open-Payments-General-Payment-Data-2024--15-5M-Rows-/e7b491ad_f9ea_4379_9c6a_906d686172c8 show one sample row

Notes:

• Your Gigasheet license needs to include API and MCP permission for this capability. Contact sales@gigasheet.com for more information on licensing.
• Gigasheet's MCP server supports deep analysis with filters and groups, accessible to you by asking questions in Claude Code and having it use the installed MCP tool.
• With an MCP license you can use MCP on any sheet URL that you can access in your browser.
• For greater security, you can have Claude Code resolve your API key on every invocation by editing the Claude config file directly. Ensure your token is set in your shell profile, .e.g .zshrc. Edit the Claude config file ~/.claude.json in the relevant section. You can find the section by searching for the custom header X-GIGASHEET-TOKEN and then replacing the token value with your environment variable like ${GIGASHEET_API_KEY}.