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.
Useful Links
Related Articles
Google Sheets: Internal error encountered. Error code: 500
Overview The error "Internal error encountered. Error code: 500" is returned by the Google Sheets API and is typically caused by processing a large volume of data in a single request. Resolution To resolve this issue, reduce the Batch Size value in ...UPSERT Runs Successfully but Doesn't Insert or Update Data
Overview Sometimes an integration run in Skyvia finishes with Success, but no new data is inserted or updated in the target table. This situation most often occurs when using the UPSERT operation. Why This Happens UPSERT decides whether to Insert or ...Mapping Multi-Select Fields
Overview When working with Import, Synchronization, or Data Flow integrations and needing to map multi-select fields with different values between the source and target, you can use Expression Mapping. Expression mapping allows using simple and ...A Quick Guide to Importing and Updating Audience Members in Mailchimp
Overview This article explains how to configure an UPSERT operation for the Mailchimp ListMembers object in Skyvia. This is the recommended approach for importing and updating Audience members without creating duplicates. How UPSERT Works for ...BigCommerce: The value of the column Categories has incorrect JSON format
Overview When working with the Categories field in the Product object within the BigCommerce API, it is important to format the data correctly to ensure a successful import. In the BigCommerce API, the Categories field is an array. For more ...