Invalid email address in parameter 'to'

How To
, ,
1

Hi everyone,

Context: I’m using Make (formerly Integromat) to automate sending emails based on data from Google Sheets. Specifically, you want to send different types of emails depending on the scores recorded in Google Sheets.

Issue: I’m encountering an error related to email addresses when attempting to send emails. The error message states: “Invalid email address in parameter ‘to’.”

Details:

  1. Email Address Retrieval:
    I have a Google Sheets column (Column C) that contains recipient email addresses. You need to map this column correctly in Make to send emails to the addresses listed there.
  2. Error Message:
    The error indicates that Make does not recognize or validate the email address provided. This could be due to formatting issues or incorrect mapping.

image
image455×575 19.8 KB

image
image748×543 50.7 KB

2

Hi Gabriela,
Could you make sure that the “To” field in your Gmail module is correctly mapped to the column containing recipient email addresses from your Google Sheets. Also check the formatting of the email addresses.

1 Like
3

Hi thanks for your awenser, yes they are correctly mapped…

4

Having a similar issue where I want to add emails dynamically and it rejects all formats I’ve tried from comma separated to array with this error. How is this field meant to work?

5

I believe it should look like this:

image
image520×175 8.84 KB

The email address follows the rules for the mailto: method. No names or subject with the email address. Has to be just the valid email address.

It looks to me that you need to change 1.‘2’ to 1.‘3’. 1.‘2’ is pointing to First Name and not the email address.