Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

We’re creating a simple ticketing system that collects data from a form to a Google Sheets. I want to be able to send various types of mails to the ticket creator (eg. ‘Request received, your ticket no is XXX]’; ‘Your ticket status has been changed to aabc]’.

Is there a way to dynamically load the 'To' recipient in Action Send Email in Gmail? For example, when a new ticket is created, a new row is added to the Sheets and I want to get the requester’s email address from column E to send them a confirmation (that is, I don’t want to send the notification to the same address each time).

A further requirement would be to extract data from the relevant record in the Google Sheets and provide this information in the subject and/or body of the email.

Is it possible to do this somehow?

Hi @BrianP ,

 

Yes that is all possible. You can do the following: 

 

  1. Make the Trigger New Form Response in Google Forms
  2. Use Storage by Zapier > Increment Value to add 1 to each response (so you get a ticket number)
  3. use Gmail to send the email (or whatever email provider you are currently using)

 

Does that help? 

Hi @MohSwellam. We’re not using Google Forms as it doesn’t effectively support our multi-language requirements, so the trigger needs to come from Sheets. Also, the ticket number already exists as it comes from an auto-increment in the form.

Thanks for your suggestion, but I don’t think it will work :(

Ok, this still would work. Make the Trigger New Record in Google Sheets instead. This should also bring the Ticket number 

Yes I have that set up as the trigger. The doubt is about how to then get the value from a specific field (‘Email’) to populate the ‘To’ field in the next step (‘Send Email in Gmail’). From what I can see, it only allows a fixed value.

Hi @BrianP!

If you select the email address from the Google forms trigger data the Zap will use the information in that column each time the Zap runs.

In the Zapier editor, you’ll see the value that was found in the row when you tested the trigger, but that’s just a sample so you can test your Zap. Each time the Zap runs it will use the information that it finds in the email column for the new form. 

​I hope that's clear, please let us know if you have any questions!

Hey @Danvers! You’re right, this works like a charm and I’ve been able to use it to insert variables in the e-mail body too.

Thanks a lot!!

Terms & Conditions