I'm having an issue with my custom quote Zap and could really use some help. Here's how my Zap is set up:
- A form is submitted through GoFormz.
- Key information from the form is checked against a lookup table in Google Sheets.
- Prewritten paragraphs from the lookup table are then used to fill a Google Docs template.
This was working fine before, but we stopped using the system for a while. Now that I’ve come back to it, the Zap isn’t working properly.
The problem:
The Zap seems to go through each lookup step like it used to, but when it gets to the Google Docs step, it just skips it and I get this error message at the end of the run:
“Google Sheets: Required field "Lookup value" (lookup_value) is missing.”
What I’ve tried:
- I know this error usually happens if a field is left blank on the form. However, I’ve checked all the lookup steps, and they’re set to “Mark successful and run steps that use this search result”.
- The Google Docs step is also set to remove any unused fields. This used to work fine — any blank data was just ignored and not copied into the quote.
- I’ve also tested the Zap step-by-step manually, and it works perfectly during tests.
- including the google docs step -
What I don’t get:
If it works in the step-by-step tests, why is the Google Docs step being skipped in a full run-through?
Any ideas on what might be causing this or how to fix it would be much appreciated!
