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.

  • Home
  • Get Help
  • How Do I
  • How do I use Zapier to update Google Sheets worksheet template and send certain results by email?

hello,

I’m looking for the following solution: the web form on my websites integrates to the CRM package via zapier. that works perfect. Now the data entered in the webform can be used to calculate a price, based on a template google sheet.

what I would like to do is the following : send the parameters from the webform via zapier to a google sheet. this sheet should calculate a price and send a result via mail to a destination.

is this possible ? is I get some hints, I think I can do it….

many thanks for the help

Hi @dirk-viprent!

That sounds like it should be possible 🙂 The key to this is that in the Zap you have to create the formulas right there in the editor, where you can also map values that came from your trigger step. Here’s an example of what I mean:

In that post you can see that I’ve added formulas in the Zap, and that after that step runs I’m able to use the output of that formula. In my case, it was modifying text but you can use numbers as well.

Hopefully that helps to get you started!

sounds interesting, but the formulas I need are more complex and require lookups in tables etc. I ‘m investigating the following :

(step 1) from the input form on my website via ZAPier - fill in a line in a google spreadsheed (existing one);

(step 2) the calculation is done in the sheet (automatically, based on the parameters in the sheet)

(step 3) :  the result should be send via email.

 

I think this should be possible :there is a ZAP to fill a line in an existing google sheet; and there is a zap that allows to send a mail based on a row in a google sheet; but is the combination possible

Hi @dirk-viprent!

That sounds like it might be 2 separate Zaps then.

  1. One of the Zaps triggers on a form submission, finds a row in Google Sheets and updates it.
  2. Then another Zap triggers on a Google Sheets row update (or maybe you’re creating a new row) then sends an email.

Does that sound like what you’re trying to do?

Terms & Conditions