Gigasheet

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.

Spreadsheets Analytics Web del proveedor

Acciones

Triggers

Autenticación

—

OAuth gestionado

Información técnica: el detalle de parámetros, schemas y triggers de esta página está pensado para equipos de integración. Si solo necesitas saber si tu herramienta favorita está disponible, basta con ver la lista de acciones.

Acciones disponibles (29)

Cada acción es una operación que el agente puede ejecutar contra este conector. Haz clic en una acción para ver sus parámetros.

Delete sheet or folder by handleGIGASHEET_DELETE_DELETE_HANDLEAcción

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.

Parámetros de entrada

handlestringObligatorio
Unique handle (identifier) of the sheet or folder to delete
recursiveboolean
If true, deletes a folder and all its children. Only applicable when handle refers to a folder

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Get Client State Current VersionGIGASHEET_GET_CLIENT_STATE_CURRENT_VERSIONAcción

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.

Parámetros de entrada

handlestringObligatorio
Unique identifier (handle) of the sheet whose client state version to retrieve.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Get Connector ConnectionsGIGASHEET_GET_CONNECTORS_CONNECTIONSAcción

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

Parámetros de entrada

Sin parámetros.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Get Dataset by HandleGIGASHEET_GET_DATASET_HANDLEAcción

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

Parámetros de entrada

handlestringObligatorio
Unique identifier (handle) of the dataset to retrieve.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Get Dataset ColumnsGIGASHEET_GET_DATASET_HANDLE_COLUMNSAcción

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

Parámetros de entrada

handlestringObligatorio
Unique identifier (handle) of the dataset whose columns to list.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Get Dataset Export Download URLGIGASHEET_GET_DATASET_HANDLE_DOWNLOAD_EXPORTAcción

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

Parámetros de entrada

handlestringObligatorio
Export handle returned by the Create Export endpoint (not the sheet handle).

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Get Dataset ViewsGIGASHEET_GET_DATASET_HANDLE_VIEWSAcción

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

Parámetros de entrada

handlestringObligatorio
Unique identifier (handle) of the dataset for which to list views.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Get Docs Formulas FunctionsGIGASHEET_GET_DOCS_FORMULAS_FUNCTIONSAcción

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

Parámetros de entrada

acceptstring
Accept header value to request response format
flattenboolean
If true, attempt to coerce dictionary responses into a list of functions

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Apply Filter Template On SheetGIGASHEET_GET_FILTER_TEMPLATE_ON_SHEETAcción

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.

Parámetros de entrada

handlestringObligatorio
The unique handle (ID) of the target sheet/dataset.
filter_handlestringObligatorio
The unique handle (ID) of the saved filter template to apply.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Get Filter TemplatesGIGASHEET_GET_FILTER_TEMPLATESAcción

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

Parámetros de entrada

pageinteger
Page number for paginated results (>= 1).

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Generate New HandleGIGASHEET_GET_GENERATE_HANDLEAcción

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

Parámetros de entrada

Sin parámetros.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Get User Autofill InfoGIGASHEET_GET_USERS_AUTOFILLAcción

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

Parámetros de entrada

filtersobject
Optional query parameters as key-value pairs to filter which users' autofill details are returned

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Get Authenticated User InfoGIGASHEET_GET_USER_WHOAMIAcción

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

Parámetros de entrada

Sin parámetros.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Append Rows to Sheet by NameGIGASHEET_POST_DATASET_HANDLE_APPEND_BY_NAMEAcción

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

Parámetros de entrada

handlestringObligatorio
Dataset (sheet) handle to append rows to
recordsobject[]Obligatorio
List of row objects to append; each object must use column names as keys

Parámetros de salida

dataobjectObligatorio
Complete JSON response from GigaSheet API
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Initiate Dataset ExportGIGASHEET_POST_DATASET_HANDLE_EXPORTAcción

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

Parámetros de entrada

handlestringObligatorio
Dataset (sheet) handle to export
gridStateobject
Optional export state object containing filtering and view state. Should follow Gigasheet Filter Model structure.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Insert Blank Row in DatasetGIGASHEET_POST_DATASET_HANDLE_INSERT_BLANK_ROWAcción

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

Parámetros de entrada

indexintegerObligatorio
Zero-based index where the new blank row will be inserted.
handlestringObligatorio
Dataset handle identifying the target dataset.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Rename Columns to UniqueGIGASHEET_POST_DATASET_HANDLE_RENAME_COLUMNS_TO_UNIQUEAcción

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

Parámetros de entrada

handlestringObligatorio
Dataset handle for which to ensure unique column names.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Save Current ViewGIGASHEET_POST_DATASET_HANDLE_SAVE_CURRENT_VIEWAcción

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.

Parámetros de entrada

handlestringObligatorio
Unique dataset handle under which to save the current view.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Get Filtered Row IndexGIGASHEET_POST_FILE_HANDLE_FILTER_SHEET_ROW_NRAcción

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.

Parámetros de entrada

handlestringObligatorio
Unique sheet handle (as returned by other Gigasheet file endpoints)
row_nrintegerObligatorio
Unfiltered row number (1-based) to translate into its index in the filtered view

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Combine Files by NameGIGASHEET_POST_FILES_COMBINE_BY_NAMEAcción

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

Parámetros de entrada

columnNamestringObligatorio
Column header name to use as the key when combining files
outputNamestring
Optional name for the newly combined file.
fileHandlesstring[]Obligatorio
List of Gigasheet file handles to combine

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Export Gigasheet to S3GIGASHEET_POST_MAVEN_EXPORTAcción

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

Parámetros de entrada

paramsobjectObligatorio
Connector-specific parameters for the export.
connectorstringObligatorio
Must be 'S3' to use the AWS S3 export connector.
exportHandlestringObligatorio
Handle of the pre-created Gigasheet export to deliver to S3.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Import from S3GIGASHEET_POST_MAVEN_IMPORTAcción

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.

Parámetros de entrada

paramsobjectObligatorio
Container for S3 import-specific settings
connectorstringObligatorio
Connector type, must be 'S3' for S3 import

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Request API AccessGIGASHEET_POST_REQUEST_API_ACCESSAcción

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

Parámetros de entrada

Sin parámetros.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Unroll Delimited ColumnGIGASHEET_POST_UNROLL_DELIMITED_COLUMN_HANDLE_COLUMNAcción

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

Parámetros de entrada

columnstringObligatorio
Name or identifier of the column to unroll.
handlestringObligatorio
Unique sheet handle/identifier.
splitBystring
Delimiter to split the column values by (e.g., ',' or '|'). If not provided, the column must already be of an array type.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Upload from URLGIGASHEET_POST_UPLOAD_URLAcción

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.

Parámetros de entrada

urlstringObligatorio
Public or pre-signed URL of the file to ingest.
namestring
Optional friendly filename to display in Gigasheet.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Set Dataset Client State VersionGIGASHEET_PUT_DATASET_HANDLE_CLIENTSTATE_VERSIONAcción

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.

Parámetros de entrada

handlestringObligatorio
Unique identifier for the dataset handle.
versionstringObligatorio
Client state version identifier to apply.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Update cell by column name and rowGIGASHEET_PUT_DATASET_HANDLE_COL_ROW_BY_NAMEAcción

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.

Parámetros de entrada

rowintegerObligatorio
Row number to update (1-based index).
valueanyObligatorio
New value to set for the specified cell. Can be any valid JSON value.
columnstringObligatorio
Name of the column to update. Must uniquely match an existing column.
handlestringObligatorio
Unique identifier (handle) of the dataset.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Share fileGIGASHEET_PUT_FILE_HANDLE_SHARE_FILEAcción

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

Parámetros de entrada

emailsstring[]Obligatorio
List of recipient email addresses to invite
handlestringObligatorio
Unique file handle to share
messagestring
Optional message to include in the share invitation
permissionsinteger[]Obligatorio
List of permission codes to grant (e.g., [0] for view)

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Create/Update Filter TemplateGIGASHEET_PUT_FILTER_TEMPLATES_FILTER_HANDLEAcción

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.

Parámetros de entrada

sheetstring
Optional sheet/dataset handle to associate the saved filter template with. Required by API when creating a new saved filter.
filterModelobjectObligatorio
Arbitrary JSON object defining the filter conditions per the Gigasheet Filter Model schema. Must include a top-level `_cnf_` array of OR groups.
filter_handlestringObligatorio
Handle of the saved filter to create or update. Must be lowercase hex + digits + underscores.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not