Add multiple rows
Google Sheets Add Multiple Rows is a powerful AI tool that enables users to seamlessly append several rows of data to a specified Google Sheet worksheet. Designed for efficiency and ease of use, it supports adding bulk data with optional formatting reset features.
Features
- Add multiple rows simultaneously to a Google Sheet worksheet.
- Supports selection of specific drives including Shared Drives.
- Allows resetting of row formatting to default styles after adding data.
- Requires only essential parameters like sheet ID, worksheet ID, and rows data array.
- Integrates easily with workflows through Google Sheets API compatibility.
Benefits
- Streamlines bulk data entry, saving time and reducing manual effort.
- Ensures data is added accurately to the correct spreadsheet and worksheet.
- Maintains consistent formatting with automatic reset options.
- Enhances productivity by automating repetitive data upload tasks.
- Simplifies integration with existing Google Workspace tools and workflows.
Description
Add multiple rows of data to a Google Sheet. See the documentation
Parameters
5 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-add-multiple-rows, 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-multiple-rows, 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-multiple-rows, propName: worksheetId. |
| rowsrequired | string | Provide an array of arrays |
| resetRowFormat | boolean | Reset the formatting of the rows that were added (line style to none, background to white, foreground color to black, font size to 10, no bold, no italic, no strikethrough, horizontalAlignment to left). This is useful if you want to add rows to a formatted table in Google Sheets. |