Google Sheets MCP integration
Looks up rows, appends and upserts records, aggregates columns, applies filters and validation, and builds charts.
42actions available
Three actions you can hand over today
Every action runs live through MCP. Nothing to build, nothing to maintain.
Look up spreadsheet row
Lyro finds the first row in a Google Sheet where a cell exactly matches a search term. Whoever's asking gets the right row back instantly instead of scanning the sheet by hand.
Find and replace in spreadsheet
Lyro finds and replaces text across a Google Sheet in one pass. A bulk correction that would mean manually editing many cells happens in a single step.
Add sheet to existing spreadsheet
Lyro adds a new sheet to an existing Google Sheets spreadsheet. A fresh tab for new data is ready without anyone opening the file to create it.
How businesses use Google Sheets + Lyro
Each card is one request a support team gets, and the Google Sheets actions Lyro runs to close it.
Answer from the row that holds the number
Lyro finds the row matching what someone asked about, reads the values around it, and totals a column when the question is about the whole set, so the answer comes from the sheet as it stands now.
Look Up Spreadsheet RowGet Spreadsheet ValuesAggregate Column DataRecord data without creating a duplicate
Lyro appends the new entry, or upserts it so an existing record is updated rather than repeated, and writes a batch in one pass when a conversation produced several rows.
Append Values To SpreadsheetUpsert RowsBatch Update Spreadsheet ValuesKeep the sheet readable as it grows
Lyro sets the filter that isolates the rows in question, formats the cells that need to stand out, and adds a validation rule so future entries stay in the allowed set.
Set Basic FilterFormat CellSet Data Validation RuleStand up a new report
Lyro creates the spreadsheet or adds a tab to an existing one, and builds the chart that makes the trend visible, so a recurring report does not start with a blank file.
Create A Google SheetAdd Sheet To Existing SpreadsheetCreate Chart In Google Sheets
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 Google Sheets actions it has and picks the ones a request needs.
- 01
Connect Google Sheets
Authorize the Google Sheets 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.
- 02
Tell your agent what you need
Describe the job the way you would hand it to a teammate. Lyro maps it to the Google Sheets actions that close it and chains as many as the request needs.
- 03
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
Everything else about Google Sheets
Setup, permissions, and the limits of what Lyro can do inside Google Sheets.
Not if you use Upsert Rows, which matches on a key and updates the existing row instead of appending a second one. Create Spreadsheet Row and Append Values To Spreadsheet always add, so the upsert action is the one to prefer for anything that can arrive twice.
Every action available in Google Sheets
All 42 actions your agent can call on Google Sheets, straight from the live MCP connection.
Add sheet to existing spreadsheet
Adds a new sheet to a spreadsheet.
Aggregate column data
Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
Append dimension
Append new rows or columns to a sheet, increasing its size.
Auto-resize rows or columns
Auto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions.
Batch clear values by data filter
Clears one or more ranges of values from a spreadsheet using data filters.
Batch get spreadsheet
Retrieves data from specified cell ranges in a Google Spreadsheet.
Batch update values by data filter
Update values in ranges matching data filters.
Clear basic filter
Clear the basic filter from a sheet.
Clear spreadsheet values
Clears cell content (preserving formatting and notes) from a specified A1 notation range in a Google Spreadsheet; the range must correspond to an existing sheet and cells.
Create chart in google sheets
Create a chart in a Google Sheets spreadsheet using the specified data range and chart type.
Create a google sheet
Creates a new Google Spreadsheet in Google Drive.
Create spreadsheet column
Creates a new column in a Google Spreadsheet.
Create spreadsheet row
Inserts a new, empty row into a specified sheet of a Google Spreadsheet at a given index, optionally inheriting formatting from the row above.
Delete chart from google sheets
Delete an existing chart from a Google Sheets spreadsheet.
Delete dimension (rows/columns)
Delete specified rows or columns from a sheet in a Google Spreadsheet.
Delete sheet
Delete a sheet (worksheet) from a spreadsheet.
Find and replace in spreadsheet
Find and replace text in a Google Spreadsheet.
Format cell
Applies text and background cell formatting to a specified range in a Google Sheets worksheet.
Get conditional format rules
List conditional formatting rules for each sheet (or a selected sheet) in a normalized, easy-to-edit form.
Get data validation rules
Extract data validation rules from a Google Sheets spreadsheet.
Get sheet names
Lists all worksheet names from a specified Google Spreadsheet (which must exist), useful for discovering sheets before further operations.
Get spreadsheet by data filter
Returns the spreadsheet at the given ID, filtered by the specified data filters.
Get spreadsheet info
Retrieves metadata for a Google Spreadsheet using its ID.
Insert dimension in google sheet
Insert new rows or columns into a sheet at a specified location.
Look up spreadsheet row
Finds the first row in a Google Spreadsheet where a cell's entire content exactly matches the query string, searching within a specified A1 notation range or the first sheet by default.
Mutate conditional format rules
Add, update, delete, or reorder conditional format rules on a Google Sheet.
Search developer metadata
Search for developer metadata in a spreadsheet.
Search spreadsheets
Search for Google Spreadsheets using various filters including name, content, date ranges, and more.
Set basic filter
Set a basic filter on a sheet in a Google Spreadsheet.
Set data validation rule
Set or clear data validation rules (including dropdowns) on a range in Google Sheets.
The tools Google Sheets sits next to
Same connection, same setup. Pick the next one your team already uses.
Excel
Reads ranges and tables, appends rows, updates cells, sorts and filters data, and exports a workbook to PDF.
Alttext.ai
Generates alt text for one image or a whole page of them, searches the library by keyword, and corrects entries as images change.
Convertapi
Imports files from a URL, converts PDFs to DOCX or images, runs long jobs asynchronously, and confirms a format pair is supported.
Dreamstudio
Turns a written brief into a DreamStudio generation, guides it with a reference image, and checks which engines and credits the key has left.
Happy scribe
Happy Scribe is an automatic transcription service that converts audio and video files into accurate text.
Pandadoc
Reads recipients, fields, and pricing on a document, builds new ones from uploaded files, and keeps folders and contacts current.
Ready to connect Google Sheets?
Authorize the account and your agent has all 42 actions from the first conversation.