Hello Community !
I’ve set up a zap with Gdrive / GoogleSheets.
Unfortunately, I’m unable to make the “ lookup spreasheet row” function in the zap work.
The spreadsheet “countries and emails” is a 2 column table, with 200 lines: Countries| emails . Yes there are headers.
When someone fills a form (country being a mandatory field), then the zap should perform a Lookup to find to which email address it should be forwarded.
So, I set up the lookup spreadsheet row like this:
- Lookup column: countries
- Lookup value: (inherited from form): Italy for instance
I had of course selected the right spreadsheet, worksheet etc. in my gdrive and there are values in there
But I get this message:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/af625613-0d7e-4857-bd67-85008d54456c.jpg)
Does anyone have a clue? Can somebody help me please?
Best answer by robschmidt
View original