Skip to main content
Best answer

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

  • September 6, 2023
  • 2 replies
  • 578 views

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 by Troy TessaloneBest answer by Troy Tessalone

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:

 

View original
Did this topic help you find an answer to your question?
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

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30912 replies
  • Answer
  • September 6, 2023

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:

 


shalgrim
Forum|alt.badge.img+8
  • Zapier Staff
  • 406 replies
  • September 7, 2023

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