sheets_insert_date
Insert a date into a Google Sheets cell with automatic format detection and locale support. Choose from ISO, US, or EU date formats.
Instructions
Insert properly formatted dates in Google Sheets with locale support and automatic detection
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| date | Yes | Date to insert (supports various formats: YYYY-MM-DD, DD.MM.YYYY, MM/DD/YYYY, or relative dates like "today", "tomorrow") | |
| range | Yes | The A1 notation range to insert the date (e.g., "Sheet1!A1") | |
| format | No | Date format preference (locale=spreadsheet locale, iso=YYYY-MM-DD, us=MM/DD/YYYY, eu=DD.MM.YYYY) | locale |
| autoDetect | No | Automatically detect and parse date format (default: true) | |
| useEUFormat | No | Use semicolon separator for EU locale sheets (auto-detected from user language/context if not specified) | |
| spreadsheetId | Yes | The ID of the spreadsheet (found in the URL after /d/) |