Hi, we have a private contact form which mortgage advisers can submit information. This info needs to go to several people. I use web hooks to gather the data and compile an email to be sent via gmail. All good.
Here’s the odd bit, the list of recipients occasionally changes. So, I have created a list of recipients in a google sheet, which can be accessed and modified by the admin staff. When the form is submitted, I need the zap to send the info to the email addresses listed on the sheet. Is this possible?
Best answer
How do I send emails to multiple recipients from Google Sheets using Zapier?
Best answer by Troy TessaloneBest answer by Troy Tessalone
Hi
Good question.
Yes, you’ll need to add another column in the GSheet to search by.
e.g. USE with values of NO/YES.
Then you can use one of these options:

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.