"Missing Value of Required Parameter"

Questions
1

:bullseye: What is your goal?

I am wanting to automatically send an email to customers who have requested to be notified when we receive inventory of an out-of-stock item. We have a google sheet with their email and item information that is connected to shopify.

:thinking: What is the problem & what have you tried?

In the Gmail module in the To spot, I have put the customer email that was taken from the Google Sheet. However, I am receiving an error saying that there is a missing parameter in that spot. I have tried deleted the module and making it again, but that does not work. Chat GPT is trying to tell me to put a bunch of iterators in the scenario but I don’t trust that.

:clipboard: Error messages or input/output bundles

Missing value of required parameter ‘to’.

:link: Create public scenario page

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

Screenshot 2026-02-12 at 12.35.36 PM.png
Screenshot 2026-02-12 at 12.35.36 PM.png2784×1876 218 KB

Invalid Reference in a Filter
2

Hi,

Please check whether you are receiving the email address from Google Sheets Search rows module or not.

If everything feels correct to you, Can you share the screenshot of output 4th module (Google Sheets: Search rows)?

3

If your sheets return no results, the email will not be available.

Simply add a filter after the search rows module:

Total number of bundles
Numeric operator: greater than
0

This prevents the rest of the scenario from continuing if there are 0 results.

You are right. An iterator would only cause more issues here, because you do not have an ARRAY to iterate.

Never trust AI to help you build a Make scenario. The best place to learn about Make are the official sources: the Make Academy and Help Centre.

— @samliew

2 Likes