Importing Shopify Customer Data to Google Sheets via API

Shopify Discussion
, ,

Topic summary

A user is attempting to import all Shopify customer data into Google Sheets using the Shopify API. They’ve successfully:

  • Created a private app for API access
  • Set up an API connector in Google Sheets
  • Retrieved the first 250 customer records

Current Challenge:
The user is stuck on implementing pagination to fetch the complete dataset beyond the initial 250 rows. They’re unclear about how to properly configure the “next page path” field in the Google Sheets API connector, though they’ve set “Run until” to “no data returned.”

Proposed Solutions:

  1. Technical approach: Use Shopify’s Link header pagination by extracting the rel=“next” URL from response headers and setting it as the “next page path.” This should automatically fetch all records.

  2. App alternatives: Two third-party apps were suggested as simpler alternatives:

    • Sheet Master: Automates exports to Google Sheets with prebuilt customer export templates and in-sheet data refresh capabilities
    • SyncRage: Offers a generous free plan for data syncing

The discussion remains open with multiple solution paths available.

Summarized with AI on October 24. AI used: claude-sonnet-4-5-20250929.
1

Hi,

I want to import all customer data from Shopify to Google sheets via API.

I have completed and tested these steps :

1- Created my private app for API connection

2- Set up API connector on Google Sheets

3-Managed to pull first 250 rows to Google Sheets

However, where I am stuck is, I didn’t understand how to get the full data.

I am using “Next Page URL” as pagination, and there are 2 fields on Google Sheets API connectors which I should be using which are:

a) next page path (I am not clear on this)

b) Run until (I am using “until no data returned” for this)

Any help is much appreciated here.

Best regards,

London Grocery

2

Hi @Cagdas

If you are still looking for a solution you can try Sheet Master on the Shopify App Store

The app can automate your data exports directly to Google Sheets and can refresh data directly form within Sheets. Screenshot of the prebuilt customer export below. Please email us at support@comstack.co if you need assistance.

Anto_S_0-1661507394079.png
Anto_S_0-1661507394079.png1365×765 117 KB

4

Use Pagination Shopify Admin API via the Link header. Set “Next page path” with the URL of rel="next"received in the response headers. Keep “Run until” as “no data returned.” It will fetch all the customer records in Google Sheets automatically without any pagination.

5

To be honest, it can be take quite a lot of time to implement the API. There are a few apps you can use, one would be SyncRange which has a generous free plan.