Symptoms
When using either the Google Sheets Lookup Spreadsheet Row or Look Spreadsheet Rows (output as Line Items) action, you see the error message "Required field "Lookup Value" (lookup_value) is missing."
This error will appear in the Zap editor when testing Zap steps or in Zap history after your Zap runs. The Zap run status will display as stopped.
Causes
This happens when the mapped field from the previous step in the Lookup Value field is blank and is required for the search to be completed.
How to fix it
To fix the issue:
- Ensure the data from the previous step is consistently sent to the currently mapped field, or replace the mapped field with one that consistently provides a value.
- If you cannot change the current mapped field, you can either:
- Add a step to set a default value as a fallback whenever your mapped field does not have data.
- Add conditional logic using a filter or branching logic with paths to your Zap. This will allow you to set what the Zap should do if your mapped value contains no value.