Convert Squarespace profiles to Shopify customers in Google Sheets

This workflow converts an exported CSV from Squarespace profiles into a Shopify-compatible format for customer import.

How It Works Clone this [Google Sheets template](https://docs.google.com/spreadsheets/d/1ZUP7RySMCjQUBAvlZhSE1rOul1FMVHvTSF0QexuV7mQ/edit?usp=sharing), which includes two sheets:

Squarespace Profiles (Input) 1. Go to Squarespace Dashboard → Contacts 2. Click the three-dot icon → Select Export all Contacts

Shopify Customers (Output) - This sheet formats the data to match Shopify's customer import CSV. - Shopify Dashboard → Customers → Import customers by CSV

The workflow can run on-demand or be triggered via webhook.

Via webhook 1. Set up webhook node to expect a POST request 2. Trigger the webhook using this code (psuedo) - replace {webhook-url} with the actual URL

const formData = new FormData(); formData.append('file', blob, 'profilesexport.csv'); // Add file to FormData

fetch('{webhook-url}', { // Replace with your target URL method: 'POST', mode: 'no-cors', body: formData });