---
title: "Google Sheets integration for LuumenAI"
url: "https://www.luumen.ai/integrations/google-sheets/"
entity: SoftwareIntegration
category: "Productivity & files"
audience: "SRE, DevOps, platform engineering, IT operations"
---

# Google Sheets integration for LuumenAI

Read the trackers your team lives in, and add to them with approval

## What LuumenAI can do with Google Sheets

LuumenAI connects to Google Sheets with OAuth 2.0 and exposes 50 tools (17 read-only · 26 write · 7 destructive). For connected tools, admins configure which actions may run automatically and which require approval, within the access granted to the user.

## Key facts

- Authentication: OAuth 2.0
- Tools available: 50 tools (17 read-only · 26 write · 7 destructive)
- Deployment: scoped as part of your Pilot, Platform, or Managed rollout
- Category: Productivity & files

## About Google Sheets with LuumenAI

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.

## Example tools

Read-only (17 in total):

- `GOOGLESHEETS_AGGREGATE_COLUMN_DATA` — Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
- `GOOGLESHEETS_BATCH_GET` — Retrieves data from specified cell ranges in a Google Spreadsheet.
- `GOOGLESHEETS_EXPORT_DRIVE_FILE` — Export an entire native spreadsheet as XLSX, ODS, PDF, ZIP, CSV, or TSV; use Export Sheet as PDF for print layout and range controls.
- `GOOGLESHEETS_EXPORT_SHEET_AS_PDF` — Render one sheet tab or rectangular range as PDF with orientation, gridline, margin, and fit-to-width controls.
- `GOOGLESHEETS_GET_CONDITIONAL_FORMAT_RULES` — List conditional formatting rules for each sheet (or a selected sheet) in a normalized, easy-to-edit form.
- `GOOGLESHEETS_GET_DATA_VALIDATION_RULES` — Extract data validation rules from a Google Sheets spreadsheet.
- `GOOGLESHEETS_GET_DRIVE_FILE_METADATA` — Get JSON metadata for one Drive file without downloading its content.
- `GOOGLESHEETS_GET_SHEET_NAMES` — Lists all worksheet names from a specified Google Spreadsheet (which must exist), useful for discovering sheets before further operations.

Write and destructive (33 in total, subject to configured approval policy):

- `GOOGLESHEETS_ADD_SHEET` — Adds a new sheet to a spreadsheet.
- `GOOGLESHEETS_APPEND_DIMENSION` — Append new rows or columns to a sheet, increasing its size.
- `GOOGLESHEETS_AUTO_RESIZE_DIMENSIONS` — Auto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions.
- `GOOGLESHEETS_BATCH_CLEAR_VALUES_BY_DATA_FILTER` — Clears one or more ranges of values from a spreadsheet using data filters.
- `GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER` — Update values in ranges matching data filters.
- `GOOGLESHEETS_CLEAR_BASIC_FILTER` — Clear the basic filter from a sheet.
- `GOOGLESHEETS_CLEAR_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.
- `GOOGLESHEETS_CREATE_CHART` — Create a chart in a Google Sheets spreadsheet using the specified data range and chart type.

## Frequently asked 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?

For connected tools, admins configure which actions may run automatically and which require approval, within the access granted to the user.

### 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.

Full page: https://www.luumen.ai/integrations/google-sheets/