Skip to main content

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.

@Respect Voters I can’t think of any way to do this with a Google Sheets trigger, as the trigger event doesn’t return any field that indicates whether the row is a new or an undated one. Is there any reason you couldn’t use a Zapier Table instead of a Google Sheet for this workflow? Zapier Tables does offer separate triggers for:

  1. New Record
  2. New or Updated Record
  3. New or Updated or Deleted Record
  4. Updated Record

@Respect Voters I can’t think of any way to do this with a Google Sheets trigger, as the trigger event doesn’t return any field that indicates whether the row is a new or an undated one. Is there any reason you couldn’t use a Zapier Table instead of a Google Sheet for this workflow? Zapier Tables does offer separate triggers for:

  1. New Record
  2. New or Updated Record
  3. New or Updated or Deleted Record
  4. Updated Record

Interesting thought. I have a lot of volunteers whose permissions are managed through Google. Asking them to join another platform is untenable. Is there a way to “sync” a Zapier Table with a Google Sheet without using a million zaps?