Sheets Add Column
sheets_add_columnAdd one fully configured column, including its optional enrichment prompt, output-format instructions, context-column scope, select options, and placement. Reuse returned IDs and option IDs when inserting values; no metadata reread is needed for a column you just created. A typeLocked column cannot change type in place; use sheets_copy_column for an explicit conversion while preserving the source.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Sheet title without leading or trailing whitespace. | |
| type | Yes | Use url for website/domain/profile links (store canonical HTTPS URLs), email/phone for validated contact lists, number for quantities, checkbox for booleans, date for calendar dates, select/multi_select for bounded option catalogs, text for names, notes, identifiers and unnormalized categories. For exact CSV imports preserve original text unless conversion was requested. Never coerce identifiers, leading zeros, formatted ranges or units to numbers. | |
| prompt | Yes | ||
| sheetId | Yes | ||
| placement | Yes | ||
| optionLabels | Yes | ||
| idempotencyKey | Yes | Stable key for one logical mutation. Reuse the identical key and payload after an ambiguous outcome; different work or batches need different keys. Inspect receipts or live state before retrying. | |
| contextColumnIds | Yes | ||
| formatInstructions | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | No | ||
| column | Yes | ||
| revision | Yes | ||
| catalogues | No | ||
| changesetId | No | ||
| operationId | Yes | ||
| schemaRevision | No | ||
| createdColumnId | No |