Gigasheet MCP integration
Puts a plain-language question to a huge dataset, cleans duplicate and broken rows, derives formula and label columns, and exports the finished view on request.
150actions available
Three actions you can hand over today
Every action runs live through MCP. Nothing to build, nothing to maintain.
Create AI chat query
Lyro creates AI-powered analyses of Gigasheet datasets to answer questions about large data tables. Support agents extract insights from complex data without writing SQL or manual calculations.
Update cell by column name and row
Lyro updates individual cells in Gigasheet datasets by specifying column name and row number. Data corrections happen instantly without navigating spreadsheet interfaces manually.
Share file
Lyro shares Gigasheet files with specific recipients to collaborate on data analysis with customers or team members. Teams distribute data insights without manual email attachments.
How businesses use Gigasheet + Lyro
Each card is one request a support team gets, and the Gigasheet actions Lyro runs to close it.
Ask a huge dataset a question in plain language
Lyro puts the question to the dataset's AI chat, reads the columns behind the answer, and counts the rows it covers, so a file too large to open still gives up a specific number.
Create AI Chat QueryGet Dataset ColumnsCount Dataset RowsClean the file before anyone works from it
Lyro removes the duplicated rows, trims the whitespace that quietly breaks a join, and drops everything outside the filter, so what someone downloads is the usable version.
Delete Duplicated Rows from DatasetTrim Column WhitespaceDelete Rows Not Matching FilterDerive the column the question actually needs
Lyro generates the formula, previews what it produces before anything is committed, and adds the conditional label column that turns raw values into the categories people ask about.
Generate AI FormulaCreate Formula PreviewCreate Conditional Label ColumnGet the result to whoever asked for it
Lyro saves the current view, starts the export, and hands back the download URL, so the person waiting gets the filtered slice rather than a link to the whole dataset.
Save Current ViewInitiate Dataset ExportGet Dataset Export Download URL
How it works
Get started in 3 steps
Connect once, then just ask. There is no workflow builder to learn and nothing to maintain — Lyro reads the Gigasheet actions it has and picks the ones a request needs.
Connect Gigasheet
Authorize the Gigasheet account your team already uses — one consent screen, no API keys, no mapping tables. Lyro can only do what you granted that account, and you can disconnect it at any time.
Tell your agent what you need
Describe the job the way you would hand it to a teammate. Lyro maps it to the Gigasheet actions that close it and chains as many as the request needs.
Watch it work
The agent runs the actions inside the conversation the customer is already in, so nobody copies data between tabs and your team can take over at any point.
Get started free
Gigasheet · Lyro
What can you do in Gigasheet without me setting anything up?
These, right away:
- Create AI chat query
- Check connector source availability
- Cancel http enrichment task
Great, let's start with the first one.
FAQ
Everything else about Gigasheet
Setup, permissions, and the limits of what Lyro can do inside Gigasheet.
Yes. Calculate Enrich Expected Credits prices the job up front, Get User Enrichment Credits reports the balance left, and Preview HTTP Enrichment shows what the enrichment returns on a sample before it runs across the whole file.
Every action available in Gigasheet
All 150 actions your agent can call on Gigasheet, straight from the live MCP connection.
Append rows to dataset
Appends rows to an existing Gigasheet dataset using column letters as keys.
Append sheet from another sheet
Append data from a source sheet to a target sheet by matching column names.
Apply http enrichment
Apply generic HTTP enrichment to a Gigasheet dataset.
Calculate enrich expected credits
Calculate expected credits for a user-defined HTTP enrichment operation.
Cancel http enrichment task
Cancel a running enrichment task.
Check connector source availability
Check if a source of the given type is available.
Combine files
Combine multiple files into a new file.
Copy file
Copy a file in Gigasheet.
Count dataset deduplication results
Count how many duplicates will be removed and how many rows remain when deduplicating.
Count dataset groups
Count the number of groups matching certain criteria in a Gigasheet dataset.
Count dataset rows
Counts rows in a Gigasheet dataset matching specified filter criteria.
Count dataset activities
Get total activity count on a given Gigasheet dataset.
Create AI chat query
AI analysis assistant for Gigasheet datasets.
Create dataset column comment
Add a comment to a column in a Gigasheet dataset.
Add comment to cell
Add a comment to a specific cell in a Gigasheet dataset.
Create conditional label column
Add a label column to a Gigasheet dataset with values based on conditional filters.
Create formula column
Create a new column based on a formula input in a Gigasheet dataset.
Edit formula column
Edit a formula column in a Gigasheet dataset.
Create formula preview
Calculate a formula preview on a Gigasheet dataset and return sample results with involved column values.
Create iterator column
Add an iterator column to a Gigasheet dataset based on current filters and order.
Create dataset liveshare
Create a new liveshare for a Gigasheet dataset.
Create dataset view
Create a new view for a Gigasheet dataset with a specified name and client state version.
Explode JSON column
Explode JSON data in a column into separate columns.
Create file aggregation
Retrieve ungrouped aggregated values for a Gigasheet file.
Create blank file
Create an empty file in your Gigasheet Library.
Create files directory
Create a new folder in your Gigasheet Library.
Create cross-file lookup
Creates a cross-file lookup to enrich data by matching values between two sheets.
Send MCP request to sheet assistant
Interact with Gigasheet Sheet Assistant via the Model Context Protocol (MCP) over HTTP.
Split column
Split a column into multiple columns based on a separator.
Delete sheet assistant logs
Delete Sheet Assistant chat history for a specific sheet.
The tools Gigasheet sits next to
Same connection, same setup. Pick the next one your team already uses.
Amplitude
Reads funnel, retention, and revenue metrics on request, annotates releases on the chart, updates cohort membership, and files GDPR deletions.
Databox
Creates Databox data sources and datasets, pushes records into them, verifies each ingestion landed, and removes what is no longer feeding a dashboard.
Hex
Triggers project runs, reports run status and rendered charts, edits draft cells, and keeps workspace collections and sharing tidy.
More trees
Reads a forest's CO2 captured and tree counts, lists the active planting projects behind them, and onboards users to a plantation account.
Ragic
Searches Ragic sheets for the record behind a question, reads its fields, and returns it as a PDF or the file attached to the row.
Tally
Reads form responses and the questions behind them, builds and edits forms from block definitions, and wires submissions out through webhooks.
Ready to connect Gigasheet?
Authorize the account and your agent has all 150 actions from the first conversation.