Skip to main content

Hi everyone,

I’m working on a volunteer signup flow using SignUpGenius, Google Sheets, and Zapier Paths.

 

What I’m trying to do:

  • Volunteers sign up through SignUpGenius
  • I use Zapier to:
    • Lookup the correct row in Google Sheets (matching on a helper column: Date+Area)
    • Place the volunteer’s name into the next available Walker slot 
    • I use Zapier Paths  to check which Walker column is empty, and fill it accordingly

 

My path logic looks like this (example for Path B2):

  • Role = Walker
  • Walker 1 → EXISTS
  • Walker 2 → DOES NOT EXIST
  • → Update Row → Walker 2

The issue:

Even though Walker 1  is already filled, Zapier still overwrites it when a new walker signs up. It seems like the condition is not properly detecting that Column Walker 1 has content.

I’ve tried:

  • Refreshing the test row in the Lookup step
  • Using "Text contains" and "Text does not contain" with a value like n/a
  • In testing each path it works fine, but testing it with real data it does not. 

But the overwrite still happens.

 

Has anyone run into this?

Is there a better way to detect if a cell in the lookup row is truly empty before updating it?

Or a more reliable setup to ensure only the first available Walker slot is filled?

Any ideas, scripts, or Zap logic suggestions would be much appreciated.

Thanks!

This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing sensitive details.

Hi ​@Matt Eberlein,

 

Welcome to the Community.

It looks like you're dealing with a complex Zapier workflow. The problem likely stems from using Zapier's "Exists" condition, which checks if a field exists at all, not whether it's empty, causing fields like "Walker 1" to be overwritten even when blank. Instead, try using "Text exactly matches" or "Text does not exactly match" with a placeholder like a space or "n/a" to better identify empty fields. Alternatively, you can use a Formatter step before your Paths—try the "Numbers" action with "Get ordinal" to identify empty fields, which returns "0th" for blank entries. If those methods don't solve the issue, the root cause might be how data is formatted in your Google Sheet or how your Lookup step is configured.

I hope this helps. Please let me know if you have any further questions or if there's anything else I can assist you with.
 


Hey ​@Matt Eberlein, just checking in—did Jammer’s reply help to get it sorted? Or did you find a different solution?

Want to make sure everything is all good here, so let us know if you still need any help at all! 🙂