Create a spreadsheet
create_spreadsheetCreate a new Google Sheets spreadsheet with custom title, locale, time zone, and named tabs, and get back its ID, URL, and sheet metadata for immediate use.
Instructions
Creates a new Google Sheets spreadsheet and returns it: spreadsheetId, spreadsheetUrl, properties (title, locale, timeZone) and sheets[] with each sheet's numeric sheetId. sheet_titles creates one tab per title in order (omitted = a single default "Sheet1"). The file lands in the authorized user's My Drive root — moving it into a folder needs the Drive API, which this server does not cover. Save the returned spreadsheetId: the Sheets API has no list endpoint of its own (search_spreadsheets exists, but it needs a Drive scope on the token).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| title | Yes | The spreadsheet title (also the Drive file name). | |
| locale | No | Spreadsheet locale as ISO code, e.g. "en_US" or "ru_RU" (affects number/date parsing). | |
| time_zone | No | Time zone in CLDR format, e.g. "Europe/Moscow" (affects NOW()/TODAY()). | |
| sheet_titles | No | Tab titles to create, in order, e.g. ["Data","Summary"]. Omitted = one default sheet. |