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. It uses 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 (page_info) 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. page_info** – Used for pagination; only limit and fields are allowed when paginating.

📌 Note: When you query paginated chunks with page_info, 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.

Google Sheets Template Clone this spreadsheet: 📎 Google Sheets Template

According to Squarespace documentation, your spreadsheet can have up to three columns and must be arranged in this order (no header):

Email Address
First Name (optional)
Last Name (optional)
Shopify Customer ID (this field will be ignored)

Exporting a Compatible CSV for Squarespace Contacts This workflow also generates a CSV file that can be imported into Squarespace Contacts.

How to Import the CSV to Squarespace: Open the Lists & Segments panel and click on your mailing list. Click Add Subscribers, then select Upload a list. Click Add a CSV file and select the file to import. Toggle These subscribers accept marketing to confirm permission. Preview your list, then click Import.

Who Is This For? Shopify store owners** who need to export all customers to Google Sheets. Anyone looking for a flexible and scalable** Shopify customers extraction solution. Squarespace website owners** who want to bulk-create their Contacts using CSV.

Explore More Templates
👉 Check out my other n8n templates