How to work with Google Sheets – MCP tools

sheets_append_values
mcp-gsheets
Add rows of data to a specified table in Google Sheets using a spreadsheet ID and A1 notation range. Choose how data is interpreted and inserted for precise control.
MIT License
sheets_copy_to
mcp-gsheets
Copy a specific sheet from one Google Sheets spreadsheet to another by specifying source and destination spreadsheet IDs and the sheet ID to transfer.
MIT License
sheets_delete_sheet
mcp-gsheets
Remove unwanted sheets from a Google Sheets document by specifying the spreadsheet ID and sheet ID, streamlining document organization and management.
MIT License
delete_sheets_tool
google-sheets-mcp
Remove unwanted sheets from a Google Spreadsheet by specifying the spreadsheet name and sheet names to delete.
sheets_insert_sheet
mcp-gsheets
Add a new sheet to a Google Sheets spreadsheet by specifying its title, position, and dimensions. Requires the spreadsheet ID for integration.
MIT License
sheets_create_spreadsheet
mcp-gsheets
Create a new Google Sheets spreadsheet with customizable titles, sheet configurations, and predefined rows and columns through the mcp-gsheets server.
MIT License

Interested in MCP?

Join the MCP community for support and updates.