Updating Lead Information in Clay: Seeking Alternatives to Avoid Duplicates
Hey Guys! Currently I have an n8n workflow that I use to capture visitors from my website, calculate a Score System based on some rules and them add this lead on Clay. Sometimes a lead will return to my website and do stuff like clicking in a button or view a page, so I need to update it's information (leadscores) on my Clay table. That would be the best scenario. But I don't know how to update row's information, it only allows me to add new ones. I lookup for solutions on Clay's community, but don't find it. Anyone have an idea about alternatives? Right now what happens is that when a lead return to the website, Clay generate a new row and leads are been duplicated. I thought on sending leads to a Google Sheets and them mirror that sheet with Clay, but looks like it's not possible too. Clay just interact with external sources, but external sources can't interact with Clay cause we don't have API endpoints available to manipulate data inside Clay. That would be a nice feature!