Hey, having issues with my clay to sheet integration - can you help why it's overwriting every row everytime I run it?
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
Great! Let me know if you have more questions.
.png)