Sync Shopify customers to Google Sheets + Squarespace compatible csv

This workflow retrieves all Shopify Customers and saves them into a Google Sheets spreadsheet using the [Shopify Admin REST API](https://shopify.dev/docs/api/admin-rest/2025-01/resources/customer). It uses [pagination](https://shopify.dev/docs/api/admin-rest/usage/pagination) to ensure all customers are collected efficiently.

N8n does not have built-in actions for Customers, so I built the workflow using an HTTP Request node.

How It Works This workflow uses the HTTP Request node to fetch paginated chunks manually.

- Shopify uses cursor-based pagination (pageinfo) instead of traditional page numbers. - Pagination data is stored in the response headers, so we need to enable Include Response Headers and Status in the HTTP Request node. - The workflow processes customer data, saves it to Google Sheets, and formats a compatible CSV for Squarespace Contacts import. - This workflow can be run on demand or scheduled to keep your data up to date.

Parameters You can adjust these parameters in the HTTP Request node:

- limit – The number of customers per request (default: 50, max: 250). - fields – Comma-separated list of fields to retrieve. - pageinfo – Used for pagination; only limit and fields are allowed when paginating.

📌 Note: When you query paginated chunks with pageinfo, only the limit and fields parameters are allowed.

Credentials - Shopify API Key – Required for authentication. - Google Sheets API credentials – Needed to insert data into the spreadsheet.