> **Building with AI coding agents?** Install the authstack plugin with one command. This equips your agent with accurate Scalekit implementation patterns.
>
> **Recommended** (the `-y` flags skip prompts, so the command runs without an interactive terminal):
> ```bash
> npx -y @scalekit-inc/cli setup -y
> ```
>
> Global:
> ```bash
> npm install -g @scalekit-inc/cli
> scalekit setup -y
> ```
>
> Supports Claude Code, Cursor, GitHub Copilot, Codex + skills for other Agent Skills-compatible agents in `~/.agents/skills`.
> Skills: integrate-agentkit, implement-saaskit, add-mcp-oauth, implement-sso, implement-scim.
> [Full setup guide](https://docs.scalekit.com/dev-kit/build-with-ai/)

---

# Connect AI agents to Gigasheet

The Gigasheet connector lets your AI agent act in each user's Gigasheet account. Each user connects their own Gigasheet API key once, and Scalekit sends it with every call, so your agent never handles credentials. It comes with 57 tools.

**Authentication:** API Key
**Categories:** Analytics, Files & Documents
**Tools:** 57: 28 read, 24 write, 5 destructive
**Users sign in with:** API key
**Built by:** Scalekit connector
**Try it:** [Playground in the Scalekit dashboard](https://app.scalekit.com/ws/signup?sk_intent=playground&provider=GIGASHEET)

## Setup

1. ### Install the SDK

   **Node.js**

   ```bash
   npm install @scalekit-sdk/node dotenv
   ```

   **Python**

   ```bash
   pip install scalekit-sdk-python python-dotenv
   ```

2. ### Set your credentials

   Add your Scalekit credentials to your `.env` file. Find values in **[app.scalekit.com](https://app.scalekit.com)** > **Developers** > **API Credentials**.

   ```sh title=".env"
   SCALEKIT_ENVIRONMENT_URL=<your-environment-url>
   SCALEKIT_CLIENT_ID=<your-client-id>
   SCALEKIT_CLIENT_SECRET=<your-client-secret>
   ```

3. ### Create the Gigasheet connection

   In **AgentKit > Connections**, create a Gigasheet connection. The name you give it is the `connection_name` your code passes. See [Configure connections](/agentkit/connections/).

4. ### Authorize a user and make your first call

   **Node.js** (`quickstart.mts`)

   ```typescript
   import { ScalekitClient } from '@scalekit-sdk/node'
   import 'dotenv/config'
   import { createInterface } from 'node:readline/promises'

   const scalekit = new ScalekitClient(
     process.env.SCALEKIT_ENVIRONMENT_URL,
     process.env.SCALEKIT_CLIENT_ID,
     process.env.SCALEKIT_CLIENT_SECRET,
   )
   const actions = scalekit.actions

   const connector = 'gigasheet'
   const identifier = 'user_123'

   // Generate an authorization link for the user
   const { link } = await actions.getAuthorizationLink({ connectionName: connector, identifier })
   console.log('Authorize Gigasheet:', link)
   const rl = createInterface({ input: process.stdin, output: process.stdout })
   await rl.question('Press Enter after authorizing...')
   rl.close()

   // Make your first call
   const result = await actions.executeTool({
     connector,
     identifier,
     toolName: 'gigasheet_whoami_get',
     toolInput: {},
   })
   console.log(result)
   ```

   ```bash
   npx tsx quickstart.mts
   ```

   **Python** (`quickstart.py`)

   ```python
   import os
   from scalekit import ScalekitClient
   from dotenv import load_dotenv
   load_dotenv()

   scalekit_client = ScalekitClient(
       env_url=os.getenv("SCALEKIT_ENVIRONMENT_URL"),
       client_id=os.getenv("SCALEKIT_CLIENT_ID"),
       client_secret=os.getenv("SCALEKIT_CLIENT_SECRET"),
   )
   actions = scalekit_client.actions

   connection_name = "gigasheet"
   identifier = "user_123"

   # Generate an authorization link for the user
   link_response = actions.get_authorization_link(
       connection_name=connection_name,
       identifier=identifier,
   )
   print("Authorize Gigasheet:", link_response.link)
   input("Press Enter after authorizing...")

   # Make your first call
   result = actions.execute_tool(
       tool_input={},
       tool_name="gigasheet_whoami_get",
       connection_name=connection_name,
       identifier=identifier,
   )
   print(result)
   ```

   ```bash
   python quickstart.py
   ```

   Each user opens the link once and enters their Gigasheet credentials there. See [Authorize a user](/agentkit/tools/authorize/) for the full flow and statuses.

## Tools

Pass the exact name to `execute_tool`, with an input like each tool's example. To ask for a tool that's missing, use the [request form](https://scalekitsupport.portal.usepylon.com/forms/request-a-connector-tool).

**Node.js**

```typescript
const result = await actions.executeTool({
  toolName: 'gigasheet_dataset_activity_list',
  toolInput: {
    handle: '<handle>',
  },
  connector: 'gigasheet',
  identifier: 'user_123',
})
```

**Python**

```python
result = actions.execute_tool(
    tool_name="gigasheet_dataset_activity_list",
    tool_input={
        "handle": "<handle>",
    },
    connection_name="gigasheet",
    identifier="user_123",
)
```

`result.data` is the app's response as JSON, and `result.execution_id` (`executionId` in Node.js) is the ID of the call.

### `gigasheet_dataset_activity_list`

List Sheet Activity · Read-only

List the write actions made on a Gigasheet sheet.
Returns actions with type, user and time.
Use this to audit changes to a sheet.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `page` (`string`, optional): Page of results, starting at 0. Example: 0.
- `page_size` (`string`, optional): Results per page. Example: 25.

Example input: `{"handle":"<handle>"}`

### `gigasheet_dataset_columns_list`

List Sheet Columns · Read-only

List the columns of a Gigasheet sheet.
Returns each column's ID, name and type.
Use this to get the column IDs other tools need.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"handle":"<handle>"}`

### `gigasheet_dataset_filter`

Filter Sheet Rows · Read-only

Get the rows of a Gigasheet sheet that match a filter written with column names, between a start and end row.
Returns the matching rows and the last row number.
Use this for structured filtering. Use gigasheet_dataset_query for grouping, aggregation and sorting.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `end_row` (`integer`, optional): Row to stop before. Example: 100.
- `filter_model` (`object`, optional): Filter in the by-name form: an object whose _cnf_ key holds a list of OR-groups, each a list of conditions with colName, type (such as equals, contains, greaterThan) and filter (the value); the groups are ANDed. See the Filter Model Detail Guide. Example: {"_cnf_": [[{"colName": "Country", "type": "equals", "filter": "US"}]]}
- `start_row` (`integer`, optional): First row to return, starting at 0. Example: 0.

Example input: `{"handle":"<handle>"}`

### `gigasheet_dataset_get`

Describe Sheet · Read-only

Get the metadata of a Gigasheet sheet: file name, column names and types, row count and modification time.
Returns the sheet description.
Use this before querying or editing a sheet. Use gigasheet_dataset_columns_list for column IDs.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"handle":"<handle>"}`

### `gigasheet_dataset_note_get`

Get Sheet Note · Read-only

Get the note attached to a Gigasheet sheet.
Returns the note text.
Use this to read a sheet's description.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"handle":"<handle>"}`

### `gigasheet_dataset_operation_status_get`

Get Operation Status · Read-only

Get the status of the last operation on a Gigasheet sheet, such as an upload, formula or enrichment.
Returns the operation type, state and progress.
Use this to wait for a long operation to finish.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"handle":"<handle>"}`

### `gigasheet_dataset_query`

Query Sheet with GigaScript · Read-only

Run a GigaScript program against a Gigasheet sheet without changing it, for example FILTER Country = US; ROWGROUPBY State; AGGREGATE sum(Revenue); SORT Revenue DESC; LIMIT 10; DISPLAY.
Returns headers, types and rows (and counts when count is true), plus a permalink to the same view.
Use this to read, filter, group and aggregate data. Send DISPLAY alone to see the first rows, or HELP for the language summary.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `query` (`string`, required): GigaScript program: statements separated by ; and ending in DISPLAY. Statements: COLUMN <col>, FILTER <clause>, SORT <col> ASC|DESC, ROWGROUPBY <col>, AGGREGATE <func>(<col>), LIMIT <n> (1-10000, default 10). Example: FILTER Country = US; LIMIT 25; DISPLAY.
- `count` (`boolean`, optional): True adds row and group counts to the response. Example: true.
- `omit_rows` (`boolean`, optional): True returns only the schema and permalink without running the query; cannot be combined with count. Example: false.
- `show_state` (`boolean`, optional): True includes the compiled query state. Example: false.

Example input: `{"handle":"<handle>","query":"<query>"}`

### `gigasheet_dataset_rows_count`

Count Sheet Rows · Read-only

Count the rows of a Gigasheet sheet that match a filter.
Returns the number of matching rows.
Use this to size a result before reading it. Leave the filter empty to count all rows.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `filter_model` (`object`, optional): Filter model by column ID, as the Gigasheet grid uses it; leave empty for all rows. Example: {"C": {"filterType": "text", "type": "equals", "filter": "US"}}

Example input: `{"handle":"<handle>"}`

### `gigasheet_duplicates_count`

Count Duplicate Rows · Read-only

Count how many duplicate rows a Gigasheet sheet has across the given columns, and how many rows would remain after deduplication.
Returns the duplicate and remaining counts.
Use this to check data quality.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `columns` (`array`, required): IDs of the columns whose value combination defines a duplicate. Example: ["B", "D"]
- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"columns":["B","D"],"handle":"<handle>"}`

### `gigasheet_enrichment_credits_get`

Get Enrichment Credits · Read-only

Get the user's remaining Gigasheet enrichment credits.
Returns the credit balance.
Use this before running enrichments.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs: none.

Example input: `{}`

### `gigasheet_export_download_get`

Get Export Download URL · Read-only

Get a presigned download URL for a finished Gigasheet export.
Returns the URL of the export file.
Use this after gigasheet_export_create once its state is processed.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the export, from gigasheet_export_create or gigasheet_exports_list. Example: e_4b5c6d7e_8f90.

Example input: `{"handle":"<handle>"}`

### `gigasheet_exports_list`

List Exports · Read-only

List the exports the Gigasheet user has created.
Returns exports with handle, file name, state and dates.
Use this to find an export to download with gigasheet_export_download_get.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `page` (`integer`, optional): Page of results, starting at 0. Example: 0.
- `page_size` (`integer`, optional): Results per page. Example: 25.

Example input: `{}`

### `gigasheet_formula_functions_list`

List Formula Functions · Read-only

List the functions Gigasheet formulas support, with documentation.
Returns each function's name, syntax and description.
Use this before writing a formula for gigasheet_formula_run.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `dialect` (`string`, optional): SQL dialect (default ClickHouse). Example: ClickHouse.

Example input: `{}`

### `gigasheet_library_folder_list`

List Library Folder · Read-only

List the files and folders the user owns inside a Gigasheet library folder (not nested deeper).
Returns items with handle, file name, type, size, row count and dates.
Use this to browse a folder.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the folder. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"handle":"<handle>"}`

### `gigasheet_library_home_list`

List Recent Files · Read-only

List the suggested recent files shown on the Gigasheet home page.
Returns recent sheets with handle, file name and dates.
Use this to find what the user worked on lately.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs: none.

Example input: `{}`

### `gigasheet_library_path_get`

Get File Path · Read-only

Get the chain of parent folders of a Gigasheet file or folder, including the item itself.
Returns the folders from the root down, with handle and name.
Use this to show where a file lives.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the file or folder. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"handle":"<handle>"}`

### `gigasheet_library_root_list`

List Library Root · Read-only

List the files and folders at the root of the user's Gigasheet library.
Returns items with handle, file name, type, size, row count, owner and dates.
Use this to find sheet handles. Use gigasheet_library_folder_list for a folder and gigasheet_library_search to search.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs: none.

Example input: `{}`

### `gigasheet_library_search`

Search Library · Read-only

Search the Gigasheet library by file metadata: owner, file name, column headers and note by default.
Returns matching files with handle, name and owner.
Use this to find a sheet by name or column. Use gigasheet_library_root_list to browse.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `search_term` (`string`, required): Text to search for. Example: customers.
- `fields` (`array`, optional): Fields to search: owner, file_name, headers or note. All four by default. Example: ["file_name", "headers"]

Example input: `{"search_term":"<search_term>"}`

### `gigasheet_library_shared_with_me_list`

List Files Shared With Me · Read-only

List the files other users have shared with the Gigasheet user, at the root level.
Returns shared items with handle, file name and owner.
Use this to find sheets others gave you access to.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs: none.

Example input: `{}`

### `gigasheet_library_shared_with_team_list`

List Files Shared With My Team · Read-only

List the files shared with the user's Gigasheet team, at the root level.
Returns shared items with handle, file name and owner.
Use this to find team sheets.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs: none.

Example input: `{}`

### `gigasheet_saved_filter_apply`

Get Saved Filter for Sheet · Read-only

Turn a saved Gigasheet filter into a filter model for a specific sheet.
Returns the filter model with that sheet's column IDs.
Use the result as filter_model in gigasheet_dataset_rows_count.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `filter_handle` (`string`, required): Handle of the saved filter, from gigasheet_saved_filters_list. Example: f_1a2b3c4d5e6f.
- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"filter_handle":"<filter_handle>","handle":"<handle>"}`

### `gigasheet_saved_filter_get`

Get Saved Filter · Read-only

Get one saved Gigasheet filter.
Returns the filter's name and conditions.
Use this to inspect a saved filter.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `filter_handle` (`string`, required): Handle of the saved filter, from gigasheet_saved_filters_list. Example: f_1a2b3c4d5e6f.

Example input: `{"filter_handle":"<filter_handle>"}`

### `gigasheet_saved_filters_list`

List Saved Filters · Read-only

List the user's saved Gigasheet filters.
Returns saved filters with handle, name and the columns they use.
Use this to reuse a filter on a sheet with gigasheet_saved_filter_apply.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `page` (`integer`, optional): Page of results, starting at 0. Example: 0.

Example input: `{}`

### `gigasheet_space_used_get`

Get Space Used · Read-only

Get how much storage the Gigasheet user has used.
Returns the space used and the plan limit.
Use this before uploading large files.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs: none.

Example input: `{}`

### `gigasheet_user_details_get`

Get User Details · Read-only

Get detailed information about the Gigasheet user, such as name, email, plan and team.
Returns the user's profile and account details.
Use this for plan and team information.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs: none.

Example input: `{}`

### `gigasheet_view_get`

Get View · Read-only

Get one saved view of a Gigasheet sheet.
Returns the view's name and client state.
Use this for a view's details.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `view` (`string`, required): Handle of the view, from gigasheet_views_list. Example: v_8a1b2c3d4e5f.

Example input: `{"handle":"<handle>","view":"<view>"}`

### `gigasheet_views_list`

List Views · Read-only

List the saved views of a Gigasheet sheet.
Returns views with handle, name and client state version.
Use this to find a view.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"handle":"<handle>"}`

### `gigasheet_whoami_get`

Get Current User · Read-only

Get the Gigasheet user the API key belongs to.
Returns the username and whether the request is authenticated.
Use this to check the connection.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs: none.

Example input: `{}`

### `gigasheet_blank_rows_insert`

Insert Blank Rows · Write

Insert empty rows into a Gigasheet sheet at a row index.
Returns the new row.
Use this to make room for manual entries.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `index` (`integer`, required): Row index to insert at. Example: 0.
- `num_rows` (`integer`, optional): Number of rows to insert (default 1). Example: 1.

Example input: `{"handle":"<handle>","index":0}`

### `gigasheet_blank_sheet_create`

Create Blank Sheet · Write

Create an empty Gigasheet sheet with a set number of rows and columns.
Returns the new sheet with its handle.
Use this to start a sheet you fill with gigasheet_rows_append or gigasheet_cell_update.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `filename` (`string`, required): Sheet name. Example: Lead tracker.
- `folder_handle` (`string`, optional): Folder to create it in. Example: 9e8d7c6b_5a4f_4e3d_2c1b_0a9f8e7d6c5b.
- `num_cols` (`integer`, optional): Number of columns. Example: 5.
- `num_rows` (`integer`, optional): Number of rows. Example: 10.

Example input: `{"filename":"<filename>"}`

### `gigasheet_cell_update`

Update Cell · Write

Update one cell of a Gigasheet sheet, found by column name and row number.
Returns a success acknowledgement.
Use this for single edits. The call fails if the column name is missing or appears more than once.

Read only: no. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `column_name` (`string`, required): Name of the column. Example: Status.
- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `row` (`string`, required): Row number of the cell. Example: 12.
- `value` (`string`, required): New cell value. Example: Closed.

Example input: `{"column_name":"<column_name>","handle":"<handle>","row":"<row>","value":"<value>"}`

### `gigasheet_column_cast`

Change Column Type · Write

Change the data type of a Gigasheet column.
Returns a success acknowledgement.
Use this to make numbers, dates or IP addresses sortable and filterable as such.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `cast_format` (`string`, required): Format of the values: ipv4, ipv6, integer, decimal, email_address or zip_code. Example: decimal. One of: `ipv4`, `ipv6`, `integer`, `decimal`, `email_address`, `zip_code`.
- `cast_type` (`string`, required): Target type: ip_address, plain_text, number or date. Example: number. One of: `ip_address`, `plain_text`, `number`, `date`.
- `column_id` (`string`, required): Column ID (such as B), from gigasheet_dataset_columns_list. Example: B.
- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"cast_format":"ipv4","cast_type":"ip_address","column_id":"<column_id>","handle":"<handle>"}`

### `gigasheet_column_change_case`

Change Column Case · Write

Change the text case of a Gigasheet column to uppercase, lowercase, capitalized or proper case.
Returns a success acknowledgement.
Use this to normalize names.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `case` (`string`, required): New case: Uppercase, Lowercase, Capitalize or Proper. Example: Proper. One of: `Uppercase`, `Lowercase`, `Capitalize`, `Proper`.
- `column_id` (`string`, required): Column ID (such as B), from gigasheet_dataset_columns_list. Example: B.
- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"case":"Uppercase","column_id":"<column_id>","handle":"<handle>"}`

### `gigasheet_column_extract_domain`

Extract Domain · Write

Extract the domain from a Gigasheet column of URLs into a new column.
Returns a success acknowledgement.
Use this to group web data by site.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `column_id` (`string`, required): ID of the column that holds URLs. Example: B.
- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"column_id":"<column_id>","handle":"<handle>"}`

### `gigasheet_column_split`

Split Column · Write

Split the values of a Gigasheet column into two or more columns at a separator.
Returns a success acknowledgement.
Use this to break apart combined values.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `column` (`string`, required): ID of the column to split. Example: B.
- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `separator` (`string`, required): Separator to split at. Example: ,.

Example input: `{"column":"<column>","handle":"<handle>","separator":"<separator>"}`

### `gigasheet_column_trim_whitespace`

Trim Column Whitespace · Write

Trim leading and trailing whitespace from the values of a Gigasheet column.
Returns a success acknowledgement.
Use this to clean imported data.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `column_id` (`string`, required): Column ID (such as B), from gigasheet_dataset_columns_list. Example: B.
- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"column_id":"<column_id>","handle":"<handle>"}`

### `gigasheet_columns_combine`

Combine Columns · Write

Combine several columns of a Gigasheet sheet into a new column with a separator.
Returns a success acknowledgement.
Use this to build full names or addresses.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `columns` (`array`, required): IDs of the columns to combine, in order. Example: ["B", "C"]
- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `name` (`string`, required): Name of the new column. Example: Full Name.
- `separator` (`string`, required): Text placed between the values, such as a space, comma or dash. Example:  - .

Example input: `{"columns":["B","C"],"handle":"<handle>","name":"<name>","separator":"<separator>"}`

### `gigasheet_columns_rename_by_name`

Rename Columns · Write

Rename columns of a Gigasheet sheet by their current names.
Returns a success acknowledgement.
Use this to clean up headers.

Read only: no. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `rename_columns` (`array`, required): Renames, each an object with current_name and new_name. Example: [{"current_name": "cust_nm", "new_name": "Customer Name"}]

Example input: `{"handle":"<handle>","rename_columns":[{"current_name":"cust_nm","new_name":"Customer Name"}]}`

### `gigasheet_dataset_note_set`

Set Sheet Note · Write

Set the note of a Gigasheet sheet, up to 20,000 characters.
Returns a success acknowledgement.
Use this to document a sheet.

Read only: no. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `note` (`string`, required): Note text, up to 20,000 characters. Example: Weekly export of CRM leads; refreshed every Monday.

Example input: `{"handle":"<handle>","note":"<note>"}`

### `gigasheet_export_create`

Create Export · Write

Queue an export of a Gigasheet sheet to a downloadable file.
Returns the export handle immediately.
Use gigasheet_export_download_get with that handle once the export is processed.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `filename` (`string`, required): Name of the export file. Example: customers-us.csv.
- `grid_state` (`object`, required): Grid state to export, such as a filterModel and sortModel; an empty object exports the whole sheet. Example: {}
- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `folder_handle` (`string`, optional): Folder to put the export in. Example: 9e8d7c6b_5a4f_4e3d_2c1b_0a9f8e7d6c5b.

Example input: `{"filename":"<filename>","grid_state":{},"handle":"<handle>"}`

### `gigasheet_file_copy`

Copy File · Write

Copy a Gigasheet sheet (or a folder with recursive) into the user's library.
Returns a success acknowledgement with the new handle.
Use this to duplicate a sheet before editing.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `handle` (`string`, required): Handle of the sheet or folder to copy. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `file_name` (`string`, optional): Name of the copy. Example: Customers (copy)
- `folder_handle` (`string`, optional): Folder to put the copy in. Example: 9e8d7c6b_5a4f_4e3d_2c1b_0a9f8e7d6c5b.
- `recursive` (`boolean`, optional): True copies a folder with its contents. Example: false.

Example input: `{"handle":"<handle>"}`

### `gigasheet_file_move`

Move File · Write

Move a Gigasheet sheet or folder into another folder or to the library root.
Returns a success acknowledgement.
Use this to organize the library. The destination folder must exist.

Read only: no. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `dest_dir_handle` (`string`, required): Handle of the destination folder; empty string for the root. Example: 9e8d7c6b_5a4f_4e3d_2c1b_0a9f8e7d6c5b.
- `handle` (`string`, required): Handle of the sheet or folder to move. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"dest_dir_handle":"<dest_dir_handle>","handle":"<handle>"}`

### `gigasheet_file_rename`

Rename File · Write

Rename a Gigasheet sheet or folder.
Returns a success acknowledgement.
Use this to change a file's name.

Read only: no. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `filename` (`string`, required): New name. Example: Customers 2026.
- `handle` (`string`, required): Handle of the sheet or folder. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"filename":"<filename>","handle":"<handle>"}`

### `gigasheet_find_and_replace`

Find and Replace · Write

Find and replace values in columns of a Gigasheet sheet; the original values are kept in a column renamed Original Values - <name>.
Returns the updated column.
Use this for bulk text fixes.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `col_ids` (`array`, required): IDs of the columns to search. Example: ["B"]
- `find` (`string`, required): Text to find. Example: N/A.
- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `replace` (`string`, required): Replacement text; an empty string clears the matches. Example: Unknown.
- `case_sensitive` (`boolean`, optional): True matches case. Example: false.
- `whole_cell_match` (`boolean`, optional): True replaces only cells that match entirely. Example: true.

Example input: `{"col_ids":["B"],"find":"<find>","handle":"<handle>","replace":"<replace>"}`

### `gigasheet_folder_create`

Create Folder · Write

Create a folder in the Gigasheet library.
Returns the created folder with its handle.
Use this to organize sheets.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `filename` (`string`, required): Folder name. Example: Q4 reports.
- `folder_handle` (`string`, optional): Parent folder handle; the library root if empty. Example: 9e8d7c6b_5a4f_4e3d_2c1b_0a9f8e7d6c5b.

Example input: `{"filename":"<filename>"}`

### `gigasheet_formula_run`

Add Formula Column · Write

Add a column to a Gigasheet sheet computed from a formula over other columns.
Returns a success acknowledgement.
Use this for calculated columns. Use gigasheet_formula_functions_list for supported functions.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `column_name` (`string`, required): Name of the new column. Example: Total.
- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `literal_formula` (`string`, required): Formula using column names, such as Price * Quantity. Example: Price * Quantity.
- `after_column_id` (`string`, optional): ID of the column to place the new column after. Example: D.

Example input: `{"column_name":"<column_name>","handle":"<handle>","literal_formula":"<literal_formula>"}`

### `gigasheet_rows_append`

Append Rows · Write

Append rows to a Gigasheet sheet, given as objects keyed by column name.
Returns a success acknowledgement.
Use this to add data. Use gigasheet_sheet_append_from_sheet to copy rows from another sheet.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `records` (`array`, required): Rows to add, each an object of column name to value. Example: [{"Name": "Jane Doe", "Country": "US"}]

Example input: `{"handle":"<handle>","records":[{"Name":"Jane Doe","Country":"US"}]}`

### `gigasheet_sheet_append_from_sheet`

Append From Another Sheet · Write

Append all rows of one Gigasheet sheet to another, matching columns by name.
Returns a success acknowledgement.
Use this to merge sheets with the same columns.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `from_handle` (`string`, required): Handle of the source sheet. Example: 7d2e3f4a_1b2c_4d5e_8f90_a1b2c3d4e5f6.
- `handle` (`string`, required): Handle of the target sheet. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `add_unmatched_columns` (`boolean`, optional): True adds source columns that the target lacks as new columns. Example: true.
- `case_insensitive` (`boolean`, optional): True ignores letter case when matching column names. Example: true.
- `trim_column_names` (`boolean`, optional): True ignores leading and trailing spaces in column names. Example: true.

Example input: `{"from_handle":"<from_handle>","handle":"<handle>"}`

### `gigasheet_sheet_assistant_chat`

Ask Sheet Assistant · Write

Ask Gigasheet's AI Sheet Assistant a question about a sheet you can edit; it may answer or apply changes such as filters.
Returns the assistant's reply.
Use this for natural-language analysis. Use gigasheet_dataset_query for exact, read-only queries.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `query` (`string`, required): Question or instruction for the assistant. Example: Which 5 states have the most customers?.

Example input: `{"handle":"<handle>","query":"<query>"}`

### `gigasheet_upload_from_url`

Upload From URL · Write

Import a file into Gigasheet from a public URL (CSV, JSON, Excel and other supported formats), or append its records to an existing sheet.
Returns the handle of the new sheet.
Use this to load data. Use gigasheet_dataset_operation_status_get to wait for parsing.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `url` (`string`, required): Public URL of the file. Example: https://example.com/data/customers.csv.
- `folder_handle` (`string`, optional): Folder to upload into. Example: 9e8d7c6b_5a4f_4e3d_2c1b_0a9f8e7d6c5b.
- `name` (`string`, optional): Name for the new sheet. Example: customers.csv.
- `skip_type_inference` (`boolean`, optional): True treats every column as text. Example: false.
- `target_handle` (`string`, optional): Handle of a sheet to append the records to instead of creating a sheet. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"url":"<url>"}`

### `gigasheet_view_create`

Create View · Write

Create a named view of a Gigasheet sheet from a client state version (filters, sorting, grouping and visible columns).
Returns the created view with its handle.
Use this to save a way of looking at a sheet.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `name` (`string`, required): View name. Example: US customers.
- `client_state_id` (`string`, optional): Client state version to base the view on; the current state if empty. Example: cs_5f6e7d8c.

Example input: `{"handle":"<handle>","name":"<name>"}`

### `gigasheet_view_update`

Update View · Write

Rename a Gigasheet view or point it at another client state version.
Returns the updated view.
Use this to change a saved view.

Read only: no. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `view` (`string`, required): Handle of the view, from gigasheet_views_list. Example: v_8a1b2c3d4e5f.
- `client_state_id` (`string`, optional): Client state version for the view. Example: cs_5f6e7d8c.
- `name` (`string`, optional): New view name. Example: US customers (active)

Example input: `{"handle":"<handle>","view":"<view>"}`

### `gigasheet_column_delete`

Delete Column · Destructive

Delete one column of a Gigasheet sheet by column ID.
Returns a success acknowledgement.
Use this to drop a column. Use gigasheet_columns_delete_by_name for several columns.

Read only: no. Destructive: yes. Idempotent (safe to retry): yes.

Inputs:

- `column_id` (`string`, required): Column ID (such as B), from gigasheet_dataset_columns_list. Example: B.
- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"column_id":"<column_id>","handle":"<handle>"}`

### `gigasheet_columns_delete_by_name`

Delete Columns by Name · Destructive

Delete several columns of a Gigasheet sheet by name.
Returns a success acknowledgement.
Use this to drop unneeded columns. Use gigasheet_column_delete to delete one column by ID.

Read only: no. Destructive: yes. Idempotent (safe to retry): no.

Inputs:

- `column_names` (`array`, required): Names of the columns to delete. Example: ["Internal ID", "Notes"]
- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.

Example input: `{"column_names":["Internal ID","Notes"],"handle":"<handle>"}`

### `gigasheet_file_delete`

Delete File · Destructive

Delete a Gigasheet sheet or an empty folder; with recursive, delete a folder and everything in it.
Returns a success acknowledgement.
Use this to remove files for good.

Read only: no. Destructive: yes. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the sheet or folder. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `recursive` (`boolean`, optional): True deletes a folder and all its children. Example: false.

Example input: `{"handle":"<handle>"}`

### `gigasheet_saved_filter_delete`

Delete Saved Filter · Destructive

Delete a saved Gigasheet filter.
Returns a success acknowledgement.
Use this to remove a filter you no longer need.

Read only: no. Destructive: yes. Idempotent (safe to retry): yes.

Inputs:

- `filter_handle` (`string`, required): Handle of the saved filter, from gigasheet_saved_filters_list. Example: f_1a2b3c4d5e6f.

Example input: `{"filter_handle":"<filter_handle>"}`

### `gigasheet_view_delete`

Delete View · Destructive

Delete a saved view of a Gigasheet sheet; the data is not changed.
Returns a success acknowledgement.
Use this to remove a view.

Read only: no. Destructive: yes. Idempotent (safe to retry): yes.

Inputs:

- `handle` (`string`, required): Handle of the sheet, from gigasheet_library_root_list or gigasheet_library_search. Example: 6c1f2e5a_9b3d_4f7e_a2c8_0d1e2f3a4b5c.
- `view` (`string`, required): Handle of the view, from gigasheet_views_list. Example: v_8a1b2c3d4e5f.

Example input: `{"handle":"<handle>","view":"<view>"}`

## Related

Other Analytics connectors ([all 177](/agentkit/connectors/?category=analytics)):

- [Google Sheets](/agentkit/connectors/googlesheets/): Scalekit connector, OAuth, 48 tools
- [HubSpot](/agentkit/connectors/hubspot/): Scalekit connector, OAuth, 457 tools
- [AWS Redshift](/agentkit/connectors/redshift/): Scalekit connector, Trusted identity provider, 10 tools


---

## More Scalekit documentation

| Resource | What it contains | When to use it |
|----------|-----------------|----------------|
| [/llms.txt](/llms.txt) | Structured index with routing hints per product area | Start here — find which documentation set covers your topic before loading full content |
| [/llms-full.txt](/llms-full.txt) | Complete documentation for all Scalekit products in one file | Use when you need exhaustive context across multiple products or when the topic spans several areas |
| [sitemap-0.xml](https://docs.scalekit.com/sitemap-0.xml) | Full URL list of every documentation page | Use to discover specific page URLs you can fetch for targeted, page-level answers |
