To perform an update operation on the target, you need to specify the

Initial Column Range

and

Final Column Range

fields in the Google Sheets connection. If you don't specify the values for these fields, the mapping processes incorrect rows.

To perform a delete operation on a Google Sheets target, you need to configure a data filter based on the

Range

field in the Google Sheets source. The mapping applies the filter and ensures that the delete operation targets only the specific data.