About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Dynamic 'To' recipients in Action Send Email in Gmail

  • 20 January 2023
  • 6 replies
  • 241 views
A
  • Anonymous
  • 0 replies

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 [abc]’.

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?

icon

Best answer by Danvers 23 January 2023, 11:17

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.

6 replies

MohSwellam
Userlevel 7
Badge +8

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? 

Founder of GeekyAir.com
A

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 :(

MohSwellam
Userlevel 7
Badge +8

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

Founder of GeekyAir.com
A

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.

Danvers
Userlevel 7
Badge +12

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!

A

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