How do I lookup a value in a google sheets table and return a corresponding value which can then be pushed to an app. Specifically, I am pulling data from mailparser. I want zapier to lookup a value in a google sheets table (or any other app where I can store a table), find the adjacent normalized value and return this, which will then go to Pipedrive. I can’t figure out how to do. Would love some guidance. Thank you.
Best answer by nicksimardView original