Help Needed: "Missing value of required parameter 'to'" in Gmail Module

How To
1

Hi everyone,

I’m currently building a scenario in Make.com that involves sending emails using the Gmail module. However, I’m running into the following error:

BundleValidationError
Validation failed for 1 parameter(s).
Missing value of required parameter ‘to’.

Here’s the context of my setup:

  1. I’m using the Google Sheets > Get Range Values module to retrieve email addresses from column E and status from column F in my Google Sheets.
  2. The Gmail module is configured to map the email addresses from column E to the To field.
  3. I’ve verified that the email addresses in Google Sheets are properly formatted (e.g., test@example.com) and that the data is being retrieved correctly in the output of Get Range Values.
  4. Despite mapping the email addresses in the To field of the Gmail module, I keep getting the above error.

What I’ve tried so far:

  • Testing with a fixed email address in the To field (this works).
  • Verifying that the range in Get Range Values is set correctly (e.g., E2:F).
  • Ensuring that the email addresses in Google Sheets are valid and contain no extra spaces or invalid characters.
  • Running the scenario step by step to check the outputs of each module.

Does anyone know what could be causing this issue? Could it be related to how I’m mapping the To field, or is there a better way to retrieve and handle the data?

Any advice or solutions would be greatly appreciated!

Thank you!

1 Like
2

Hi @Jean-Marc_GIGLI

Could you share the output bundle of sheet module and input bundle of Gmail mail module, so that we can further assist you.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation