Gigasheet
Gigasheet is a big data automation platform that offers a spreadsheet-like interface for analyzing and managing large datasets, enabling users to automate tasks, integrate with various data sources, and streamline data workflows.
This is a first-class FlyMyAI MCP. Agents discover it automatically via tool search and call the actions below on demand - you never wire it up by hand. See the Composio catalog for how discovery works.
Connect
Gigasheet authenticates with an API key. Generate the credential in your Gigasheet account, then paste it into FlyMyAI the first time an agent uses a Gigasheet action.
Get your Gigasheet credential →
Fields to fill in FlyMyAI
| Field | Details |
|---|---|
Gigasheet API Key | The API key used to authenticate requests to the Gigasheet API. Find or create your API key in your Gigasheet account settings. (required) |
Actions
Every action this integration exposes. Agents pick the right one from the task; you do not call them by name.
| Action | What it does | Required inputs |
|---|---|---|
GIGASHEET_DELETE_DELETE_HANDLE | Tool to delete a sheet or folder by handle. Use after obtaining the handle of a sheet or empty folder. Set recursive=True to delete all children of a folder. | handle |
GIGASHEET_GET_CLIENT_STATE_CURRENT_VERSION | Tool to fetch the current client-state version metadata for a sheet. Use after obtaining a sheet handle to determine the current version identifier for creating views. | handle |
GIGASHEET_GET_CONNECTORS_CONNECTIONS | Tool to list connector connections. Use after setting a valid Gigasheet API token. | - |
GIGASHEET_GET_DATASET_HANDLE | Tool to get dataset metadata. Use after you have obtained the dataset handle. | handle |
GIGASHEET_GET_DATASET_HANDLE_COLUMNS | Tool to list all column metadata (IDs, names, types) for a dataset. Use after obtaining a dataset handle. | handle |
GIGASHEET_GET_DATASET_HANDLE_DOWNLOAD_EXPORT | Tool to retrieve the download URL for an exported dataset. Use after initiating an export and obtaining its handle. | handle |
GIGASHEET_GET_DATASET_HANDLE_VIEWS | Tool to list all views associated with a specific dataset. Use after confirming the dataset handle and its status. | handle |
GIGASHEET_GET_DOCS_FORMULAS_FUNCTIONS | Tool to retrieve all supported formula functions. Use after authenticating with a valid API token. | - |
GIGASHEET_GET_FILTER_TEMPLATES | Tool to retrieve all saved filter templates. Use after authentication is confirmed. | - |
GIGASHEET_GET_FILTER_TEMPLATE_ON_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. | filter_handle, handle |
GIGASHEET_GET_GENERATE_HANDLE | Tool to generate a new unique dataset handle. Use when you need a fresh FileUuid before creating or referencing datasets. | - |
GIGASHEET_GET_USERS_AUTOFILL | Tool to fetch autofill info for the authenticated user. Use after setting a valid Gigasheet API token. | - |
GIGASHEET_GET_USER_WHOAMI | Tool to fetch the authenticated user's details. Use after setting a valid Gigasheet API token. | - |
GIGASHEET_POST_DATASET_HANDLE_APPEND_BY_NAME | Tool to append rows to a sheet by column names. Use after verifying the sheet handle and column names. | handle, records |
GIGASHEET_POST_DATASET_HANDLE_EXPORT | Tool to initiate an export of a dataset. Use when you need to queue an export job with optional filtering. Use after preparing any filter state. Example: Initiate export for sheet 'sheet_abc123' with filters: '("gridState": ("filterModel": ( ... )))' | handle |
GIGASHEET_POST_DATASET_HANDLE_INSERT_BLANK_ROW | Tool to insert a blank row with null values into a dataset. Use after determining the insertion index. | handle, index |
GIGASHEET_POST_DATASET_HANDLE_RENAME_COLUMNS_TO_UNIQUE | Tool to rename all columns in a dataset to unique names. Use when duplicate column names could cause conflicts in downstream processing. | handle |
GIGASHEET_POST_DATASET_HANDLE_SAVE_CURRENT_VIEW | Tool to persist the current view in a Gigasheet dataset. Use after configuring a view to ensure the current layout and filters are saved on the server. | handle |
GIGASHEET_POST_FILES_COMBINE_BY_NAME | Tool to combine multiple files by a shared column name. Use when you need to merge several Gigasheet files based on a common header. | fileHandles, columnName |
GIGASHEET_POST_FILE_HANDLE_FILTER_SHEET_ROW_NR | Tool to retrieve the filtered-set row index for a given unfiltered row number. Use after applying filters when you need the row's position in the filtered view. | handle, row_nr |
GIGASHEET_POST_MAVEN_EXPORT | Tool to export Gigasheet data to AWS S3. Use after generating an export handle and ensuring the S3 bucket has correct permissions. | connector, params, exportHandle |
GIGASHEET_POST_MAVEN_IMPORT | 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. | connector, params |
GIGASHEET_POST_REQUEST_API_ACCESS | Tool to request access to the Gigasheet API. Use when you need to obtain an API key. | - |
GIGASHEET_POST_UNROLL_DELIMITED_COLUMN_HANDLE_COLUMN | Tool to explode a column containing delimited data into multiple rows. Use after confirming dataset handle and target column. | handle, column |
GIGASHEET_POST_UPLOAD_URL | 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. | url |
GIGASHEET_PUT_DATASET_HANDLE_CLIENTSTATE_VERSION | Tool to set the client state version of a dataset. Use when you need to apply or revert to a saved client state version after data updates. | handle, version |
GIGASHEET_PUT_DATASET_HANDLE_COL_ROW_BY_NAME | 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. | handle, column, row, value |
GIGASHEET_PUT_FILE_HANDLE_SHARE_FILE | Tool to share a Gigasheet file with specified recipients. Use after creating or updating a sheet to grant email-based access. | handle, emails, permissions |
GIGASHEET_PUT_FILTER_TEMPLATES_FILTER_HANDLE | 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. | filter_handle, filterModel |
Links
We love our partners - FlyMy.AI builds with the best. Thanks, Gigasheet!