runelay

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_spreadsheet makes a spreadsheet, optionally with a header row and rows already filled, and returns its URL.
  • Read. get_values reads a range in A1 notation, such as Sheet1!A1:C10.
  • Overwrite. update_values writes rows into a range, parsed as if you typed them, so formulas and dates work.
  • Append. append_rows adds 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, plus openid, userinfo.email and userinfo.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

  1. Open the connectors in the panel

    Pick Google Sheets from the catalog.

  2. Log in once

    A browser tab opens on Google Sheets. Approve the access and close it.

  3. Done

    The token is stored encrypted on your server and refreshed by Runelay. Every agent with a Runelay key can use the connection.

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.

Try it on your machineFree and open source. Runs on your computer or your server.
Download runelayInstall on your server