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.

Free plan available · No credit card · OAuth connect

What the Google Sheets Agent does

Six ways the agent makes your spreadsheets work harder.

Reads your data

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

Writes and updates rows

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

Runs SQL queries

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

Creates charts

Build charts and visualizations from your spreadsheet data automatically.

Manages sheets

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

Formats and validates

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

Three steps, two minutes

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

Step 1

Connect Google Sheets

One-click OAuth. Choose which spreadsheets and folders to grant access to.

Step 2

Share your data

Tell the agent which spreadsheets to work with and what each one tracks.

Step 3

Start analyzing

Ask the agent to pull data, generate reports, or update records — all from chat.

Powerful workflows, out of the box

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

Daily metrics updateSchedule

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

Cron: weekdays 8amFetch data from APIsUpdate spreadsheet rowsPost summary to Slack
Log new dealsTrigger

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

Stripe: payment receivedExtract deal detailsAppend row to sheetUpdate totals
Generate a reportButton

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

Select spreadsheetRun SQL queryGenerate summaryCreate chart
Weekly data cleanupSchedule

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

Cron: Sunday 8pmScan all sheetsFlag issuesAuto-fix simple errors

Every Google Sheets action, available as a tool

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

25tools
4categories
1API

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

Your data, your rules

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

Spreadsheet-level access

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

Read-only option

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

Pause in one click

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

Revoke anytime

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

Questions, answered

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.

Your spreadsheets, supercharged.

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

No credit card required · OAuth connect · Revoke anytime