How to grab email address from google sheet and send a front message using all the emails in the cell

How To
1

I have email addresses in a Google Sheets, How to map all the emails that are in the google sheet cell to the “To” field in Front.

Example:
In the googlesheets cell I have hector@someemail.com;erick@someemail.com
Need to read that cell grab the two emails and map it to the “to” field

If I do it directly an erros occurs.

[400] Bad request: The request contains an invalid resource
Reason:
hector@someemail.com;erick@someemail.com is an invalid email handle.

2

Hi @Hector_Rojo_Duran

I think in the gmail to option accept array with email id.
image

Please use split function to make email array
{{split(“hector@someemail.com;erick@someemail.com”; “;”)}}

image

If you need further help in implementation, please contact us.
MSquare Support
Visit us here
Youtube Channel

2 Likes
3

Thank you, it works properly using the split function

4

I have solved the problem of sending the emails, But know the attachements are thowing this error.
Excel cannot open the file ‘file.xlsx’ because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

In the scenario, I am using an iterator and array integrator to get the files on a slack msg and attach them to the email.
Screenshot 2023-09-11 at 15.47.48

any advise?