Mantle Chat
All integrations
Mantle Google Sheets Agent

Your AI spreadsheet analyst

Connect Google Sheets and let AI read data, write rows, run queries, and build reports — your spreadsheets just got smarter.

Connect your Google SheetsSee all integrations

Free plan available · No credit card · OAuth connect

Available tools
25
Ready workflows
4
Tool categories
4
Shared connection
1

Capabilities

What the Google Sheets Agent does

Six ways the agent makes your spreadsheets work harder.

01

Reads your data

The agent reads values, formulas, and metadata from any sheet or range you share.

02

Writes and updates rows

Add new rows, update cells, or batch-update entire ranges with fresh data.

03

Runs SQL queries

Query your spreadsheet data using SQL syntax — filter, join, and aggregate without formulas.

04

Creates charts

Build charts and visualizations from your spreadsheet data automatically.

05

Manages sheets

Add, rename, copy, and delete sheets within your spreadsheets.

06

Formats and validates

Apply conditional formatting, data validation rules, and cell formatting.

Setup

Three steps, two minutes

Connect. Share your spreadsheets. Let the agent read, write, and analyze.

  1. 01Connect Google SheetsOne-click OAuth. Choose which spreadsheets and folders to grant access to.
  2. 02Share your dataTell the agent which spreadsheets to work with and what each one tracks.
  3. 03Start analyzingAsk the agent to pull data, generate reports, or update records — all from chat.

Workflows

Powerful workflows, out of the box

Triggered by data changes, schedules, or events from other tools.

01 · Schedule

Daily metrics update

Every morning, the agent pulls data from your tools and updates your metrics spreadsheet.

  1. 1Cron: weekdays 8am
  2. 2Fetch data from APIs
  3. 3Update spreadsheet rows
  4. 4Post summary to Slack

02 · Trigger

Log new deals

When a deal closes in Stripe, the agent adds a row to your revenue tracking sheet.

  1. 1Stripe: payment received
  2. 2Extract deal details
  3. 3Append row to sheet
  4. 4Update totals

03 · Button

Generate a report

One click to query a spreadsheet and create a formatted summary with charts.

  1. 1Select spreadsheet
  2. 2Run SQL query
  3. 3Generate summary
  4. 4Create chart

04 · Schedule

Weekly data cleanup

Every Sunday, the agent scans your sheets for duplicates, blanks, and formatting issues.

  1. 1Cron: Sunday 8pm
  2. 2Scan all sheets
  3. 3Flag issues
  4. 4Auto-fix simple errors

Toolbox

Every Google Sheets action, available as a tool

The agent can read, write, query, and format — through the official Google Sheets API.

Tools
25
Categories
4
API
1

Read data

6 tools

Fetch values, metadata, and spreadsheet info from any range.

  • Get values
  • Batch get values
  • Get spreadsheet info
  • Search spreadsheets
  • Lookup row
  • Get sheet names

Write data

7 tools

Write, append, and batch-update values across your spreadsheets.

  • Update values
  • Append values
  • Batch update
  • Create row
  • Create column
  • Upsert rows
  • Clear values

Query & analyze

6 tools

Run SQL queries, aggregate data, and manage tables.

  • Execute SQL
  • Query table
  • Aggregate column data
  • Get table schema
  • List tables
  • Find and replace

Sheets & formatting

6 tools

Manage sheets, charts, and cell formatting.

  • Add sheet
  • Delete sheet
  • Create chart
  • Format cell
  • Set data validation
  • Conditional formatting

Control

Your data, your rules

Full control over which spreadsheets the agent can access and modify.

01

Spreadsheet-level access

Share only the spreadsheets you choose. The agent cannot browse your entire Drive.

02

Read-only option

Grant read-only access for reporting without any data modifications.

03

Pause in one click

Toggle the agent off from the dashboard. All Sheets access stops immediately.

04

Revoke anytime

Disconnect Google Sheets to revoke OAuth. No residual data access.

FAQ

Questions, answered.

The practical details about access, setup, and using Google Sheets with Mantle.

Only spreadsheets you explicitly share. The agent cannot browse your Drive for sheets unless you grant access.

Write operations target specific ranges. The agent never overwrites data outside the range you specify.

The agent can read formula results and write new formulas into cells. It can also run SQL queries against your data.

Yes. The agent handles batch operations efficiently and can work with spreadsheets of any size.

Yes. The agent can create charts, aggregate data, and format cells to build visual reports inside your sheets.

Start for free — no credit card needed. The Free plan includes a usage allowance that refills every 5 hours. Paid plans unlock more usage and team features.

Keep connecting

Google Sheets is just the start.

Connect the other tools your team already uses—same workspace, shared context, and one place to discuss the result.

Explore all integrations

Google Sheets + Mantle

Your spreadsheets, supercharged.

Connect Google Sheets and let AI read, write, and analyze your data. Start on the Free plan.

Connect your Google SheetsBook a demo

No credit card required · OAuth connect · Revoke anytime