Question

How to create Google Tasks based on results of Google Form?

  • 24 September 2021
  • 2 replies
  • 22 views

Hi, everyone.  Tapping into your universal wisdom.

Has anyone created a zap that generates a task based on the responses to a survey in google forms?  For example, if you are asking potential clients if they are interested in different products:

product A

  • interested
  • not interested
  • not sure
  • wrong person

product B

  • interested
  • not interested
  • not sure
  • wrong person

etc.

If they answer ‘interested’ to any product, I would like to generate a task for a colleague (through Google calendar).  If the answer was ‘not sure’ to any product, this would generate a task for a different colleague. The tasks would note which product the potential client was interested in or ‘not sure’ about.

I have the results from the google form survey feeding into a google sheet.  The data is shown in the following manner.

Timestamp DATE Who? Email Product A Product B Product C
xxx xxx person A persona... interested not interested maybe
xxx xxx person B personb... wrong person maybe

not interested

 

Any ideas?  Thanks, all.


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 6
Badge +6

Hi @CMN , 

 

You can use Filters and Paths to build the Zap.

 

 

 

Userlevel 7
Badge +14

Hi @CMN 

Try using Filters/Paths in your Zaps.

Filter: https://zapier.com/apps/filter/help

Path: https://zapier.com/apps/paths/integrations