If you have a Zap that triggers from a new or updated row in a Google Sheet, and the Zap is off while rows are added to the sheet then it wont trigger from the changes when it's turned back on.
Luckily, there's a really easy way to make the Zap 'see' the changes by using the version history of the sheet.
- Turn your Zap OFF
- Go to your Sheet. Click file > Version History > See Version History. Choose a version from before the changes were made and click 'Restore this Version'.
- Turn the Zap back ON
- Go back to the version history and restore the most recent version of the sheet
When you do this the Zap will 'see' the changes made to the sheet and will trigger from any rows that were added/updated between the two versions!