Skip to main content

I’ve read the documentation and community posts but have been stuck on this for two days.  I just want this step to lookup spreadsheet row and find the right value.  As you can see this zap recognizes my drive, my spreadsheet, my worksheet, and the keywords column.  Try Lookup value and bupkus!  No value from my spreadsheet gets represented in this step.  I’ve tried changing the different lookup columns for laughs and there’s no available spreadsheet value there either.  If I manually type in a keyword, it works.  But that’s not what we want here.  

Desperately in search of some solution here, please.  This is like the simplest thing.  I don’t know why it isn’t working.  

Hi ​@PMalmont 

In the GSheet step, for the Lookup Value field, you need to set a static value or map a dynamic variable from a previous Zap step.

Help for mapping variables: https://help.zapier.com/hc/en-us/articles/8496343026701-Send-data-between-steps-by-mapping-fields

 

For us to have more context, it will be helpful for you to post screenshots showing how your GSheet is configured, along with outlined a specific example that you are trying to configure with the lookup column/value and expected row match in the GSheet.


Hi ​@Troy Tessalone 

Thanks for your speedy response.  Thanks for clarifying that the data has to come from inside the zap.  My expectation was I could just pull from any old spreadsheet.  I’ll fix my zap steps accordingly.

 

Thanks again!

Paul