Add multiple rows
The Google Sheets Add Multiple Rows tool enables seamless addition of multiple rows of data to any specified Google Sheets spreadsheet and worksheet. It simplifies bulk data entry, boosting productivity and data management efficiency.
Features
- Append multiple rows of data to a specific Google Sheets worksheet at once.
- Supports selection between My Drive and Shared Drive for file storage.
- Allows specifying target spreadsheet and worksheet via their IDs or selection.
- Option to reset the formatting of newly added rows to default styles for consistent appearance.
- Includes detailed documentation and easy configuration steps for effortless integration.
Benefits
- Streamlines bulk data input, saving time and reducing manual effort.
- Enhances data consistency by standardizing row formatting automatically.
- Improves workflow automation by integrating seamlessly with existing Google Drive setups.
- Enables precise control over spreadsheet and worksheet selection for flexibility.
- Simplifies complex data management tasks, making Google Sheets more powerful and user-friendly.
Description
Add multiple rows of data to a Google Sheet. See the documentation
Parameters
5 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | Defaults to |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID |
| worksheetIdrequired | string | Select a worksheet or provide a worksheet ID |
| 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. |
