sheets_insert_date
Insert dates into Google Sheets with locale-aware formatting and automatic format detection. Supports various date formats and relative dates.
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/) |