Consider the following rules and guidelines when you write data to a Google Sheets target:
•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.