The zap appears to work ok when testing, but as soon as I switch to live the look up fails to locate spreadsheet.
It is something to do with Custom Lookup that isn’t locating file correctly, have tried time delays without success. Has anyone done something similar and functions ok?
Hi Tanya!
I can see that you’ve been corresponding with our support team about a similar issue (maybe this exact one?). They will likely be the best folks to help you out, since they can dig into your Zaps and have visibility that we won’t have here.
You’d mentioned in one of your responses that you’d found a workaround. Is that no longer working for you?
I had asked similar from Support, thought someone in community may have found a solution hence posting here too.
Until development within Zapier progresses to stabilise Custom Lookups I will get coding done within GSheets.
Hi Tanya! Thanks for the follow up on this and for letting us know how you’re currently working around the limitation 
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.