Mapping the RowNo Column for UPDATE/UPSERT Operations in Google Sheets
Overview
When performing UPDATE or UPSERT operations on Google Sheets data in Skyvia, the RowNo field is mandatory. RowNo is a unique auto-generated row number assigned to each row in the sheet. Skyvia uses it to identify which row to update. Without correct RowNo mapping, the integration cannot locate the target row and will fail or create duplicates.
How to Map the RowNo Column
Use Target Lookup Mapping to resolve the RowNo value based on a matching key column in the sheet.
In the example above, the Lookup Key Columns are Name and Sku, which are assumed to contain unique data. Skyvia looks up the RowNo from Sheet1 where the source Sku matches the target Name.
Behavior by Operation Type
| Operation | Match Found | No Match Found |
|---|---|---|
| UPDATE | Updates the row using its RowNo | Error: record not found |
| UPSERT | Updates the row using its RowNo | If Set null when no match found is enabled - inserts a new row with an auto-generated RowNo |
Important
The fields used as Lookup Key Columns (e.g., Sku and Name) must also be mapped to each other through Column Mapping.