Sheets Copy Column
sheets_copy_columnCopy a consistent snapshot of a column into a new typed column. Preserve the source, omit and report invalid values, and return a durable job ID. Use get_column_copy for completion; undo the resulting add_column changeset to remove the copy.
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. | |
| sheetId | Yes | ||
| columnId | Yes | ||
| selectOptions | 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. | |
| expectedColumnVersion | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| id | Yes | ||
| error | Yes | ||
| status | Yes | ||
| sheetId | Yes | ||
| totalCount | Yes | ||
| copiedCount | Yes | ||
| failedCount | Yes | ||
| processedCount | Yes | ||
| resultColumnId | Yes |