Skip to main content
Question

Can you use Paths for columns in Google Sheets?

  • October 16, 2022
  • 1 reply
  • 64 views

Hi @cb2022 , 

 

This is definitely doable using a Lookup Row in Google Sheets step and Paths by Zapier :) 

What you need to do is the following: 

 

  1. After the form submission (which should be the trigger) add an Action that is Lookup Row in Google Sheets by searching in the Emails field guide. Dont forget to set the “Should this step be considered a "success" when nothing is found?” to “Yes”
  2. Create a Paths by Zapier where the condition would be “zap success = true” and another one for “zap success = false” 
  3. Now you have 2 paths, one where you have an entry for this email address (the action in this path would be to update the google sheets row) and another path where there is no email address available in the google sheet so the action would be Create new row 

let me know if this works for you :) 

Did the same concept works for column elements?

 

This post was split from Add OR update row in Google Sheets

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

1 reply

MohSwellam
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+8
  • Zapier Orchestrator & Solution Partner
  • October 16, 2022

Hi @robinsah , 

 

Im not following, can you please give me an example of column elements?