Best answer

How do I send emails to multiple recipients from Google Sheets using Zapier?

  • 6 September 2023
  • 2 replies
  • 300 views

Userlevel 1

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?

icon

Best answer by Troy Tessalone 6 September 2023, 15:33

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @mikenco 

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:

 

Userlevel 6
Badge +8

I’d consider using tables.zapier.com or the Storage by Zapier app as alternatives