Connect Gigasheet to OpenClaw on Operator.io
Gigasheet is a big data automation platform with a spreadsheet-like interface for managing massive datasets. It makes it easy to automate, analyze, and streamline workflows without code.
Automate Gigasheet with AI
On Operator, an OpenClaw agent pilots Gigasheet for you. It reads your message, plans the steps, and runs them in Gigasheet, using actions like append rows to dataset, append sheet from another sheet, apply http enrichment.
Your agent reaches Gigasheet directly or through connectors like Composio MCP and Pipedream MCP, which handle the sign in and token refresh for you, so there is nothing to wire up and no API keys to paste.
What your agent can do with Gigasheet
Your agent can call any of these Gigasheet actions by name as part of a larger task. Ask for the outcome you want and it picks the right ones.
Append Rows to Dataset
Appends rows to an existing Gigasheet dataset using column letters as keys. Use when you need to add new data rows to a sheet by specifying values for each column position (A, B, C, etc.).
Append Sheet from Another Sheet
Tool to append data from a source sheet to a target sheet by matching column names. Use when you need to combine data from two existing sheets based on column name matching rather than column IDs. This action matches columns from the sou...
Apply HTTP Enrichment
Tool to apply generic HTTP enrichment to a Gigasheet dataset. Use when you need to enrich dataset rows by calling external APIs and adding the response data as new columns. This action creates an enrichment job that calls a specified HTT...
Calculate Enrich Expected Credits
Calculate expected credits for a user-defined HTTP enrichment operation. Use this before initiating an enrichment to estimate costs based on the number of rows and columns that will be processed. This tool helps you: - Estimate credit co...
Cancel HTTP Enrichment Task
Tool to cancel a running enrichment task. Use when you need to stop an in-progress HTTP enrichment job that was previously initiated. This action attempts to cancel an enrichment task identified by its task handle. Cancellation is only p...
Check Connector Source Availability
Tool to check if a source of the given type is available. Use this to verify whether a specific connector integration (e.g., Snowflake, Salesforce) is configured and available for the authenticated user. This updates corresponding connec...
Combine Files
Tool to combine multiple files into a new file. Use when you need to merge several files where column names and types match. Optionally add source filename tracking or append rows to the first file in-place.
Copy File
Tool to copy a file in Gigasheet. Use when you need to duplicate an existing file/sheet into your library with an optional new name and destination folder.
Count Dataset Deduplication Results
Tool to count how many duplicates will be removed and how many rows remain when deduplicating. Use when you need to preview the impact of a deduplication operation before executing it, or to understand the number of duplicate rows in a d...
Count Dataset Groups
Tool to count the number of groups matching certain criteria in a Gigasheet dataset. Use when you need to determine how many distinct groups exist based on specified row grouping columns and optional filters. This action is useful for un...
Count Dataset Rows
Counts rows in a Gigasheet dataset matching specified filter criteria. Returns the number of rows matching the provided filters, groupings, and other parameters. For basic row counting, only the handle and optionally filterModel need to...
Count Dataset Activities
Tool to get total activity count on a given Gigasheet dataset. Use when you need to determine how many activities (creates, updates, deletes) have been performed on a dataset. This action counts activities matching the specified criteria...
Create AI Chat Query
AI analysis assistant for Gigasheet datasets. Use this to ask natural language questions about sheet data and get AI-powered insights. Only available for sheets where you have write permissions. Common use cases: - Get summaries of data...
Create Dataset Column Comment
Tool to add a comment to a column in a Gigasheet dataset. Use this when you need to annotate or document a specific column with explanatory text. Optionally notify other users by tagging their email addresses.
Add Comment to Cell
Tool to add a comment to a specific cell in a Gigasheet dataset. Use when you need to annotate or add notes to a particular cell location in the sheet.
Create Conditional Label Column
Tool to add a label column to a Gigasheet dataset with values based on conditional filters. Use when you need to categorize or label rows based on column values. This action creates a new column where each row's label is determined by ev...
Create Formula Column
Tool to create a new column based on a formula input in a Gigasheet dataset. Use when you need to calculate values based on existing columns. This action creates a new column with values computed from a formula. You must reference column...
Edit Formula Column
Tool to edit a formula column in a Gigasheet dataset. Use when you need to update an existing formula column with a new formula, rename it, or reposition it. The column must already exist and be a formula column created previously.
Create Formula Preview
Tool to calculate a formula preview on a Gigasheet dataset and return sample results with involved column values. Use this action when you need to: - Test a formula expression before applying it to an entire column - Preview formula calc...
Create Iterator Column
Tool to add an iterator column to a Gigasheet dataset based on current filters and order. Use when you need sequential row numbers in your data. This action creates a new column with sequential numbers (1, 2, 3, ...) for each row. The nu...
Create Dataset Liveshare
Tool to create a new liveshare for a Gigasheet dataset. Returns a share ID and URL for accessing the current CSV data in the sheet. Use when you need to generate a shareable link that provides live access to dataset content.
Create Dataset View
Tool to create a new view for a Gigasheet dataset with a specified name and client state version. Use when you need to save a specific dataset state as a named view for later reference.
Explode JSON Column
Tool to explode JSON data in a column into separate columns. Extracts all keys from JSON objects and creates a new column for each key. Use when you need to flatten nested JSON data in a Gigasheet dataset.
Create File Aggregation
Tool to retrieve ungrouped aggregated values for a Gigasheet file. Returns aggregated data as specified in the request payload, including support for pivot mode, filtering, sorting, and various aggregation functions. Use when you need to...
Create Blank File
Tool to create an empty file in your Gigasheet Library. Use when you need a blank spreadsheet with a specified number of rows and columns.
Create Files Directory
Tool to create a new folder in your Gigasheet Library. Use when you need to organize datasets by creating a new directory for file storage.
Create Cross-File Lookup
Creates a cross-file lookup to enrich data by matching values between two sheets. Use when you need to pull related data from a reference sheet into your source sheet based on matching column values. This is similar to VLOOKUP in Excel....
Send MCP Request to Sheet Assistant
Tool to interact with Gigasheet Sheet Assistant via the Model Context Protocol (MCP) over HTTP. Use when you need to query or manipulate sheet data through MCP-compatible LLM tools. This endpoint implements JSON-RPC 2.0 protocol and supp...
Split Column
Tool to split a column into multiple columns based on a separator. Use when you need to divide column values into separate columns in a Gigasheet dataset.
Delete Sheet Assistant Logs
Tool to delete Sheet Assistant chat history for a specific sheet. Use when you need to clear all AI assistant conversation logs associated with a sheet handle.
Delete columns by name
Tool to delete multiple columns from a Gigasheet dataset by their column names. Use when you need to remove specific columns from a sheet.
Delete Connector Source
Tool to delete a connector source for the authenticated user. Use when you need to remove an integration connection such as Salesforce, S3, or Google Sheets from Gigasheet.
Delete Dataset Comment
Tool to delete a comment from a cell in a Gigasheet dataset. Use this when you need to remove a specific comment that was previously added to a cell. The comment ID can be obtained using the list comments action.
Delete Rows Not Matching Filter
Deletes rows in a Gigasheet dataset that do NOT match the specified filter criteria. Use this when you want to keep only the rows that match a filter and remove everything else. The filter uses Conjunctive Normal Form (CNF) where conditi...
Delete Duplicated Rows from Dataset
Tool to delete duplicated rows from a Gigasheet dataset based on specified columns and sort model. Use when you need to remove duplicate entries identified by matching values in one or more columns. When multiple rows have identical valu...
Delete Rows from Dataset
Tool to delete selected rows from a Gigasheet dataset. Use when you need to remove specific rows identified by their row IDs (iterator numbers). Row IDs are subject to change, so it's best practice to obtain them immediately before delet...
Delete Rows Matching Filter
Tool to delete rows in a Gigasheet dataset that match a specified filter. Use when you need to remove specific rows based on filter criteria. The filterModel uses Conjunctive Normal Form (CNF) structure with column identifiers, filter va...
Delete dataset view
Tool to delete a specific view from a Gigasheet dataset. Use when you need to remove a saved view from a dataset. Requires both the dataset handle and the view handle to identify the view to delete.
Delete dataset live share
Tool to delete a live share of a Gigasheet dataset. Use when you need to revoke or remove an existing live share link. The shareid is the unique identifier of the live share to be deleted.
Delete sheet or folder by handle
Deletes a Gigasheet sheet or folder by its unique handle identifier. For sheets, this permanently removes the dataset. For folders, use recursive=True to delete the folder along with all its contents (sheets and subfolders), or omit/set...
Delete column from sheet
Tool to delete a single column from a Gigasheet sheet by its column identifier. Use when you need to permanently remove a specific column from a sheet.
Delete Filter Template
Tool to delete a saved filter template by its unique handle. Use when you need to remove a persisted filter configuration that is no longer needed.
Delete multiple columns from file
Tool to delete multiple columns from a Gigasheet file. Use when you need to remove specific columns from a sheet by their identifiers.
Filter File Rows
Tool to retrieve rows from a Gigasheet file matching specified filter criteria. Use when you need to query or extract data from a sheet with optional filtering, sorting, and pagination. For basic filtering, only the filterModel field nee...
Generate Dataset Description
Generates an AI-powered description for a Gigasheet dataset. Use this when you need to automatically create a summary or description of a dataset's content and structure based on its data.
Get Sheet AI Chat History
Tool to retrieve AI chat history for a sheet. Returns up to 20 most recent messages exchanged with the sheet assistant. Use when you need to review previous AI interactions or understand the conversation context for a specific sheet.
Get Cell Comments
Tool to get comments for a specific cell in a Gigasheet dataset. Use when you need to retrieve comments that have been added to a particular cell at the intersection of a column and row.
Get Client State Current Version
Retrieves the current client-state version and timestamp for a specified sheet. The version identifier is used when creating or updating views and saved states. Call this action after obtaining a sheet handle to get the latest version be...
Plus 102 more Gigasheet actions your agent can call.
How to connect Gigasheet
You authorize Gigasheet once from your dashboard. Operator holds the connection and refreshes the access tokens on its own, so your agent keeps working with Gigasheet without you signing in again. The same setup unlocks every other app your agent can reach, so you only do it once.
When you are ready, the get started guide walks through standing up your OpenClaw agent.
Common questions about Gigasheet
- How do I connect Gigasheet to Operator?
- You authorize Gigasheet once from your Operator dashboard. Operator holds the connection and refreshes the access token for you, so your agent keeps working with Gigasheet without you signing in again.
- Can my agent pull and update data in Gigasheet?
- Yes. It can read records, write new ones, and answer questions about what is stored. Point it at Gigasheet and ask for a figure or a list, or have it keep a table in step with another app you have connected, all in plain language.
- Do I need to write code or manage Gigasheet API keys?
- No code and no API keys. You authorize Gigasheet through a normal sign in and Operator handles the connection, so there is nothing to wire up or host.
- Can my agent use Gigasheet together with my other apps?
- Yes. The same agent reaches every app you connect, so it can move between Gigasheet and tools like Nasa, Api ninjas, Apify in one job, reading from one and acting in another without you wiring anything between them.
More apps to automate
Apps your agent runs alongside Gigasheet, or browse all integrations.
Put your agent on Gigasheet
Sign in, connect Gigasheet, and hand your agent the work. Your first week is free.
Try for free