Add column
Google Sheets Add Column is an efficient AI-powered tool designed to seamlessly insert new columns into your spreadsheets, streamlining data organization and management. It integrates with Google Sheets API to automate column creation based on your specified parameters.
Features
- Easily add a new column to the right of a specified existing column or at the beginning of the sheet.
- Supports selection of specific drives including Google Shared Drives for precise spreadsheet targeting.
- Allows specifying exact spreadsheet and worksheet IDs to ensure accurate editing.
- Integrates smoothly with Google Sheets API using batchUpdate for efficient updates.
- User-friendly input schema with clear parameters and detailed documentation for easy implementation.
Benefits
- Saves time by automating the tedious task of manually adding columns in spreadsheets.
- Enhances data organization and structure, improving overall spreadsheet management.
- Compatible with shared drives and multiple worksheets to fit various workflow needs.
- Reduces errors associated with manual data entry by automating column insertion.
- Easy to integrate and use with comprehensive documentation, boosting productivity immediately.
Description
Create a new column in a spreadsheet. See the documentation
Parameters
4 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | The drive containing the spreadsheet to edit. If you are connected with any Google Shared Drives, you can select it here. You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-add-column, propName: drive. |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-add-column, propName: sheetId. |
| worksheetIdrequired | integer | Select a worksheet or provide a worksheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-add-column, propName: worksheetId. |
| column | string | Insert new column to the RIGHT of this column. Leave blank to insert at start of sheet |