I need some help. I have two sheets (Unproceesed and Processed) in a single googlesheet. I want the Zap to monitor and check. If Column D = “Sent via Zap” move that row (Or all rows matching the criteria) to the “Processed Tab” and add it to the end.
Any help would be appreciated.
Think about using a trigger when the sheet is updated.
Check if column d = sent via zap. If true create a new row in the processed tab ( sheet).
Clear the original row (this will delete the row)
You can see the triggers and actions at https://zapier.com/apps.
Search Google sheets.
Hope this helps.
Hi there 
Just came across this and wanted to check how things are going—did Badger’s suggestion do the trick?
Keen to ensure you’re all set so please let us know if you need any further help here! 
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.