Integrations/Google Sheets

Control what your AI agents do in Google Sheets.

Let your team build AI agents for Google Sheets. Bollard AI controls what each one can do, spreadsheet by spreadsheet.

Google Sheets
Reporting Agent
Reporting SpreadsheetOffReadFull use
Forecast SpreadsheetOffReadFull use
Payroll SpreadsheetOffReadFull use
Delete or overwrite data
What agents can do

Set what each agent can do in every spreadsheet.

Each spreadsheet gets one of three levels: Off, Read, or Full use. Anything not allowed is denied.

Off
No access
The agent can't see the spreadsheet or that it exists.
Read
Read-only
The agent can read the cell values and tabs in that spreadsheet. It can't change anything.
Full use
Edit and update
The agent can edit cell values and add rows in that spreadsheet.

Some actions stay off until explicitly turned on

Each one removes a tab or wipes data across cells for good, so it could override the limits set on individual spreadsheets.

Deleting sheets or tabsClearing or overwriting cell ranges in bulkChanging developer metadata
Set up & manage

Connect once. Manage everyone from there.

Connect once, then control access person by person. No new keys to hand out.

Step 1 · Set up

Connect once, company-wide

An admin connects your company's Google Sheets a single time and chooses which spreadsheets it covers. Any spreadsheet left out stays out of reach for every agent.

Step 2 · Manage

Control access per person and agent

From one dashboard, set what every person and their agents can reach. Change it any time, with no new keys for anyone.

OffNo access
ReadRead-only
Full useRead and edit cell values in a single spreadsheet
Example

A reporting agent.

A reporting agent edits the Reporting spreadsheet and can read Forecast, but it can't open the Payroll spreadsheet or wipe a tab.

Reporting SpreadsheetOffReadFull use
Forecast SpreadsheetOffReadFull use
Payroll SpreadsheetOffReadFull use

Manage access

ALLOWEDReporting Agent edited a cell in Reporting
ALLOWEDReporting Agent read a value in Forecast
BLOCKEDReporting Agent tried to open the Payroll spreadsheet, denied by default

Monitor activity

The security model

Top-tier security.

Bollard AI is access control for AI agents. It sits between your agents and Google Sheets, so they never hold your Google Sheets keys and never reach Google Sheets directly.

Everything runs through Bollard AI

Agents send their requests to Bollard AI, not to Google Sheets. Bollard AI checks each one against your rules and passes only the allowed requests through.

Denied by default

Every spreadsheet starts off-limits, and wiping data in bulk is held back on top of that. An agent gets in only where you've allowed it, and anything Bollard AI doesn't recognise is refused and held for review, never waved through on a guess.

Your keys stay sealed

Your Google Sheets keys are sealed in a vault unique to your company and never shown again. Bollard AI unlocks them only for the instant an allowed request needs it.

Activity you can read

Every attempt is recorded in plain English: who or which agent, what they tried, which spreadsheet or tab, and the decision. The record is readable and can't be edited after the fact.

Questions

Google Sheets, answered.

Does connecting Google Sheets hand Bollard AI all your spreadsheets?+
Only what's connected. An admin chooses which spreadsheets Bollard AI covers, and that sets the most any agent could reach. Bollard AI doesn't browse or copy your data. It sits in front of it and checks every request the agents make, passing or blocking each one.
Can an agent wipe a tab or overwrite our data?+
Not unless you turn it on. Deleting sheets and tabs, and clearing or overwriting cell ranges in bulk, are held off by default, so an agent can edit where you allow without ever wiping data, until you explicitly allow it.
Can an agent see more than the person who owns it?+
No. An agent reaches only what its owner reaches. An explicit Off always overrides an inherited permission.
Where do our Google Sheets keys live?+
Sealed in an encrypted vault, behind a key unique to your company. It's never shown again once connected, and Bollard AI unseals it only for the instant an allowed request needs it.
What happens when an agent tries something it's not allowed to do?+
Bollard AI blocks the request before it reaches Google Sheets, and the blocked attempt lands in the activity record with the reason.
How do we connect Google Sheets?+
An admin connects the company's Google Sheets once. Bollard AI seals the connection and builds the list of spreadsheets to set rules for. From then on, all management happens in the Bollard AI dashboard.
Early access

Put your team's agents to work in Google Sheets, without the risk.

We're onboarding our first development partners now. Tell us about your setup and we'll be in touch.