+
Beyond-Bot.ai + 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.
What You Can Do with this Integration
Automate Data Entry
Automatically sync new contacts or deals from Beyond-Bot.ai to Gigasheet.
Enrich Customer Profiles
Use Beyond-Bot.ai to find and add new information to your records in Gigasheet.
Trigger Workflows
Start automated workflows in Gigasheet based on conversations with your virtual expert.
Available Actions
Here are the specific actions your virtual expert can perform within Gigasheet.
Delete Sheet Or Folder By 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.
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 Connector Connections
Tool to list connector connections. Use after setting a valid Gigasheet API token.
Get Dataset By Handle
Tool to get dataset metadata. Use after you have obtained the dataset handle.
Get Dataset Columns
Tool to list all column metadata (IDs, names, types) for a dataset. Use after obtaining a dataset handle.
Get Dataset Export Download Url
Tool to retrieve the download URL for an exported dataset. Use after initiating an export and obtaining its handle.
Get Dataset 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.
Apply 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.
Generate New Handle
Tool to generate a new unique dataset handle. Use when you need a fresh FileUuid before creating or referencing datasets.
Get User Autofill Info
Tool to fetch autofill info for the authenticated user. Use after setting a valid Gigasheet API token.
Get Authenticated User Info
Tool to fetch the authenticated user's details. Use after setting a valid Gigasheet API token.
Append Rows To Sheet By Name
Tool to append rows to a sheet by column names. Use after verifying the sheet handle and column names.
Initiate Dataset 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": { ... }}}`
Insert Blank Row In Dataset
Tool to insert a blank row with null values into a dataset. Use after determining the insertion index.
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.
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.
Get Filtered Row Index
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.
Combine Files 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.
Export Gigasheet To S3
Tool to export Gigasheet data to AWS S3. Use after generating an export handle and ensuring the S3 bucket has correct permissions.
Import From S3
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.
Request Api Access
Tool to request access to the Gigasheet API. Use when you need to obtain an API key.
Unroll Delimited Column
Tool to explode a column containing delimited data into multiple rows. Use after confirming dataset handle and target column.
Upload From 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.
Set Dataset Client State 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.
Update Cell By Column Name And Row
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.
Share File
Tool to share a Gigasheet file with specified recipients. Use after creating or updating a sheet to grant email-based access.
Create/Update Filter Template
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.