# Gigasheet

Gigasheet is a big data automation platform that offers a spreadsheet-like interface for analyzing and managing large datasets, enabling users to automate tasks, integrate with various data sources, and streamline data workflows.

- **Category:** spreadsheets
- **Auth:** API_KEY
- **Composio Managed App Available?** N/A
- **Tools:** 152
- **Triggers:** 0
- **Slug:** `GIGASHEET`
- **Version:** 20260312_00

## Tools

### Append Rows to Dataset

**Slug:** `GIGASHEET_APPEND_DATASET`

Appends 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the Gigasheet dataset to append rows to. Example: 'f2ce9f7d_f429_402a_b0a0_5e5587feb608' |
| `records` | array | Yes | List of record objects to append as new rows. Each record is a dictionary where keys are column letters (A, B, C, etc.) and values are the cell data. Note: Column A is typically reserved for row numbers in Gigasheet. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Append Sheet from Another Sheet

**Slug:** `GIGASHEET_APPEND_DATASET_FROM_SHEET`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the target sheet to append data to. Example: 'f2ce9f7d_f429_402a_b0a0_5e5587feb608' |
| `from_handle` | string | Yes | Unique identifier (handle) of the source sheet to append data from. Example: 'a5f49fe7_dde2_45b3_96d9_1338ebf21904' |
| `case_insensitive` | boolean | No | Whether to ignore letter case in column names when matching columns between sheets. |
| `trim_column_names` | boolean | No | Whether to ignore leading and trailing spaces in column names when matching columns between sheets. |
| `add_unmatched_columns` | boolean | No | Whether to add any unmatched source sheet columns as new columns in the target sheet. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Apply HTTP Enrichment

**Slug:** `GIGASHEET_APPLY_USER_DEFINED_HTTP_ENRICHMENT`

Tool to apply generic HTTP enrichment to a Gigasheet dataset. Use when you need to enrich dataset rows by calling external APIs and adding the response data as new columns. This action creates an enrichment job that calls a specified HTTP endpoint for each row (or batch of rows) in your dataset, extracts data from the API responses using JSON paths, and creates new columns with the enriched data. The operation is asynchronous and returns a job handle for monitoring progress. Common use cases: - Enrich customer records by calling a CRM API - Validate email addresses using a validation service - Lookup product details from an external catalog - Geocode addresses using a mapping API - Fetch social media profiles for contact enrichment

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `bulk` | object | No | Bulk enrichment configuration. |
| `handle` | string | Yes | Sheet (dataset) handle identifier. Must be a valid dataset handle obtained from upload or dataset operations. |
| `method` | string | Yes | HTTP request method to use for enrichment. Must be one of: GET, POST, PUT, PATCH. |
| `columns` | array | Yes | List of columns with data used in enrichment requests. These columns can be referenced in url_template and body_template using their Id values. |
| `headers` | object | No | HTTP headers to include in enrichment requests (e.g., authentication, content-type). Do not include the X-GIGASHEET-TOKEN header as it's handled automatically. |
| `recipe_id` | string | No | Gigasheet recipe ID to associate with this enrichment (optional). |
| `sort_model` | array | No | Sort models to apply to the dataset before enrichment. |
| `filter_model` | object | No | Filter model to apply to the dataset before enrichment. Only rows matching the filter will be enriched. |
| `url_template` | string | Yes | URL template string for the enrichment API endpoint. Can include column ID placeholders (e.g., {A}, {B}) that will be replaced with actual values from each row. |
| `LaxValidation` | boolean | No | Internal flag to skip live DNS validation (for testing against local servers). Not recommended for production use. |
| `body_template` | string | No | Request body template string for POST/PUT/PATCH requests. Can include column ID placeholders (e.g., {A}, {B}) that will be replaced with actual values from each row. |
| `response_type` | string | No | Expected response type from the API. One of 'json', 'raw', 'unknown'. Default is 'json'. |
| `output_path_map` | array | Yes | List of mappings that specify how to extract data from the API response and create new columns. Each mapping defines a column name and JSON path to extract the value. |
| `retry_properties` | object | No | Retry configuration for failed requests. |
| `body_escape_format` | string | No | Escape format for body template. One of 'json', 'none'. Default is 'none'. |
| `email_on_completion` | array | No | List of email addresses to notify when the enrichment operation completes. |
| `maximum_requests_per_second` | number | No | Maximum number of API requests to make per second (rate limiting). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Calculate Enrich Expected Credits

**Slug:** `GIGASHEET_CALCULATE_ENRICH_EXPECTED_CREDITS`

Calculate 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 operations

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `colIds` | array | No | List of column identifiers to be used in the enrichment. Each column ID represents a column in the dataset (e.g., ['A', 'B', 'C']). If omitted, calculates credits for all applicable columns. |
| `handle` | string | Yes | Unique identifier (handle) of the user-defined HTTP enrichment. This is the enrichment configuration handle, not the dataset handle. Format: lowercase letters a-f, numbers, and underscores (e.g., 'cfd53422_4516_42e9_bb92_91cec8af8ff8'). |
| `filterModel` | object | No | Filter model to apply before calculating credits. Each key is a column name, and the value defines the filter condition. Only rows matching the filter will be counted for credit calculation. If omitted, calculates credits for all rows. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Cancel HTTP Enrichment Task

**Slug:** `GIGASHEET_CANCEL_ENRICH_USER_DEFINED_HTTP_TASK`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `task_handle` | string | Yes | Unique identifier (handle) of the enrichment task to cancel. This is returned when you create an enrichment job using the apply enrichment endpoint. Format: lowercase letters a-f, numbers, and underscores separated by underscores (e.g., 'cfd53422_4516_42e9_bb92_91cec8af8ff8'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Check Connector Source Availability

**Slug:** `GIGASHEET_CHECK_CONNECTORS_SOURCES_CONNECTORNAME`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `connector_name` | string | Yes | Integration to check source for (e.g., 'snowflake', 'salesforce', 'bigquery') |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Combine Files

**Slug:** `GIGASHEET_COMBINE_FILES`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handles` | array | Yes | List of file handles to combine. Column names and types must match across all files. |
| `inPlace` | boolean | No | If set to true, appends rows from all other sheets to the first sheet in the list instead of creating a new file. |
| `fileName` | string | No | Name for the newly combined file. If not provided, a default name will be assigned. |
| `folderHandle` | string | No | Handle of the folder where the combined file should be stored. |
| `addInputFilename` | boolean | No | If set to true, adds an extra column containing the input filename for each row. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Copy File

**Slug:** `GIGASHEET_COPY_FILE`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `state` | object | No | Optional state object to preserve specific sheet state (filters, views, etc.) in the copy. |
| `handle` | string | Yes | Handle of the sheet you want to copy into your library. This is the unique identifier of the source file to be copied. |
| `fileName` | string | No | Name for the copied file. If not provided, a default name will be generated. |
| `recursive` | boolean | No | Whether to recursively copy nested items if the file is a folder or contains nested structures. |
| `folderHandle` | string | No | Handle of the destination folder where the copy should be placed. If not provided, the copy will be placed in the default location. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Count Dataset Deduplication Results

**Slug:** `GIGASHEET_COUNT_DATASET_DEDUPLICATE_ROWS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset to analyze for duplicates. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f46c012a_194f_47e5_a639_8ad8d290e491'). |
| `columns` | array | No | List of column IDs used for deduplication. Deduplication is performed based on unique tuples of values from the given columns. If not provided, all columns are used for comparison. |
| `sortModel` | array | No | Sorts to use when deduplicating. If not provided, default sheet row order will be used. This determines which duplicate rows are kept when multiple rows have the same values in the specified columns. |
| `filterModel` | object | No | Filter model to use when deduplicating. Only rows matching this filter will be deduplicated. All other rows will remain. Each key is a column name, and the value defines the filter condition. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Count Dataset Groups

**Slug:** `GIGASHEET_COUNT_DATASET_GROUPS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `endRow` | integer | No | Ending row index for pagination. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset to count groups in. Typically returned by upload or dataset operations. |
| `startRow` | integer | No | Starting row index for pagination. |
| `groupKeys` | array | No | List of group keys to filter by. Empty list means no filtering by group keys. |
| `pivotCols` | array | No | List of column configurations to use for pivoting, if pivot mode is enabled. |
| `pivotMode` | boolean | No | Whether to enable pivot mode for the count operation. |
| `sortModel` | array | No | Sort configuration for the groups being counted. |
| `valueCols` | array | No | List of value columns to aggregate when counting groups. |
| `FieldTypes` | array | No | List of field types if working with pivot mode. System checks type of field by example: int, float, string. |
| `filterModel` | object | No | Filter conditions to apply before counting groups. Keys are column names, values are filter specifications. |
| `rowGroupCols` | array | Yes | List of column configurations to use for row grouping. Each column defines how data should be grouped. |
| `AllowUnstableOrder` | boolean | No | Set to true to allow unstable result order for faster performance on large files. |
| `ungroupedAggregations` | array | No | List of aggregations to apply to ungrouped data. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Count Dataset Rows

**Slug:** `GIGASHEET_COUNT_DATASET_ROWS`

Counts 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-rows

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `endRow` | integer | No | Ending row index for pagination (exclusive). Use with startRow to count a specific range of rows. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset to count rows from. Format: lowercase letters a-f, numbers, and underscores (e.g., 'a5f49fe7_dde2_45b3_96d9_1338ebf21904'). |
| `startRow` | integer | No | Starting row index for pagination (0-based). Use with endRow to count a specific range of rows. |
| `groupKeys` | array | No | Array of group keys for hierarchical grouping. Used to drill down into specific groups when counting. |
| `pivotCols` | array | No | List of columns to use as pivot columns in pivot mode. These columns become the new column headers in the pivot table. |
| `pivotMode` | boolean | No | Enable pivot mode for counting. When true, enables pivot table functionality with grouping and aggregation. |
| `sortModel` | array | No | List of sort specifications to apply before counting. Each specification defines a column and sort direction. |
| `valueCols` | array | No | List of value columns for aggregation in pivot mode. Defines which columns to aggregate and how. |
| `FieldTypes` | array | No | List of field types (e.g., 'int', 'float', 'string') for type checking in pivot mode. System uses these to validate field types during operations. |
| `filterModel` | object | No | Filter model specifying which rows to include in the count. Each key is a column name, and the value defines the filter condition (e.g., {'Status': {'type': 'equals', 'filter': 'Active'}}). See Gigasheet Filter Model documentation for detailed filter syntax. |
| `rowGroupCols` | array | No | List of columns to group by when counting rows. Used to create row groupings in pivot mode. |
| `AllowUnstableOrder` | boolean | No | Allow unstable result ordering for better performance on large datasets. When true, the API may return results in a non-deterministic order to optimize query speed. |
| `ungroupedAggregations` | array | No | List of aggregations to compute on ungrouped data. Applied when not using row grouping. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Count Dataset Activities

**Slug:** `GIGASHEET_COUNT_DATASETS_ACTIVITY_COUNT`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `End` | string | No | End timestamp for the activity time range filter. Only activities before this time will be counted. Combines with Start for range filtering. |
| `Page` | integer | No | Page number for pagination (0-based). Used when counting paginated activity results. |
| `Query` | string | No | Freeform search query to filter activities. Searches across activity fields like action names, user emails, and descriptions. |
| `Start` | string | No | Start timestamp for the activity time range filter. Only activities after this time will be counted. Combines with End for range filtering. |
| `Users` | array | No | Filter by user emails. If provided, only activities performed by these users will be counted. Multiple users are OR-ed together. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset to get activity count for. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f46c012a_194f_47e5_a639_8ad8d290e491'). |
| `Actions` | array | No | Filter by specific action names. If provided, only activities matching these action names will be counted. Multiple actions are OR-ed together. |
| `PageSize` | integer | No | Number of activities per page for pagination. Default is 100. |
| `Categories` | array | No | Filter by activity categories. If provided, only activities in these categories will be counted. Multiple categories are OR-ed together. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create AI Chat Query

**Slug:** `GIGASHEET_CREATE_AI_CHAT`

AI 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `Query` | string | Yes | Natural language question or instruction to ask the AI assistant about the sheet data. Examples: 'What data is in this sheet?', 'Summarize the key trends', 'What are the top 5 values?' |
| `handle` | string | Yes | Unique identifier (handle) of the sheet to analyze. This must be a sheet where you have write permissions. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f2ce9f7d_f429_402a_b0a0_5e5587feb608'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create Dataset Column Comment

**Slug:** `GIGASHEET_CREATE_DATASET_COLUMN_COMMENT`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `column` | string | Yes | Column identifier where the comment should be added. Use column letters like 'A', 'B', 'C', etc. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset where the comment should be added. Example: 'f46c012a_194f_47e5_a639_8ad8d290e491' |
| `comment` | string | Yes | The comment text to add to the column. |
| `tagged_emails` | array | No | List of email addresses to notify about this comment. |
| `share_with_tagged_emails` | boolean | No | Whether to share the comment with users specified in tagged_emails. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Add Comment to Cell

**Slug:** `GIGASHEET_CREATE_DATASET_COMMENT`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `row` | integer | Yes | Row number where the comment will be attached. Row numbers start from 1. |
| `column` | string | Yes | Column identifier (letter) where the comment will be attached. Example: 'A', 'B', 'C', etc. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset where the comment will be added. |
| `comment` | string | Yes | Text content of the comment to be added to the cell. |
| `tagged_emails` | array | No | List of email addresses to tag in the comment and optionally notify. |
| `share_with_tagged_emails` | boolean | No | Whether to share the comment with tagged email addresses. If true, emails in tagged_emails will receive notifications. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create Conditional Label Column

**Slug:** `GIGASHEET_CREATE_DATASET_CONDITIONAL_LABEL_COLUMN`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `cases` | array | Yes | List of conditional cases. Each case contains a filterModel and corresponding label. Cases are evaluated in order; first matching case determines the label for each row. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset to which the label column should be added. Format: lowercase letters a-f, numbers, and underscores (e.g., 'a5f49fe7_dde2_45b3_96d9_1338ebf21904'). |
| `defaultLabel` | string | No | Default label to apply to rows that don't match any case. If not specified, rows not matching any case may remain unlabeled. |
| `outputColumn` | string | Yes | Name for the new label column to be created in the dataset. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create Formula Column

**Slug:** `GIGASHEET_CREATE_DATASET_FORMULA`

Tool 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 needs

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset to which the formula column should be added. Example: 'f2ce9f7d_f429_402a_b0a0_5e5587feb608' |
| `formula` | string | No | Formula expression using column letters (e.g., 'G * 2', 'A + B'). Use column letters like 'A', 'B', 'C' to reference columns. This field is required if you want to create a formula column. |
| `columnName` | string | Yes | Name for the new formula column that will be created in the dataset. |
| `afterColumnId` | string | No | Column identifier after which to insert the new formula column. If not specified, the column will be appended at the end. |
| `literalFormula` | string | No | Human-readable formula using actual column names for documentation purposes (e.g., 'Price * 2'). This should be provided alongside 'formula' for better readability. Cannot be used alone without 'formula'. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Edit Formula Column

**Slug:** `GIGASHEET_CREATE_DATASET_FORMULA_EDIT`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `column` | string | Yes | Column identifier or name of the existing formula column to edit. This can be a column letter (e.g., 'J', 'K') or column name. The column must already exist and be a formula column. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset containing the formula column to edit. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f2ce9f7d_f429_402a_b0a0_5e5587feb608'). |
| `formula` | string | No | New formula expression using column letters (e.g., 'G * 3', 'A + B'). This is the formula that will be applied to the column. Must be a valid Gigasheet formula expression. |
| `columnName` | string | No | New name for the formula column. If not provided, the column name remains unchanged. |
| `afterColumnId` | string | No | Column ID after which to position the edited formula column. If not provided, the column position remains unchanged. |
| `literalFormula` | string | No | Human-readable formula using actual column names instead of letters (e.g., 'Price * 3', 'Quantity * Rate'). This provides better readability and documentation of the formula logic. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create Formula Preview

**Slug:** `GIGASHEET_CREATE_DATASET_FORMULA_PREVIEW`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset on which to compute the formula preview. This is typically returned by file upload actions or dataset creation operations. Format: lowercase letters a-f, numbers, and underscores. |
| `formula` | string | Yes | Formula expression to calculate on the dataset. Can reference columns using column names (e.g., 'A * 2', 'E * 2', 'Price + Tax'). The formula will be evaluated and sample results returned with involved column values. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create Iterator Column

**Slug:** `GIGASHEET_CREATE_DATASET_ITERATOR_COLUMN`

Tool 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 sequence

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset to which the iterator column should be added. Example: 'f2ce9f7d_f429_402a_b0a0_5e5587feb608' |
| `sortModel` | array | No | List of sort specifications to apply before numbering rows. The iterator column will respect this sort order, numbering rows in the sorted sequence. If not provided, rows will be numbered in their current order. |
| `columnName` | string | Yes | Name for the new iterator column that will be created. This column will contain sequential row numbers based on the current filters and sort order. |
| `filterModel` | object | No | Filter model specifying which rows to include in the iterator numbering. Each key is a column name, and the value defines the filter condition. Only rows matching the filter will be numbered sequentially. If not provided, all rows will be numbered. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create Dataset Liveshare

**Slug:** `GIGASHEET_CREATE_DATASET_LIVESHARE`

Tool to create a new liveshare for a Gigasheet dataset. Returns a share ID and URL for accessing the current CSV data in the sheet. Use when you need to generate a shareable link that provides live access to dataset content.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset for which to create a liveshare. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f2ce9f7d_f429_402a_b0a0_5e5587feb608'). |
| `client_state_version_id` | string | No | Optional client state version ID for the sheet to share. If not specified, the live share will point to the latest view of the creator of the live share. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create Dataset View

**Slug:** `GIGASHEET_CREATE_DATASET_VIEW`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `name` | string | Yes | Name for the new view. This is the display name that will be shown in the UI. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset for which to create a view. Format: lowercase letters a-f, numbers, and underscores (e.g., 'a5f49fe7_dde2_45b3_96d9_1338ebf21904'). |
| `client_state_id` | string | Yes | Client state version ID to use as the basis for this view. This defines the filters, sorts, and other view settings to capture. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Explode JSON Column

**Slug:** `GIGASHEET_CREATE_EXPLODE_JSON`

Tool to explode JSON data in a column into separate columns. Extracts all keys from JSON objects and creates a new column for each key. Use when you need to flatten nested JSON data in a Gigasheet dataset.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `keys` | array | No | Optional list of JSON keys to extract from the column. If not provided, the API will automatically extract the most common keys (up to 2000). Use this to specify exactly which keys to explode into separate columns. |
| `column` | string | Yes | Column ID or name of the column containing JSON data to explode. This is the column whose JSON values will be extracted into separate columns. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset/sheet containing the JSON column. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., 'cfd53422_4516_42e9_bb92_91cec8af8ff8'). |
| `indices` | array | No | Optional list of row indices to process. If not provided, all rows will be processed. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create File Aggregation

**Slug:** `GIGASHEET_CREATE_FILE_AGGREGATION`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `endRow` | integer | No | Ending row index for pagination. |
| `handle` | string | Yes | Unique identifier (handle) of the file/sheet to aggregate. Typically returned by upload or dataset operations. |
| `startRow` | integer | No | Starting row index for pagination. |
| `groupKeys` | array | No | List of group keys to filter by. Empty list means no filtering by group keys. |
| `pivotCols` | array | No | List of column configurations to use for pivoting, if pivot mode is enabled. |
| `pivotMode` | boolean | No | Whether to enable pivot mode for the aggregation operation. |
| `sortModel` | array | No | Sort configuration for the aggregation results. |
| `valueCols` | array | No | List of value columns to aggregate. |
| `FieldTypes` | array | No | List of field types if working with pivot mode. System checks type of field by example: int, float, string. |
| `filterModel` | object | No | Filter conditions to apply before aggregation. Keys are column names, values are filter specifications. |
| `rowGroupCols` | array | No | List of column configurations to use for row grouping. |
| `AllowUnstableOrder` | boolean | No | Set to true to allow unstable result order for faster performance on large files. |
| `ungroupedAggregations` | array | No | List of aggregations to apply to ungrouped data. Each aggregation specifies a field, aggregation function, and display name. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create Blank File

**Slug:** `GIGASHEET_CREATE_FILES_BLANK`

Tool to create an empty file in your Gigasheet Library. Use when you need a blank spreadsheet with a specified number of rows and columns.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `numCols` | integer | Yes | Number of empty columns to create in the blank file. |
| `numRows` | integer | Yes | Number of empty rows to create in the blank file. |
| `filename` | string | Yes | Name of the blank file to create (e.g., 'my_data.csv'). |
| `folderHandle` | string | No | Optional folder handle to place the file in a specific folder. |
| `uploadToTeam` | boolean | No | If true, upload the file to team workspace; otherwise to personal workspace. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create Files Directory

**Slug:** `GIGASHEET_CREATE_FILES_DIRECTORY`

Tool to create a new folder in your Gigasheet Library. Use when you need to organize datasets by creating a new directory for file storage.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `name` | string | Yes | Name of the folder to create in your Library. Must be unique within the parent directory. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create Cross-File Lookup

**Slug:** `GIGASHEET_CREATE_LOOKUP`

Creates 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `col` | string | Yes | Column ID in the source file to search for matching data (e.g., 'A', 'B', 'C'). Values in this column are matched against the reference file's column |
| `handle` | string | Yes | Unique identifier (handle) of the source Gigasheet dataset where the new lookup column will be added. Example: '749ff5b7_878c_41cc_9cd0_5092d345cd46' |
| `referenceFile` | object | Yes | Configuration object specifying the reference file and columns to use for the lookup operation |
| `matchConditions` | object | No | Configuration for matching behavior when performing cross-file lookups. |
| `returnAllMatches` | boolean | No | If true, returns all matching rows from the reference file. If false or omitted, returns only the first match |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Send MCP Request to Sheet Assistant

**Slug:** `GIGASHEET_CREATE_MCP`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `id` | string | Yes | Request identifier for JSON-RPC. Can be a number or string. |
| `method` | string | Yes | MCP method to call. Common values: 'tools/list' (list available tools), 'tools/call' (call a specific tool). |
| `params` | object | Yes | Parameters for the MCP method. For 'tools/list', include 'protocolVersion'. For 'tools/call', include tool name and arguments. |
| `jsonrpc` | string | Yes | JSON-RPC version, must be '2.0'. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Split Column

**Slug:** `GIGASHEET_CREATE_SPLIT_COLUMN`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `Column` | string | Yes | Column ID or name to split. This is typically a letter (e.g., 'A', 'B', 'C') or the column name. |
| `handle` | string | Yes | Handle of sheet containing the column to split. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., 'aa8359b8_3122_4d5d_956d_a6a99d4820d0'). |
| `Separator` | string | Yes | Character or string separator to split the column values by. Common separators include comma (','), space (' '), pipe ('\|'), or custom delimiters. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete Sheet Assistant Logs

**Slug:** `GIGASHEET_DELETE_AI_HANDLE_LOGS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique handle (identifier) of the sheet whose AI assistant logs should be deleted. This is typically found in the Gigasheet UI URL or returned from upload/create operations. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete columns by name

**Slug:** `GIGASHEET_DELETE_COLUMNS_BY_NAME`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the Gigasheet dataset to delete columns from. Example: 'a5f49fe7_dde2_45b3_96d9_1338ebf21904' |
| `column_names` | array | Yes | List of column names to delete from the dataset. Column names are case-sensitive and must exactly match the names in the sheet. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete Connector Source

**Slug:** `GIGASHEET_DELETE_CONNECTORS_SOURCES_CONNECTORNAME`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `connector_name` | string | Yes | Name of the integration/connector to delete (e.g., 'salesforce', 's3', 'google-sheets'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete Dataset Comment

**Slug:** `GIGASHEET_DELETE_DATASET_COMMENT`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `row` | integer | Yes | Row number where the comment is located. Must be a positive integer. |
| `column` | string | Yes | Column identifier where the comment is located. Use column letters like 'A', 'B', 'C', etc. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset containing the comment. Example: 'f46c012a_194f_47e5_a639_8ad8d290e491' |
| `comment` | string | Yes | Unique identifier of the comment to delete. This can be obtained from the list comments action. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete Rows Not Matching Filter

**Slug:** `GIGASHEET_DELETE_DATASET_DELETE_ROWS_NOT_MATCHING_FILTER`

Deletes 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset in which to delete rows. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. |
| `filterModel` | object | Yes | Filter specification using Conjunctive Normal Form (CNF). Rows that do NOT match this filter will be deleted. Structure: {'_cnf_': [[{filter1}, {filter2}], [{filter3}]]} where inner arrays use OR logic and outer arrays use AND logic. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete Duplicated Rows from Dataset

**Slug:** `GIGASHEET_DELETE_DATASET_HANDLE_DEDUPLICATE_ROWS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., 'a5f49fe7_dde2_45b3_96d9_1338ebf21904'). |
| `columns` | array | Yes | List of column identifiers used for deduplication. Deduplication is performed based on unique tuples of values from the given columns. Column identifiers are typically column letters (e.g., 'A', 'B') or column names. |
| `sortModel` | array | No | Sorts to use when deduplicating. If not provided, default sheet row order will be used. When multiple rows have the same values in the specified columns, the sort model determines which row to keep. |
| `filterModel` | object | No | Filter model to use when deduplicating. Only rows matching this filter will be deduplicated. All other rows will remain. This is an arbitrary JSON object that follows the Gigasheet Filter Model schema. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete Rows from Dataset

**Slug:** `GIGASHEET_DELETE_DATASET_HANDLE_DELETE_ROWS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `rows` | array | Yes | List of row IDs (iterator numbers) to delete. Row IDs are subject to change, so best practice is to obtain them immediately before deletion. Each ID should be a positive integer representing the row number. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., 'a5f49fe7_dde2_45b3_96d9_1338ebf21904'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete Rows Matching Filter

**Slug:** `GIGASHEET_DELETE_DATASET_HANDLE_DELETE_ROWS_MATCHING_FILTER`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique handle (identifier) of the dataset from which rows will be deleted. This is typically found in the Gigasheet UI URL or returned from upload/create operations. |
| `filterModel` | object | Yes | Filter model object in Conjunctive Normal Form (CNF) that defines which rows to delete. Structure: {'_cnf_': [[{filter_clause_1}, ...], ...]} where each clause includes 'colId' (column identifier), 'filter' (array of values to match), 'filterType' (e.g., 'text', 'number'), and 'type' (e.g., 'containsAny', 'equalsAny', 'greaterThan'). Example: {'_cnf_': [[{'colId': 'B', 'filter': ['test'], 'filterType': 'text', 'type': 'containsAny'}]]} |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete dataset view

**Slug:** `GIGASHEET_DELETE_DATASET_HANDLE_VIEWS_VIEW`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `view` | string | Yes | Unique identifier (handle) of the view to delete. View handles are returned from the list views operation or can be found in the view management interface. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset containing the view to delete. This is typically found in the Gigasheet UI URL or returned from dataset operations. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete dataset live share

**Slug:** `GIGASHEET_DELETE_DATASET_LIVESHARE_SHAREID`

Tool to delete a live share of a Gigasheet dataset. Use when you need to revoke or remove an existing live share link. The shareid is the unique identifier of the live share to be deleted.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `shareid` | string | Yes | Share ID of the live share to delete. This is the unique identifier of an existing live share that you want to remove. Format: lowercase letters a-f, numbers, and underscores (e.g., '88bd5adc_8f74_40ff_8978_156c463e8249'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete sheet or folder by handle

**Slug:** `GIGASHEET_DELETE_DELETE_HANDLE`

Deletes 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique handle (identifier) of the sheet or folder to delete. This is typically found in the Gigasheet UI URL or returned from upload/create operations. |
| `recursive` | boolean | No | If true, recursively deletes a folder and all its contents (sheets and subfolders). Only applicable when handle refers to a folder. If false or omitted, will only delete empty folders or individual sheets. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete column from sheet

**Slug:** `GIGASHEET_DELETE_FILES_COLUMNS_COLUMN`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `column` | string | Yes | Column identifier (ID) to delete from the sheet. This is typically a letter (A, B, C, etc.) or column ID. |
| `handle` | string | Yes | Unique identifier (handle) of the sheet from which to delete the column. Example: '1a666b27_b901_4b7f_ad44_7de5980be1c9' |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete Filter Template

**Slug:** `GIGASHEET_DELETE_FILTER_TEMPLATES_FILTER_HANDLE`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `filter_handle` | string | Yes | Unique identifier (UUID format with underscores) for the saved filter template to delete. This can be obtained from the GET /filter-templates endpoint. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete multiple columns from file

**Slug:** `GIGASHEET_DELETE_MULTIPLE_COLUMNS`

Tool to delete multiple columns from a Gigasheet file. Use when you need to remove specific columns from a sheet by their identifiers.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the Gigasheet file to delete columns from. Example: 'f0e39d54_f221_4559_b643_50c7b73a2e20' |
| `columnsToDelete` | array | Yes | List of column identifiers to delete from the file. Column identifiers are typically letters like 'A', 'B', 'C' for Excel-style columns or column names depending on the file format. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Filter File Rows

**Slug:** `GIGASHEET_FILTER_FILE_ROWS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `endRow` | integer | No | Ending row index for pagination (0-based, exclusive). Use with startRow to retrieve a specific range of rows. For example, startRow=0 and endRow=10 returns the first 10 rows. |
| `handle` | string | Yes | Unique identifier of the sheet/file to filter. Obtain from actions like POST_UPLOAD_URL or GET_DATASET_HANDLE. |
| `startRow` | integer | No | Starting row index for pagination (0-based). Use with endRow to retrieve a specific range of rows from the filtered result set. |
| `groupKeys` | array | No | Keys for grouping rows in pivot mode |
| `pivotCols` | array | No | Columns to use as pivot dimensions when pivotMode is enabled |
| `pivotMode` | boolean | No | Enable pivot mode for data aggregation and grouping |
| `sortModel` | array | No | Array of sort configurations to apply to the result set. Each item specifies a column and sort direction. |
| `valueCols` | array | No | Value columns to aggregate in pivot mode |
| `FieldTypes` | array | No | Field type information for pivot mode operations (e.g., int, float, string). The system uses this to determine correct type handling. |
| `filterModel` | object | No | Filter model object defining which rows to return. This is an arbitrary JSON object that follows the Gigasheet Filter Model schema. Use an empty object {} to return all rows without filters. For more details, see the Filter Model Detail Guide. |
| `rowGroupCols` | array | No | Columns to group rows by in pivot mode |
| `columnHighlights` | object | No | Column highlighting configurations mapped by column identifier |
| `AllowUnstableOrder` | boolean | No | Set to true to allow unstable result ordering for faster performance on large files. Results may be returned in non-deterministic order. |
| `ungroupedAggregations` | array | No | Aggregations to compute without grouping |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Generate Dataset Description

**Slug:** `GIGASHEET_GENERATE_DATASET_DESCRIPTION`

Generates 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset to generate a description for. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f2ce9f7d_f429_402a_b0a0_5e5587feb608'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Sheet AI Chat History

**Slug:** `GIGASHEET_GET_AI_HANDLE_LOGS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the sheet to get AI assistant history for. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f2ce9f7d_f429_402a_b0a0_5e5587feb608'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Cell Comments

**Slug:** `GIGASHEET_GET_CELL_COMMENTS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `row` | integer | Yes | Row number for the cell. Must be a positive integer. |
| `column` | string | Yes | Column identifier for the cell. Typically a letter like 'A', 'B', 'C', etc. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f46c012a_194f_47e5_a639_8ad8d290e491'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Client State Current Version

**Slug:** `GIGASHEET_GET_CLIENT_STATE_CURRENT_VERSION`

Retrieves 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the sheet whose client state version to retrieve. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Connector Connection Parameters

**Slug:** `GIGASHEET_GET_CONNECTOR_CONNECTION_PARAMS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `connector_name` | string | Yes | Name of the connector/integration to get connection parameters for (e.g., 'bigquery', 'snowflake', 'postgres') |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Connector Connection Parameters

**Slug:** `GIGASHEET_GET_CONNECTORS_CONNECTION_PARAMS_CONNECTORNAME`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `connector_name` | string | Yes | Name of the connector/integration to retrieve connection parameters for (e.g., 'bigquery', 'snowflake', 'postgres') |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Connector Connections

**Slug:** `GIGASHEET_GET_CONNECTORS_CONNECTIONS`

Tool to list connector connections. Use after setting a valid Gigasheet API token.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Connector Sources

**Slug:** `GIGASHEET_GET_CONNECTORS_SOURCES`

Tool to retrieve information about connected data sources for the user. Returns a list of data sources with their type, status, and folder location. Use after setting a valid Gigasheet API token.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Connector Source Parameters

**Slug:** `GIGASHEET_GET_CONNECTORS_SOURCES_PARAMS_CONNECTORNAME`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `connector_name` | string | Yes | Name of the connector/integration to get parameters for. Examples include: salesforce, snowflake, databricks, s3, bigquery, postgresql, mysql, etc. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Dataset Column Comments

**Slug:** `GIGASHEET_GET_DATASET_COLUMN_COMMENTS`

Tool to get comments for a specific column in a dataset sheet. Use when you need to retrieve comments that have been added to a particular column.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `column` | string | Yes | Column identifier (e.g., 'A', 'B', 'C') for which to retrieve comments. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset containing the column. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Dataset by Handle

**Slug:** `GIGASHEET_GET_DATASET_HANDLE`

Retrieves 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 access

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset to retrieve. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., '791b8d45_1b32_4ea1_816a_583174cac9d9'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Dataset Columns

**Slug:** `GIGASHEET_GET_DATASET_HANDLE_COLUMNS`

Tool to list all column metadata (IDs, names, types) for a dataset. Use after obtaining a dataset handle.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset whose columns to list. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Dataset Export Download URL

**Slug:** `GIGASHEET_GET_DATASET_HANDLE_DOWNLOAD_EXPORT`

Tool to retrieve the download URL for an exported dataset. Use after initiating an export and obtaining its handle.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Export handle returned by the Create Export endpoint (not the sheet handle). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Dataset Liveshare CSV

**Slug:** `GIGASHEET_GET_DATASET_HANDLE_LIVESHARE_SHAREID`

Tool to retrieve CSV data from a Gigasheet liveshare. Returns the current data in text CSV format. Use when you need to export or access shared dataset data via a liveshare link.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset to retrieve. Format: lowercase letters a-f, numbers, and underscores. |
| `shareid` | string | Yes | Share ID to get data for. This identifies the specific liveshare view of the dataset. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Dataset Note

**Slug:** `GIGASHEET_GET_DATASET_HANDLE_NOTE`

Tool to retrieve a dataset's note by handle. Use this to get AI-generated or user-provided descriptions of a dataset.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset whose note to retrieve. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f2ce9f7d_f429_402a_b0a0_5e5587feb608'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Dataset Organization Permissions

**Slug:** `GIGASHEET_GET_DATASET_HANDLE_ORGANIZATION_PERMISSIONS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset to retrieve organization permissions for. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., '06dc2c33_cb0e_42e5_83f8_ac24521a8de4'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Dataset Version Metadata

**Slug:** `GIGASHEET_GET_DATASET_HANDLE_VERSION`

Retrieves 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset to retrieve. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f46c012a_194f_47e5_a639_8ad8d290e491'). |
| `version` | string | Yes | Version identifier (UUID) of the dataset to retrieve. This is typically obtained from the Get Client State Current Version action or other version-tracking endpoints. Format: lowercase letters a-f, numbers, and underscores (e.g., '9dd01c22_a84d_4ce8_9ace_8c1d88f65f69'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Dataset Views

**Slug:** `GIGASHEET_GET_DATASET_HANDLE_VIEWS`

Tool to list all views associated with a specific dataset. Use after confirming the dataset handle and its status.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset for which to list views. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Dataset Operation Status

**Slug:** `GIGASHEET_GET_DATASET_OPERATION_STATUS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset to check operation status. This is the dataset handle returned by file upload or other dataset operations. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Dataset Activity

**Slug:** `GIGASHEET_GET_DATASETS_HANDLE_ACTIVITY`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `page` | string | No | Page of results to get. Used for pagination when there are many activity entries. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset for which to retrieve activity history. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. |
| `pageSize` | string | No | Number of results to get per page. Controls how many activity entries are returned in a single request. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Dataset View Metadata

**Slug:** `GIGASHEET_GET_DATASET_VIEWS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `view` | string | Yes | Unique identifier (handle) of the view to retrieve. Format: lowercase letters a-f, numbers, and underscores (e.g., '338e1cee_ca6d_4d48_bf36_93e15cbb8a15'). |
| `handle` | string | Yes | Unique identifier (handle) of the dataset. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f46c012a_194f_47e5_a639_8ad8d290e491'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Docs Formulas Functions

**Slug:** `GIGASHEET_GET_DOCS_FORMULAS_FUNCTIONS`

Tool to retrieve all supported formula functions. Use after authenticating with a valid API token.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `accept` | string | No | Accept header value to request response format |
| `flatten` | boolean | No | If true, attempt to coerce dictionary responses into a list of functions. Defaults to True since the API typically returns a dictionary. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Enrich Task Status

**Slug:** `GIGASHEET_GET_ENRICH_USER_DEFINED_HTTP_TASK_HANDLE`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `task_handle` | string | Yes | Unique identifier (handle) of the enrichment task to check. This is returned when applying a user-defined HTTP enrichment. Format: lowercase letters a-f, numbers, and underscores (e.g., '00000000_0000_0000_0000_000000000000'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Apply Filter Template On Sheet

**Slug:** `GIGASHEET_GET_FILTER_TEMPLATE_ON_SHEET`

Tool to fetch a saved filter template's model for a given sheet. Use when you need the exact filter structure for a specific sheet and template.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | The unique handle (ID) of the target sheet/dataset. |
| `filter_handle` | string | Yes | The unique handle (ID) of the saved filter template to apply. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Filter Templates

**Slug:** `GIGASHEET_GET_FILTER_TEMPLATES`

Retrieves 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `page` | integer | No | Optional page number for paginated results (must be >= 1). Omit to get all templates without pagination. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Filter Template by Handle

**Slug:** `GIGASHEET_GET_FILTER_TEMPLATES_FILTER_HANDLE`

Retrieves 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `filter_handle` | string | Yes | Unique identifier for the filter template to retrieve. Format: lowercase hex + digits + underscores (e.g., 'f548cadd_c15f_43b0_89ee_0ab1684dfc5c'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Generate New Handle

**Slug:** `GIGASHEET_GET_GENERATE_HANDLE`

Tool to generate a new unique dataset handle. Use when you need a fresh FileUuid before creating or referencing datasets.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Library Files

**Slug:** `GIGASHEET_GET_LIBRARY`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Library Files in Directory

**Slug:** `GIGASHEET_GET_LIBRARY_HANDLE`

Retrieves 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the parent directory to list library files from. This is the directory handle that contains the files you want to retrieve. Format: lowercase letters a-f, numbers, and underscores (e.g., 'b3139bab_fa35_4b1b_b2e3_40407fb61f5d'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Library Home Page Files

**Slug:** `GIGASHEET_GET_LIBRARY_HOME`

Tool to retrieve suggested recent files for the home page. Returns a list of recently accessed datasets with metadata, permissions, and sharing information. Use when you need to display or work with the user's recent files.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Library Path

**Slug:** `GIGASHEET_GET_LIBRARY_PATH`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the file or folder to retrieve the path for. Format: lowercase letters a-f, numbers, and underscores (e.g., 'cfd53422_4516_42e9_bb92_91cec8af8ff8'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get TICIntel NPI Public Profile

**Slug:** `GIGASHEET_GET_TICINTEL_NPI_NPI_PUBLIC`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `npi` | string | Yes | 10-digit National Provider Identifier (NPI) number. This is a unique identification number for covered health care providers in the United States. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get TIC Intel States

**Slug:** `GIGASHEET_GET_TICINTEL_STATES`

Tool to list available TIC Intel states from Gigasheet. Returns a list of state names or codes that can be used for TIC Intel data queries. Use when you need to know which states are available for TIC Intel analysis.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Cities by State

**Slug:** `GIGASHEET_GET_TICINTEL_STATES_STATE_CITIES`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `state` | string | Yes | State code (e.g., 'CA' for California, 'NY' for New York, 'TX' for Texas). This is the two-letter abbreviation used in the US to identify states. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Providers by City

**Slug:** `GIGASHEET_GET_TICINTEL_STATES_STATE_CITIES_CITY_PROVIDERS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `city` | string | Yes | City name (e.g., 'Los Angeles', 'New York'). URL encoding will be handled automatically. |
| `state` | string | Yes | State code (e.g., 'CA' for California, 'NY' for New York). The two-letter abbreviation identifying the state. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get User Details

**Slug:** `GIGASHEET_GET_USER_DETAILS`

Retrieves detailed information about the authenticated user in Gigasheet. Use when you need to check user account details, storage quota usage, or verify assigned roles and permissions.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get User Enrichment Credits

**Slug:** `GIGASHEET_GET_USER_ENRICHMENT_CREDITS`

Tool to get the current user's enrichment credit information. Use when you need to check available enrichment credits or usage.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get User Metadata

**Slug:** `GIGASHEET_GET_USER_METADATA`

Tool to retrieve metadata for the authenticated user. Returns user metadata including billing info, feature flags, and onboarding status. Use when you need to fetch user configuration or settings.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get User Autofill Suggestions

**Slug:** `GIGASHEET_GET_USERS_AUTOFILL`

Retrieves 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `filters` | object | No | Optional query parameters to filter autofill results. Accepts key-value pairs such as 'type', 'search', 'limit', etc. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get User Space Used

**Slug:** `GIGASHEET_GET_USER_SPACE_USED`

Tool to get the amount of space used by the current user in bytes. Use when you need to check storage usage.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Authenticated User Info

**Slug:** `GIGASHEET_GET_USER_WHOAMI`

Tool to fetch the authenticated user's details. Use after setting a valid Gigasheet API token.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Billing Plans

**Slug:** `GIGASHEET_LIST_BILLING_PLANS`

Tool to list available Gigasheet billing plans. Returns all billing plans with their item details and pricing information. Use when you need to view subscription options.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Dataset Comments

**Slug:** `GIGASHEET_LIST_DATASET_COMMENTS`

Tool to get all comments in a dataset sheet. Use this when you need to retrieve comments that have been added to cells in the dataset.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset for which to retrieve comments. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Dataset Liveshares

**Slug:** `GIGASHEET_LIST_DATASET_LIVESHARES`

Tool to list all liveshares for a specific Gigasheet dataset. Use when you need to view existing shared links for a dataset.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset for which to list liveshares. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f2ce9f7d_f429_402a_b0a0_5e5587feb608'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List All Datasets

**Slug:** `GIGASHEET_LIST_DATASETS`

Tool to retrieve all datasets owned by the user at any folder depth. Returns a list of datasets with their metadata. The API may trim certain fields to keep response size manageable. Use the 'types' parameter to filter by dataset type (sheet or export).

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `types` | array | No | Filter to include only specific dataset types. Valid values are 'sheet' or 'export'. Omit to return all types. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Datasets by Handle

**Slug:** `GIGASHEET_LIST_DATASETS_BY_HANDLE`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `page` | integer | No | Page number for pagination (0-based). Default is 0 (first page). Use this to navigate through multiple pages of results. |
| `types` | array | No | Filter results to include only specific dataset types. Valid values are 'sheet' (for spreadsheet files) and 'export' (for exported files). If not specified, all types are included. |
| `handle` | string | Yes | Unique identifier (handle) of the parent dataset or folder location to list files from. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f46c012a_194f_47e5_a639_8ad8d290e491'). |
| `pageSize` | integer | No | Number of results to return per page. Must be at least 1. If not specified, the server default is used. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Library Exports

**Slug:** `GIGASHEET_LIST_LIBRARY_EXPORTS`

Tool to list exports owned by the current user, regardless of location. Use when you need to retrieve all exports associated with the authenticated user's account.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `page` | integer | No | Page of results, default 0 (first page). Used for pagination. |
| `pageSize` | integer | No | Number of results per page. Used for pagination. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Shared Files by Handle

**Slug:** `GIGASHEET_LIST_SHARED_FILES_BY_HANDLE`

Tool to retrieve all files with permissions shared with the user in a specific directory location. Use when you need to see what files have been shared with you in a particular folder. Returns files limited to the requested directory level and will not return nested files at any deeper directory level.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the parent directory to list shared files from. Format: lowercase letters a-f, numbers, and underscores (e.g., 'b3139bab_fa35_4b1b_b2e3_40407fb61f5d'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Move file or folder to directory

**Slug:** `GIGASHEET_MOVE_FILE_DIRECTORY`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique handle (identifier) of the file or folder to move. This is typically found in the Gigasheet UI URL or returned from upload/create operations. |
| `dest_dir_handle` | string | No | Handle of the destination directory where the file or folder should be moved. If null or omitted, moves the item to the root of your Library. The destination folder must already exist, and creating a directory loop is forbidden. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Update User Metadata

**Slug:** `GIGASHEET_PATCH_USER_METADATA`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `userEmail` | string | No | User email address. Note: This field is deprecated and may be removed in future API versions. It should not be used for new integrations. |
| `onboarding` | object | No | Onboarding metadata object containing user onboarding state and preferences. This is a flexible object that can store any onboarding-related key-value pairs to track the user's progress through onboarding flows. |
| `chargebee_id` | string | No | Chargebee customer ID. Managed by Zapier/Chargebee integration. Only set this if you are integrating with Chargebee billing system. |
| `feature_preanalysis` | string | No | Controls pre-analysis feature for the user. Valid values are: empty string (default/not set), 'enabled', or 'disabled'. Use 'enabled' to turn on automatic data analysis before processing, or 'disabled' to turn it off. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Generate AI Formula

**Slug:** `GIGASHEET_POST_AI_HANDLE_FORMULATE`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `Query` | string | Yes | Natural language description of the formula you want to generate. Describe the transformation or calculation you want to perform on the sheet data. Examples: 'Convert column A to uppercase', 'Calculate the sum of columns B and C', 'Extract the domain from email addresses in column D'. |
| `handle` | string | Yes | Unique identifier (handle) of the sheet for which to generate a formula. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f2ce9f7d_f429_402a_b0a0_5e5587feb608'). You must have read permissions on the sheet to use this action. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Cast Column Data Type

**Slug:** `GIGASHEET_POST_CAST_COLUMN_HANDLE_COLUMN`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `column` | string | Yes | Column identifier or name to change data type. Can be a column letter (e.g., 'A', 'B', 'C') or numeric ID. |
| `handle` | string | Yes | Unique identifier (handle) of the sheet containing the column to convert. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f2ce9f7d_f429_402a_b0a0_5e5587feb608'). |
| `cast_type` | string ("ip_address" | "plain_text" | "number" | "date") | Yes | High-level data type to cast the column to (ip_address, plain_text, number, or date). |
| `cast_format` | string ("ipv4" | "ipv6" | "integer" | "decimal" | "email_address" | "zip_code") | Yes | Specific format to cast the column data to. Must be compatible with the cast_type. For example, 'integer' or 'decimal' work with cast_type 'number'. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Change Column Case

**Slug:** `GIGASHEET_POST_CHANGE_CASE_HANDLE_COL`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `col` | string | Yes | Column ID or name to change case in. This is typically a letter (e.g., 'A', 'B', 'C') or the column name. |
| `case` | string ("Uppercase" | "Lowercase" | "Capitalize" | "Proper") | Yes | Case transformation type to apply to the column values. Uppercase converts all text to uppercase, Lowercase converts all text to lowercase, Capitalize capitalizes the first letter of each value, and Proper capitalizes the first letter of each word. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset containing the column to transform. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f2ce9f7d_f429_402a_b0a0_5e5587feb608'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Clean Company Name

**Slug:** `GIGASHEET_POST_CLEAN_COMPANY_NAME_HANDLE_COL`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `col` | string | Yes | Column ID or name for the column containing company names to clean. This can be a letter (e.g., 'B') or column name. |
| `handle` | string | Yes | Handle of sheet with column containing company names to clean. This is the unique identifier for the dataset. Format: lowercase letters a-f, numbers, and underscores (e.g., '06dc2c33_cb0e_42e5_83f8_ac24521a8de4'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Combine Columns

**Slug:** `GIGASHEET_POST_COMBINE_COLUMNS_HANDLE`

Tool to combine multiple columns into a single new column with a separator. Use when you need to merge column values from a Gigasheet dataset.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `name` | string | Yes | Name for the new combined column. |
| `handle` | string | Yes | Handle of sheet with columns to combine. |
| `columns` | array | Yes | List of column names to combine. Must contain at least two columns. |
| `separator` | string | Yes | String separator to use when joining column values. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Append Rows to Sheet by Name

**Slug:** `GIGASHEET_POST_DATASET_HANDLE_APPEND_BY_NAME`

Appends 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the Gigasheet dataset to append rows to. Example: '3df6235c_5af3_4a8e_ab3f_5541d69693ad' |
| `records` | array | Yes | List of record objects to append as new rows. Each record is a dictionary where keys are exact column names (case-sensitive) and values are the cell data. Partial records (missing some columns) are allowed. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Generate Dataset Assistant Tips

**Slug:** `GIGASHEET_POST_DATASET_HANDLE_ASSISTANT_TIPS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset to generate tips for. Format: lowercase letters a-f, numbers, and underscores (e.g., 'a5f49fe7_dde2_45b3_96d9_1338ebf21904'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Initiate Dataset Export

**Slug:** `GIGASHEET_POST_DATASET_HANDLE_EXPORT`

Initiates 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Dataset (sheet) handle to export. Must be a valid dataset handle obtained from upload or dataset creation operations. |
| `gridState` | object | No | Optional grid state object containing filtering and view preferences for the export. Use 'filterModel' to specify column filters with types like 'equals', 'contains', 'greaterThan', 'lessThan'. If omitted, exports the entire dataset without filters. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Find and Replace in Dataset

**Slug:** `GIGASHEET_POST_DATASET_HANDLE_FIND_AND_REPLACE`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `find` | string | Yes | The text or pattern to search for in the specified columns. Can be an empty string to find empty cells. |
| `colIDs` | array | Yes | List of column identifiers to perform find and replace on. Column IDs are typically single uppercase letters (e.g., 'A', 'B', 'C') or multi-character identifiers for larger datasets. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset to perform find and replace on. Format: lowercase letters a-f, numbers, and underscores (e.g., 'cfd53422_4516_42e9_bb92_91cec8af8ff8'). |
| `replace` | string | Yes | The text to replace the found values with. |
| `language` | string | No | Language code for text processing (e.g., 'es' for Spanish). Default is English if not specified. |
| `caseSensitive` | boolean | No | Whether the search should be case-sensitive. Default is false if not specified. |
| `wholeCellMatch` | boolean | No | Whether to match the entire cell content or allow partial matches. When true, only cells that exactly match the 'find' value will be replaced. Default is false if not specified. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Insert Blank Row in Dataset

**Slug:** `GIGASHEET_POST_DATASET_HANDLE_INSERT_BLANK_ROW`

Tool to insert a blank row with null values into a dataset. Use after determining the insertion index.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `index` | integer | Yes | Zero-based index where the new blank row will be inserted. |
| `handle` | string | Yes | Dataset handle identifying the target dataset. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Rename Columns to Unique

**Slug:** `GIGASHEET_POST_DATASET_HANDLE_RENAME_COLUMNS_TO_UNIQUE`

Tool to rename all columns in a dataset to unique names. Use when duplicate column names could cause conflicts in downstream processing.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Dataset handle for which to ensure unique column names. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Save Current View

**Slug:** `GIGASHEET_POST_DATASET_HANDLE_SAVE_CURRENT_VIEW`

Saves 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | The unique identifier (handle) of the dataset whose current view should be saved. Format: lowercase letters a-f, numbers, and underscores (e.g., '8f7596f2_f4e3_4f49_8814_8043aa6c2bf5'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Select columns by name

**Slug:** `GIGASHEET_POST_DATASET_HANDLE_SELECT_COLUMNS_BY_NAME`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the Gigasheet dataset to select columns from. Example: 'a5f49fe7_dde2_45b3_96d9_1338ebf21904' |
| `column_names` | array | Yes | List of column names to keep in the dataset, in the desired order. All other columns will be deleted. The row number column is always retained automatically. Column names are case-sensitive and must exactly match the names in the sheet. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Extract Domain from URL Column

**Slug:** `GIGASHEET_POST_EXTRACT_DOMAIN_HANDLE_COL`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `col` | string | Yes | Column ID or name for the column containing URLs to extract domains from. This can be a letter (e.g., 'A', 'B', 'C') or column name. |
| `handle` | string | Yes | Unique identifier (handle) of the sheet containing the URL column. Format: lowercase letters a-f, numbers, and underscores (e.g., '7c8a72f4_f53a_4dad_a3a3_c464ef9129e6'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Filter File Rows by Column Name

**Slug:** `GIGASHEET_POST_FILE_HANDLE_FILTER_BY_NAME`

Filter 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `endRow` | integer | No | Ending row index for the result set (0-based, exclusive). Use this for pagination to limit the number of rows returned. The result will include rows from startRow up to (but not including) endRow. If not provided, defaults to startRow + 10 |
| `handle` | string | Yes | Unique identifier (handle) of the Gigasheet file to filter. Format: lowercase letters a-f, numbers, and underscores (e.g., '749ff5b7_878c_41cc_9cd0_5092d345cd46') |
| `startRow` | integer | No | Starting row index for the result set (0-based). Use this for pagination to specify where to begin returning rows. If not provided, defaults to 0 |
| `filterModel` | object | Yes | Filter configuration using column names as keys. Each key must be an exact column name (case-sensitive), and the value is a filter configuration object with 'filterType' (text/number/date), 'type' (equals/contains/etc), and 'filter' (string or array of values). Example: {'ColumnA': {'filterType': 'text', 'type': 'equals', 'filter': 'test'}, 'ColumnB': {'filterType': 'number', 'type': 'greaterThan', 'filter': '100'}} |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Filtered Row Index

**Slug:** `GIGASHEET_POST_FILE_HANDLE_FILTER_SHEET_ROW_NR`

Maps 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier of the sheet/file (handle returned by upload or other file operations) |
| `row_nr` | integer | Yes | Row number in the unfiltered dataset (1-based index). This endpoint returns where this row appears in the filtered result set |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Filter File with Stream Progress

**Slug:** `GIGASHEET_POST_FILE_HANDLE_FILTER_STREAM_PROGRESS`

Filter data from a Gigasheet file with real-time streaming progress updates. Returns filtered rows along with processing statistics (bytes and rows processed). Use when you need to apply filters to a dataset and retrieve the filtered results with pagination support.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `endRow` | integer | No | Ending row index (0-based, exclusive) for the filtered result set. Specify the row number where the result set should end. |
| `handle` | string | Yes | Unique identifier of the sheet/file (handle returned by upload or other file operations). Format: lowercase letters a-f, numbers, and underscores (e.g., 'cfd53422_4516_42e9_bb92_91cec8af8ff8'). |
| `startRow` | integer | No | Starting row index (0-based) for the filtered result set. Defaults to 0 if not specified. |
| `groupKeys` | array | No | Array of group keys for hierarchical grouping |
| `pivotCols` | array | No | Array of pivot column configurations when pivot mode is enabled |
| `pivotMode` | boolean | No | Enable pivot mode for the data view |
| `sortModel` | array | No | Array of sort configurations specifying the sort order for columns |
| `valueCols` | array | No | Array of value column configurations for aggregation |
| `FieldTypes` | array | No | Array of field type hints (e.g., 'int', 'float', 'string') for pivot mode operations |
| `filterModel` | object | No | Filter configuration object specifying which filters to apply to columns. Use column names as keys and filter criteria as values. Empty object {} means no filters applied. |
| `rowGroupCols` | array | No | Array of row grouping column configurations |
| `columnHighlights` | object | No | Dictionary mapping column names to highlight configurations |
| `AllowUnstableOrder` | boolean | No | Set to true to allow unstable result ordering for faster performance on large files. Results may not be in a consistent order between calls. |
| `ungroupedAggregations` | array | No | Array of aggregation configurations for ungrouped data |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Save Exported File

**Slug:** `GIGASHEET_POST_FILE_HANDLE_SAVE_EXPORTED`

Saves 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | File handle identifier for the dataset to save with applied filters and grouping. Must be a valid file handle obtained from export operations. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Combine Files by Name

**Slug:** `GIGASHEET_POST_FILES_COMBINE_BY_NAME`

Tool to combine multiple files by a shared column name. Use when you need to merge several Gigasheet files based on a common header.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `columnName` | string | Yes | Column header name to use as the key when combining files |
| `outputName` | string | No | Optional name for the newly combined file. |
| `fileHandles` | array | Yes | List of Gigasheet file handles to combine |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Export Gigasheet to S3

**Slug:** `GIGASHEET_POST_MAVEN_EXPORT`

Tool to export Gigasheet data to AWS S3. Use after generating an export handle and ensuring the S3 bucket has correct permissions.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `params` | object | Yes | Connector-specific parameters for the export. |
| `connector` | string | Yes | Must be 'S3' to use the AWS S3 export connector. |
| `exportHandle` | string | Yes | Handle of the pre-created Gigasheet export to deliver to S3. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Import from S3

**Slug:** `GIGASHEET_POST_MAVEN_IMPORT`

Tool to import data from AWS S3 into your Gigasheet Library. Use when you need to pull objects or prefixes from an S3 bucket into Gigasheet.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `params` | object | Yes | Container for S3 import-specific settings |
| `connector` | string | Yes | Connector type, must be 'S3' for S3 import |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Request Access to File

**Slug:** `GIGASHEET_POST_REQUEST_ACCESS_HANDLE`

Tool to request access to a Gigasheet file. Use when you need permission to view or edit a file owned by another user.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Handle of the sheet to request access to. This is the unique identifier for the Gigasheet file. Format: lowercase letters a-f, numbers, and underscores (e.g., 'aa8359b8_3122_4d5d_956d_a6a99d4820d0'). |
| `message` | string | No | Optional message to include with the access request, explaining why you need access to the file. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Request API Access

**Slug:** `GIGASHEET_POST_REQUEST_API_ACCESS`

Request 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Trim Column Whitespace

**Slug:** `GIGASHEET_POST_TRIM_WHITESPACE_HANDLE_COL`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `col` | string | Yes | Column ID to trim whitespace in. This is typically a letter (e.g., 'A', 'B', 'C') or column name. |
| `handle` | string | Yes | Unique identifier (handle) of the sheet containing the column to trim whitespace from. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., '749ff5b7_878c_41cc_9cd0_5092d345cd46'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Unroll Delimited Column

**Slug:** `GIGASHEET_POST_UNROLL_DELIMITED_COLUMN_HANDLE_COLUMN`

Tool to explode a column containing delimited data into multiple rows. Use after confirming dataset handle and target column.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `column` | string | Yes | Name or identifier of the column to unroll. |
| `handle` | string | Yes | Unique sheet handle/identifier. |
| `splitBy` | string | No | Delimiter to split the column values by (e.g., ',' or '\|'). If not provided, the column must already be of an array type. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Upload Raw Data Direct

**Slug:** `GIGASHEET_POST_UPLOAD_DIRECT`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `name` | string | Yes | Name of the file when uploaded. This will be the display name in Gigasheet. |
| `contents` | array | Yes | Array of integers representing the byte contents of the file to upload. Maximum size: 128 MB. Example: [110, 97, 109, 101] for 'name' |
| `callbackUrl` | string | No | Optional callback URL to receive notifications when the upload completes. |
| `targetHandle` | string | No | If provided, records will be appended to the dataset with this handle instead of creating a new file. |
| `parentDirectory` | string | No | Parent directory to upload the file to. If left blank, the file is uploaded to the outer library. |
| `skipNotification` | boolean | No | Whether to skip sending notifications for this upload. Defaults to false. |
| `skipTypeInference` | boolean | No | If set to true, all columns are treated as string type instead of inferring types. Defaults to false. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Upload from URL

**Slug:** `GIGASHEET_POST_UPLOAD_URL`

Tool to upload data to Gigasheet from a specified URL. Use when you have a public or pre-signed link and want to ingest it directly.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `url` | string | Yes | Public or pre-signed URL of the file to ingest. |
| `name` | string | No | Optional friendly filename to display in Gigasheet. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Preview HTTP Enrichment

**Slug:** `GIGASHEET_PREVIEW_ENRICH_USER_DEFINED_HTTP`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `bulk` | object | No | Bulk enrichment configuration. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset to enrich. Format: lowercase letters a-f, numbers, and underscores (e.g., 'cfd53422_4516_42e9_bb92_91cec8af8ff8'). |
| `method` | string ("GET" | "POST" | "PUT" | "PATCH") | Yes | HTTP request method to use for enrichment. |
| `columns` | array | Yes | List of columns from the dataset that will be used in enrichment requests. These columns provide data for URL templates and request bodies. |
| `headers` | object | No | HTTP headers to include in enrichment requests (e.g., {'Authorization': 'Bearer token'}). |
| `recipe_id` | string | No | Gigasheet recipe ID to use (optional). |
| `sort_model` | array | No | Sort specifications to apply before enrichment. |
| `filter_model` | object | No | Filter model to apply before enrichment. Only rows matching the filter will be enriched. |
| `url_template` | string | Yes | URL template string for the HTTP request. Can include column ID placeholders in curly braces (e.g., 'https://api.example.com/lookup?id={A}'). |
| `LaxValidation` | boolean | No | Internal flag to skip live DNS validation for testing. Default is false. |
| `body_template` | string | No | Request body template string for POST/PUT/PATCH requests. Can include column ID placeholders in curly braces. |
| `response_type` | string ("json" | "raw" | "unknown") | No | Response type for enrichment results. |
| `output_path_map` | array | Yes | Mapping of output columns to JSON paths in the API response. Each mapping creates a new column with values extracted from the response. |
| `retry_properties` | object | No | Retry configuration for failed requests. |
| `body_escape_format` | string ("json" | "none") | No | Body escape format for request body. |
| `email_on_completion` | array | No | List of email addresses to notify when enrichment completes. |
| `maximum_requests_per_second` | number | No | Rate limit for enrichment requests (maximum requests per second). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Set Dataset Client State Version

**Slug:** `GIGASHEET_PUT_DATASET_HANDLE_CLIENTSTATE_VERSION`

Applies 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | The dataset handle (UUID format) identifying which dataset's client state to set. Obtain from actions like POST_UPLOAD_URL or GET_DATASET_HANDLE. |
| `version` | string | Yes | The client state version identifier (UUID format) to apply or restore. Obtain from GET_CLIENT_STATE_CURRENT_VERSION or from saved views. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Update cell by column name and row

**Slug:** `GIGASHEET_PUT_DATASET_HANDLE_COL_ROW_BY_NAME`

Tool to update a cell in a dataset by specifying column name and row number. Use after dataset is loaded and column name uniqueness is ensured.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `row` | integer | Yes | Row number to update (1-based index). |
| `value` | string | Yes | New value to set for the specified cell. Can be any valid JSON value. |
| `column` | string | Yes | Name of the column to update. Must uniquely match an existing column. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Share file

**Slug:** `GIGASHEET_PUT_FILE_HANDLE_SHARE_FILE`

Tool to share a Gigasheet file with specified recipients. Use after creating or updating a sheet to grant email-based access.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `emails` | array | Yes | List of recipient email addresses to share the file with. Note: Email sub-addresses (aliases with '+' character) are not allowed by the API |
| `handle` | string | Yes | Unique file handle (identifier) of the Gigasheet file to share |
| `message` | string | No | Optional message to include with the share invitation. Note: This parameter can only be used when sharing with existing Gigasheet users. For new users not yet registered on Gigasheet, omit this parameter |
| `permissions` | array | Yes | List of permission codes corresponding to each email. Use 0 for view-only access. Each permission code corresponds to the email at the same index |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Opt out of shared file

**Slug:** `GIGASHEET_PUT_FILE_HANDLE_SHARE_OPT_OUT`

Tool to remove your access from a file that has been shared with you. Use when you want to opt out of a shared file.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique file handle (identifier) of the shared Gigasheet file to opt out from. This removes your access to the file that was shared with you. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create/Update Filter Template

**Slug:** `GIGASHEET_PUT_FILTER_TEMPLATES_FILTER_HANDLE`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `sheet` | string | Yes | Sheet/dataset handle to associate the saved filter template with. Required for both creating and updating filter templates. |
| `filterModel` | object | Yes | Arbitrary JSON object defining the filter conditions per the Gigasheet Filter Model schema. Must include a top-level `_cnf_` array of OR groups. |
| `filter_handle` | string | Yes | Handle of the saved filter to create or update. Must be lowercase hex + digits + underscores. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Rename Columns by Name

**Slug:** `GIGASHEET_RENAME_COLUMNS_BY_NAME`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the dataset containing columns to rename. |
| `rename_columns` | array | Yes | List of column rename operations to perform. Each operation specifies the current name and new name for a column. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Rename File

**Slug:** `GIGASHEET_RENAME_FILE`

Tool to rename a file in Gigasheet. Use when you need to change the display name of a sheet.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the sheet to rename. This is typically found in the Gigasheet UI URL or returned from upload/create operations. |
| `filename` | string | Yes | New filename to assign to the sheet. This is the display name that will appear in the Gigasheet interface. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Reset Client State to Default

**Slug:** `GIGASHEET_RESET_CLIENT_STATE`

Resets 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the sheet whose client state should be reset to default. Obtain from actions like POST_UPLOAD_URL or GET_DATASET_HANDLE. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Reset User Password

**Slug:** `GIGASHEET_RESET_USER_PASSWORD`

Tool to trigger password reset for the authenticated user. Use when a user needs to reset their password and has a valid API token.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Search Dataset Activity

**Slug:** `GIGASHEET_SEARCH_DATASETS_ACTIVITY`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `End` | string | No | End date/time (ISO 8601 format) for filtering activities. Only activities before or on this time are included. |
| `Page` | integer | No | Page number for pagination (0-based). Start with 0 for the first page. |
| `Query` | string | No | Freeform search query to filter activity entries. Searches across action names, users, and other activity details. |
| `Start` | string | No | Start date/time (ISO 8601 format) for filtering activities. Only activities on or after this time are included. |
| `Users` | array | No | Filter by user email addresses or identifiers. Multiple values are OR-ed together. Leave empty to include all users. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset to search activity for. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f46c012a_194f_47e5_a639_8ad8d290e491'). |
| `Actions` | array | No | Filter by specific action names (e.g., ['UpdateCell', 'FindAndReplace']). Multiple values are OR-ed together. Leave empty to include all actions. |
| `PageSize` | integer | No | Number of activity entries to return per page. Must be at least 1. |
| `Categories` | array | No | Filter by activity categories. Multiple values are OR-ed together. Leave empty to include all categories. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Search Library

**Slug:** `GIGASHEET_SEARCH_LIBRARY`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `fields` | array | No | Optional list of specific metadata fields to search through (e.g., ['owner', 'file_name', 'headers', 'note']). If not specified, searches across owner, file_name, headers, and note by default. |
| `searchTerm` | string | Yes | The search term to look for in file metadata. Required field. Searches across owner, file name, headers, and notes by default. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Send Invite Emails

**Slug:** `GIGASHEET_SEND_INVITE`

Tool to send email invitations to join Gigasheet. Use when you need to invite users to collaborate on the platform.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `recipients` | array | Yes | List of email addresses to send invitations to. Each email should be a valid email address. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Set Aggregate Filter Model

**Slug:** `GIGASHEET_SET_CLIENT_STATE_AGGREGATE_FILTER_MODEL`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | The sheet handle (UUID format with underscores) identifying which sheet's aggregate filter model to set. |
| `filterModel` | object | Yes | Aggregate filter model object defining the filter conditions. This is a dictionary that can contain various filter configurations. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Set Client State Aggregations

**Slug:** `GIGASHEET_SET_CLIENT_STATE_AGGREGATIONS`

Sets 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the sheet to update. This is typically obtained from dataset operations like POST_UPLOAD_URL or GET_DATASET_HANDLE. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f2ce9f7d_f429_402a_b0a0_5e5587feb608'). |
| `aggregations` | array | Yes | List of aggregation operations to apply to the sheet. Each aggregation specifies a column and the type of calculation to perform. Multiple aggregations can be applied simultaneously to different columns. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Set Client State Column State

**Slug:** `GIGASHEET_SET_CLIENT_STATE_COLUMN_STATE`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | The dataset handle (UUID format) identifying which sheet's column state to set. Obtain from actions like POST_UPLOAD_URL or GET_DATASET_HANDLE. |
| `columnState` | array | Yes | List of column state configurations. Each item defines the state for one column (width, sort, visibility, etc.). Only include columns you want to update. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Set Client State Filter Model

**Slug:** `GIGASHEET_SET_CLIENT_STATE_FILTER_MODEL`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Handle of the sheet to update the filter model for. This is the sheet/dataset identifier (UUID format). Obtain from actions like POST_UPLOAD_URL or GET_DATASET_HANDLE. |
| `filterModel` | object | Yes | Filter model object defining the filter conditions to apply to the client state. This is an arbitrary JSON object that follows the Gigasheet Filter Model schema. Use an empty object {} to clear all filters. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Set Client State Group Columns

**Slug:** `GIGASHEET_SET_CLIENT_STATE_GROUP_COLUMNS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the sheet to update. Obtain from actions like POST_UPLOAD_URL or GET_DATASET_HANDLE. |
| `columnIds` | array | Yes | Array of column IDs to set as group columns. Use letter-based identifiers like 'A', 'B', 'C', not numeric IDs. The columns specified will be used for grouping data in the sheet view. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Set Client State Sort Model

**Slug:** `GIGASHEET_SET_CLIENT_STATE_SORT_MODEL`

Sets 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the sheet whose sort model to update. Format: lowercase letters a-f, numbers, and underscores. |
| `sortModel` | array | Yes | List of sort specifications to apply to the sheet. The order in the list determines sort priority (first item is primary sort, second is secondary, etc.). Pass an empty list to clear all sorting. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Set Client State Visible Columns

**Slug:** `GIGASHEET_SET_CLIENT_STATE_VISIBLE_COLUMNS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Unique identifier (handle) of the sheet whose visible columns to set. Obtain from actions like POST_UPLOAD_URL or GET_DATASET_HANDLE. |
| `columnIds` | array | No | List of column IDs to make visible in the sheet. If empty, all columns are shown. Obtain column IDs from GET_DATASET_HANDLE_COLUMNS action. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Set Dataset Client State

**Slug:** `GIGASHEET_SET_DATASET_CLIENTSTATE`

Sets 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `state` | object | Yes | The client state object containing view configuration. This typically includes properties like 'view' (view name), 'filters' (applied filters), 'sorts' (sort configuration), 'columns' (visible columns), and other view-related settings. |
| `handle` | string | Yes | The dataset handle (UUID format) identifying which dataset's client state to set. Obtain from actions like POST_UPLOAD_URL or GET_DATASET_HANDLE. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Set Dataset Column Currency

**Slug:** `GIGASHEET_SET_DATASET_COLUMN_CURRENCY`

Tool to set currency format for a dataset column. Use when you need to format numeric data as currency with specific currency codes.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `column` | string | Yes | Column ID (e.g., 'A', 'B', 'C') to set currency format. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset. |
| `currency_code` | string | Yes | ISO 4217 currency code (e.g., 'USD', 'EUR', 'GBP'). See https://en.wikipedia.org/wiki/ISO_4217 for full list. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Set Dataset Note

**Slug:** `GIGASHEET_SET_DATASET_NOTE`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `note` | string | Yes | The note text to set for the dataset. Maximum length is 20,000 characters. Can be used to add descriptions, context, or metadata about the dataset. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset to set the note for. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., '06dc2c33_cb0e_42e5_83f8_ac24521a8de4'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Update Dataset Cell

**Slug:** `GIGASHEET_UPDATE_DATASET_CELL`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `col` | string | Yes | Column letter identifying the cell to update (e.g., 'A', 'B', 'C'). Note: Column A is typically the row number column, so data usually starts at B. |
| `row` | string | Yes | Row number identifying the cell to update (1-based index). Must be provided as a string. |
| `value` | string | Yes | New value to set for the specified cell. The value will be updated in the dataset at the specified column and row. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset containing the cell to update. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f46c012a_194f_47e5_a639_8ad8d290e491'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Update Dataset View

**Slug:** `GIGASHEET_UPDATE_DATASET_VIEWS`

Tool to update the client state of a specified view. Use when you need to rename a view or update its client state ID.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `name` | string | No | New name for the view. |
| `view` | string | Yes | Handle of the view to update. This is the view identifier (UUID format). |
| `handle` | string | Yes | Handle of the dataset. This is the dataset identifier (UUID format). |
| `client_state_id` | string | No | Client state ID to associate with the view. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Upsert Rows in Dataset

**Slug:** `GIGASHEET_UPSERT_ROWS`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `col` | string | Yes | Column letter indicating the starting column position for the upsert operation. Must be a letter (A, B, C, etc.). Note: Column A is typically the row number column, so data usually starts at B. |
| `row` | string | Yes | Row number indicating the starting row position for the upsert operation. Must be a 1-based row number as a string. |
| `cells` | array | Yes | 2D array of cell values to upsert. Each inner array represents a row of data, and each element in the inner array represents a cell value. Overlapping cells will be overwritten. Example: [['TestValue1', 'TestValue2'], ['TestValue3', 'TestValue4']] upserts 2 rows with 2 columns each. |
| `handle` | string | Yes | Unique identifier (handle) of the dataset where rows will be upserted. Format: lowercase letters a-f, numbers, and underscores (e.g., '749ff5b7_878c_41cc_9cd0_5092d345cd46'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Validate Dataset Formula

**Slug:** `GIGASHEET_VALIDATE_DATASET_FORMULA`

Tool 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

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handle` | string | Yes | Handle of the dataset on which to validate the formula. |
| `formula` | string | Yes | Formula expression to validate (e.g., 'A * 2', 'E + 10'). Use column names or references in the formula. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Validate Files Combine

**Slug:** `GIGASHEET_VALIDATE_FILES_COMBINE`

Tool 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.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handles` | array | Yes | List of file handles to validate for combining. Each handle uniquely identifies a file in Gigasheet. |
| `inPlace` | boolean | No | If set to true, will append the rows from all other sheets to the first sheet on the list. |
| `fileName` | string | No | Name for the combined file. If not provided, a default name will be used. |
| `folderHandle` | string | No | Optional folder handle where the combined file will be stored. |
| `addInputFilename` | boolean | No | If set to true, will add an extra column containing the input filename. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Validate Files Combine by Name

**Slug:** `GIGASHEET_VALIDATE_FILES_COMBINE_BY_NAME`

Tool to validate a combine by name request before executing it. Use when you need to check if multiple files can be combined by matching column names, and identify any potential errors or issues.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `handles` | array | Yes | Array of file handles to be combined. Must contain at least two handles. |
| `new_sheet_name` | string | Yes | Name for the new combined sheet. |
| `addInputFilename` | boolean | No | If set to true, will add an extra column containing the input filename. |
| `case_insensitive` | boolean | No | Whether to ignore letter case in column names when matching. |
| `trim_column_names` | boolean | No | Whether to ignore leading and trailing spaces in column names when matching. |
| `add_unmatched_columns` | boolean | No | Whether to add any unmatched source sheet columns as new columns in the target sheet. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |