How to Send Emails from Google Sheets: A Guide for Make.com Users

Have you ever tried to send an email to multiple recipients using email addresses from a Google Sheets cell, only to encounter an error? This is a common problem that many Make.com users face. But don't worry, there's a simple solution to this problem.

Problem

The issue arises when you try to map all the emails that are in a Google Sheets cell to the 'To' field in Front. For example, if you have the following emails in a cell: hector@someemail.com [hector@someemail.com];erick@someemail.com, and you try to read that cell and map it to the 'To' field, you'll get a [400] Bad request error. This is because the string of emails is considered an invalid email handle.

Solution

The solution to this problem is to use the split function to make an array of email ids. Here's how you can do it:

{{split("hector@someemail.com [hector@someemail.com];erick@someemail.com”; ";”)}}

This function will split the string of emails at each semicolon, creating an array of individual emails that can be correctly mapped to the 'To' field.

Troubleshooting Tips

If you're still encountering issues, make sure that the emails in your Google Sheets cell are separated by a semicolon and a space. Also, ensure that there are no extra characters or spaces in the email addresses.

Conclusion

So there you have it! With the split function, you can easily send emails to multiple recipients using email addresses from a Google Sheets cell. Remember, the key is to create an array of individual emails that can be correctly mapped to the 'To' field. Happy emailing!

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.