Gigasheet

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.

Untrusted display-only summary

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…

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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

Untrusted display-only summary

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.

Untrusted display-only summary

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

Untrusted display-only summary

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

Untrusted display-only summary

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…

Untrusted display-only summary

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

Untrusted display-only summary

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.

Untrusted display-only summary

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…

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary