Create Google Sheet
Tool ID: googledrive_sheet_create
Summary
Creates a new Google Sheet with a title and optional starting rows of values. Requires your explicit confirmation. Prefer a shared folder so teammates can open the file easily.
When to use it
- New spreadsheet — Trackers, simple tables, export-style grids.
- Seed with rows — Create the Sheet and write an initial table starting at A1.
- Put it in the right folder — Create inside a known folder id.
What you need
| Requirement | Required? |
|---|---|
| Metraclick connection | Yes |
| Tool enabled for your account | Yes |
| Google Drive credentials (with Sheets write access) | Yes |
Parameters
| Parameter | Required? | Description |
|---|---|---|
title |
Yes | Spreadsheet title. |
confirm |
Yes to create | Must be true to create the file. |
values |
No | Optional 2D table: a list of rows, each row a list of cells (text, numbers, true/false, or empty). Written starting at A1 on the first sheet. |
folder_id |
No | Destination folder id. If omitted (or root), the file stays in the connected account’s My Drive. |
Values are entered the way a user would type them in Sheets (dates and simple formulas may be interpreted by Google).
What you get back
| Field | Meaning |
|---|---|
file |
The new Sheet’s metadata and links |
rows_written |
How many rows from values were written (0 if none) |
Example prompts
Create a Google Sheet titled “Lead list” in folder id 1XyZ… with a header row Name, Email, Status and two sample rows. Confirm with me before creating it.
I confirm — create that Sheet.
Make an empty Sheet called “Q3 expenses” in our Finance shared folder. Ask me before you create it.
Tips
- Confirm clearly — Same rule as Docs: nothing is created until you approve. No dry-run.
- Shared folder — Prefer a folder id your team can access, especially with service-account credentials.
- Simple cells — Each cell should be plain text, a number, true/false, or empty — not nested objects.
- Larger data — Very large grids may hit Google API limits; start with a reasonable table.