Upsert row
The Google Sheets Upsert Row tool seamlessly integrates with Google Sheets to add or update rows of data efficiently. It simplifies data management by ensuring your spreadsheet stays current without duplicate entries.
Features
- Supports upserting rows by specifying a key column and value to identify existing records.
- Automatically updates existing rows or inserts new rows based on the key's presence.
- Allows selection of specific Drive, spreadsheet, and worksheet IDs to target precise locations.
- Customizable insert arrays enable flexible input of multiple cell values per operation.
- Includes comprehensive documentation with clear formatting requirements for smooth implementation.
Benefits
- Ensures your Google Sheets data is always up-to-date with minimal manual effort.
- Prevents duplicate data entries by intelligently managing inserts and updates.
- Integrates easily into automated workflows, saving time and reducing errors.
- Supports collaboration by allowing precise targeting of shared drives and sheets.
- Enhances data reliability and consistency across your team’s spreadsheets.
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 |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID |
| worksheetIdrequired | string | Select a worksheet or provide a worksheet ID |
| 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. |