Importing Shopify Customer Data to Google Sheets via API

Shopify Discussion
, ,
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.