Best answer

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

  • 11 March 2021
  • 3 replies
  • 19 views

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?

icon

Best answer by robschmidt 11 March 2021, 10:09

Hi @SocoCom,

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

 

And it works fine:

 

View original

3 replies

Userlevel 4
Badge +3

Hi @SocoCom,

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

 

And it works fine:

 

Userlevel 1

Thanks a lot @robschmidt  !!!

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.

Reply