Pulling Shopify Data into Google Sheets (What are the possibilities?)

First some background.

I’m experimenting with pulling data from various sources (including GA) into Google Sheets and found a plugin called mixed analytics that will allow me to pull in Shopify Order Data (via the ‘orders’ endpoint):

https://{api key}:{api [email removed]

The output from this API pull appears to be useful for pulling a simple “Top Products by Sales Report” as I can simply write a sumif formula to create a table of top products sorted by sales.

My question is, what other Shopify API pulls are available and what types of reporting is possible?

There isn’t much documentation around the APIs and the subsequent endpoints and it seems like many of the API endpoints are deprecated . What other endpoints beside “orders.json” night be useful?

Also, as I have Shopify connected to our GA, should I mostly rely on pulling my data via the GA API instead?

What are you talking about, what’s are your reading or referencing that leads you to believe such a thing.

https://shopify.dev/api/admin

https://shopify.dev/api/admin-rest/2022-01/resources/report

https://shopify.dev/apps/shopifyql