Hi, question for updating or adding new columns to existing row in google sheets. I can export data to Google Sheets by using 'Look up, Add, update rows'. But it keeps adding the data in new rows, I want the data to be updated (or added) in the correct (already existing) row. Screenshot as example. Is that possible?
๐ค You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Hi Marlene, thanks for reaching out. It looks like you were directing your lookup function to the wrong column here. I went in and edited your column setup to lookup the validated email column and update the leads if an email is already present in the spreadsheet: https://downloads.intercomcdn.com/i/o/1192819759/b7c58f164168e33d140b13cb/CleanShot+2024-09-25+at+10_45_20.gif?expires=1727277300&signature=3f72e7b9ea2ddf0f937c8807b139231b20546c25c9aabe8346c39e14577bae14&req=dSEuFMF%2FlIZaUPMW1HO4zRDnmZxXwy6wQgL3pCNGvSQkYKp6LOllT9h5yfGJ%0AQcoF%0A This should run correctly now. If you could test this setup and let me know if it fixes your issue that would be great. I hope this was helpful. If there's anything else I can assist you with, please let me know!
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!