Create Spreadsheet

Create a new Google Spreadsheet with optional initial tabs, locale/timezone settings, optional Drive folder placement, and optional initial cell values.

Overview

The Create Spreadsheet tool allows you to:

• Create a new spreadsheet with a title
• Optionally create one or more initial sheet tabs
• Optionally set spreadsheet locale and timezone
• Optionally move the spreadsheet into a specific Google Drive folder
• Optionally write initial values to a range (e.g., headers)

Prerequisites

• A connected Google Account with OAuth authentication
• Google Sheets API enabled in your Google Cloud project
• Google Drive API enabled (required if using parent_folder_id)
• Setup Guide

Usage

Basic Create

{
  "tool": "google_sheets_Create_Spreadsheet",
  "arguments": {
    "title": "Reeva Weekly Report"
  }
}

Create with Multiple Sheets/Tabs

{
  "tool": "google_sheets_Create_Spreadsheet",
  "arguments": {
    "title": "Team Dashboard",
    "sheets": [
      { "title": "Data", "row_count": 2000, "column_count": 30 },
      { "title": "Summary" }
    ],
    "timezone": "America/Los_Angeles"
  }
}

Create in a Google Drive Folder

{
  "tool": "google_sheets_Create_Spreadsheet",
  "arguments": {
    "title": "Client Tracker",
    "parent_folder_id": "0Bxxxxxxxxxxxxxxxxxxxx",
    "sheets": [{ "title": "Clients" }]
  }
}

Create and Write Initial Values (Headers)

If initial_range omits a sheet name (no !), the tool automatically writes into the first created sheet by prefixing its title.

{
  "tool": "google_sheets_Create_Spreadsheet",
  "arguments": {
    "title": "Sales Log",
    "sheets": [{ "title": "Sales" }],
    "initial_range": "A1:D1",
    "initial_values": [["Date", "Customer", "Amount", "Notes"]],
    "value_input_option": "USER_ENTERED"
  }
}

Parameters

Parameter	Type	Required	Description
title	string	Yes	Spreadsheet title
sheets	array[object]	No	Initial sheet/tab configuration (each item requires title; optional row_count, column_count)
locale	string	No	Spreadsheet locale (e.g. en_US)
timezone	string	No	Spreadsheet timezone (IANA format, e.g. America/Los_Angeles)
parent_folder_id	string	No	Google Drive folder ID to place the new spreadsheet into (requires Drive API enabled)
initial_range	string	No	A1 range to write initial_values into (must be provided if initial_values is provided)
initial_values	array[array]	No	2D array of values to write (must be provided if initial_range is provided)
value_input_option	string	No	RAW or USER_ENTERED (defaults to USER_ENTERED)

Response

Success Response

{
  "success": true,
  "message": "Spreadsheet created successfully",
  "spreadsheet_id": "1abcDEFgHIjklMNOpQrStUvWxYz",
  "spreadsheet_url": "https://docs.google.com/spreadsheets/d/1abcDEFgHIjklMNOpQrStUvWxYz/edit",
  "title": "Sales Log",
  "locale": "en_US",
  "timezone": "America/Los_Angeles",
  "parent_folder_id": "0Bxxxxxxxxxxxxxxxxxxxx",
  "sheets": [
    {
      "sheet_id": 0,
      "title": "Sales",
      "row_count": 1000,
      "column_count": 26
    }
  ],
  "initial_write": {
    "updated_range": "Sales!A1:D1",
    "updated_rows": 1,
    "updated_columns": 4,
    "updated_cells": 4
  }
}

Error Response

{
  "error": "Google Sheets API is not enabled in your Google Cloud project..."
}