Question

How to prevent Zap from triggering when Google Sheets when rows are sorted?

  • 19 December 2021
  • 1 reply
  • 118 views

I’m an “amateur” Zap user so I hope this doesn’t sound like a simple/stupid question :-)

 

I have a Google Sheet with many columns of data, including some that have dates.

I’m trying to create a Zap that sends Emails when I change the Date in one particular column.  That’s the easy part.  What I can’t figure out is how to make it so that if/when I re-sort/re-order the lines on the spreadsheet, the system doesn’t think I’ve changed the Date in EVERY row.

EXAMPLE:  

Sheet is sorted in  Alphabetical order, so the Line I change is Row 10. I understand how to make this action occur.
But if/when I re-sort the Sheet by the order of a different column, ALL the rows are reordered and the system then thinks I’ve changed the Date in ALL of the rows and the action is triggered for every row.  

I just need the action linked/tied to that one row regardless of re-sorting and so the system won’t respond every time I re-sort the Sheet.  
Does that make sense?

Any help you can provide is appreciated.


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Marcellusjr 

I’d suggest considering using Airtable instead of GSheets: https://zapier.com/apps/airtable/integrations#triggers-and-actions

Airtable has Views: https://support.airtable.com/hc/en-us/articles/202624989-Guide-to-views

Views have Sorting.

Views can be used to trigger Zaps. (e.g. Date = Today)