mcp-gsheetsTools Reference
sheets_insert_date
Insert date values into cells
sheets_insert_date
Insert a date value into a cell with proper formatting.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The spreadsheet ID |
range | string | Yes | Cell to insert date (e.g., "Sheet1!A1") |
date | string | Yes | Date in ISO format (YYYY-MM-DD) |
format | string | No | Date format pattern |
Example
{
"tool": "sheets_insert_date",
"arguments": {
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"range": "Sheet1!A1",
"date": "2024-12-19",
"format": "YYYY-MM-DD"
}
}