# Display products pull in Google Sheets

**URL:** <https://developer-forum.veeqo.com/t/display-products-pull-in-google-sheets/552>\
**Category:** API Queries (How To)\
**Created:** [March 9, 2022, 2:11pm UTC](https://developer-forum.veeqo.com/t/display-products-pull-in-google-sheets/552 "2022-03-09T14:11:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![joe](https://avatars.discourse-cdn.com/v4/letter/j/FF6200/32.png) [@joe](https://developer-forum.veeqo.com/u/joe)\
**Post date:** [March 9, 2022, 2:11pm UTC](https://developer-forum.veeqo.com/t/display-products-pull-in-google-sheets/552/1 "2022-03-09T14:11:55Z")

</div>

Hi,

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.

[https://api.veeqo.com/products?warehouse\_id=25694&page\_size=50&page=1](https://api.veeqo.com/products?warehouse_id=25694&page_size=50&page=1)

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?

Joe

---

<div class="post-metadata">

**Author:** ![tco](https://yyz1.discourse-cdn.com/flex033/user_avatar/developer-forum.veeqo.com/tco/32/158_2.png) [@tco](https://developer-forum.veeqo.com/u/tco)\
**Post date:** [January 16, 2023, 5:55pm UTC](https://developer-forum.veeqo.com/t/display-products-pull-in-google-sheets/552/2 "2023-01-16T17:55:12Z")

</div>

Hi Joe,

Did you get any help on pulling products in Sheet1 via Google Apps Script to? If so, please paste the code. Appreciate it.