Integration

Gigasheet integration

Gigasheet is a cloud spreadsheet for very large datasets. Upload CSV and other files from a URL, browse and search the library, read sheet metadata and columns, filter, count, group and aggregate rows, query a sheet with GigaScript, append, update, upsert, insert and delete rows and cells, clean and transform columns (formulas, split, combine, change case or type, find and replace, explode JSON, lookups across files), deduplicate, combine sheets, manage views, saved filters and notes, run on-demand or custom HTTP enrichments, ask the AI Sheet Assistant, and export filtered data to a downloadable zip. Every POST, PUT, PATCH and DELETE costs 1 API token, GET is free; enrichments also spend enrichment credits. Not exposed: account deletion, API key issuance and revocation, team and invitation emails, the MCP endpoint, data connectors, the web app's client-state routes, raw byte upload, setting organization permissions, and routes whose body the reference leaves undocumented (email and IP enrichments, save-exported, file entry creation). Authentication is an API key sent in the X-GIGASHEET-TOKEN header.

Connect Gigasheet How integrations work

Ask it in chat

Say what should happen.
The workflow builds itself.

When this happens, do that in Gigasheet.Built from the 118 Gigasheet tools below, on the connection you add once.

What you can do with Gigasheet

Each of these is one operation on one endpoint, available both as a workflow step and as a tool an AI agent can call on its own. Nothing bundles several operations into one action, so what a run did stays readable afterwards.

Most endpoints run on the free plan. A few, mainly the ones that publish on your behalf, need a paid plan.

Column, 21 operations

add_conditional_label_columnAdd conditional label columnPOSTAdds a column whose value is the label of the first case whose filter the row matches, else defaultLabel.
add_formula_columnAdd formula columnPOSTAdds a column computed by a formula over other columns. An empty formula "" adds a blank column.
add_iterator_columnAdd iterator columnPOSTAdds a column numbering the rows (1, 2, 3...) in the order given by sortModel, among rows matching filterModel.
change_column_caseChange column casePOSTChanges the letter case of every value in a column: Uppercase, Lowercase, Capitalize or Proper.
change_column_typeChange column typePOSTConverts a column to another data type (number, date, IP address or plain text) with a format such as integer, decimal or ipv4.
clean_company_namesClean company namesPOSTCleans company names in a column by stripping suffixes such as Inc or LLC. Works on English-alphabet names.
combine_columnsCombine columnsPOSTAdds a column that joins several columns' values with a separator.
cross_file_lookupCross file lookupPOSTAdds columns from a reference sheet to this sheet, matching this sheet's column with a column of the reference (like VLOOKUP).
delete_columnDelete columnDELETEDeletes one column from a sheet.
delete_columnsDelete columnsPOSTDeletes several columns from a sheet by column id.
delete_columns_by_nameDelete columns by namePOSTDeletes several columns from a sheet by their names.
edit_formula_columnEdit formula columnPOSTReplaces the formula of a column created by add_formula_column.
enrich_on_demandEnrich on demandPOSTEnriches a column at once (not batched) with revenuebase-linkedin or revenuebase-email, adding result columns. Spends enrichment credits; filterModel limits the rows.
explode_json_columnExplode json columnPOSTAdds one column per JSON key found in a column. Without keys, uses the most common keys, up to 2000.
extract_domainExtract domainPOSTAdds a column with the domain of each URL in a column.
list_columnsList columnsGETReturns a sheet's columns: Id (the letter used as colId in filters and other tools), Name and FieldType.
make_column_names_uniqueMake column names uniquePOSTRenames columns where needed so every column name is unique, keeping names that already are.
rename_columnsRename columnsPOSTRenames columns by name.
select_columnsSelect columnsPOSTKeeps only the named columns, in the given order (delete_all_others true), or moves them first and keeps the rest. The row number column always stays.
split_columnSplit columnPOSTSplits a column into two or more columns at a separator.
trim_whitespaceTrim whitespacePOSTTrims leading and trailing whitespace from every value in a column.

Row, 15 operations

append_rowsAppend rowsPOSTAppends rows to an existing sheet. Each record maps column ids (from list_columns) to values.
append_rows_by_nameAppend rows by namePOSTAppends rows to an existing sheet, using column names instead of column ids.
append_rows_from_sheetAppend rows from sheetPOSTAppends the rows of a source sheet to a target sheet, matching columns by name.
count_duplicate_rowsCount duplicate rowsPOSTCounts how many rows delete_duplicate_rows would remove and how many would remain, without changing the sheet.
count_rowsCount rowsPOSTReturns how many rows match a filter. Only filterModel is needed for a plain count.
delete_duplicate_rowsDelete duplicate rowsDELETEDeletes duplicate rows, keeping the first of each set of rows that share the given columns' values. count_duplicate_rows previews the effect.
delete_rowsDelete rowsDELETEDeletes rows by row id (the # row number). Row ids change after edits, so read them just before deleting.
delete_rows_matching_filterDelete rows matching filterDELETEDeletes every row that matches the filter.
delete_rows_not_matching_filterDelete rows not matching filterDELETEDeletes every row that does not match the filter.
filter_rowsFilter rowsPOSTReturns the rows of a sheet matching a filter model, with startRow and endRow for paging. For basic filtering only filterModel is needed. query_sheet is simpler for most reads.
filter_rows_by_nameFilter rows by namePOSTReturns rows matching a filter written with column names instead of ids. Supports a subset of filter_rows.
get_filtered_row_numberGet filtered row numberPOSTReturns where an unfiltered row number lands in the filtered result.
insert_blank_rowsInsert blank rowsPOSTInserts blank rows at a position in a sheet.
query_sheetQuery sheetPOSTRuns a GigaScript query on a sheet and returns headers, types and rows, plus a permalink. Statements end with DISPLAY, e.g. FILTER Region = West; SORT Revenue DESC; LIMIT 25; DISPLAY.
unroll_delimited_columnUnroll delimited columnPOSTExplodes delimited lists in a column into rows: each element becomes its own row, other fields copied.

File, 14 operations

copy_fileCopy filePOSTCopies a sheet into your library.
delete_fileDelete fileDELETEPermanently deletes a sheet or an empty folder; with recursive true, a folder and everything in it.
list_folder_filesList folder filesGETLists the files and folders inside one folder, paged, as a list of entries. Each FileUuid is a handle to pass to other tools.
list_library_folderList library folderGETDeclares no output fields (Gigasheet documents no response shape); use list_folder_files for a typed listing. Asks for the files you own inside one folder (not deeper), with their permissions.
list_library_rootList library rootGETDeclares no output fields (Gigasheet documents no response shape); use list_root_files for a typed listing. Asks for the datasets you own at any depth, files shared with you and ids of files you shared.
list_recent_filesList recent filesGETReturns suggested recent files, as on the Gigasheet home page.
list_root_filesList root filesGETLists the files and folders at the root of your library, as a list of entries. Each FileUuid is a handle to pass to other tools.
list_shared_with_meList shared with meGETDeclares no output fields (Gigasheet documents no response shape), so a workflow step gets nothing usable from it. Asks for the files shared with you, at the root.
list_shared_with_me_folderList shared with me folderGETDeclares no output fields (Gigasheet documents no response shape), so a workflow step gets nothing usable from it. Asks for the files shared with you inside one folder (not deeper).
list_shared_with_teamList shared with teamGETDeclares no output fields (Gigasheet documents no response shape), so a workflow step gets nothing usable from it. Asks for the files shared with your team, at the root.
list_shared_with_team_folderList shared with team folderGETDeclares no output fields (Gigasheet documents no response shape), so a workflow step gets nothing usable from it. Asks for the files shared with your team inside one folder.
move_fileMove filePUTMoves a file or folder into another folder, or to the library root. The folder must exist.
rename_fileRename filePOSTRenames a sheet or folder.
search_librarySearch libraryPOSTSearches file metadata (owner, file_name, headers and note by default), not file contents. Returns matching library entries.

Sheet, 9 operations

combine_sheetsCombine sheetsPOSTCombines sheets with matching column names and types into a new sheet (or in place into the first). An in-place combine still running after 15 s answers 202: poll get_operation_status on the first sheet.
combine_sheets_by_nameCombine sheets by namePOSTCombines sheets into a new sheet, matching columns by header name.
create_blank_sheetCreate blank sheetPOSTCreates an empty sheet in your library.
get_sheetGet sheetGETReturns a sheet's metadata: name, Status (loading, processing, processed or error), row count, column names and types, and update time. Poll it after upload_from_url or create_export until Status is processed.
get_sheet_versionGet sheet versionGETReturns a sheet's metadata as it was in one version: name, status, row count, column names and types.
save_current_viewSave current viewPOSTSaves a sheet's current view (filters and grouping) as a new file.
upload_from_urlUpload from urlPOSTLoads a file (CSV and other formats) from a URL into a new sheet, or appends to targetHandle. Returns Handle; poll get_sheet until Status is processed.
validate_combine_sheetsValidate combine sheetsPOSTChecks a combine_sheets request and returns every error it would hit, without combining.
validate_combine_sheets_by_nameValidate combine sheets by namePOSTChecks a combine_sheets_by_name request and returns every error it would hit, without combining.

Saved filter, 5 operations

delete_saved_filterDelete saved filterDELETEDeletes a saved filter.
get_saved_filterGet saved filterGETReturns a saved filter's name, owner, dates and template.
get_saved_filter_modelGet saved filter modelGETReturns a saved filter applied to a sheet: filterModel is ready to pass to filter_rows, count_rows or create_export.
list_saved_filtersList saved filtersGETLists your saved filters: Id (the filter handle), Name and dates. Use an Id with get_saved_filter_model.
save_filterSave filterPUTCreates or updates a saved filter from a filter model and the sheet it applies to.

View, 5 operations

create_viewCreate viewPOSTCreates a named view of a sheet from a client state version.
delete_viewDelete viewDELETEDeletes a view of a sheet.
get_viewGet viewGETReturns one view of a sheet: id, name, owner and client_state.
list_viewsList viewsGETLists the saved views of a sheet: id, name, owner and client_state.
update_viewUpdate viewPATCHUpdates a view's name or client state.

Cell, 4 operations

find_and_replaceFind and replacePOSTReplaces text in columns. Adds a column with the replaced values under the original name and renames the original column Original Values - <name>.
update_cellUpdate cellPUTSets the value of one cell, addressed by column id and row id.
update_cell_by_nameUpdate cell by namePUTSets the value of one cell, addressed by column name and row number. Fails if the name is missing or shared by several columns.
upsert_cellsUpsert cellsPUTWrites a block of cells starting at a column id and row number; existing cells in the block are overwritten.

Enrichment task, 4 operations

apply_http_enrichmentApply http enrichmentPOSTRuns a custom HTTP enrichment: calls url_template once per matching row and writes response fields to new columns. Returns a task handle for get_http_enrichment_task. Spends enrichment credits.
cancel_http_enrichment_taskCancel http enrichment taskPOSTCancels a custom HTTP enrichment task; no partial results are written.
get_http_enrichment_taskGet http enrichment taskGETDeclares no output fields (Gigasheet documents no response shape), so a workflow step gets nothing usable from it. Asks for the status of one custom HTTP enrichment task.
list_http_enrichment_tasksList http enrichment tasksGETDeclares no output fields (Gigasheet documents no response shape), so a workflow step gets nothing usable from it. Asks for your active custom HTTP enrichment tasks, or those of one sheet.

Activity, 3 operations

count_sheet_activityCount sheet activityPOSTCounts the write actions on a sheet matching the criteria (all non-blank criteria must match).
list_sheet_activityList sheet activityGETLists the write actions recorded on a sheet (who changed what, when), paged.
search_sheet_activitySearch sheet activityPOSTSearches the write actions on a sheet by action, category, user, time range or text, paged.

Export, 3 operations

create_exportCreate exportPOSTQueues an export of a sheet, optionally filtered, and returns its handle at once. Poll get_sheet with that handle until processed, then call get_export_download_url.
get_export_download_urlGet export download urlGETReturns presignedUrl, a temporary link to the export's zip of CSV. Pass the EXPORT handle from create_export, after get_sheet on it shows Status processed.
list_exportsList exportsGETLists the exports you own, wherever they are, paged.

Formula, 3 operations

build_formula_with_aiBuild formula with aiPOSTTurns a plain-language request into a Gigasheet formula for a sheet you can read. Returns Formula; run it with add_formula_column.
preview_formulaPreview formulaPOSTComputes a formula on a few rows without changing the sheet; returns sample results with the values used.
validate_formulaValidate formulaPOSTChecks whether a formula is valid for the sheet without running it.

Column currency, 2 operations

set_column_currencySet column currencyPUTFormats a column as a currency.
unset_column_currencyUnset column currencyDELETERemoves the currency formatting of a column.

Enrichment credit, 2 operations

estimate_http_enrichment_creditsEstimate http enrichment creditsPOSTReturns how many enrichment credits a custom HTTP enrichment would use for the given columns and filter.
get_enrichment_creditsGet enrichment creditsGETReturns your enrichment credits: Limit and Used.

Federated table, 2 operations

check_federated_tableCheck federated tablePOSTChecks whether sheets can form a federated table and returns the proposed schema. Creates nothing.
create_federated_tableCreate federated tablePOSTCreates a federated table that queries the rows of several sheets without copying them. check_federated_table tests compatibility first.

File share, 2 operations

leave_shared_fileLeave shared filePUTRemoves your own access to a file that someone shared with you.
share_fileShare filePUTShares a file with people by email, with read (0) or read and write (0 and 1) permission. Gigasheet emails them unless skip_notification is true.

Folder, 2 operations

create_folderCreate folderPOSTCreates a folder in your library.
get_file_pathGet file pathGETReturns the chain of parent folders of a file or folder, including itself, ordered by level.

Linked sheet, 2 operations

create_linked_sheetCreate linked sheetPOSTCreates a linked sheet showing the rows of one view of a sheet.
refresh_linked_sheetsRefresh linked sheetsPOSTRecomputes the column metadata of every linked sheet created from this sheet's views; row counts update in the background.

Sheet assistant message, 2 operations

delete_sheet_assistant_historyDelete sheet assistant historyDELETEDeletes the Sheet Assistant conversation of a sheet.
list_sheet_assistant_historyList sheet assistant historyGETReturns recent Sheet Assistant messages of a sheet: role, content, message type and time.

Sheet note, 2 operations

get_sheet_noteGet sheet noteGETReturns the note attached to a sheet, with a success flag.
set_sheet_noteSet sheet notePUTSets the note of a sheet (at most 20,000 characters), replacing the current one.

User, 2 operations

get_user_detailsGet user detailsGETDeclares no output fields (Gigasheet documents no response shape), so a workflow step gets nothing usable from it; use get_whoami to check the key. Asks for the signed-in user's details.
get_whoamiGet whoamiGETReturns the username behind the API key and whether the request is authenticated. Use it to check the key.

Aggregation, 1 operation

get_aggregationsGet aggregationsPOSTReturns aggregated values (sum, average and so on, from valueCols or ungroupedAggregations) over the rows matching a filter, without grouping.

Analysis tip, 1 operation

generate_analysis_tipsGenerate analysis tipsPOSTUses AI to suggest example analyses for a sheet. Returns Examples, a list of suggestions.

Enrichment, 1 operation

preview_http_enrichmentPreview http enrichmentPOSTRuns a custom HTTP enrichment on a few rows and returns the result, without changing the sheet.

File access request, 1 operation

request_file_accessRequest file accessPOSTEmails the owner of a file to ask for access to it.

Formula function, 1 operation

list_formula_functionsList formula functionsGETReturns every function usable in formulas, with documentation and examples.

Handle, 1 operation

generate_handleGenerate handleGETReturns a new well-formed handle string. It creates nothing.

Npi plan, 1 operation

list_npi_plansList npi plansGETFor a price-transparency rate sheet, lists the payer and plan pairs a provider (NPI) has negotiated rates for. An NPI with no rates gives an empty list.

Npi profile, 1 operation

get_npi_profileGet npi profileGETReturns the public profile of a healthcare provider by NPI (names, taxonomy, locations), without contracted rates.

Operation status, 1 operation

get_operation_statusGet operation statusGETReturns the status of the last operation on a sheet, used after a 202 answer (an in-place combine still running). Status is empty (no operation), Working, Done or Error; also Message, Owner and UpdatedAt.

Row group, 1 operation

count_groupsCount groupsPOSTReturns how many groups match a filter when rows are grouped by rowGroupCols.

Sheet assistant, 1 operation

ask_sheet_assistantAsk sheet assistantPOSTAsks Gigasheet's AI Sheet Assistant a question about a sheet you can write to; it analyzes the data and answers. Read the conversation with list_sheet_assistant_history.

Sheet description, 1 operation

generate_sheet_descriptionGenerate sheet descriptionPOSTUses AI to write a short description of a sheet. Returns Description.

Sheet permission, 1 operation

get_organization_permissionsGet organization permissionsGETReturns the permissions a sheet grants to members of your organization.

Storage usage, 1 operation

get_space_usedGet space usedGETDeclares no output fields: Gigasheet answers a bare integer, which this catalog cannot map to a field, so a workflow step gets nothing usable from it. Asks for the storage space your files use.

Use Gigasheet from Claude Code, Cursor or Codex

Connect Gigasheet in LiveContext, create an API key in Settings, then add the LiveContext MCP server to your client. Its Gigasheet operations become tools the client can call, next to every other integration you connected.

Claude Code

claude mcp add --transport http livecontext https://livecontext.ai/mcp --header "X-API-Key: YOUR_API_KEY"

Codex (~/.codex/config.toml)

[mcp_servers.livecontext]
url = "https://livecontext.ai/mcp"

[mcp_servers.livecontext.http_headers]
"X-API-Key" = "YOUR_API_KEY"

Cursor, Claude Desktop and other JSON configs

{
  "mcpServers": {
    "livecontext": {
      "type": "http",
      "url": "https://livecontext.ai/mcp",
      "headers": {
        "X-API-Key": "YOUR_API_KEY"
      }
    }
  }
}

Set up the MCP server step by step

How to connect Gigasheet

Create your workspace
Sign up free. Nothing to install.
Connect Gigasheet once
Add your Gigasheet connection in Settings. Every tool from this integration reuses it, and secrets are encrypted at rest and visible only to you.
Describe the job in chat
The workflow builds itself in front of you and picks the endpoints it needs. Drag the steps yourself on the canvas whenever you would rather be explicit.