Gigasheet
for LuumenAI
Query large datasets in Gigasheet and make changes as approved steps
Connect Gigasheet and your datasets become something you can ask questions about from the terminal. Count rows behind a filter, check how many duplicates a cleanup would remove, pull the rows that match a condition. When you want to change a sheet — enrich it, append to it, combine files — the agent shows the plan first and waits for your approval.
The Gigasheet toolbox
149 tools: 67 read, 82 write. Reads answer instantly. Writes require approval by default. Everything is logged.
- ReadCalculate Enrich Expected CreditsCalculate expected credits for a user-defined HTTP enrichment operation.
- ReadCount Dataset Deduplication ResultsCount how many duplicates will be removed and how many rows remain when deduplicating.
- ReadCount Dataset GroupsCount the number of groups matching certain criteria in a Gigasheet dataset.
- ReadCount Dataset RowsCounts rows in a Gigasheet dataset matching specified filter criteria.
- ReadCount Dataset ActivitiesGet total activity count on a given Gigasheet dataset.
- ReadCreate AI Chat QueryAI analysis assistant for Gigasheet datasets.
- ReadCreate Formula PreviewCalculate a formula preview on a Gigasheet dataset and return sample results with involved column values.
- ReadCreate File AggregationRetrieve ungrouped aggregated values for a Gigasheet file.
- ReadFilter File RowsRetrieve rows from a Gigasheet file matching specified filter criteria.
- ReadGenerate Dataset DescriptionGenerates an AI-powered description for a Gigasheet dataset.
- ReadGet Sheet AI Chat HistoryRetrieve AI chat history for a sheet.
- ReadGet Cell CommentsGet comments for a specific cell in a Gigasheet dataset.
- ReadGet Client State Current VersionRetrieves the current client-state version and timestamp for a specified sheet.
- ReadGet Connector Connection ParametersGet connection parameters for a specific connector.
- ReadGet Connector ConnectionsList connector connections.
- ReadGet Connector SourcesRetrieve information about connected data sources for the user.
- ReadGet Connector Source ParametersGet parameters required for a specific connector source type.
- ReadGet Dataset Column CommentsGet comments for a specific column in a dataset sheet.
- ReadGet Dataset by HandleRetrieves comprehensive metadata for a specific dataset in Gigasheet.
- ReadGet Dataset ColumnsList all column metadata (IDs, names, types) for a dataset.
- ReadGet Dataset Export Download URLRetrieve the download URL for an exported dataset.
- ReadGet Dataset Liveshare CSVRetrieve CSV data from a Gigasheet liveshare.
- ReadGet Dataset NoteRetrieve a dataset's note by handle.
- ReadGet Dataset Organization PermissionsRetrieve organization file permissions for a dataset.
- ReadGet Dataset Version MetadataRetrieves metadata about a dataset at a specific version.
- ReadGet Dataset ViewsList all views associated with a specific dataset.
- ReadGet Dataset Operation StatusGet information about the last operation on a dataset.
- ReadGet Dataset ActivityGet the list of write actions on a given dataset sheet.
- ReadGet Dataset View MetadataRetrieve view metadata for a specific view within a dataset.
- ReadGet Docs Formulas FunctionsRetrieve all supported formula functions.
- ReadGet Enrich Task StatusGet status for a user-defined HTTP enrichment task.
- ReadApply Filter Template On SheetFetch a saved filter template's model for a given sheet.
- ReadGet Filter TemplatesRetrieves all saved filter templates from GigaSheet.
- ReadGet Filter Template by HandleRetrieves details of a specific saved filter template by its unique handle.
- ReadGet Library FilesRetrieve all datasets and files in the user's Gigasheet library.
- ReadGet Library Files in DirectoryRetrieves all library files with file permissions in a given directory.
- ReadGet Library Home Page FilesRetrieve suggested recent files for the home page.
- ReadGet Library PathRetrieve the chain of parent directories for a file or folder in Gigasheet.
- ReadGet TICIntel NPI Public ProfileRetrieve public NPI (National Provider Identifier) profile from TICIntel database.
- ReadGet TIC Intel StatesList available TIC Intel states from Gigasheet.
- ReadList Cities by StateRetrieve a list of cities for a given US state code from the TICIntel dataset.
- ReadList Providers by CityRetrieve a list of healthcare providers in a specific city and state from the TicIntel dataset.
- ReadGet User DetailsRetrieves detailed information about the authenticated user in Gigasheet.
- ReadGet User Enrichment CreditsGet the current user's enrichment credit information.
- ReadGet User MetadataRetrieve metadata for the authenticated user.
- ReadGet User Autofill SuggestionsRetrieves autofill suggestions for the authenticated user, including team members and previously used share recipients.
- ReadGet User Space UsedGet the amount of space used by the current user in bytes.
- ReadGet Authenticated User InfoFetch the authenticated user's details.
- ReadList Billing PlansList available Gigasheet billing plans.
- ReadList Dataset CommentsGet all comments in a dataset sheet.
- ReadList Dataset LivesharesList all liveshares for a specific Gigasheet dataset.
- ReadList All DatasetsRetrieve all datasets owned by the user at any folder depth.
- ReadList Datasets by HandleList files and datasets in a given Gigasheet location.
- ReadList Library ExportsList exports owned by the current user, regardless of location.
- ReadList Shared Files by HandleRetrieve all files with permissions shared with the user in a specific directory location.
- ReadGenerate AI FormulaGenerate Excel-style formulas using AI based on natural language queries.
- ReadGenerate Dataset Assistant TipsGenerate AI-powered tips for analyzing a dataset.
- ReadInitiate Dataset ExportInitiates an asynchronous export job for a Gigasheet dataset.
- ReadFilter File Rows by Column NameFilter rows in a Gigasheet file by column names and return matching results.
- ReadGet Filtered Row IndexMaps an unfiltered row number to its position in the filtered result set.
- ReadFilter File with Stream ProgressFilter data from a Gigasheet file with real-time streaming progress updates.
- ReadPreview HTTP EnrichmentPreview a generic HTTP enrichment on a Gigasheet dataset before executing it on all rows.
- ReadSearch Dataset ActivitySearch the history of write actions performed on a Gigasheet dataset.
- ReadSearch LibrarySearch through the Gigasheet file library by file metadata.
- ReadValidate Dataset FormulaValidate a formula expression against a dataset.
- ReadValidate Files CombineValidate a combine files request and return all errors that might appear.
- ReadValidate Files Combine by NameValidate a combine by name request before executing it.
- WriteAppend Rows to DatasetAppends rows to an existing Gigasheet dataset using column letters as keys. Approval by default
- WriteAppend Sheet from Another SheetAppend data from a source sheet to a target sheet by matching column names. Approval by default
- WriteApply HTTP EnrichmentApply generic HTTP enrichment to a Gigasheet dataset. Approval by default
- WriteCancel HTTP Enrichment TaskCancel a running enrichment task. Approval by default
- WriteCheck Connector Source AvailabilityCheck if a source of the given type is available. Approval by default
- WriteCombine FilesCombine multiple files into a new file. Approval by default
- WriteCopy FileCopy a file in Gigasheet. Approval by default
- WriteCreate Dataset Column CommentAdd a comment to a column in a Gigasheet dataset. Approval by default
- WriteAdd Comment to CellAdd a comment to a specific cell in a Gigasheet dataset. Approval by default
- WriteCreate Conditional Label ColumnAdd a label column to a Gigasheet dataset with values based on conditional filters. Approval by default
- WriteCreate Formula ColumnCreate a new column based on a formula input in a Gigasheet dataset. Approval by default
- WriteEdit Formula ColumnEdit a formula column in a Gigasheet dataset. Approval by default
- WriteCreate Iterator ColumnAdd an iterator column to a Gigasheet dataset based on current filters and order. Approval by default
- WriteCreate Dataset LiveshareCreate a new liveshare for a Gigasheet dataset. Approval by default
- WriteCreate Dataset ViewCreate a new view for a Gigasheet dataset with a specified name and client state version. Approval by default
- WriteExplode JSON ColumnExplode JSON data in a column into separate columns. Approval by default
- WriteCreate Blank FileCreate an empty file in your Gigasheet Library. Approval by default
- WriteCreate Files DirectoryCreate a new folder in your Gigasheet Library. Approval by default
- WriteCreate Cross-File LookupCreates a cross-file lookup to enrich data by matching values between two sheets. Approval by default
- WriteSend MCP Request to Sheet AssistantInteract with Gigasheet Sheet Assistant via the Model Context Protocol (MCP) over HTTP. Approval by default
- WriteSplit ColumnSplit a column into multiple columns based on a separator. Approval by default
- WriteDelete Sheet Assistant LogsDelete Sheet Assistant chat history for a specific sheet. Approval by default
- WriteDelete columns by nameDelete multiple columns from a Gigasheet dataset by their column names. Approval by default
- WriteDelete Connector SourceDelete a connector source for the authenticated user. Approval by default
- WriteDelete Dataset CommentDelete a comment from a cell in a Gigasheet dataset. Approval by default
- WriteDelete Rows Not Matching FilterDeletes rows in a Gigasheet dataset that do NOT match the specified filter criteria. Approval by default
- WriteDelete Duplicated Rows from DatasetDelete duplicated rows from a Gigasheet dataset based on specified columns and sort model. Approval by default
- WriteDelete Rows from DatasetDelete selected rows from a Gigasheet dataset. Approval by default
- WriteDelete Rows Matching FilterDelete rows in a Gigasheet dataset that match a specified filter. Approval by default
- WriteDelete dataset viewDelete a specific view from a Gigasheet dataset. Approval by default
- WriteDelete dataset live shareDelete a live share of a Gigasheet dataset. Approval by default
- WriteDelete sheet or folder by handleDeletes a Gigasheet sheet or folder by its unique handle identifier. Approval by default
- WriteDelete column from sheetDelete a single column from a Gigasheet sheet by its column identifier. Approval by default
- WriteDelete Filter TemplateDelete a saved filter template by its unique handle. Approval by default
- WriteDelete multiple columns from fileDelete multiple columns from a Gigasheet file. Approval by default
- WriteGenerate New HandleGenerate a new unique dataset handle. Approval by default
- WriteMove file or folder to directoryMove a file or folder into a folder or to the root of your Library. Approval by default
- WriteUpdate User MetadataUpdate user metadata in Gigasheet. Approval by default
- WriteCast Column Data TypeChange a column's data type in a Gigasheet dataset. Approval by default
- WriteChange Column CaseChange the case of a column to Uppercase, Lowercase, Capitalized, or Proper. Approval by default
- WriteClean Company NameClean company names by stripping common business suffixes (Inc., LLC, Corp., etc.). Approval by default
- WriteCombine ColumnsCombine multiple columns into a single new column with a separator. Approval by default
- WriteAppend Rows to Sheet by NameAppends one or more rows to a Gigasheet dataset using column names as keys. Approval by default
- WriteFind and Replace in DatasetFind and replace values in specified columns of a Gigasheet dataset. Approval by default
- WriteInsert Blank Row in DatasetInsert a blank row with null values into a dataset. Approval by default
- WriteRename Columns to UniqueRename all columns in a dataset to unique names. Approval by default
- WriteSave Current ViewSaves the current view state of a Gigasheet dataset and returns a view handle. Approval by default
- WriteSelect columns by nameSelect specific columns from a Gigasheet dataset by name, keeping only those columns in the specified order. Approval by default
- WriteExtract Domain from URL ColumnExtract domain from a URL column in a Gigasheet dataset. Approval by default
- WriteSave Exported FileSaves a file state with applied filters and grouping to create an exported version. Approval by default
- WriteCombine Files by NameCombine multiple files by a shared column name. Approval by default
- WriteExport Gigasheet to S3Export Gigasheet data to AWS S3. Approval by default
- WriteImport from S3Import data from AWS S3 into your Gigasheet Library. Approval by default
- WriteRequest Access to FileRequest access to a Gigasheet file. Approval by default
- WriteRequest API AccessRequest API access by sending a notification to Gigasheet support team. Approval by default
- WriteTrim Column WhitespaceTrim leading and trailing whitespace from all values in a column. Approval by default
- WriteUnroll Delimited ColumnExplode a column containing delimited data into multiple rows. Approval by default
- WriteUpload Raw Data DirectUpload raw data directly to Gigasheet using byte array contents. Approval by default
- WriteUpload from URLUpload data to Gigasheet from a specified URL. Approval by default
- WriteSet Dataset Client State VersionApplies or restores a specific client state version to a dataset. Approval by default
- WriteUpdate cell by column name and rowUpdate a cell in a dataset by specifying column name and row number. Approval by default
- WriteShare fileShare a Gigasheet file with specified recipients. Approval by default
- WriteOpt out of shared fileRemove your access from a file that has been shared with you. Approval by default
- WriteCreate/Update Filter TemplateCreate or update a saved filter template. Approval by default
- WriteRename Columns by NameRename columns in a Gigasheet dataset using their current names. Approval by default
- WriteRename FileRename a file in Gigasheet. Approval by default
- WriteReset Client State to DefaultResets the client state of a sheet to the default state. Approval by default
- WriteReset User PasswordTrigger password reset for the authenticated user. Approval by default
- WriteSend Invite EmailsSend email invitations to join Gigasheet. Approval by default
- WriteSet Aggregate Filter ModelSet the aggregate filter model in the client state of a sheet. Approval by default
- WriteSet Client State AggregationsSets aggregations in the client state of a sheet. Approval by default
- WriteSet Client State Column StateSet column state in the client state of a sheet. Approval by default
- WriteSet Client State Filter ModelSet the filter model in the client state of a sheet. Approval by default
- WriteSet Client State Group ColumnsSet group columns in the client state of a sheet. Approval by default
- WriteSet Client State Sort ModelSets the sort model for a sheet's client state. Approval by default
- WriteSet Client State Visible ColumnsSet visible columns in the client state of a sheet. Approval by default
- WriteSet Dataset Client StateSets the client state of a dataset using a state object. Approval by default
- WriteSet Dataset Column CurrencySet currency format for a dataset column. Approval by default
- WriteSet Dataset NoteSet or update a note on a dataset in Gigasheet. Approval by default
- WriteUpdate Dataset CellUpdate a single cell value in a Gigasheet dataset by column letter and row number. Approval by default
- WriteUpdate Dataset ViewUpdate the client state of a specified view. Approval by default
- WriteUpsert Rows in DatasetUpsert rows in an existing Gigasheet dataset. Approval by default
One prompt, start to finish
What a governed Gigasheet run looks like inside Luumen.
Questions
How does LuumenAI connect to Gigasheet?
Authorize once with API token. Luumen lists the scopes each action needs before you approve the connection, and credentials never appear in the chat.
Can LuumenAI change things in Gigasheet on its own?
Read actions answer immediately. Anything that writes — append rows to dataset, append sheet from another sheet, apply http enrichment, cancel http enrichment task, and more — is shown as a plan and requires approval by default, including the 16 actions classified as destructive. Administrators configure that per tool, so you decide exactly which actions can ever run unattended.
Who gets access to the integration?
You decide. Actions are granted per agent, skill, and team, and per environment — production is not staging. Read access can be broad while writes stay narrow.
Is there an audit trail?
Every call to Gigasheet — read or write, approved or declined — is recorded with the actor, the input, and the result, and can be linked to the ticket or change record.
Put Gigasheet to work with Luumen
Connect in minutes. Every action scoped, approved, and audited from day one.