This https://github.com/xing5/mcp-google-sheets Google Sheet MCP should work, If you follow Method A of setting up Auth but you have to convert the json file to base64 like one of their uvx + CREDENTIALS_CONFIG example.
{
"mcpServers": {
"google-sheets": {
"command": "uvx",
"args": ["mcp-google-sheets@latest"],
"env": {
// Paste the full Base64 string here
"CREDENTIALS_CONFIG": "ewogICJ0eXBlIjogInNlcnZpY2VfYWNjb3VudCIsCiAgInByb2plY3RfaWQiOiAi...",
"DRIVE_FOLDER_ID": "your_shared_folder_id_here" // Still needed for Service Account folder context
}
}
}
}