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.

Question

Is it possible to send different customised emails without using Paths?

  • 22 June 2023
  • 3 replies
  • 56 views
Bel 
Hello,I do professional training, and my goal is to automate my lead reception and then send an automatic email depending on the training chosen. I have 10 formations.So at first I extract the leads on my sheets (something I manage to do) but I can't automate the sending of personalized emails according to the training chosen. is it possible to automate the sending of mail without using the path function and to do it in the same ZAP?

3 replies

SamB
Rank
Userlevel 7
Badge +11

Welcome to the Community, @Bel!

What a great question! If you want to avoid using Paths but still be able to handle this within a single Zap then I think you could potentially use a lookup table for this. Instead of using a Formatter by Zapier action to create the lookup table I think you’d want to use different app like Google Sheets to maintain the lookup table. That way you can more easily view and edit the text for each message. 

I’m thinking the lookup table would contain a list of the possible training options that might be chosen and the corresponding middle part of the message you want to send. Then in the Zap, on the action that sends the message, you can have the start and end of the message the same for all emails but personalise the start of the message with the persons name. And for the middle part of the message you’d select the custom message that’s output by the Google Sheets action.

You can find out more about how to set up a lookup table with Google Sheets here:

 
How does that approach sound? If you give that a try and run into any issues just let us know, always happy to help further! 🙂

Bel

Bonjour,

 

Merci pour la réponse, mais j’ai un peu de mal à comprendre la procedure, mon mail est le meme pr tout le monde, seul le lien drive comportant la pièce jointe change. Comment faire svp ?

Translation:
​​​
Good morning, Thank you for the answer, but I'm having a little trouble understanding the procedure, my email is the same for everyone, only the drive link with the attachment changes. How to do please?

ken.a
Userlevel 7
Badge +6

Hi there @Bel,

I’m jumping in to see if I can help!

To add a few things from SamB’s suggestion. Here's a general outline of how you might set up your Zap:

  1. Trigger: Google Sheets - New Spreadsheet Row
  2. Action: Formatter by Zapier - Lookup Table
  3. Action: Gmail - Send Email

In the Lookup Table action, you would set up a table that maps each of your 10 trainings to a specific email template. The input would be the training chosen (pulled from the Google Sheets row), and the output would be the corresponding email template.

Then, in the Send Email action, you would use the output from the Lookup Table action as the body of the email. This way, each lead would receive a personalized email based on the training they chose.

Here's how you might set up the Lookup Table:

301241d6c9ed6f21575d7bf9f42633d0.png
(view larger)

Please note that this is only a rough draft of your workflow. You might want to reach out to our certified Zapier Experts to help you set this up and streamline your workflow. You can reach out to our Zapier Experts here: https://zapier.com/experts

Hopefully, this helps! 😊

Reply


Terms & Conditions