Skip to main content


Connect Shopify to Google Sheets

Castodia automatically imports fresh data from your Shopify Store to your Google Sheets on a highly customizable schedule. Auto-refresh data as often as every 1 minute for near real-time data.

How to Connect Shopify Store to Google Sheets

Castodia lets you pull data from your Shopify Store directly into Google Sheets.

To connect your Airtable Bases, follow the steps below:‍

  1. Open the Castodia Admin Dashboard
  2. From the Databases Menu, click on Create
  3. Add a nickname for your source connection
  4. From the dropdown menu, select Shopify
  5. Gather and enter your data source Acess Token and your Shop URL. How to get a token?
  6. Click the "Test" button to verify your credentials
  7. Click the "Save" button once a green notification pops up, indicating that the add-on was successfully installed.

And that's it! Enjoy running your queries.

How to Get your Shopify Access Token


You only need these steps if you don't already have an access token.

  1. Go to and login to your store account
  2. On the left side menu click on Settings

Shopify settings

  1. On the top left side you’ll find your Shop URL, you’ll need this URL to add your Shopify source on Castodia. Shopify shop url

  2. Go to Apps and Sales channels Shopify app and sales

  3. Click on Developer apps button located on the top right corner Shopify developer apps

  4. Click on Allow custom app development Shopify custom development


  1. Click on Create an app Shopify create app

  2. Input a name and click on Create app Shopify name app

  3. Click on Configure Admin API scopes (learn more about Shopify API access scopes) Shopify configure scopes

  4. Select the resources you’d like to access using this token (Note: we only require read-only access scopes for the resources you’d like to connect) Shopify access resource

  5. Click on Selected tab to view your selections and confirm that only read access was granted for each resource. Shopify grants

  6. Click on Save Shopify api creds

  7. Click on API credentials tab on the top menu

Shopify install

  1. Click on Install app (Note: you’ll only be able to install the app once you’ve selected/configured access scopes) Shopify token Shopify access token

  2. You may then click on Reveal token once and store it in a safe place, this is your Access Token credential. Shopify app token complete

  3. You are done! With your Shop URL and your Access token credentials you are able to connect Shopify on the Castodia admin app. If you need help creating a source on Castodia, please refer to our Integrations page. For more information on Shopify Apps, please refer to their guide.