Upsert row
The Google Sheets Upsert Row tool allows you to add or update rows in a Google Sheets spreadsheet seamlessly. It simplifies data management by enabling automatic insertion or updating of row data based on a specified key column.
Features
- Supports inserting new rows if the key value does not exist.
- Automatically updates existing rows based on the specified key column without duplicating data.
- Allows selection of specific Google Drive folders or Shared Drives for spreadsheet storage.
- Enables targeting specific worksheets within a spreadsheet using worksheet IDs.
- Supports custom expressions for dynamic row data insertion and updates.
Benefits
- Enhances data accuracy by preventing duplicate entries.
- Saves time with automated row insertion and update processes.
- Improves workflow efficiency through integration with Google Sheets API.
- Provides flexibility in managing data across multiple sheets and drives.
- Reduces manual errors by automating spreadsheet data operations.
Description
Upsert a row of data in a Google Sheet. See the documentation
IMPORTANT: The arguments have specific formats. Please follow the instructions below:
- insert: Return JSON in this format: string[]
Parameters
7 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-upsert-row, 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-upsert-row, 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-upsert-row, propName: worksheetId. |
| insertrequired | string[] | Insert statement: the row data you want to add to the Google sheet if the key doesn't exist. If the key does exist and Update is not set, the row will be updated using this array. Enter individual cell values or enter a custom expression to pass an array with each element representing a cell/column value (e.g. |
| columnrequired | string | The column of the sheet to lookup (e.g. |
| value | string | The value of the key to search for in Key Column. Defaults to the value in Insert's "key" column if left blank. |
| updates | object | Update statment: if the spreadsheet contains duplicate key Value in some row in the specified Column, individual cells in the first duplicate row will be updated using this object's column-value pairs.<br /> Enter the column name for the key (e.g. |