Anybody has leveraged the API to get data from ZPOOL in a Google Sheet?

I tried but got lost in the proceed.    I believe though that should I have something to start with I could achieve what I want.

Thanks for your support...