Skip to main content

Hello, community folks! Itā€™s nearly summer and our Workspace Invaders series is heatinā€™ up!Ā šŸ”„šŸ”„šŸ”„

Ā 

Helping scientists plan experiments faster

Ā 

A little over a month ago,Ā @JustinV22Ā  from Locus.ly asked for some recommendations from the community on how to send different emails based on answers. While there isnā€™t a direct way to send different emails based on the answers respondents provide, Justin found a crafty solution using Typeform Webhooks and Zapier.Ā 

Ā 

Locus.ly helps scientists find tests to run their experiments through an outcome quiz typeform. The form asks a few questions based on the data theyā€™d like to obtain, then presents them with a beautiful customized PDF of the test theyā€™ll need to run as well as the costs of each test. Previously, this data had to be scoured by the scientists on their own by contacting each company individually and asking the sales rep similar questions.

Ā 

Our idea was to bill it as "6 months of research in 6 minutes" ā€“ Justin Valley

Ā 

We were blown away by both the idea and the solution so James and I caught up with Locus.ly Founder Justin and his Scientific Consultant Brian Steffy to find out how (and why!) they did it!

Ā 

In this video, weā€™ll talkĀ about:Ā 

Ā 

  • What Locus.ly is and how they found Typeform

  • Using the outcomes quiz template to simplify the questionnaire

  • How to use Webhooks, Zapier, and Typeform to send custom emails based on answers

  • Setting up different email templates within Zapier
    Ā 

Ā 

Ā 

How to do it yourself

Ā 

Want to build your own quiz with multiple outcomes or want to share different products with your customers based on their preferences? Here's a quick guide to setting up Zapier + Typeform Webhooks to send different emails based on the outcome your respondent received ā€“ just like Justin didā€¦
Ā 

1. Set up your zapĀ 


The first step is to set up your zap. Youā€™ll want the trigger event to be ā€œCatch Hookā€ in Zapier, followed by ā€œUtilities,ā€ then ending with ā€œSend Emailā€ in your email service provider. For the sake of this tutorial, weā€™ll be using Gmail.Ā 

Ā 

2GIFiQhi4O-6nvr1Yx3E3qZ4XM__I7xIQfb6HGN4OkHOn7V4rJkEiDA4mQABD-QRddkio_x8_EBiRleAmrZUOXI_5joHvyDiWGArsSSwZSkxFQeYm1zdtbx8xKHpUO1pxSv_A9Sb

Ā 

2. Turn on webhooks and submit a real responseĀ 
Ā 

Youā€™ll first want to submit a real response to your form in order to capture the endings within the results. A test webhook wonā€™t capture this data for you.Ā 

Ā 

After you submit a real response, you can grab the webhook URL within your zap and add this to your Typeform like this:Ā 

Ā 

ZyiLlkrfoQ4uiIDiyPzHCguJC17nurTi_fzrYy9fCSeMjioh31lMZt0bgxP5igZJ3HNlFfBribRjfz_ZdvzGxJeWva8Lg-l8piS6-vwxO4q0KRK8d6IhLrlRKWIsDnu_jERDERMt

Ā 

Be sure to test the trigger in Zapier in order to move to the next step!

Ā 

3. Find the Outcome IDs to setup Zapier Utilities

Ā 

The ID is a unique string of letters and numbers assigned to each ending on the form. This will help Zapier identify which ending was submitted to the results and then send a different email accordingly.Ā 

Ā 

You can find the Outcome ID by searching through the Webhook data.Ā 

Ā 

xX16YG1CJZ6nsUZHFRCGVRAIyGMGFw6yothdUYt3vBuZdmWCi2VhNeVdF3erdNQ2dr2ry5wA2dZ2IL7RocXU5-CwH5QYnzRfWef5YRyy1HYEe1qPU9CnN75IibF6-jz-0NN9oPUh

Ā 

Weā€™d suggest adding the outcome IDs to a Google Spreadsheet so itā€™s easier to keep track of.Ā 

Ā 

L0f8FQLoKlK_7EXu40CDtLGdutELWABGI3QCrvJL7n73QTM8Ie_9NU7HQ35QdM3SCbFv9Zp4PDf9iCHwtz3NSShmj18B_40q0QQL520lA8gEfV0cNGdW3Lhv5W5Oktnl0PiXUj7R

Ā 

4. Create a lookup table
Ā 

Create a lookup table with the IDs and the information youā€™d like to have in your email.Ā For this tutorial, weā€™re changing the URL within each email, but you could add specific text instead, too.Ā 

sN7dnOLl-gQ_vIi9MKrd6ZM47PAZZCnYZiLMz0u1p_5rPWsQt38XDNnitVG19xT08nbG6XlLGx6DtbmMWU-nZm1FXav1FcrtHKZD3nddoKQOBQZ_Mq9ce2TTNNgckeK4qak_Sklk

Ā 

In case anything changes with your form, be sure to add a Fallback value underneath the Lookup Table options. This will provide a default value in case the zap canā€™t match any of the IDs within the table.Ā 

Ā 

5. Finally, format the body of your email!Ā 

Ā 

QN2p82KeJY__T8tMbfUgqGZjdFalAmIDPQpWSBiOMQaIY25_ulRPmuypyag15EY1Uzrll5XSQJY1v3APINPGC9gn_NqK_VKFxQU93_H49qa6YC9KgndFgQ0gUtHOS8rzVpos3Zkh

Ā 

When a respondent submits your form now, the body of the email will change according to the zap youā€™ve setup. Be sure to test this before sharing the form live with respondents to make sure everything is working!Ā 

Ā 

Helpful resourcesĀ šŸ“ššŸ“ššŸ“š

Ā 

If youā€™re curious about Locus.ly, be sure to check them out and follow their progress here!Ā 


Got a cool use case like Locus.ly's? We'd love to hear from you and share what you're doing with our community like Justin and Brian did. Just hit us up via this typeform.

@LizĀ @JamesĀ - very cool!!Ā 

des


This is mind boggling. Congrats Locus.ly and team!!!Ā 

@LizĀ what's their community handle? She should mention them here!Ā 


Ah, thank you @GabrielĀ ! I meant to update the post afterwards when it let me tag people. Updating now!


Thanks so much for the shoutout and awesome write-up/video @LizĀ and James!Ā  Hope this is helpful to others, too!Ā Ā 


@JustinV22Ā @LizĀ @JamesĀ - great job on this. pretty cool use case.Ā 

I like the ā€˜relative simplicityā€™ of the set up in Zapier.. well done.Ā 

cheers

Ā 

des


@john.desboroughĀ Same!! Iā€™m thinking of using this setup now for a new form Iā€™ve been thinking of building! The process is way easier than I ever thought it could be.Ā :rofl:


@JustinV22Ā - one quick question about the ā€˜outcome reportsā€™: based on what i could see in the video, and not having gone and run the typeform, are all the outcome report/lists static or is there some dynamic content that is included into the actual report body based on the typeform data (ie merging any data into a template that produces a customized version of the report)?Ā 

cheers

des


@john.desboroughĀ great question.Ā  We started with trying to make it dynamic and then realized that was going to complicate things with so many different outcomes.Ā  Now they are all static.Ā  Hope that helps!


@JustinV22Ā - thanks for the update. I figured as much but was just checkinā€™.. thatā€™s a lot of doco to keep up to date if and as prices changes but i really do love the concept and what you have implemented to date.Ā 

kudos to you folk!

Ā 

des


Hi, Iā€™m pretty much trying to replicate what Locus.ly has done as it fits my needs exactly. The issue I am encountering is that when I create the Lookup Table in Zapier, I donā€™t see a field ā€œForm Response Definition Outcome Choices ID:<list of IDs>ā€ as shown in the example. I only see a single ID corresponding to the a quiz answer as seen in the screenshot below.Ā 

Any pointers on what I am doing differently? Thanks!


Hi @shree_pkĀ Thanks for stopping by! For all of the outcome choices to appear, you have to have at least one response submitted with that outcome. Then, youā€™ll see the options for each. Let me know if that doesnā€™t work!


Hi @LizĀ - thank you so much. I was a little confused with the naming of the lookup key that corresponded to the endings. I was looking for Outcome Choices, but Nicolas from the Typeform dev team confirmed that Response Ending Id was indeed correct. I am in the process of configuring the Zap with the outcome choices as you have suggested. Thank you again.


Woot! Let us know how it goes, @shree_pkĀ !


This is exactly what iā€™m looking for - amazing!!Ā 

Ā 

One quick question - does anyone have any idea if this will work with Zapier Tables instead of Google Sheets?

Ā 

Thanks as always,

Luis


Hi @luisjbdouglasĀ Thanks for stopping by! I havenā€™t personally tried with Zapier tables, but I canā€™t see why it wouldnā€™t work with it. Iā€™d go ahead and give it a try!


Reply