i have zapier setup to capture data from an Iauditor report and for that data to be added to a google sheet. My issue ism some of the data i eed, i just need it if theres a change. For example, i need to know if a store has cooler in it, if it does, we mark Yes, it captures that data and logs it. On the next visit, if the store still has the cooler, we answer yes, i dont need that to be duplicated in the sheet. Is there a way to make this happen?
Best answer by steph.nView original
@Jaime - thanks for writing to us today! Happy to help.
It sounds like you’re trying to find and update rows in Google Sheets. Could you give this a try and let me know if that was the outcome you were trying to do?