Gigasheet integratie

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 source sheet to the target sheet based on column names, with opti…

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 HTTP endpoint for each row (or batch of rows) in your dataset, ex…

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 costs before running an enrichment - Understand resource require…

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 possible for tasks that are still in progress (not yet complete…

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 connection statuses.

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 dataset based on specific column combinations.

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 understanding data distribution and cardinality before performin…

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 be specified. Advanced features like pivot mode, grouping, and…

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 such as time range, users, action types, and categories. Non-…