Google Sheets MCP server

This is a small helper that connects your AI assistant to Google Sheets. Once it is set up, you can ask your AI in plain words to look something up in a spreadsheet, add a row, or make a new sheet, and it will do it for you. It is handy for anyone who spends time copying numbers in and out of spreadsheets by hand.

What this MCP server does

You ask your AI something about a spreadsheet, like reading a range of cells or adding a new row. The AI sends that request to this helper running quietly on your computer. The helper signs in to Google using a special account you set up, then reads or changes the sheet you told it about. The result, like the values it found or a note that the change was made, comes back into your chat window. You never have to open the spreadsheet yourself unless you want to check it.

Click to zoom

What you can do with it

• Read values from any range in a spreadsheet you shared
• Add new rows or update existing cells
• Create a brand new spreadsheet
• Add a new sheet or tab inside a spreadsheet
• Delete a sheet or clear a range of cells
• List the sheets inside a spreadsheet

Try asking your AI

• “Read the Sales tab in my Q3 spreadsheet and tell me the total for column C”
• “Add a new row to my Expenses sheet with today's date and a note about lunch”
• “Create a new spreadsheet called Team Tracker with a sheet named Tasks”
• “Clear the old data in the Draft tab of my planning sheet”

What it gives back to you

You get answers in plain text right in the chat, like the values from the cells you asked about or a short summary of what it found. When it makes a change, it tells you what it did, for example that a row was added or a sheet was created. It does not show you the whole spreadsheet unless you ask for it.

Before you start

Who it's for

Anyone who works with Google Sheets often and wants to read or update them by just asking their AI, without clicking around.