Insert dimension
The Google Sheets Insert Dimension tool provides a seamless way to add rows or columns to your spreadsheets programmatically. Leveraging Google's Sheets API, it allows precise control over where and how dimensions are inserted, enhancing your data organization capabilities.
Features
- Insert rows or columns into Google Sheets at specified positions.
- Choose to inherit formatting and properties from adjacent rows or columns.
- Supports insertion by specifying start and end indices for precise control.
- Compatible with both personal drives and shared drives for flexible file management.
- Integrates easily with Pipedream for streamlined automation workflows.
Benefits
- Save time automating spreadsheet modifications without manual edits.
- Maintain consistent formatting by inheriting styles from adjacent dimensions.
- Improve data management by inserting dimensions exactly where needed.
- Increase efficiency by integrating with automated workflow platforms like Pipedream.
- Facilitate collaboration by supporting shared drives alongside personal Google Drive.
Description
Insert a dimension into a spreadsheet. See the documentation
Parameters
6 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | Defaults to You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-insert-dimension, 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-insert-dimension, propName: sheetId. |
| dimensionrequired | enum | The dimension to insert |
| startIndex | integer | The start (inclusive) of the span, or not set if unbounded |
| endIndexrequired | integer | The end (exclusive) of the span |
| inheritFromBeforerequired | boolean | Whether dimension properties should be extended from the dimensions before or after the newly inserted dimensions. True to inherit from the dimensions before (in which case the start index must be greater than 0), and false to inherit from the dimensions after. For example, if row index 0 has red background and row index 1 has a green background, then inserting 2 rows at index 1 can inherit either the green or red background. If inheritFromBefore is true, the two new rows will be red (because the row before the insertion point was red), whereas if inheritFromBefore is false, the two new rows will be green (because the row after the insertion point was green). |