- Category: spreadsheets
- Auth: API_KEY
- Composio-managed OAuth available? N/A
- Tools: 150
- Triggers: 0
- Slug:
GIGASHEET - Version: 20261101_00
Tools
Append Rows to Dataset
Append Rows to Dataset
GIGASHEET_APPEND_DATASETAppends rows to an existing Gigasheet dataset using column letters as keys. Use when you need to add new data rows to a sheet by specifying values for each column position (A, B, C, etc.).Input Parameters
Output
Append Sheet from Another Sheet
Append Sheet from Another Sheet
GIGASHEET_APPEND_DATASET_FROM_SHEETTool to append data from a source sheet to a target sheet by matching column names. Use when you need to combine data from two existing sheets based on column name matching rather than column IDs. This action matches columns from the source sheet to the target sheet based on column names, with options for case-insensitive matching and trimming whitespace. Unmatched columns can optionally be added as new columns to the target sheet.Input Parameters
Output
Apply HTTP Enrichment
Apply HTTP Enrichment
GIGASHEET_APPLY_USER_DEFINED_HTTP_ENRICHMENTApply generic HTTP enrichment to a Gigasheet dataset, using an external endpoint and response paths to add enriched columns. The operation is asynchronous and may return a job handle for monitoring progress.Input Parameters
Output
Calculate Enrich Expected Credits
Calculate Enrich Expected Credits
GIGASHEET_CALCULATE_ENRICH_EXPECTED_CREDITSCalculate expected credits for a user-defined HTTP enrichment operation. Use this before initiating an enrichment to estimate costs based on the number of rows and columns that will be processed. This tool helps you: - Estimate credit costs before running an enrichment - Understand resource requirements for filtered enrichments - Plan budget for large-scale enrichment operationsInput Parameters
Output
Cancel HTTP Enrichment Task
Cancel HTTP Enrichment Task
GIGASHEET_CANCEL_ENRICH_USER_DEFINED_HTTP_TASKTool to cancel a running enrichment task. Use when you need to stop an in-progress HTTP enrichment job that was previously initiated. This action attempts to cancel an enrichment task identified by its task handle. Cancellation is only possible for tasks that are still in progress (not yet completed or already failed). The task handle is returned when you start an enrichment job using the apply enrichment endpoint.Input Parameters
Output
Check Connector Source Availability
Check Connector Source Availability
GIGASHEET_CHECK_CONNECTORS_SOURCES_CONNECTORNAMETool to check if a source of the given type is available. Use this to verify whether a specific connector integration (e.g., Snowflake, Salesforce) is configured and available for the authenticated user. This updates corresponding connection statuses.Input Parameters
Output
Combine Files
Combine Files
GIGASHEET_COMBINE_FILESTool to combine multiple files into a new file. Use when you need to merge several files where column names and types match. Optionally add source filename tracking or append rows to the first file in-place.Input Parameters
Output
Copy File
Copy File
GIGASHEET_COPY_FILETool to copy a file in Gigasheet. Use when you need to duplicate an existing file/sheet into your library with an optional new name and destination folder.Input Parameters
Output
Count Dataset Deduplication Results
Count Dataset Deduplication Results
GIGASHEET_COUNT_DATASET_DEDUPLICATE_ROWSTool to count how many duplicates will be removed and how many rows remain when deduplicating. Use when you need to preview the impact of a deduplication operation before executing it, or to understand the number of duplicate rows in a dataset based on specific column combinations.Input Parameters
Output
Count Dataset Groups
Count Dataset Groups
GIGASHEET_COUNT_DATASET_GROUPSTool to count the number of groups matching certain criteria in a Gigasheet dataset. Use when you need to determine how many distinct groups exist based on specified row grouping columns and optional filters. This action is useful for understanding data distribution and cardinality before performing more expensive operations like full group aggregations. It supports advanced features like pivot mode, filtering, and sorting configurations.Input Parameters
Output
Count Dataset Rows
Count Dataset Rows
GIGASHEET_COUNT_DATASET_ROWSCounts rows in a Gigasheet dataset matching specified filter criteria. Returns the number of rows matching the provided filters, groupings, and other parameters. For basic row counting, only the handle and optionally filterModel need to be specified. Advanced features like pivot mode, grouping, and aggregations are available for complex counting scenarios. Common use cases: - Count all rows in a dataset - Count rows matching specific filter conditions - Count grouped rows in pivot tables - Validate filter results before exporting data For detailed information on constructing filter models, refer to the Gigasheet Filter Model Detail Guide at https://gigasheet.readme.io/reference/post_dataset-handle-count-rowsInput Parameters
Output
Count Dataset Activities
Count Dataset Activities
GIGASHEET_COUNT_DATASETS_ACTIVITY_COUNTTool to get total activity count on a given Gigasheet dataset. Use when you need to determine how many activities (creates, updates, deletes) have been performed on a dataset. This action counts activities matching the specified criteria such as time range, users, action types, and categories. Non-blank criteria are AND-ed together, while multi-value fields (Actions, Categories, Users) are OR-ed. Returns the total count of matching activities.Input Parameters
Output
Create AI Chat Query
Create AI Chat Query
GIGASHEET_CREATE_AI_CHATAI analysis assistant for Gigasheet datasets. Use this to ask natural language questions about sheet data and get AI-powered insights. Only available for sheets where you have write permissions. Common use cases: - Get summaries of data patterns and trends - Ask questions about specific columns or values - Request analysis of data relationships - Extract key insights from large datasets Note: Requires write access to the target sheet.Input Parameters
Output
Create Dataset Column Comment
Create Dataset Column Comment
GIGASHEET_CREATE_DATASET_COLUMN_COMMENTTool to add a comment to a column in a Gigasheet dataset. Use this when you need to annotate or document a specific column with explanatory text. Optionally notify other users by tagging their email addresses.Input Parameters
Output
Add Comment to Cell
Add Comment to Cell
GIGASHEET_CREATE_DATASET_COMMENTTool to add a comment to a specific cell in a Gigasheet dataset. Use when you need to annotate or add notes to a particular cell location in the sheet.Input Parameters
Output
Create Conditional Label Column
Create Conditional Label Column
GIGASHEET_CREATE_DATASET_CONDITIONAL_LABEL_COLUMNTool to add a label column to a Gigasheet dataset with values based on conditional filters. Use when you need to categorize or label rows based on column values. This action creates a new column where each row’s label is determined by evaluating filter conditions. Cases are evaluated in order, and the first matching case determines the label. Rows not matching any case receive the defaultLabel (if specified). Before using this tool: 1. Obtain a valid dataset handle using actions like GIGASHEET_POST_UPLOAD_URL or GIGASHEET_GET_DATASET_HANDLE 2. Identify column IDs/names using GIGASHEET_GET_DATASET_HANDLE_COLUMNS 3. Construct appropriate filter models - note that filter values must be strings even for numeric comparisons Example use case: Create a “Priority” column that labels rows as “High” if Amount > 1000, “Medium” if Amount > 100, otherwise “Low”.Input Parameters
Output
Create Formula Column
Create Formula Column
GIGASHEET_CREATE_DATASET_FORMULATool to create a new column based on a formula input in a Gigasheet dataset. Use when you need to calculate values based on existing columns. This action creates a new column with values computed from a formula. You must reference columns by letter (e.g., ‘A’, ‘B’, ‘C’) using the ‘formula’ parameter. The ‘literalFormula’ parameter can be provided alongside ‘formula’ for documentation purposes to show the human-readable column names, but cannot be used alone. Formula syntax supports: - Column references: A, B, C (required, use column letters) - Arithmetic operations: +, -, *, / - Functions: UPPER(), LOWER(), CONCATENATE(), etc. - Example: “A * 2”, “UPPER(B)”, “CONCATENATE(B, C)” Before using this tool: 1. Obtain a valid dataset handle using GIGASHEET_POST_UPLOAD_URL or GIGASHEET_GET_DATASET_HANDLE 2. Use GIGASHEET_GET_DATASET_HANDLE_COLUMNS to identify column letters for formula construction 3. Construct the appropriate formula expression based on your calculation needsInput Parameters
Output
Edit Formula Column
Edit Formula Column
GIGASHEET_CREATE_DATASET_FORMULA_EDITTool to edit a formula column in a Gigasheet dataset. Use when you need to update an existing formula column with a new formula, rename it, or reposition it. The column must already exist and be a formula column created previously.Input Parameters
Output
Create Formula Preview
Create Formula Preview
GIGASHEET_CREATE_DATASET_FORMULA_PREVIEWTool to calculate a formula preview on a Gigasheet dataset and return sample results with involved column values. Use this action when you need to: - Test a formula expression before applying it to an entire column - Preview formula calculations on sample data - Validate formula syntax and see example outputs - View which columns are involved in the formula computation The action returns sample rows showing the formula result along with the values from columns referenced in the formula. This is useful for validating formulas before creating computed columns or performing bulk calculations.Input Parameters
Output
Create Iterator Column
Create Iterator Column
GIGASHEET_CREATE_DATASET_ITERATOR_COLUMNTool to add an iterator column to a Gigasheet dataset based on current filters and order. Use when you need sequential row numbers in your data. This action creates a new column with sequential numbers (1, 2, 3, …) for each row. The numbering respects any applied filters and sort order, making it useful for ranking, indexing, or tracking row positions after data transformations. Before using this tool: 1. Obtain a valid dataset handle using GIGASHEET_POST_UPLOAD_URL or GIGASHEET_GET_DATASET_HANDLE 2. Optionally define filters using filterModel to number only specific rows 3. Optionally specify sort order using sortModel to control the numbering sequenceInput Parameters
Output
Create Dataset View
Create Dataset View
GIGASHEET_CREATE_DATASET_VIEWTool to create a new view for a Gigasheet dataset with a specified name and client state version. Use when you need to save a specific dataset state as a named view for later reference.Input Parameters
Output
Explode JSON Column
Explode JSON Column
GIGASHEET_CREATE_EXPLODE_JSONExplode JSON data in a Gigasheet dataset column into separate columns. Optionally select JSON keys and row indices to process.Input Parameters
Output
Create File Aggregation
Create File Aggregation
GIGASHEET_CREATE_FILE_AGGREGATIONTool to retrieve ungrouped aggregated values for a Gigasheet file. Returns aggregated data as specified in the request payload, including support for pivot mode, filtering, sorting, and various aggregation functions. Use when you need to compute summary statistics across columns without grouping by specific keys.Input Parameters
Output
Create Blank File
Create Blank File
Create Files Directory
Create Files Directory
Create Cross-File Lookup
Create Cross-File Lookup
GIGASHEET_CREATE_LOOKUPCreates a cross-file lookup to enrich data by matching values between two sheets. Use when you need to pull related data from a reference sheet into your source sheet based on matching column values. This is similar to VLOOKUP in Excel. Before using this tool: 1. Obtain valid handles for both the source and reference datasets 2. Identify the column IDs (A, B, C, etc.) in both sheets using GIGASHEET_GET_DATASET_HANDLE_COLUMNS 3. Ensure the columns you’re matching have compatible data types The lookup will create a new column in the source sheet with values from the reference sheet where matches are found.Input Parameters
Output
Send MCP Request to Sheet Assistant
Send MCP Request to Sheet Assistant
GIGASHEET_CREATE_MCPTool to interact with Gigasheet Sheet Assistant via the Model Context Protocol (MCP) over HTTP. Use when you need to query or manipulate sheet data through MCP-compatible LLM tools. This endpoint implements JSON-RPC 2.0 protocol and supports MCP methods like ‘tools/list’ (to discover available tools) and ‘tools/call’ (to execute specific tools). The Sheet Assistant can perform operations like querying data, analyzing sheets, and other data manipulation tasks.Input Parameters
Output
Split Column
Split Column
GIGASHEET_CREATE_SPLIT_COLUMNTool to split a column into multiple columns based on a separator. Use when you need to divide column values into separate columns in a Gigasheet dataset.Input Parameters
Output
Delete Sheet Assistant Logs
Delete Sheet Assistant Logs
GIGASHEET_DELETE_AI_HANDLE_LOGSTool to delete Sheet Assistant chat history for a specific sheet. Use when you need to clear all AI assistant conversation logs associated with a sheet handle.Input Parameters
Output
Delete columns by name
Delete columns by name
GIGASHEET_DELETE_COLUMNS_BY_NAMETool to delete multiple columns from a Gigasheet dataset by their column names. Use when you need to remove specific columns from a sheet.Input Parameters
Output
Delete Connector Source
Delete Connector Source
GIGASHEET_DELETE_CONNECTORS_SOURCES_CONNECTORNAMETool to delete a connector source for the authenticated user. Use when you need to remove an integration connection such as Salesforce, S3, or Google Sheets from Gigasheet.Input Parameters
Output
Delete Dataset Comment
Delete Dataset Comment
GIGASHEET_DELETE_DATASET_COMMENTTool to delete a comment from a cell in a Gigasheet dataset. Use this when you need to remove a specific comment that was previously added to a cell. The comment ID can be obtained using the list comments action.Input Parameters
Output
Delete Rows Not Matching Filter
Delete Rows Not Matching Filter
GIGASHEET_DELETE_DATASET_DELETE_ROWS_NOT_MATCHING_FILTERDeletes rows in a Gigasheet dataset that do NOT match the specified filter criteria. Use this when you want to keep only the rows that match a filter and remove everything else. The filter uses Conjunctive Normal Form (CNF) where conditions can be combined with AND/OR logic.Input Parameters
Output
Delete Duplicated Rows from Dataset
Delete Duplicated Rows from Dataset
GIGASHEET_DELETE_DATASET_HANDLE_DEDUPLICATE_ROWSTool to delete duplicated rows from a Gigasheet dataset based on specified columns and sort model. Use when you need to remove duplicate entries identified by matching values in one or more columns. When multiple rows have identical values in the specified columns, the sort model determines which row to keep (if not specified, default sheet row order is used). Optionally apply a filter to deduplicate only a subset of rows.Input Parameters
Output
Delete Rows from Dataset
Delete Rows from Dataset
GIGASHEET_DELETE_DATASET_HANDLE_DELETE_ROWSTool to delete selected rows from a Gigasheet dataset. Use when you need to remove specific rows identified by their row IDs (iterator numbers). Row IDs are subject to change, so it’s best practice to obtain them immediately before deletion using a query or list action.Input Parameters
Output
Delete Rows Matching Filter
Delete Rows Matching Filter
GIGASHEET_DELETE_DATASET_HANDLE_DELETE_ROWS_MATCHING_FILTERTool to delete rows in a Gigasheet dataset that match a specified filter. Use when you need to remove specific rows based on filter criteria. The filterModel uses Conjunctive Normal Form (CNF) structure with column identifiers, filter values, and match conditions.Input Parameters
Output
Delete dataset view
Delete dataset view
GIGASHEET_DELETE_DATASET_HANDLE_VIEWS_VIEWTool to delete a specific view from a Gigasheet dataset. Use when you need to remove a saved view from a dataset. Requires both the dataset handle and the view handle to identify the view to delete.Input Parameters
Output
Delete sheet or folder by handle
Delete sheet or folder by handle
GIGASHEET_DELETE_DELETE_HANDLEDeletes a Gigasheet sheet or folder by its unique handle identifier. For sheets, this permanently removes the dataset. For folders, use recursive=True to delete the folder along with all its contents (sheets and subfolders), or omit/set to false to delete only empty folders. The handle can be obtained from sheet URLs or from create/upload operations.Input Parameters
Output
Delete column from sheet
Delete column from sheet
GIGASHEET_DELETE_FILES_COLUMNS_COLUMNTool to delete a single column from a Gigasheet sheet by its column identifier. Use when you need to permanently remove a specific column from a sheet.Input Parameters
Output
Delete Filter Template
Delete Filter Template
GIGASHEET_DELETE_FILTER_TEMPLATES_FILTER_HANDLETool to delete a saved filter template by its unique handle. Use when you need to remove a persisted filter configuration that is no longer needed.Input Parameters
Output
Delete multiple columns from file
Delete multiple columns from file
GIGASHEET_DELETE_MULTIPLE_COLUMNSTool to delete multiple columns from a Gigasheet file. Use when you need to remove specific columns from a sheet by their identifiers.Input Parameters
Output
Filter File Rows
Filter File Rows
GIGASHEET_FILTER_FILE_ROWSTool to retrieve rows from a Gigasheet file matching specified filter criteria. Use when you need to query or extract data from a sheet with optional filtering, sorting, and pagination. For basic filtering, only the filterModel field needs to be specified.Input Parameters
Output
Generate Dataset Description
Generate Dataset Description
GIGASHEET_GENERATE_DATASET_DESCRIPTIONGenerates an AI-powered description for a Gigasheet dataset. Use this when you need to automatically create a summary or description of a dataset’s content and structure based on its data.Input Parameters
Output
Get Sheet AI Chat History
Get Sheet AI Chat History
GIGASHEET_GET_AI_HANDLE_LOGSTool to retrieve AI chat history for a sheet. Returns up to 20 most recent messages exchanged with the sheet assistant. Use when you need to review previous AI interactions or understand the conversation context for a specific sheet.Input Parameters
Output
Get Cell Comments
Get Cell Comments
GIGASHEET_GET_CELL_COMMENTSTool to get comments for a specific cell in a Gigasheet dataset. Use when you need to retrieve comments that have been added to a particular cell at the intersection of a column and row.Input Parameters
Output
Get Client State Current Version
Get Client State Current Version
GIGASHEET_GET_CLIENT_STATE_CURRENT_VERSIONRetrieves the current client-state version and timestamp for a specified sheet. The version identifier is used when creating or updating views and saved states. Call this action after obtaining a sheet handle to get the latest version before performing state-related operations.Input Parameters
Output
Get Connector Connection Parameters
Get Connector Connection Parameters
GIGASHEET_GET_CONNECTOR_CONNECTION_PARAMSTool to get connection parameters for a specific connector. Use when you need to discover what parameters are required to set up a connector integration.Input Parameters
Output
Get Connector Connection Parameters
Get Connector Connection Parameters
GIGASHEET_GET_CONNECTORS_CONNECTION_PARAMS_CONNECTORNAMETool to retrieve connection parameters for a specific connector type. Use when you need to discover what parameters are required to configure a data source connection.Input Parameters
Output
Get Connector Connections
Get Connector Connections
Get Connector Sources
Get Connector Sources
Get Connector Source Parameters
Get Connector Source Parameters
GIGASHEET_GET_CONNECTORS_SOURCES_PARAMS_CONNECTORNAMETool to get parameters required for a specific connector source type. Use when configuring a data source connection to understand what information needs to be collected from the user.Input Parameters
Output
Get Dataset Column Comments
Get Dataset Column Comments
Get Dataset by Handle
Get Dataset by Handle
GIGASHEET_GET_DATASET_HANDLERetrieves comprehensive metadata for a specific dataset in Gigasheet. This tool fetches detailed information about a dataset including its processing status, file properties, column structure, owner information, and more. Use this after uploading a file or when you have a valid dataset handle to get its current state and schema. Common use cases: - Check if a dataset has finished processing (Status field) - Get column names and data types for the dataset - Retrieve file size, row count, and creation timestamps - Verify dataset ownership and accessInput Parameters
Output
Get Dataset Columns
Get Dataset Columns
Get Dataset Export Download URL
Get Dataset Export Download URL
Get Dataset Note
Get Dataset Note
GIGASHEET_GET_DATASET_HANDLE_NOTETool to retrieve a dataset’s note by handle. Use this to get AI-generated or user-provided descriptions of a dataset.Input Parameters
Output
Get Dataset Organization Permissions
Get Dataset Organization Permissions
GIGASHEET_GET_DATASET_HANDLE_ORGANIZATION_PERMISSIONSTool to retrieve organization file permissions for a dataset. Use when you need to check what permissions the requester’s organization has on a specific file. This action returns permissions only for the same organization that the requester is a member of. The permissions are returned as a list of integers representing different permission levels.Input Parameters
Output
Get Dataset Version Metadata
Get Dataset Version Metadata
GIGASHEET_GET_DATASET_HANDLE_VERSIONRetrieves metadata about a dataset at a specific version. Returns information including file name, column names and types, row count, modification timestamp, and processing status. Use this when you need to access historical versions of a dataset or verify dataset state at a particular point in time.Input Parameters
Output
Get Dataset Views
Get Dataset Views
Get Dataset Operation Status
Get Dataset Operation Status
GIGASHEET_GET_DATASET_OPERATION_STATUSTool to get information about the last operation on a dataset. Use when you need to check if a long-running operation (like import, export, or data transformation) has completed.Input Parameters
Output
Get Dataset Activity
Get Dataset Activity
GIGASHEET_GET_DATASETS_HANDLE_ACTIVITYTool to get the list of write actions on a given dataset sheet. Use this to retrieve the activity history and audit trail of modifications made to a dataset.Input Parameters
Output
Get Dataset View Metadata
Get Dataset View Metadata
GIGASHEET_GET_DATASET_VIEWSTool to retrieve view metadata for a specific view within a dataset. Use when you have both a dataset handle and a view handle to get detailed view information.Input Parameters
Output
Get Docs Formulas Functions
Get Docs Formulas Functions
Get Enrich Task Status
Get Enrich Task Status
GIGASHEET_GET_ENRICH_USER_DEFINED_HTTP_TASK_HANDLETool to get status for a user-defined HTTP enrichment task. Use when you need to check if an enrichment operation has completed or to monitor its progress.Input Parameters
Output
Apply Filter Template On Sheet
Apply Filter Template On Sheet
Get Filter Templates
Get Filter Templates
GIGASHEET_GET_FILTER_TEMPLATESRetrieves all saved filter templates from GigaSheet. Filter templates store reusable filter configurations that can be applied to datasets. Returns a list of templates with their IDs, names, owners, filter criteria, and timestamps. Supports optional pagination via the page parameter.Input Parameters
Output
Get Filter Template by Handle
Get Filter Template by Handle
GIGASHEET_GET_FILTER_TEMPLATES_FILTER_HANDLERetrieves details of a specific saved filter template by its unique handle. Use when you need to inspect a particular filter template’s configuration, metadata, or filter criteria.Input Parameters
Output
Generate New Handle
Generate New Handle
Get Library Files
Get Library Files
GIGASHEET_GET_LIBRARYTool to retrieve all datasets and files in the user’s Gigasheet library. Returns all datasets owned by the user at any folder depth, files directly shared with the user, and IDs of files the user has shared. Use this to get a complete overview of all accessible files and their metadata including status, sharing permissions, and file properties.Output
Get Library Files in Directory
Get Library Files in Directory
GIGASHEET_GET_LIBRARY_HANDLERetrieves all library files with file permissions in a given directory. Returns library files owned by the user making the request, limited to the requested directory level only (does not include nested files from deeper subdirectories).Input Parameters
Output
Get Library Home Page Files
Get Library Home Page Files
Get Library Path
Get Library Path
GIGASHEET_GET_LIBRARY_PATHTool to retrieve the chain of parent directories for a file or folder in Gigasheet. Returns the complete path hierarchy from root to the specified item, sorted by folder level. Use when you need to understand the location of a file or folder within the library structure.Input Parameters
Output
Get TICIntel NPI Public Profile
Get TICIntel NPI Public Profile
GIGASHEET_GET_TICINTEL_NPI_NPI_PUBLICTool to retrieve public NPI (National Provider Identifier) profile from TICIntel database. Use when you need comprehensive information about a healthcare provider including their specialty, location, procedures, payment rates, and TICIntel scoring data. The NPI must be a valid 10-digit number registered in the TICIntel database.Input Parameters
Output
Get TIC Intel States
Get TIC Intel States
List Cities by State
List Cities by State
GIGASHEET_GET_TICINTEL_STATES_STATE_CITIESTool to retrieve a list of cities for a given US state code from the TICIntel dataset. Use when you need to get all available cities within a specific state.Input Parameters
Output
List Providers by City
List Providers by City
GIGASHEET_GET_TICINTEL_STATES_STATE_CITIES_CITY_PROVIDERSTool to retrieve a list of healthcare providers in a specific city and state from the TicIntel dataset. Use when you need to find providers by geographic location.Input Parameters
Output
Get User Details
Get User Details
Get User Enrichment Credits
Get User Enrichment Credits
Get User Metadata
Get User Metadata
Get User Autofill Suggestions
Get User Autofill Suggestions
GIGASHEET_GET_USERS_AUTOFILLRetrieves autofill suggestions for the authenticated user, including team members and previously used share recipients. Useful for autocomplete functionality when sharing files or collaborating with team members.Input Parameters
Output
Get User Space Used
Get User Space Used
Get Authenticated User Info
Get Authenticated User Info
List Billing Plans
List Billing Plans
List Dataset Comments
List Dataset Comments
List All Datasets
List All Datasets
GIGASHEET_LIST_DATASETSRetrieve datasets owned by the user at any folder depth, optionally filtering by type (sheet or export). Returns selected dataset metadata; other fields are omitted, and the API may also trim fields.Input Parameters
Output
List Datasets by Handle
List Datasets by Handle
GIGASHEET_LIST_DATASETS_BY_HANDLETool to list files and datasets in a given Gigasheet location. Use when you need to browse the contents of a parent dataset or folder, optionally filtering by type (sheet or export). Supports pagination for large result sets. Returns metadata about each file including handle, name, size, status, and timestamps.Input Parameters
Output
List Library Exports
List Library Exports
Move file or folder to directory
Move file or folder to directory
GIGASHEET_MOVE_FILE_DIRECTORYTool to move a file or folder into a folder or to the root of your Library. Use when organizing your Gigasheet workspace. The destination folder must already exist, and creating directory loops is forbidden.Input Parameters
Output
Update User Metadata
Update User Metadata
GIGASHEET_PATCH_USER_METADATATool to update user metadata in Gigasheet. Use this to modify user-level settings such as billing integration (Chargebee ID), feature flags (pre-analysis), and onboarding state. At least one field must be provided to perform the update.Input Parameters
Output
Generate AI Formula
Generate AI Formula
GIGASHEET_POST_AI_HANDLE_FORMULATETool to generate Excel-style formulas using AI based on natural language queries. Use when you need to create formulas for data transformation, calculation, or extraction on a Gigasheet dataset. This action is available for sheets where you have read permissions. Provide a natural language description of the operation you want to perform, and the AI will generate the appropriate formula syntax that can be applied to your sheet data.Input Parameters
Output
Cast Column Data Type
Cast Column Data Type
GIGASHEET_POST_CAST_COLUMN_HANDLE_COLUMNTool to change a column’s data type in a Gigasheet dataset. Use when you need to convert column data from one type to another (e.g., string to number, text to IP address). The operation is asynchronous and returns a success acknowledgment.Input Parameters
Output
Change Column Case
Change Column Case
GIGASHEET_POST_CHANGE_CASE_HANDLE_COLTool to change the case of a column to Uppercase, Lowercase, Capitalized, or Proper. Use when you need to standardize text formatting in a column for consistency or data processing requirements.Input Parameters
Output
Clean Company Name
Clean Company Name
GIGASHEET_POST_CLEAN_COMPANY_NAME_HANDLE_COLTool to clean company names by stripping common business suffixes (Inc., LLC, Corp., etc.). Use when standardizing company names to avoid duplicates. Currently works only on English-alphabet versions of names.Input Parameters
Output
Combine Columns
Combine Columns
Append Rows to Sheet by Name
Append Rows to Sheet by Name
GIGASHEET_POST_DATASET_HANDLE_APPEND_BY_NAMEAppends one or more rows to a Gigasheet dataset using column names as keys. This tool adds new rows to an existing dataset by matching the keys in each record to the column names in the sheet. Column names must match exactly (case-sensitive). You can provide partial records (only some columns), and missing columns will be left empty. Before using this tool: 1. Obtain a valid dataset handle (e.g., using GIGASHEET_POST_UPLOAD_URL or GIGASHEET_GET_DATASET_HANDLE) 2. Retrieve column names using GIGASHEET_GET_DATASET_HANDLE_COLUMNS to ensure you use correct names The API will return an error if the handle is invalid or column names don’t match.Input Parameters
Output
Generate Dataset Assistant Tips
Generate Dataset Assistant Tips
GIGASHEET_POST_DATASET_HANDLE_ASSISTANT_TIPSTool to generate AI-powered tips for analyzing a dataset. Use when you need suggestions for data analysis or exploration. This action generates intelligent recommendations based on the dataset structure and content to help users discover insights and perform meaningful analyses.Input Parameters
Output
Initiate Dataset Export
Initiate Dataset Export
GIGASHEET_POST_DATASET_HANDLE_EXPORTInitiates an asynchronous export job for a Gigasheet dataset. Returns an export job handle that can be used with the download export endpoint to retrieve the exported file once processing completes. Use this action when you need to: - Export a complete dataset to CSV format - Export a filtered subset of data by applying column filters - Create downloadable data snapshots for sharing or backup The export process is asynchronous - this action queues the job and returns immediately with a handle. Use the GET /dataset/{handle}/download-export endpoint to poll the export status and download the file when ready. Example usage: 1. Export entire dataset: {“handle”: “9f60b220_8716_49eb_ad53_a206f8aaa0bf”} 2. Export with filter: {“handle”: “9f60b220_8716_49eb_ad53_a206f8aaa0bf”, “gridState”: {“filterModel”: {“Year”: {“type”: “equals”, “filter”: “2023”}}}}Input Parameters
Output
Find and Replace in Dataset
Find and Replace in Dataset
GIGASHEET_POST_DATASET_HANDLE_FIND_AND_REPLACETool to find and replace values in specified columns of a Gigasheet dataset. Use when you need to update or clean data by replacing specific values across one or more columns. This action creates a new column with the replaced values (keeping the original column name) and renames the original column to ‘Original Values - [column name]’ for reference.Input Parameters
Output
Insert Blank Row in Dataset
Insert Blank Row in Dataset
Rename Columns to Unique
Rename Columns to Unique
Save Current View
Save Current View
GIGASHEET_POST_DATASET_HANDLE_SAVE_CURRENT_VIEWSaves the current view state of a Gigasheet dataset and returns a view handle. This operation captures the current layout, filters, sorts, column visibility, and other view settings of the dataset at the time of the call. The returned view handle can be used to reference this saved view state later. Use this after applying filters, sorts, or other transformations that you want to preserve.Input Parameters
Output
Select columns by name
Select columns by name
GIGASHEET_POST_DATASET_HANDLE_SELECT_COLUMNS_BY_NAMETool to select specific columns from a Gigasheet dataset by name, keeping only those columns in the specified order. Use when you need to reduce a dataset to only certain columns or reorder columns. All columns not specified will be deleted, but the row number column is always retained automatically.Input Parameters
Output
Extract Domain from URL Column
Extract Domain from URL Column
GIGASHEET_POST_EXTRACT_DOMAIN_HANDLE_COLTool to extract domain from a URL column in a Gigasheet dataset. Use when you need to parse URLs and extract just the domain portion (e.g., extracting ‘example.com’ from ‘https://www.example.com/path’).Input Parameters
Output
Filter File Rows by Column Name
Filter File Rows by Column Name
GIGASHEET_POST_FILE_HANDLE_FILTER_BY_NAMEFilter rows in a Gigasheet file by column names and return matching results. This endpoint uses column names directly (not column IDs) and supports text, number, and date filters. Use this when you need to query data with specific filter conditions and know the exact column names.Input Parameters
Output
Get Filtered Row Index
Get Filtered Row Index
GIGASHEET_POST_FILE_HANDLE_FILTER_SHEET_ROW_NRMaps an unfiltered row number to its position in the filtered result set. Returns the 1-based index of where a specific row appears after filters are applied, or 0 if the row is filtered out. Useful for locating specific rows when filters are active on a sheet.Input Parameters
Output
Filter File with Stream Progress
Filter File with Stream Progress
GIGASHEET_POST_FILE_HANDLE_FILTER_STREAM_PROGRESSFilter data from a Gigasheet file with pagination support. Returns the final filtered result and, when available, positive byte and row processing counts from progress events.Input Parameters
Output
Save Exported File
Save Exported File
GIGASHEET_POST_FILE_HANDLE_SAVE_EXPORTEDSaves a file state with applied filters and grouping to create an exported version. Returns a JSON response acknowledging if the save request was successful. Use this action when you need to persist filtered or grouped views of a dataset as a separate exported file. The operation is asynchronous and returns an export handle to track the job status.Input Parameters
Output
Combine Files by Name
Combine Files by Name
Export Gigasheet to S3
Export Gigasheet to S3
Import from S3
Import from S3
Request Access to File
Request Access to File
GIGASHEET_POST_REQUEST_ACCESS_HANDLETool to request access to a Gigasheet file. Use when you need permission to view or edit a file owned by another user.Input Parameters
Output
Request API Access
Request API Access
GIGASHEET_POST_REQUEST_API_ACCESSRequest API access by sending a notification to Gigasheet support team. This tool sends a notification email to Gigasheet support requesting API key access for the authenticated user. The Gigasheet team will review the request and provide an API key separately. This does NOT immediately return an API key. Use this when you need to initiate the process of obtaining API access credentials.Output
Trim Column Whitespace
Trim Column Whitespace
GIGASHEET_POST_TRIM_WHITESPACE_HANDLE_COLTool to trim leading and trailing whitespace from all values in a column. Use when you need to clean up text data and remove extra spaces for consistency and data quality.Input Parameters
Output
Unroll Delimited Column
Unroll Delimited Column
GIGASHEET_POST_UNROLL_DELIMITED_COLUMN_HANDLE_COLUMNTool to explode a column containing delimited data into multiple rows. Use after confirming dataset handle and target column.Input Parameters
Output
Upload Raw Data Direct
Upload Raw Data Direct
GIGASHEET_POST_UPLOAD_DIRECTTool to upload raw data directly to Gigasheet using byte array contents. Use when you have file data as bytes and want to create a new sheet or append to an existing one.Input Parameters
Output
Upload from URL
Upload from URL
Preview HTTP Enrichment
Preview HTTP Enrichment
GIGASHEET_PREVIEW_ENRICH_USER_DEFINED_HTTPTool to preview a generic HTTP enrichment on a Gigasheet dataset before executing it on all rows. This action tests the HTTP enrichment configuration by executing a small sample of requests and returning both successful results and any failures. Use this to validate your enrichment configuration (URL template, headers, output mappings) before running it on the entire dataset. The preview shows: - Sample successful API responses with extracted values - Sample failed requests with error details - Execution time for performance estimation - Response type validation This is essential for debugging enrichment configurations and avoiding costly mistakes on large datasets.Input Parameters
Output
Set Dataset Client State Version
Set Dataset Client State Version
GIGASHEET_PUT_DATASET_HANDLE_CLIENTSTATE_VERSIONApplies or restores a specific client state version to a dataset. Client state includes view settings like filters, sorts, visible columns, and aggregations. Use this to restore a previously saved state or apply a specific version after making changes to the dataset.Input Parameters
Output
Update cell by column name and row
Update cell by column name and row
Create/Update Filter Template
Create/Update Filter Template
GIGASHEET_PUT_FILTER_TEMPLATES_FILTER_HANDLETool to create or update a saved filter template. Use when you need to persist or modify filter criteria by providing a filter handle and the filter model.Input Parameters
_cnf_ array of OR groups.Output
Rename Columns by Name
Rename Columns by Name
GIGASHEET_RENAME_COLUMNS_BY_NAMETool to rename columns in a Gigasheet dataset using their current names. Use when you need to update column names to more descriptive or standardized values.Input Parameters
Output
Rename File
Rename File
GIGASHEET_RENAME_FILETool to rename a file in Gigasheet. Use when you need to change the display name of a sheet.Input Parameters
Output
Reset Client State to Default
Reset Client State to Default
GIGASHEET_RESET_CLIENT_STATEResets the client state of a sheet to the default state. This clears all view customizations including filters, sorts, visible columns, and aggregations, returning the sheet to its original default view. Use this when you need to remove all applied customizations and restore the initial state.Input Parameters
Output
Reset User Password
Reset User Password
Search Dataset Activity
Search Dataset Activity
GIGASHEET_SEARCH_DATASETS_ACTIVITYTool to search the history of write actions performed on a Gigasheet dataset. Use when you need to audit changes, track user activity, or review the modification history of a dataset. Returns a paginated list of activity entries including user information, timestamps, and action details. Supports filtering by action type, category, user, time range, and freeform search queries. All filter criteria are AND-ed together, while multiple values within a filter field are OR-ed.Input Parameters
Output
Search Library
Search Library
GIGASHEET_SEARCH_LIBRARYTool to search through the Gigasheet file library by file metadata. Use when you need to find files by owner name, file name, column headers, or notes. By default searches across owner, file_name, headers, and note fields. You can optionally specify which metadata fields to search through. This does not search within file contents - only metadata.Input Parameters
Output
Send Invite Emails
Send Invite Emails
Set Aggregate Filter Model
Set Aggregate Filter Model
GIGASHEET_SET_CLIENT_STATE_AGGREGATE_FILTER_MODELTool to set the aggregate filter model in the client state of a sheet. Use this to apply aggregate filtering to your data view by providing the sheet handle and the filter model object.Input Parameters
Output
Set Client State Aggregations
Set Client State Aggregations
GIGASHEET_SET_CLIENT_STATE_AGGREGATIONSSets aggregations in the client state of a sheet. Aggregations allow you to compute summary statistics (sum, count, average, min, max, etc.) across columns in your dataset. Use this action to define which columns should display aggregated values and what type of calculation to apply. The aggregations are stored in the sheet’s client state and will be visible when viewing the sheet.Input Parameters
Output
Set Client State Column State
Set Client State Column State
GIGASHEET_SET_CLIENT_STATE_COLUMN_STATETool to set column state in the client state of a sheet. Use to configure column widths, sort order, visibility, pinning, and aggregations. This updates the visual layout and behavior of columns in the grid view.Input Parameters
Output
Set Client State Filter Model
Set Client State Filter Model
GIGASHEET_SET_CLIENT_STATE_FILTER_MODELTool to set the filter model in the client state of a sheet. Use when you need to apply or update filter conditions to a dataset’s view state. Pass an empty object to clear all filters.Input Parameters
Output
Set Client State Group Columns
Set Client State Group Columns
GIGASHEET_SET_CLIENT_STATE_GROUP_COLUMNSTool to set group columns in the client state of a sheet. Use this to configure which columns are used for grouping data in the sheet view. Column IDs must be letter-based (A, B, C) not numeric.Input Parameters
Output
Set Client State Sort Model
Set Client State Sort Model
GIGASHEET_SET_CLIENT_STATE_SORT_MODELSets the sort model for a sheet’s client state. Use this to programmatically sort data by one or more columns in ascending or descending order. The sort model persists as part of the sheet’s view state and can be retrieved later.Input Parameters
Output
Set Client State Visible Columns
Set Client State Visible Columns
GIGASHEET_SET_CLIENT_STATE_VISIBLE_COLUMNSTool to set visible columns in the client state of a sheet. Use when you want to control which columns are displayed in the sheet view. If columnIds is empty, all columns will be shown.Input Parameters
Output
Set Dataset Client State
Set Dataset Client State
GIGASHEET_SET_DATASET_CLIENTSTATESets the client state of a dataset using a state object. Client state includes view settings like filters, sorts, visible columns, and aggregations. Use this to apply custom view configurations to a dataset programmatically.Input Parameters
Output
Set Dataset Column Currency
Set Dataset Column Currency
GIGASHEET_SET_DATASET_COLUMN_CURRENCYTool to set currency format for a dataset column. Use when you need to format numeric data as currency with specific currency codes.Input Parameters
Output
Set Dataset Note
Set Dataset Note
GIGASHEET_SET_DATASET_NOTETool to set or update a note on a dataset in Gigasheet. Use this to add descriptive text, context, or metadata to a dataset for documentation purposes. The note can be up to 20,000 characters long and will be visible when retrieving the dataset metadata.Input Parameters
Output
Update Dataset Cell
Update Dataset Cell
GIGASHEET_UPDATE_DATASET_CELLTool to update a single cell value in a Gigasheet dataset by column letter and row number. Use after dataset is loaded and when you know the specific column letter (A, B, C, etc.) and row number to update.Input Parameters
Output
Update Dataset View
Update Dataset View
Upsert Rows in Dataset
Upsert Rows in Dataset
GIGASHEET_UPSERT_ROWSTool to upsert rows in an existing Gigasheet dataset. Use when you need to insert or update multiple rows of data starting from a specific column and row position. Overlapping cells will be overwritten with the new values.Input Parameters
Output
Validate Dataset Formula
Validate Dataset Formula
GIGASHEET_VALIDATE_DATASET_FORMULATool to validate a formula expression against a dataset. Use when you need to check if a formula is syntactically correct and can be applied to the dataset before executing it.Input Parameters
Output
Validate Files Combine
Validate Files Combine
GIGASHEET_VALIDATE_FILES_COMBINETool to validate a combine files request and return all errors that might appear. Use when you need to check if files can be combined before executing the actual combine operation.