How do I connect Gigasheet?

Sign up for Conductor Deck, then add a Gigasheet step to a workflow on the visual canvas. The builder walks you through the connection it needs — an account authorization or the required keys — right inside the step. No separate setup or code.

Yes — Conductor Deck has a free tier you can build and run workflows on, with no credit card required. Paid plans raise the monthly run limits and add advanced features when you need them.

What's the difference between a trigger and an action?

A trigger is the event that starts a workflow — for example, a Stream Deck button press or an incoming event from a connected app. An action is a step the workflow performs once it runs. A workflow is one trigger followed by one or more actions.

Gigasheet + Stream Deck

spreadsheets · analytics · 0 triggers · 150 actions

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. Add Gigasheet to your Stream Deck workflows with guided setup for the connection details it needs.

Build a Gigasheet workflow — free See how it works

No code
Free tier
One Stream Deck press
Pairs with OBS & Elgato tools
OAuth & keys handled in-builder

Popular ways to use Gigasheet

Add Gigasheet to a workflow and pair it with a Stream Deck button to run it in one press — handy for spreadsheets tasks. Combine it with OBS, your Elgato tools, or any other app you connect to build a routine that fits how you work.

Browse all templates

Triggers & actions

Steps your workflow can perform in Gigasheet.

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 aggregations are available for complex counting scenarios. Common use cases: - Count all rows in a dataset - Count rows matching specific filter conditions - Count grouped rows in pivot tables - Validate filter results before exporting data For detailed information on constructing filter models, refer to the Gigasheet Filter Model Detail Guide at https://gigasheet.readme.io/reference/post_dataset-handle-count-rows

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 patterns and trends - Ask questions about specific columns or values - Request analysis of data relationships - Extract key insights from large datasets Note: Requires write access to the target sheet.

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. Before using this tool: 1. Obtain valid handles for both the source and reference datasets 2. Identify the column IDs (A, B, C, etc.) in both sheets using GIGASHEET_GET_DATASET_HANDLE_COLUMNS 3. Ensure the columns you're matching have compatible data types The lookup will create a new column in the source sheet with values from the reference sheet where matches are found.

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 columns by letter (e.g., 'A', 'B', 'C') using the 'formula' parameter. The 'literalFormula' parameter can be provided alongside 'formula' for documentation purposes to show the human-readable column names, but cannot be used alone. Formula syntax supports: - Column references: A, B, C (required, use column letters) - Arithmetic operations: +, -, *, / - Functions: UPPER(), LOWER(), CONCATENATE(), etc. - Example: "A * 2", "UPPER(B)", "CONCATENATE(B, C)" Before using this tool: 1. Obtain a valid dataset handle using GIGASHEET_POST_UPLOAD_URL or GIGASHEET_GET_DATASET_HANDLE 2. Use GIGASHEET_GET_DATASET_HANDLE_COLUMNS to identify column letters for formula construction 3. Construct the appropriate formula expression based on your calculation needs

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 needs to be specified.

Get Library Files

Tool to retrieve all datasets and files in the user's Gigasheet library. Returns all datasets owned by the user at any folder depth, files directly shared with the user, and IDs of files the user has shared. Use this to get a complete overview of all accessible files and their metadata including status, sharing permissions, and file properties.

List All Datasets

Tool to retrieve all datasets owned by the user at any folder depth. Returns a list of datasets with their metadata. The API may trim certain fields to keep response size manageable. Use the 'types' parameter to filter by dataset type (sheet or export).

List Datasets by Handle

Tool to list files and datasets in a given Gigasheet location. Use when you need to browse the contents of a parent dataset or folder, optionally filtering by type (sheet or export). Supports pagination for large result sets. Returns metadata about each file including handle, name, size, status, and timestamps.

About Gigasheet

spreadsheetsanalytics

How to connect

Sign up for free

Create your Conductor Deck account: no credit card required.

Connect Gigasheet

Follow the setup prompts for Gigasheet. Conductor Deck handles the app authorization or required connection details inside the workflow builder.

Build a workflow

Add a Gigasheet action to your visual workflow canvas. Configure the options you need, then connect it to other steps.

Assign to Stream Deck

Sync your workflow to any Stream Deck button. Press once to trigger the entire sequence.

Frequently asked questions

How do I connect Gigasheet?: Sign up for Conductor Deck, then add a Gigasheet step to a workflow on the visual canvas. The builder walks you through the connection it needs — an account authorization or the required keys — right inside the step. No separate setup or code.
Is it free?: Yes — Conductor Deck has a free tier you can build and run workflows on, with no credit card required. Paid plans raise the monthly run limits and add advanced features when you need them.
What's the difference between a trigger and an action?: A trigger is the event that starts a workflow — for example, a Stream Deck button press or an incoming event from a connected app. An action is a step the workflow performs once it runs. A workflow is one trigger followed by one or more actions.

Automate Gigasheet with your Stream Deck

Get started free View pricing

Similar integrations