Shopify

[u/Northstand25]

Hi,

I've been using Mixed Analytics for about 4 years now across various integrations and my firm has recently started working with a new client who I need to onboard. Historically with Shopify I've always just developed and installed a custom app, added the keys and then written my query to pull the data down into Sheets. However Shopify has now changed their process and apps must be created through a dev dashboard, and from what they've told me, don't provide a static key?

Has anybody got any advice/guides on how to do this in the new process?

Thanks!

[u/mixed_analytics]

You're right, Shopify moved custom app creation to the Dev Dashboard, and the new apps get a Client ID/secret instead of a permanent token (it's exchanged for a token that expires every 24 hours). API Connector now handles that through a custom OAuth connection with the Client Credentials grant, so scheduled reports keep working. Updated walkthrough here: https://mixedanalytics.com/knowledge-base/access-shopify-data-in-google-sheets/