Convert Squarespace Profiles to Shopify Customers via Google Sheets

This n8n workflow transforms exported CSV files from Squarespace profiles into a Shopify-ready customer import format, streamlining the process through a pre-configured Google Sheets template. Users export contacts from Squarespace Dashboard → Contacts → Export, then either upload manually to the input sheet or trigger via webhook with a simple POST request including the file.

The workflow reads data from the 'Squarespace Profiles' sheet, applies necessary transformations to match Shopify's CSV requirements (e.g., formatting fields like name, email, addresses), and outputs to the 'Shopify Customers' sheet. Once processed, export the output sheet as CSV and import directly into Shopify Dashboard → Customers → Import. This eliminates manual data mapping errors and saves hours of spreadsheet work.

Ideal for e-commerce businesses migrating from Squarespace to Shopify, agencies managing client transitions, or anyone handling customer data imports. Benefits include automation reliability, scalability for large contact lists, and easy setup with just Google Sheets API credentials. Use cases: platform switches, data cleanup, or periodic syncs between platforms.