Update rows
Google Sheets Update Rows tool allows you to efficiently update multiple rows within a specified range of your Google Sheets spreadsheet. It streamlines data management by automating batch updates directly within your spreadsheets.
Features
- Update multiple rows at once by specifying a range in A1 notation.
- Supports selecting the drive, including Google Shared Drives, for where the spreadsheet is stored.
- Requires minimal input: sheet ID, sheet name, range, and the row data arrays.
- Accepts array of arrays format for flexible input of row and column data.
- Integrates seamlessly with Pipedream workflows for automated data manipulation in Google Sheets.
Benefits
- Saves time by enabling batch updates instead of manual cell-by-cell edits.
- Enhances data consistency by updating multiple rows programmatically.
- Facilitates integration with other tools for automated and streamlined workflows.
- Supports collaboration by easily updating shared Google Sheets in multiple drives.
- Reduces errors common in manual data entry through automated updates.
Description
Update multiple rows in a spreadsheet defined by a range
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. You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-update-rows, propName: drive. |
| sheetIdrequired | string | The spreadsheet containing the worksheet to update You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-update-rows, propName: sheetId. |
| sheetNamerequired | string | Your sheet name You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-update-rows, propName: sheetName. |
| rangerequired | string | The A1 notation of the values to retrieve. E.g., |
| rowsrequired | string | Provide an array of arrays. Each nested array should represent a row, with each element of the nested array representing a cell/column value (e.g., passing |