Update row
The Google Sheets Update Row tool allows users to seamlessly update specific rows within their spreadsheets, enabling dynamic data management directly through an automated connector. By integrating with Google Sheets API, this tool simplifies data editing workflows within various applications.
Features
- Update any specified row in a Google Sheet with ease.
- Supports updating within Google Drive and Shared Drives.
- Automatically handles headers for intuitive column-based updates.
- Compatible with dynamic references to spreadsheets and worksheets.
- Provides direct integration with Google Sheets API for reliable performance.
Benefits
- Enhances productivity by automating spreadsheet update tasks.
- Eliminates manual errors by programmatic data entry.
- Supports collaboration by working with Shared Drives.
- Saves time with simple configuration and dynamic row targeting.
- Improves data accuracy and consistency in workflows.
Description
Update a row in a spreadsheet. 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 enter a custom expression. When referencing a spreadsheet dynamically, you must provide a custom expression for the worksheet. |
| rowrequired | integer | Row Number |
| hasHeadersrequired | boolean | If the first row of your document has headers, we'll retrieve them to make it easy to enter the value for each column. Note: When using a dynamic reference for the worksheet ID (e.g. |