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.

I have a spreadsheet that pulls WooCommerce orders through Zapier, and includes all their order information including their email address. After purchase, the customer is instructed to sign a waiver on JotForm by clicking on a link in the purchase thank you page.

Once the client signs the form in JotForm, I would like a checkbox automatically marked in a Google Sheet. The information in the Google Sheet is pulled from WooCommerce through Zapier.

How do I set up a Zap so that when the customer signs their waiver after making their WooCommerce purchase, it searches for their email address in the spreadsheet, and automatically marks the checkbox?

Hi @Team Angel 

Good question.

Try these Zap steps.

  1. Trigger: Jotform - New Submission
  2. Action: GSheets - Lookup Row
  3. Action; GSheets - Update Row
    1. Set the checkbox field to ‘true’

Hi there @Team Angel,

Welcome to the Community! 🎉

I wouldn’t anticipate that being a problem!

Here is how I see the Zap for the workflow that you have in mind:

  1. Trigger: Jotform (New Submission)
  2. Action: Google Sheets (Lookup Spreadsheet Row) - Choose the email as the “Lookup Column” and use the email from Jotform in the “Lookup Value” field.
  3. Action: Google Sheets (Update Row)

Does this sound helpful to you? If you're having trouble setting it up, please don't hesitate to reach out.

Also, it would be great if you could send us a screenshot of your Zap setup so we can make sure the fields are mapped correctly. Please don't include personal information in the screenshot, or be sure blur out any personal information.

Please keep us posted! 😊

Terms & Conditions