I hope you could help me because I have been stuck with my zap for 2 days. My goal is to update a googlesheet when I have a new row. For this, I have
- 1 sheet with my country
- 1 correspondance sheet (in the same document) with the country and the territory associated.
I manage to create my zap and with the help of the LOOKUP action the right form, sheets, columns and data are found. Howevere when I want to test and continue my zap I have an error message saying there id no data (see attachment). I don’t undretsand why because in the steps above Zapier was “showing” me the right data, so it could be read.
Can anyone please help me?
Thank you in advance,