Google Sheets
for LuumenAI
Read the trackers your team lives in, and add to them with approval
Operations teams keep real work in spreadsheets: on-call rotas, change calendars, migration trackers, capacity notes. Connect Google Sheets and Luumen can read those sheets for context during an incident or a change window, then make the edits you ask for — adding a tab, appending rows, updating cells — as a previewed step you approve. Access uses OAuth2.
The Google Sheets toolbox
50 tools: 17 read, 33 write. Reads answer instantly. Writes require approval by default. Everything is logged.
- ReadAggregate Column DataSearches for rows where a specific column matches a value and performs mathematical operations on data from another column.
- ReadBatch get spreadsheetRetrieves data from specified cell ranges in a Google Spreadsheet.
- ReadExport Drive SpreadsheetExport an entire native spreadsheet as XLSX, ODS, PDF, ZIP, CSV, or TSV; use Export Sheet as PDF for print layout and range controls.
- ReadExport Sheet as PDFRender one sheet tab or rectangular range as PDF with orientation, gridline, margin, and fit-to-width controls.
- ReadGet conditional format rulesList conditional formatting rules for each sheet (or a selected sheet) in a normalized, easy-to-edit form.
- ReadGet Data Validation RulesExtract data validation rules from a Google Sheets spreadsheet.
- ReadGet Drive File MetadataGet JSON metadata for one Drive file without downloading its content.
- ReadGet sheet namesLists all worksheet names from a specified Google Spreadsheet (which must exist), useful for discovering sheets before further operations.
- ReadGet Spreadsheet by Data FilterReturns the spreadsheet at the given ID, filtered by the specified data filters.
- ReadGet spreadsheet infoRetrieves metadata for a Google Spreadsheet using its ID.
- ReadList Charts in Google SheetsLists all charts in a Google Sheets spreadsheet across all sheets, returning chart_id, sheet metadata, chart type, title, and position.
- ReadList Drive ChangesStart a Drive change monitor or list one page after an existing token.
- ReadLook up spreadsheet rowFinds 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.
- ReadSearch Developer MetadataSearch for developer metadata in a spreadsheet.
- ReadSearch SpreadsheetsSearch for Google Spreadsheets using various filters including name, content, date ranges, and more.
- ReadBatch Get Spreadsheet Values by Data FilterReturn one or more ranges of values from a spreadsheet that match the specified data filters.
- ReadGet spreadsheet valuesReturns a range of values from a spreadsheet.
- WriteAdd Sheet to Existing SpreadsheetAdds a new sheet to a spreadsheet. Approval by default
- WriteAppend DimensionAppend new rows or columns to a sheet, increasing its size. Approval by default
- WriteAuto-Resize Rows or ColumnsAuto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions. Approval by default
- WriteBatch Clear Values By Data FilterClears one or more ranges of values from a spreadsheet using data filters. Approval by default
- WriteBatch Update Values by Data FilterUpdate values in ranges matching data filters. Approval by default
- WriteClear Basic FilterClear the basic filter from a sheet. Approval by default
- WriteClear spreadsheet valuesClears 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. Approval by default
- WriteCreate Chart in Google SheetsCreate a chart in a Google Sheets spreadsheet using the specified data range and chart type. Approval by default
- WriteCreate a Google SheetCreates a new Google Spreadsheet in Google Drive. Approval by default
- WriteCreate spreadsheet columnCreates a new column in a Google Spreadsheet. Approval by default
- WriteCreate spreadsheet rowInserts a new, empty row into a specified sheet of a Google Spreadsheet at a given index, optionally inheriting formatting from the row above. Approval by default
- WriteDelete Chart from Google SheetsDelete an existing chart from a Google Sheets spreadsheet. Approval by default
- WriteDelete Dimension (Rows/Columns)Delete specified rows or columns from a sheet in a Google Spreadsheet. Approval by default
- WriteDelete SheetDelete a sheet (worksheet) from a spreadsheet. Approval by default
- WriteFind and Replace in SpreadsheetFind and replace text in a Google Spreadsheet. Approval by default
- WriteFormat cellApplies text and background cell formatting to a specified range in a Google Sheets worksheet. Approval by default
- WriteInsert Dimension in Google SheetInsert new rows or columns into a sheet at a specified location. Approval by default
- WriteMove or Resize Chart in Google SheetsMove or resize an existing chart on a Google Sheets spreadsheet. Approval by default
- WriteMove Spreadsheet to FolderMove an existing Google Spreadsheet to a different Google Drive folder. Approval by default
- WriteMutate conditional format rulesAdd, update, delete, or reorder conditional format rules on a Google Sheet. Approval by default
- WriteSet Basic FilterSet a basic filter on a sheet in a Google Spreadsheet. Approval by default
- WriteSet Data Validation RuleSet or clear data validation rules (including dropdowns) on a range in Google Sheets. Approval by default
- WriteSort RangeSorts data within a specified range in a Google Sheet based on one or more sort criteria. Approval by default
- WriteCopy Sheet to Another SpreadsheetCopy a single sheet from a spreadsheet to another spreadsheet. Approval by default
- WriteAppend Values to SpreadsheetAppend values to a spreadsheet. Approval by default
- WriteBatch Clear Spreadsheet ValuesClear one or more ranges of values from a spreadsheet. Approval by default
- WriteUpdate Chart in Google SheetsUpdate the specification of an existing chart in a Google Sheets spreadsheet. Approval by default
- WriteUpdate Dimension Properties (Hide/Unhide & Resize)Hide/unhide rows or columns and set row heights or column widths. Approval by default
- WriteUpdate Sheet PropertiesUpdate properties of a sheet (worksheet) within a Google Spreadsheet, such as its title, index, visibility, tab color, or grid properties. Approval by default
- WriteUpdate Spreadsheet PropertiesUpdate SPREADSHEET-LEVEL properties such as the spreadsheet's title, locale, time zone, or auto-recalculation settings. Approval by default
- WriteBatch update spreadsheet valuesSet values in one or more ranges of a spreadsheet. Approval by default
- WriteUpsert Rows (Smart Update/Insert)Upsert rows - update existing rows by key, append new ones. Approval by default
- WriteUpdate spreadsheet valuesSet values in a range of a Google Spreadsheet. Approval by default
One prompt, start to finish
What a governed Google Sheets run looks like inside Luumen.
Questions
How does LuumenAI connect to Google Sheets?
Authorize once with OAuth 2.0. Luumen lists the scopes each action needs before you approve the connection, and credentials never appear in the chat.
Can LuumenAI change things in Google Sheets on its own?
Read actions answer immediately. Anything that writes — add sheet to existing spreadsheet, append dimension, auto-resize rows or columns, batch clear values by data filter, and more — is shown as a plan and requires approval by default, including the 7 actions classified as destructive. Administrators configure that per tool, so you decide exactly which actions can ever run unattended.
Who gets access to the integration?
You decide. Actions are granted per agent, skill, and team, and per environment — production is not staging. Read access can be broad while writes stay narrow.
Is there an audit trail?
Every call to Google Sheets — read or write, approved or declined — is recorded with the actor, the input, and the result, and can be linked to the ticket or change record.
Often connected alongside
All integrations
Put Google Sheets to work with Luumen
Connect in minutes. Every action scoped, approved, and audited from day one.