This issue likely occurs due to your row behavior settings in the "Lookup, Add, or Update Row" action. To fix this, you'll need to check your configuration: 1. Make sure you've properly set up your Lookup Column and Lookup Value to uniquely identify rows
2. Review your Row Behavior settings:
• If "Update row(s) if existing rows are found" is enabled, it will modify matching rows
• If you want to prevent overwriting, you can disable this settingFor the most controlled approach: ** Use a unique identifier as your Lookup Column (like an ID or email)
** Only enable "Add a row if no existing rows are found" if you want new entries
* Only enable "Update row(s) if existing rows are found" if you want to modify existing entries
Source:Google Sheets integration overview | Documentation | Clay University