Connect Google Sheets to ChatGPT
Give ChatGPT governed access to Google Sheets’s 21 tools through Runlayer, with identity, policy, scanning, and audit on every call.
Set up
Add Google Sheets to ChatGPT in four steps
Admins approve the server once. Everyone in ChatGPT then gets it through the same governed connection.
- 1
Approve Google Sheets in Runlayer
Add Google Sheets from the catalog and choose who can use it and which of its tools are allowed.
- 2
Connect ChatGPT to Runlayer
Admins publish the Runlayer Plugin and its skill to the whole ChatGPT organization. With direct tool listing turned on for your deployment, Google Sheets’s 21 tools show up in ChatGPT’s own tool list.
ChatGPT setup guide - 3
Sign in to Google Sheets
Sign in the way Google Sheets requires. Runlayer holds the credentials so they stay out of the client’s configuration.
- 4
Use Google Sheets from ChatGPT
Google Sheets’s approved tools appear in ChatGPT. Every call is checked against policy and recorded.
Tools
21 Google Sheets tools in ChatGPT
Runlayer policy decides which of these ChatGPT users can call. 4 read data only and 4 can change or delete data.
Add sheet
Add a new sheet (tab) to an existing spreadsheet.
Append
Append data to a spreadsheet.
Autofill
Extend a formula or detected series from a source range into a larger destination range (like dragging the fill handle).
Clear
Clear the values in a range while leaving the rows, columns, and formatting in place.
Clear filter
Remove a sheet's filter, restoring any rows it was hiding.
Create
Create a new spreadsheet.
Create filter
Turn on filtering over a range of a sheet (the funnel button in the Sheets UI), so rows can be sorted and filtered by column.
Delete rows
Delete rows from a sheet, shifting the rows below them up.
Control
What Runlayer can see and stop in ChatGPT
Some controls apply to every client at the gateway. Others depend on what ChatGPT exposes to Runlayer.
Gateway policy (available)
Every Google Sheets call from ChatGPT passes through Runlayer, where your policies can allow, alert, mask, or block it.
Audit trail (available)
Each call is recorded with the user, ChatGPT as the client, the tool, and the policy and scanner decisions.
Compliance API import (available)
OpenAI Compliance Logs Platform imports ChatGPT web chats for review.
Managed browser extension (available)
Managed Chrome, Edge, and Firefox deployments can monitor supported web-chat activity and apply prompt-time controls where the surface permits it.
Native enforcement adapter (not available)
Runlayer has no device-side adapter for ChatGPT yet, so control happens at the gateway.
Frequently asked questions
Connect more