Google Sheet Lookup error

  • 3 December 2021
  • 1 reply

Hello everybody :smile: ,


I have a problem with a zap with the Google Sheet Lookup action. 

My zap : New message in slack → lookup the data of the slack message to match google sheet with lookup → send slack message

My google sheet lookup search fields are mail adress (primary) and a true/false question (secondary), lately the zap stopped working and doesn’t detect the match even when the data is ok and should match (see the screenshots bellow).

My zap settings (you can see the lookup fields)
My google sheet row
Error on a row that should match

Could anyone help me with this bug ? Thanks a lot !

This post has been edited by a moderator to remove sensitive information. Please remember to obfuscate any personally identifiable information prior to posting as this is a public forum. 

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

1 reply

Userlevel 7
Badge +14

Hi @Hemea 

Did you change anything recently with the GSheet? (e.g. add/remove/reorder columns, rename columns, etc.)


Perhaps check your GSheets version history around the time when the issues started happening.