Reference

Add Comment to Cell

Tool to add a comment to a specific cell in a Gigasheet dataset.

Append Rows to Dataset

Appends rows to an existing Gigasheet dataset using column letters as keys.

Append Rows to Sheet by Name

Appends one or more rows to a Gigasheet dataset using column names as keys.

Append Sheet from Another Sheet

Tool to append data from a source sheet to a target sheet by matching column names.

Apply Filter Template On Sheet

Tool to fetch a saved filter template's model for a given sheet.

Apply HTTP Enrichment

Tool to apply generic HTTP enrichment to a Gigasheet dataset.

Calculate Enrich Expected Credits

Calculate expected credits for a user-defined HTTP enrichment operation.

Cancel HTTP Enrichment Task

Tool to cancel a running enrichment task.

Cast Column Data Type

Tool to change a column's data type in a Gigasheet dataset.

Change Column Case

Tool to change the case of a column to Uppercase, Lowercase, Capitalized, or Proper.

Check Connector Source Availability

Tool to check if a source of the given type is available.

Clean Company Name

Tool to clean company names by stripping common business suffixes (Inc., LLC, Corp., etc.).

Combine Columns

Tool to combine multiple columns into a single new column with a separator.

Combine Files

Tool to combine multiple files into a new file.

Combine Files by Name

Tool to combine multiple files by a shared column name.

Copy File

Tool to copy a file in Gigasheet.

Count Dataset Activities

Tool to get total activity count on a given Gigasheet dataset.

Count Dataset Deduplication Results

Tool to count how many duplicates will be removed and how many rows remain when deduplicating.

Count Dataset Groups

Tool to count the number of groups matching certain criteria in a Gigasheet dataset.

Count Dataset Rows

Counts rows in a Gigasheet dataset matching specified filter criteria.

Create AI Chat Query

AI analysis assistant for Gigasheet datasets.

Create Blank File

Tool to create an empty file in your Gigasheet Library.

Create Conditional Label Column

Tool to add a label column to a Gigasheet dataset with values based on conditional filters.

Create Cross-File Lookup

Creates a cross-file lookup to enrich data by matching values between two sheets.

Create Dataset Column Comment

Tool to add a comment to a column in a Gigasheet dataset.

Create Dataset Liveshare

Tool to create a new liveshare for a Gigasheet dataset.

Create Dataset View

Tool to create a new view for a Gigasheet dataset with a specified name and client state version.

Create File Aggregation

Tool to retrieve ungrouped aggregated values for a Gigasheet file.

Create Files Directory

Tool to create a new folder in your Gigasheet Library.

Create Formula Column

Tool to create a new column based on a formula input in a Gigasheet dataset.

Create Formula Preview

Tool to calculate a formula preview on a Gigasheet dataset and return sample results with involved column values.

Create Iterator Column

Tool to add an iterator column to a Gigasheet dataset based on current filters and order.

Create/Update Filter Template

Tool to create or update a saved filter template.

Delete column from sheet

Tool to delete a single column from a Gigasheet sheet by its column identifier.

Delete columns by name

Tool to delete multiple columns from a Gigasheet dataset by their column names.

Delete Connector Source

Tool to delete a connector source for the authenticated user.

Delete Dataset Comment

Tool to delete a comment from a cell in a Gigasheet dataset.

Delete dataset live share

Tool to delete a live share of a Gigasheet dataset.

Delete dataset view

Tool to delete a specific view from a Gigasheet dataset.

Delete Duplicated Rows from Dataset

Tool to delete duplicated rows from a Gigasheet dataset based on specified columns and sort model.

Delete Filter Template

Tool to delete a saved filter template by its unique handle.

Delete multiple columns from file

Tool to delete multiple columns from a Gigasheet file.

Delete Rows from Dataset

Tool to delete selected rows from a Gigasheet dataset.

Delete Rows Matching Filter

Tool to delete rows in a Gigasheet dataset that match a specified filter.

Delete Rows Not Matching Filter

Deletes rows in a Gigasheet dataset that do NOT match the specified filter criteria.

Delete Sheet Assistant Logs

Tool to delete Sheet Assistant chat history for a specific sheet.

Delete sheet or folder by handle

Deletes a Gigasheet sheet or folder by its unique handle identifier.

Edit Formula Column

Tool to edit a formula column in a Gigasheet dataset.

Explode JSON Column

Tool to explode JSON data in a column into separate columns.

Export Gigasheet to S3

Tool to export Gigasheet data to AWS S3.

Extract Domain from URL Column

Tool to extract domain from a URL column in a Gigasheet dataset.

Filter File Rows

Tool to retrieve rows from a Gigasheet file matching specified filter criteria.

Filter File Rows by Column Name

Filter rows in a Gigasheet file by column names and return matching results.

Filter File with Stream Progress

Filter data from a Gigasheet file with real-time streaming progress updates.

Find and Replace in Dataset

Tool to find and replace values in specified columns of a Gigasheet dataset.

Generate AI Formula

Tool to generate Excel-style formulas using AI based on natural language queries.

Generate Dataset Assistant Tips

Tool to generate AI-powered tips for analyzing a dataset.

Generate Dataset Description

Generates an AI-powered description for a Gigasheet dataset.

Generate New Handle

Tool to generate a new unique dataset handle.

Get Authenticated User Info

Tool to fetch the authenticated user's details.

Get Cell Comments

Tool to get comments for a specific cell in a Gigasheet dataset.

Get Client State Current Version

Retrieves the current client-state version and timestamp for a specified sheet.

Get Connector Connection Parameters

Tool to get connection parameters for a specific connector.

Get Connector Connection Parameters

Tool to retrieve connection parameters for a specific connector type.

Get Connector Connections

Tool to list connector connections.

Get Connector Source Parameters

Tool to get parameters required for a specific connector source type.

Get Connector Sources

Tool to retrieve information about connected data sources for the user.

Get Dataset Activity

Tool to get the list of write actions on a given dataset sheet.

Get Dataset by Handle

Retrieves comprehensive metadata for a specific dataset in Gigasheet.

Get Dataset Column Comments

Tool to get comments for a specific column in a dataset sheet.

Get Dataset Columns

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

Get Dataset Export Download URL

Tool to retrieve the download URL for an exported dataset.

Get Dataset Liveshare CSV

Tool to retrieve CSV data from a Gigasheet liveshare.

Get Dataset Note

Tool to retrieve a dataset's note by handle.

Get Dataset Operation Status

Tool to get information about the last operation on a dataset.

Get Dataset Organization Permissions

Tool to retrieve organization file permissions for a dataset.

Get Dataset Version Metadata

Retrieves metadata about a dataset at a specific version.

Get Dataset View Metadata

Tool to retrieve view metadata for a specific view within a dataset.

Get Dataset Views

Tool to list all views associated with a specific dataset.

Get Docs Formulas Functions

Tool to retrieve all supported formula functions.

Get Enrich Task Status

Tool to get status for a user-defined HTTP enrichment task.

Get Filter Template by Handle

Retrieves details of a specific saved filter template by its unique handle.

Get Filter Templates

Retrieves all saved filter templates from GigaSheet.

Get Filtered Row Index

Maps an unfiltered row number to its position in the filtered result set.

Get Library Files

Tool to retrieve all datasets and files in the user's Gigasheet library.

Get Library Files in Directory

Retrieves all library files with file permissions in a given directory.

Get Library Home Page Files

Tool to retrieve suggested recent files for the home page.

Get Library Path

Tool to retrieve the chain of parent directories for a file or folder in Gigasheet.

Get Sheet AI Chat History

Tool to retrieve AI chat history for a sheet.

Get TIC Intel States

Tool to list available TIC Intel states from Gigasheet.

Get TICIntel NPI Public Profile

Tool to retrieve public NPI (National Provider Identifier) profile from TICIntel database.

Get User Autofill Suggestions

Retrieves autofill suggestions for the authenticated user, including team members and previously used share recipients.

Get User Details

Retrieves detailed information about the authenticated user in Gigasheet.

Get User Enrichment Credits

Tool to get the current user's enrichment credit information.

Get User Metadata

Tool to retrieve metadata for the authenticated user.

Get User Space Used

Tool to get the amount of space used by the current user in bytes.

Import from S3

Tool to import data from AWS S3 into your Gigasheet Library.

Initiate Dataset Export

Initiates an asynchronous export job for a Gigasheet dataset.

Insert Blank Row in Dataset

Tool to insert a blank row with null values into a dataset.

List All Datasets

Tool to retrieve all datasets owned by the user at any folder depth.

List Billing Plans

Tool to list available Gigasheet billing plans.

List Cities by State

Tool to retrieve a list of cities for a given US state code from the TICIntel dataset.

List Dataset Comments

Tool to get all comments in a dataset sheet.

List Dataset Liveshares

Tool to list all liveshares for a specific Gigasheet dataset.

List Datasets by Handle

Tool to list files and datasets in a given Gigasheet location.

List Library Exports

Tool to list exports owned by the current user, regardless of location.

List Providers by City

Tool to retrieve a list of healthcare providers in a specific city and state from the TicIntel dataset.

List Shared Files by Handle

Tool to retrieve all files with permissions shared with the user in a specific directory location.

Move file or folder to directory

Tool to move a file or folder into a folder or to the root of your Library.

Opt out of shared file

Tool to remove your access from a file that has been shared with you.

Preview HTTP Enrichment

Tool to preview a generic HTTP enrichment on a Gigasheet dataset before executing it on all rows.

Rename Columns by Name

Tool to rename columns in a Gigasheet dataset using their current names.

Rename Columns to Unique

Tool to rename all columns in a dataset to unique names.

Rename File

Tool to rename a file in Gigasheet.

Request Access to File

Tool to request access to a Gigasheet file.

Request API Access

Request API access by sending a notification to Gigasheet support team.

Reset Client State to Default

Resets the client state of a sheet to the default state.

Reset User Password

Tool to trigger password reset for the authenticated user.

Save Current View

Saves the current view state of a Gigasheet dataset and returns a view handle.

Save Exported File

Saves a file state with applied filters and grouping to create an exported version.

Search Dataset Activity

Tool to search the history of write actions performed on a Gigasheet dataset.

Search Library

Tool to search through the Gigasheet file library by file metadata.

Select columns by name

Tool to select specific columns from a Gigasheet dataset by name, keeping only those columns in the specified order.

Send Invite Emails

Tool to send email invitations to join Gigasheet.

Send MCP Request to Sheet Assistant

Tool to interact with Gigasheet Sheet Assistant via the Model Context Protocol (MCP) over HTTP.

Set Aggregate Filter Model

Tool to set the aggregate filter model in the client state of a sheet.

Set Client State Aggregations

Sets aggregations in the client state of a sheet.

Set Client State Column State

Tool to set column state in the client state of a sheet.

Set Client State Filter Model

Tool to set the filter model in the client state of a sheet.

Set Client State Group Columns

Tool to set group columns in the client state of a sheet.

Set Client State Sort Model

Sets the sort model for a sheet's client state.

Set Client State Visible Columns

Tool to set visible columns in the client state of a sheet.

Set Dataset Client State

Sets the client state of a dataset using a state object.

Set Dataset Client State Version

Applies or restores a specific client state version to a dataset.

Set Dataset Column Currency

Tool to set currency format for a dataset column.

Set Dataset Note

Tool to set or update a note on a dataset in Gigasheet.

Share file

Tool to share a Gigasheet file with specified recipients.

Split Column

Tool to split a column into multiple columns based on a separator.

Trim Column Whitespace

Tool to trim leading and trailing whitespace from all values in a column.

Unroll Delimited Column

Tool to explode a column containing delimited data into multiple rows.

Update cell by column name and row

Tool to update a cell in a dataset by specifying column name and row number.

Update Dataset Cell

Tool to update a single cell value in a Gigasheet dataset by column letter and row number.

Update Dataset View

Tool to update the client state of a specified view.

Update User Metadata

Tool to update user metadata in Gigasheet.

Upload from URL

Tool to upload data to Gigasheet from a specified URL.

Upload Raw Data Direct

Tool to upload raw data directly to Gigasheet using byte array contents.

Upsert Rows in Dataset

Tool to upsert rows in an existing Gigasheet dataset.

Validate Dataset Formula

Tool to validate a formula expression against a dataset.

Validate Files Combine

Tool to validate a combine files request and return all errors that might appear.

Validate Files Combine by Name

Tool to validate a combine by name request before executing it.