Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi just trying to create my first actions and zap here so I might be missing something big so bear with me :-)


When creating my action in the UI it looks good and all test just work.

But when I create a Zap out of my action using Google Sheets as a trigger it, it fails with “Bargle. We had trouble getting a matching lookup. :-(” and no logs that can guide me in any meaningful way!

I have no idea where the problem lies..

 

So this is what I have at the moment in few steps to make it clear what I´m doing

 

Steps

  1. My google sheet 
  2. Where I hook that up to my action 
  3. I “Test and Review” with the data my action picks up from the sheet (so that works)

     

  4. And hitting “Test & Review”  I get this… “Bargle. We ad trouble getting a matching lookup. :-(“

     

 

What does this mean? Is it on my end, google end or zapier end? Here the UI is massively missing logs...

 

For more information creating my action seems to be just fine like shown below

 

 

where the response is this JSON array 

e

    "341243"

]

 

Because of all my troubles with the UI and its lack of logs, test and power I tried to convert this to an CLI but that’s also broken https://github.com/zapier/zapier-platform/issues/234

 

Hope you can help

Hey in that zap you’re highlight - I know it might seem strange at first when just beginning to use Zapier, but the lookup value is the value you are searching for - So you’re doing a vertical lookup instead of a horizontal one.

If you change this to say “Population” it will find what you’re looking for: 

 

hmmm sorry for being totally dense right now… I know that need the “Lookup value” to be in this case “Iceland” and Property Name “Population” for my action to return a value. The lookup value cant be “population” at least.

 

So I think its doing it correctly… picking up a new row where I tell it witch column goes where…

 

See here.

 

Just like what is picked up and shown when I press continue

 

 

Sorry if I’m misunderstanding you but I am finding the UI builder sourly lacking logs of just about any kind!

For others hitting this my problem was that the UI validated just fine. My API was returning an array.. BUT

it looked like this

 

>

{

   "123123"

}

]

 

When it needed to have a strongly typed property, or something like this here

 

    {

        "id": "4de6dfa0-8f5e-428a-a1ae-313290b054e8",

        "name": "341243",

        "probability": 100

    }

]

 

I hope the UI validation will be fixed so somebody else won’t have this problem.

Terms & Conditions