I'd love to pull some data from Shipstation using API to google sheets. Is there anyone out there that has been successful and mind tossing over some pointers?
If you are a savvy programmer https://github.com/natecox/pyshipstation is a good jumping off point. From there you will need to learn the google api, but I think that is really well documented so you should be just fine.
To be honest, we decided to go through Zapier. Leverage work already done. But it could be done directly through the API, yes.