Gigasheet

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

Untrusted display-only summary

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-insensi…

Untrusted display-only summary

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…

Untrusted display-only summary

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 e…

Untrusted display-only summary

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)…

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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 ope…

Untrusted display-only summary

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 av…

Untrusted display-only summary

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 A…

Untrusted display-only summary

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 ana…

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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 c…

Untrusted display-only summary

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 'literalFormu…

Untrusted display-only summary

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.

Untrusted display-only summary

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 w…

Untrusted display-only summary

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,…

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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…

Untrusted display-only summary

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'…

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary