Gigasheet integration

Read from Gigasheet (12)

Runs automatically in any conversation.

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

• Get connectors connections

  Tool to list connector connections. Use after setting a valid Gigasheet API token.

• Get dataset handle

  Tool to get dataset metadata. Use after you have obtained the dataset handle.

• Get dataset handle columns

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

• Get dataset handle download export

  Tool to retrieve the download URL for an exported dataset. Use after initiating an export and obtaining its handle.

• Get dataset handle views

  Tool to list all views associated with a specific dataset. Use after confirming the dataset handle and its status.

• Get docs formulas functions

  Tool to retrieve all supported formula functions. Use after authenticating with a valid API token.

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

• Get filter templates

  Tool to retrieve all saved filter templates. Use after authentication is confirmed.

• Get generate handle

  Tool to generate a new unique dataset handle. Use when you need a fresh FileUuid before creating or referencing datasets.

• Get users autofill

  Tool to fetch autofill info for the authenticated user. Use after setting a valid Gigasheet API token.

• Get user whoami

  Tool to fetch the authenticated user's details. Use after setting a valid Gigasheet API token.

Act in Gigasheet (17)

Runs only after you enable write access.

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

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

• 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": { ... }}}`

• Post dataset handle insert blank row

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

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

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

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

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

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

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

• Post request api access

  Tool to request access to the Gigasheet API. Use when you need to obtain an API key.

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

and 5 more.