A1 AI engineering company GitHub
Connect the Google Sheets MCP server to your AI agent Open source, MIT, on npm. Setup instructions for Claude, Cursor and Codex are in the repository; adoption questions — Telegram. GitHub repository Telegram

Google Sheets: Create a spreadsheet — MCP tool

Google Sheets MCP tool: Creates a new Google Sheets spreadsheet and returns it: spreadsheetId, spreadsheetUrl, properties (title, locale, timeZone) and sheets[] with each sheet's numeric sheetId.

Technical name: create_spreadsheet

What task it solves

I want to create a new spreadsheet.

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).

When to use it

Use this capability when you need “Create a spreadsheet” without doing the same work manually in the Google Sheets interface. It runs only when an AI client calls it.

What to provide

  • title — required. The spreadsheet title (also the Drive file name).
  • sheet_titles — optional. Tab titles to create, in order, e.g. ["Data","Summary"]. Omitted = one default sheet.
  • locale — optional. Spreadsheet locale as ISO code, e.g. "en_US" or "ru_RU" (affects number/date parsing).
  • time_zone — optional. Time zone in CLDR format, e.g. "Europe/Moscow" (affects NOW()/TODAY()).

What it returns

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).

What changes in Google Sheets

The call writes to the live spreadsheet immediately: the affected cells or properties are overwritten with the provided values. Untouched cells and properties keep their previous state, and repeating the same call converges to the same result.

Example request

Create a spreadsheet in Google Sheets. Ask for any required identifiers that are missing.

Errors and limitations

The file always lands in the authorized user's My Drive root; moving it into a folder needs the Drive API, which this server does not cover.

Access also depends on token permissions, quotas, and upstream API limits.

Related MCP tools

Technical details