Gigasheet

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.

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

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.

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.

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.

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

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

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.

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.

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.