I can start a zap with Google Sheets. The trigger options include “New Row” and “New or Updated Row”, but not just “Updated Row”. We have automations that bring in data from our CRM and add new rows to Sheets with that data. What I want to be able to do is allow our volunteers to update data directly in Sheets and have that data sync back to the CRM. What I don’t want is to have a row automatically added at the top and then suddenly my zap is trying to update our CRM with info from the bottom filled row that hasn’t changed (in case any relevant data changed in the CRM, which I don’t need to update the sheet with).
I feel like there’s got to be a clever way to ignore/halt the zaps that get triggered by new rows being added while completing the zaps for when information is updated. Maybe write some code to check the lowest filled row in the sheet and compare it to the record? Would authentication be an issue? Someone has to have figured this out before.