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.

Hi Everyone! I have some conditional actions that should be working like this:

 

  1. Lead fills out a form and gets added to our Google Sheet
  2. A Google Sheet “Lookup” of the phone number is performed to see if the lead has previously contacted us before
    1. If they have not contacted us before they get an initial welcome text (new lead text)
    2. If they have contacted us before, they get a follow up text about the new thing they’ve inquired about (existing customer text)

SEE BELOW

 

WHAT’S ACTUALLY HAPPENING

Everyone is getting the “existing customer” message and I’m not sure why. I’m wondering if I’ve accidentally created a loop of some kind.

Anyone know how I can fix this?

I wonder if it has anything to do with what I have selected below:

 

Hi @When Jess Zaps 

Good question.

We’d need to see detailed screenshots with how your Filter steps in each Path are configured, thanks.

Hey @When Jess Zaps ,

It looks like Step 1 triggers off of a new row in a worksheet, and then Step 2 looks for that user in the same worksheet. But by definition, that user will always be there since Step 1 put that data there.

One way I can think to fix this would be to search from the top down and then in Step 3 you should compare the row id from both step 1 and step 2. If they’re the same, then you’ve got a new lead. If they’re different then you’ve already seen this person before.

Let me know how that goes!

Hey @When Jess Zaps ,

It looks like Step 1 triggers off of a new row in a worksheet, and then Step 2 looks for that user in the same worksheet. But by definition, that user will always be there since Step 1 put that data there.

One way I can think to fix this would be to search from the top down and then in Step 3 you should compare the row id from both step 1 and step 2. If they’re the same, then you’ve got a new lead. If they’re different then you’ve already seen this person before.

Let me know how that goes!

I knew I was creating a problem for myself in that last screenshot! I’ve changed it to search from the top up. Is there an article I can use to read up on how to compare row ids? I’m terrible with search steps. That’s kind of how we ended up here, haha!

Hey Jess,

Just switching to top-down won’t fix the problem alone. You’ll need to change how your paths are determined. The real problem is that you’re triggering off of a lead being added to a sheet, then checking the very same sheet for that same data. But by definition it will always be there.

Ideally you’d be triggering on a sheet (or some other source) that’s different from the source before the sheet, and then you’d add it to the sheet only if it’s not in the sheet. 

But, in the way it’s set up, if you want to change it so you’re comparing Step 1 ID to Step 2 ID you have to click on the fields on both sides of the comparison and set one of them to ID from Step 1 and the other to ID from Step 2. Making that change plus the change to top-down from bottom-up should fix it. The last thing to note is that the New Lead path is where the IDs are equal. The Existing Lead path is where they’re different.

https://cdn.zappy.app/213065d2b942e70e0900a1c62df39f16.png

Terms & Conditions