Here’s a couple thoughts on how to accomplish that.
you can use the google sheets node to search for the email in a specific column. Use a set before the google sheets node to define which sheets you want to look in, and what column you want to search in.
You could also create a rag agent where you move data from google sheets into a vector store like supabase. Then tell your agent to look anywhere in the store for that email address.