Hi Everyone,

I’m a pretty experineced Zapier user and have been using it for about a year. I’ve been trying every angle at this and hope it’s possible but I cannot figure out a solution to save my life. 

I am essentially looking for a larger, more advanced version of Zapier’s Lookup Table function. I know on a small scale this is possible, but I want to have a more-scalable solution. 

Essentially let’s say I have a product that I invoiced for, and now I want to convert it to a SKU in Zapier, that’s easy enough. I have the item name in the first lookup table column then the SKU in the second. If I want to work with line items for a multi-item invoice, again, no problem I can use Zapier. 

Where it gets tricky is lets say I add 5 new products per day and delete some others. It’s unrealistic for me to edit this Zap every time I add/remove a SKU and I don’t want a 500-item lookup table to manage inside Zapier.

I was hoping I could just plug the line item output into Google Sheets lookup field, but that will not search for and convert multiple lines at a time. I also can’t have a multi-step zap because each order could be a different size. 

Please let me know what you think and I’m more than happy to answer with more details  

Ken