Tool
Update multiple rows
The Google Sheets Update Multiple Rows tool enables users to efficiently update several rows within a specified range in their Google Sheets spreadsheets. By leveraging the Google Sheets API, it simplifies batch editing tasks, saving time and enhancing spreadsheet management.
Features
- Allows updating multiple rows simultaneously in a Google Sheets worksheet.
- Supports specifying the exact range in A1 notation for precise data updates.
- Compatible with Google Shared Drives to select appropriate drives.
- Integrates seamlessly via Pipedream connector for automated workflows.
- Provides clear input requirements such as sheet ID, worksheet ID, range, and rows data for easy configuration.
Benefits
- Saves time by batch updating rows instead of manual editing.
- Improves accuracy by defining exact cell ranges to update.
- Facilitates automation and integration within existing workflows.
- Supports collaborative environments through Shared Drives compatibility.
- Enhances productivity with straightforward, API-based spreadsheet management.
Description
Update multiple rows in a spreadsheet defined by a range. See the documentation
Parameters
5 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | The drive containing the worksheet to update. If you are connected with any Google Shared Drives, you can select it here. |
| sheetIdrequired | string | The spreadsheet containing the worksheet to update |
| worksheetIdrequired | string | Select a worksheet or provide a worksheet ID |
| rangerequired | string | The A1 notation of the values to retrieve. E.g., |
| rowsrequired | string | Provide an array of arrays |