Google Sheets Lookup returning an exception

[jameswright]

Hello,

I'm trying to use the Google Sheets Lookup Action to find a row in a google sheet.

Here is my workflow URL:-

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

It currently returns an exception:-

I've tried to delete and recreate the workflow, but I'm not sure what I'm doing wrong, any ideas?

 

[Supreme]

Hey @jameswright

Seems like you might have done some changes in your Google Sheets and because of that it is able to check the data in your Google Sheets.

So, please reconnect the action step and then try again.

 

[jameswright]

Supreme,

Thanks for the idea, I basically went through and deleted everything, including the connection to my google account and started again, it's now working.

Appreciate the input.