Best answer

lookup function in GoogleSheets zap is making me mad! please help

  • 11 March 2021
  • 3 replies

Userlevel 1

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 11 March 2021, 10:09

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 1

Hi @robschmidt, thanks you for your answer. I did as you did, but still the problem has occured again. I have dropped my zap and used another way because I dind’t find any solution. Thank you for your answer, I appreciated it.

Userlevel 1

Thanks a lot @robschmidt  !!!

Userlevel 7
Badge +9

Hi @SocoCom,

This message isn’t an error, you are supposed to click on “test and review” button as shown:


And it works fine: