Finance
Pull the latest forecast tab from our `Q4 Forecast` sheet and summarise the variance against actuals.
pullsgetValuesgetSheetMetadata
Google Sheets · Live
Stop copy-pasting cells into chat.
Read Google Sheets ranges, tabs, and metadata so the agent can pull from team-maintained sheets without anyone copy-pasting cells.
- Auth
- OAuth
- Access
- Read-only by default
- Plan
- Every plan
- Freshness
- Live — every call hits the Google Sheets API
- Available on
- Every plan
Examples
Questions teams actually ask.
The tools it pulls from are shown inline — every answer in Lumen cites the underlying records it read.
Ops
Read the `Suppliers` tab in the ops master sheet — flag any supplier with a lead time over 14 days.
pullsgetValues
Reporting
Append yesterday's KPI dashboard numbers to the bottom of our daily-metrics sheet.
pullsappendValues
Scope
What Lumen sees. What it can change.
Read is on by default. Every write is a separate toggle, capped per user, and logged.
Read
What Lumen reads
Lumen calls the Google Sheets API with the Google OAuth token you grant at install. Read scope by default; append is the only opt-in write.
- Spreadsheets
Metadata: title, owner, last-edited, named ranges, tab list
- Values
Read any A1-range or named range; respect formatting / unformatted values
- Filters & sorts
Read defined filter views and basic sort orders
- Charts & images
Metadata only — no rasterised content
- Sheet permissions
Who has access at what level, useful for audit checks
Write · opt-in
What Lumen can write
Lumen can append to a sheet ("add a row") if admin-enabled per workspace. Cell-level edits, formula changes, and tab creation are out of scope today.
- Append values
Append rows to a tab; respects existing data range. Admin-only opt-in
Every call is logged with user, sheet ID, operation, range, and date. Exportable as CSV.
Install
Connect in under a minute.
No keys, no call, no app marketplace fine print.
- Authorize01
Connect with Google OAuth
In Settings → Integrations → Google Sheets, click Connect. Sign in and approve the spreadsheets.readonly scope (or .file for opt-in append).
- Share sheets02
Grant access to specific sheets
By default the integration can only read sheets your Google account already has access to — there's no separate share step beyond ensuring the right people have view access.
- Ask03
Try a warm-up question
Start with "Pull the latest forecast tab from our `Q4 Forecast` sheet" — paste the URL or name and the agent will fetch the cells.
Connect Sheets. Pull live numbers, not screenshots.
Google OAuth. Read-only by default. Append opt-in.