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?

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

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:

 

Terms & Conditions