sheets_insert_date
Insert dates into Google Sheets with automatic format detection and locale support. Specify the date, range, and format type for correctly formatted entries.
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/) |