Loading...
Read, write, and manage Google Sheets spreadsheets. Create sheets, read ranges, append rows, and batch update cells.
claude mcp add google_sheets --url https://datafaucet.dev/api/mcp/t/google-sheets
Paste into your client's MCP configuration file · most users connect in under 60s
GET endpoints
get_spreadsheet
Get spreadsheet metadata including title, sheets list, and properties. Returns sheet names and IDs for use with other operations.
https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}
get_values
Read values from a range (e.g. 'Sheet1!A1:D10'). Returns a 2D array of cell values. Empty cells are returned as empty strings.
https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}
PUT endpoints
update_values
Write values to a range. Values should be a 2D array like [["A","B"],[1,2]]. Overwrites existing data in the range.
https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}?valueInputOption=USER_ENTERED
POST endpoints
append_rows
Append rows to the end of a sheet. Finds the last row with data and inserts below it. Great for logging or adding records.
https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append?valueInputOption=USER_ENTERED&insertDataOption=INSERT_ROWS
batch_get_values
Read multiple ranges in one request. Pass comma-separated ranges. More efficient than multiple get_values calls.
https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchGet?ranges={ranges}
clear_values
Clear all values from a range without deleting the cells. Formatting is preserved.
https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchClear
create_spreadsheet
Create a new spreadsheet with a title and initial sheet name. Returns the new spreadsheet ID and URL.
https://sheets.googleapis.com/v4/spreadsheets
Run this in your terminal:
claude mcp add google_sheets https://datafaucet.dev/api/mcp/t/google-sheets
Connect Google Sheets to your AI agent in under 60 seconds. No account required.
{notion_token}) with your real credentialsNeed API keys? Try our free sandbox templates first to see MCP in action with zero setup.
Replace these placeholders with your real values before deploying:
{access_token}API settings page{range}Your value{ranges}Your value{sheet_name}Your value{spreadsheetId}Resource identifier{title}Your value{values}Your valuePreview:
GET https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId} Authorization: Bearer {access_token}
claude mcp add google_sheets --url https://datafaucet.dev/api/mcp/t/google-sheetsWhat your AI agent sees
I have access to 7 tools from Google Sheets: get_spreadsheet, get_values, update_values, and 4 more.
“Get spreadsheet metadata including title, sheets list, and properties. Returns sheet names and IDs for use with other operations.”
Calling get_spreadsheet... Done. Here are the results.
Try these prompts
“Get spreadsheet metadata including title, sheets list, and properties. Returns sheet names and IDs for use with other operations”
Copy“Read values from a range (e.g. 'Sheet1!A1:D10'). Returns a 2D array of cell values. Empty cells are returned as empty strings”
Copy“Write values to a range. Values should be a 2D array like [["A","B"],[1,2]]. Overwrites existing data in the range”
CopyClick any prompt to copy, then paste into your AI client.