Skip to main content
Question

Lookup records empty column with empty value

  • July 30, 2025
  • 1 reply
  • 10 views

Trying to build a zap that returns all records in a Google Sheet that given a particular column returns all the records that are empty on that column, the current structure looks like this, BUT if fails on the test, any ideas how to resolve this?  Thank you!

 

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

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34068 replies
  • July 30, 2025

Hi ​@jose.quispe 

I tested and it worked for me.

Help us have more info by posting screenshots showing how your Zap step is configured in the CONFIGURE tab.

Can you post screenshots showing the related GSheet Worksheet you are trying to use in the lookup? (make sure to include the top row)

 

Make sure you are using the updated version of the GSheet Zap app and action.

Make sure there are no leading/trailing whitespace surrounding the lookup value.