Short answer
Why Is My Google Sheets Zap Skipping Rows?
A Google Sheets Zap skips rows when rows are inserted above headers, required trigger columns are blank, multiple rows are pasted faster than polling, or formulas populate after the trigger check. Restore a stable header row, add fresh rows at the bottom with trigger data present, and inspect Zap History before changing the spreadsheet structure.
Common causes
- Headers were renamed, duplicated, moved, or separated by blank columns.
- The trigger column is blank when the row is first created.
- Rows are sorted, inserted, or bulk-pasted in a way the trigger does not treat as new.
- A formula fills the qualifying value after the new-row event.
Diagnostic steps
- Verify the worksheet, header row, trigger column, and connected Google account.
- Create one fresh row at the bottom and populate required fields in a single edit.
- Wait a full polling interval and search Zap History by a unique cell value.
- Move delayed calculations to a later lookup or use a stable status column as the trigger.
Example
A user pastes names first and formulas fill email addresses later. The new-row trigger sees blank emails. Populate source values together or wait on a Ready status.
Caveats
Reordering columns or sorting active sheets can affect mappings. Use a staging sheet or backup before structural changes.