Sync Shopify Customers to Google Sheets & Squarespace CSV

This n8n workflow efficiently retrieves all Shopify customers using the Admin REST API with cursor-based pagination (page_info from headers), handling chunks up to 250 customers per request. It processes the data, appends it to a Google Sheets spreadsheet via the dedicated node, and simultaneously formats a CSV file compatible with Squarespace Contacts import. Ideal for e-commerce businesses managing customer data across multiple platforms without manual exports.

Key benefits include time-saving automation for keeping customer lists updated, reducing errors from manual CSV handling, and enabling scheduled runs for real-time sync. The workflow uses HTTP Request nodes for Shopify (no built-in customer actions), supports customizable fields and limits, and includes a ready-to-clone Google Sheets template.

Use cases: Online course providers syncing Shopify buyers to Sheets for analysis; educators tracking student enrollments; or any Shopify store exporting to Squarespace for CRM migration. Run on-demand or schedule to maintain data hygiene effortlessly.