Symptoms
When using Google Sheets Update Spreadsheet Row in your Zaps, you see the error message "Required field "Row" (row) is missing". You may see this error in the details of a Zap run in your Zap history.
Causes
This error happens when the mapped field for the Row ID field has no value. This occurs when the previous Lookup Spreadsheet Row step cannot locate the right spreadsheet.
How to fix it
To fix this issue:
- Add a step to set a default value as a fallback whenever your mapped field does not have any data.
- Add a Filter step before your Update Spreadsheet Row step.
- Add a condition to the Zap so it does not run if a spreadsheet row is not found.
- Add a Paths step so your Zap has two paths:
- In one path, add a condition to the Zap so it runs if a spreadsheet row is found.
- In another path, add a condition to the Zap so it does not run if a spreadsheet row is not found.