Google Sheets MCP server

This is a small helper program that connects your AI assistant to Google Sheets. Once it is set up, you can ask your AI in plain words to look things up, add data, or make a new spreadsheet, and it will do it. It is handy for anyone who works with spreadsheets but would rather type a sentence than click around.

What this MCP server does

You ask your AI something about your spreadsheets, like reading a range of cells or adding a new row. The AI sends that request to this helper program. The helper signs in to Google Sheets with the credentials you set up, does the work, and sends the result back. Then your AI shows you the answer or confirms the change in the chat. You never have to touch the spreadsheet yourself unless you want to.

Click to zoom

What you can do with it

• List the spreadsheets in a Google Drive folder
• Create a brand new spreadsheet with a title you choose
• Read data or formulas from any range in a sheet
• Write or overwrite values in specific cells
• Add rows or columns to a sheet
• Create, rename, or copy a tab inside a spreadsheet
• Share a spreadsheet with someone by email

Try asking your AI

• “List my spreadsheets in the folder called Reports”
• “Read the data in Sheet1 of my budget spreadsheet from A1 to C20”
• “Add a new tab called March to my sales spreadsheet”
• “Share my Q4 report with ana@example.com as a writer”

What it gives back to you

You get answers in the chat, like a list of spreadsheet names, the values from a range, or the formulas in cells. When you ask it to change something, it tells you what it did, such as which cells were updated or which tab was created. For sharing, it tells you who it worked for and who it did not. Everything shows up as normal text in your conversation.

Before you start

Who it's for

Anyone who uses Google Sheets at work, like analysts, project managers, or admins, and wants to read or update their sheets by just asking their AI.