Skip to main content

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?

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:

 


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