Hi everyone,
I’m working on a scenario where I’m pulling property data (houses) from various online sources and automatically inserting them into a Google Sheet using Make. Along with the property address, I’m also storing a bunch of other associated info like price, square footage, bedrooms, etc.
My question is:
Is there a way to ensure that before a new row gets added, the scenario checks if the address already exists somewhere in the sheet, and if so, skips or updates it instead of creating a duplicate?
I’m trying to avoid having multiple rows with the same address. Any ideas on how to implement this check effectively in Make with Google Sheets?
Thanks in advance!