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.
Still need help?
If this article did not fix the issue, Zapier has a few other options to get you the help you need:
- Contact Zapier Support. Our Support team can investigate your account to find solutions.
- Ask in the Zapier Community. Get advice from experienced Zapier users in the Zapier Community.
- Learn more about getting help. Read our guide on how to get help and support with Zapier to find the best resources for your specific problem.