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 (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. 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): 1. Email Address 2. First Name (optional) 3. Last Name (optional) 4. 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: 1. Open the Lists & Segments panel and click on your mailing list. 2. Click Add Subscribers, then select Upload a list. 3. Click Add a CSV file and select the file to import. 4. Toggle These subscribers accept marketing to confirm permission. 5. 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