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:
Does anyone have a clue? Can somebody help me please?
Best answer by robschmidt
This message isn’t an error, you are supposed to click on “test and review” button as shown:
And it works fine: