Gigasheet

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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…

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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

Untrusted display-only summary

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.

Untrusted display-only summary

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

Untrusted display-only summary

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

Untrusted display-only summary

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

Untrusted display-only summary

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

Untrusted display-only summary

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

Untrusted display-only summary

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.

Untrusted display-only summary

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

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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.

Untrusted display-only summary

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…

Untrusted display-only summary

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

Untrusted display-only summary

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

Untrusted display-only summary

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.

Untrusted display-only summary

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

Untrusted display-only summary

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

Untrusted display-only summary

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.

Untrusted display-only summary

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

Untrusted display-only summary

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.

Untrusted display-only summary