Data Analysis

Gigasheet

Learn how to use Gigasheet with Composio

Overview

SLUG: GIGASHEET

Description

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.

Authentication Details

generic_api_key
stringRequired

Connecting to Gigasheet

Create an auth config

Use the dashboard to create an auth config for the Gigasheet toolkit. This allows you to connect multiple Gigasheet accounts to Composio for agents to use.

1

Select App

Navigate to Gigasheet.

2

Configure Auth Config Settings

Select among the supported auth schemes of and configure them here.

3

Create and Get auth config ID

Click “Create Gigasheet Auth Config”. After creation, copy the displayed ID starting with ac_. This is your auth config ID. This is not a sensitive ID — you can save it in environment variables or a database. This ID will be used to create connections to the toolkit for a given user.

Connect Your Account

Using API Key

1from composio import Composio
2
3# Replace these with your actual values
4gigasheet_auth_config_id = "ac_YOUR_GIGASHEET_CONFIG_ID" # Auth config ID created above
5user_id = "0000-0000-0000"  # UUID from database/app
6
7composio = Composio()
8
9def authenticate_toolkit(user_id: str, auth_config_id: str):
10    # Replace this with a method to retrieve an API key from the user.
11    # Or supply your own.
12    user_api_key = input("[!] Enter API key")
13
14    connection_request = composio.connected_accounts.initiate(
15        user_id=user_id,
16        auth_config_id=auth_config_id,
17        config={"auth_scheme": "API_KEY", "val": {"generic_api_key": user_api_key}}
18    )
19
20    # API Key authentication is immediate - no redirect needed
21    print(f"Successfully connected Gigasheet for user {user_id}")
22    print(f"Connection status: {connection_request.status}")
23    
24    return connection_request.id
25
26
27connection_id = authenticate_toolkit(user_id, gigasheet_auth_config_id)
28
29# You can verify the connection using:
30connected_account = composio.connected_accounts.get(connection_id)
31print(f"Connected account: {connected_account}")

Tools

Executing tools

To prototype you can execute some tools to see the responses and working on the Gigasheet toolkit’s playground

Python
1from composio import Composio
2from openai import OpenAI
3import json
4
5openai = OpenAI()
6composio = Composio()
7
8# User ID must be a valid UUID format
9user_id = "0000-0000-0000"  # Replace with actual user UUID from your database
10
11tools = composio.tools.get(user_id=user_id, toolkits=["GIGASHEET"])
12
13print("[!] Tools:")
14print(json.dumps(tools))
15
16def invoke_llm(task = "What can you do?"):
17    completion = openai.chat.completions.create(
18        model="gpt-4o",
19        messages=[
20            {
21                "role": "user",
22                "content": task,  # Your task here!
23            },
24        ],
25        tools=tools,
26    )
27
28    # Handle Result from tool call
29    result = composio.provider.handle_tool_calls(user_id=user_id, response=completion)
30    print(f"[!] Completion: {completion}")
31    print(f"[!] Tool call result: {result}")
32
33invoke_llm()

Tool List

Tool Name: Delete sheet or folder by handle

Description

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.

Action Parameters

handle
stringRequired
recursive
boolean

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Get Client State Current Version

Description

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.

Action Parameters

handle
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Get Connector Connections

Description

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

Action Parameters

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Get Dataset by Handle

Description

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

Action Parameters

handle
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Get Dataset Columns

Description

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

Action Parameters

handle
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Get Dataset Export Download URL

Description

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

Action Parameters

handle
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Get Dataset Views

Description

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

Action Parameters

handle
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Get Docs Formulas Functions

Description

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

Action Parameters

accept
stringDefaults to application/json
flatten
boolean

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Apply Filter Template On Sheet

Description

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.

Action Parameters

filter_handle
stringRequired
handle
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Get Filter Templates

Description

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

Action Parameters

page
integer

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Generate New Handle

Description

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

Action Parameters

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Get User Autofill Info

Description

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

Action Parameters

filters
object

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Get Authenticated User Info

Description

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

Action Parameters

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Append Rows to Sheet by Name

Description

Tool to append rows to a sheet by column names. Use after verifying the sheet handle and column names.

Action Parameters

handle
stringRequired
records
arrayRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Initiate Dataset Export

Description

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

Action Parameters

gridState
object
handle
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Insert Blank Row in Dataset

Description

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

Action Parameters

handle
stringRequired
index
integerRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Rename Columns to Unique

Description

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

Action Parameters

handle
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Save Current View

Description

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.

Action Parameters

handle
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Get Filtered Row Index

Description

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.

Action Parameters

handle
stringRequired
row_nr
integerRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Combine Files by Name

Description

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

Action Parameters

columnName
stringRequired
fileHandles
arrayRequired
outputName
string

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Export Gigasheet to S3

Description

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

Action Parameters

connector
stringRequired
exportHandle
stringRequired
params
objectRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Import from S3

Description

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.

Action Parameters

connector
stringRequired
params
objectRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Request API Access

Description

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

Action Parameters

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Unroll Delimited Column

Description

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

Action Parameters

column
stringRequired
handle
stringRequired
splitBy
string

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Upload from URL

Description

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.

Action Parameters

name
string
url
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Set Dataset Client State Version

Description

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.

Action Parameters

handle
stringRequired
version
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Update cell by column name and row

Description

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.

Action Parameters

column
stringRequired
handle
stringRequired
row
integerRequired
value
Required

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Share file

Description

Tool to share a Gigasheet file with specified recipients. Use after creating or updating a sheet to grant email-based access.

Action Parameters

emails
arrayRequired
handle
stringRequired
message
string
permissions
arrayRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Create/Update Filter Template

Description

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.

Action Parameters

filterModel
objectRequired
filter_handle
stringRequired
sheet
string

Action Response

data
objectRequired
error
string
successful
booleanRequired