Display products pull in Google Sheets


I’m trying to pull simple data through to display our in stock products, in a specfic warehouse? Then use a API conntector to put the data in Google sheets every day so I can then make some kind of price list for our customers. Also only some entries load and not the full product catalog.


Also it’s asked for JMESPath which is the variables -

“sellables”: [ “stock_entries”: [{“warehouse_id”: 25694}]

Any ideas? Any API developers out there? Happy to explain more over Skype and also pay if required?