runelay+Google SheetsIntegration · OAuth login
Google Sheets on Runelay, an open source MCP gateway
Your agents keep spreadsheets current: build a sheet from data, read a range in A1 notation and write or append rows.
Built into Runelay
Runelay calls the Google Sheets API itself with your Google token, with no third-party MCP server in between. account_whoami shows which Google account is connected.
Tools
- Create.
create_spreadsheetmakes a spreadsheet, optionally with a header row and rows already filled, and returns its URL. - Read.
get_valuesreads a range in A1 notation, such asSheet1!A1:C10. - Overwrite.
update_valueswrites rows into a range, parsed as if you typed them, so formulas and dates work. - Append.
append_rowsadds rows after the last row of the table in a range.
Try asking
- “Create a spreadsheet with this week's open bugs: title, owner and priority.”
- “Read Budget!A1:D20 and tell me which line is over plan.”
- “Append today's signups to the Signups tab.”
How it signs in
- Google OAuth through the Runelay broker. No Google Cloud project of your own; Runelay renews the token.
- Scopes:
spreadsheets,drive.file, plusopenid,userinfo.emailanduserinfo.profile.
What this connection does
Agents find these tools with search_tools and run them with call_tool, so they only enter the context when a task needs them.
Connect Google Sheets
Open the connectors in the panel
Pick Google Sheets from the catalog.
Log in once
A browser tab opens on Google Sheets. Approve the access and close it.
Done
The token is stored encrypted on your server and refreshed by Runelay. Every agent with a Runelay key can use the connection.
Use Google Sheets in your agents
Agents do not need a Google Sheets entry of their own. Point each one at Runelay and Google Sheets is there.
Questions
Can it write formulas?
Yes. Values are written as if typed, so =SUM(B2:B9) becomes a formula and dates become dates.
Can it work on spreadsheets it did not create?
Yes, if your account can open them. The spreadsheets scope covers your Google Sheets.
What is A1 notation?
The tab name plus a cell range, such as Sheet1!A1:C10. Every read and write takes a range like that.