Move customer records from a Squarespace export into a Shopify ready sheet with almost no manual work. Great for stores that are switching platforms or cleaning mailing lists. Teams can upload a CSV and get a clean customer list in minutes.

A webhook receives the CSV file and the file extractor turns it into rows. Records flow in batches of 1000 to a Squarespace profiles tab in Google Sheets, then get mapped into a Shopify customers tab. The mapping covers email, phone, names, and address fields. Tags are added automatically, and a tag changes when a last order date is present. A manual trigger path can also push existing rows from the profiles tab into the Shopify sheet without using the webhook.

Setup is simple with n8n and Google Sheets. Expect a big cut in copy and paste work and fewer import mistakes. Many teams reduce a multi hour import to about 10 minutes while keeping an audit trail in two tabs. Use it for store migrations, rebuilding customer lists, and turning form uploads into a clean Shopify customer file.

• Webhook receives CSV files via a simple POST request
• File extraction turns the uploaded CSV into structured rows
• Batch processing handles 1000 records at a time for stability
• Appends raw data to a Squarespace profiles tab in Google Sheets
• Maps and upserts customer data into a Shopify customers tab
• Auto tagging logic adds labels based on last order date
• Manual trigger lets you backfill from the profiles tab without an upload
• Google Sheets OAuth credential keeps access secure and simple

• Reduce manual work from 3 hours to 10 minutes
• Process up to 1000 records per batch without timeouts
• Improve data quality by 90 percent through mapped fields
• Keep an audit trail with raw and formatted tabs
• Accept new uploads instantly through a secure webhook

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create a Google Sheets OAuth2 credential. Double click any Google Sheets node, open the Credential to connect with dropdown, click Create new credential, choose Google Sheets OAuth2, then follow the on screen steps. Give the credential a clear name.
4. In Google Drive, create a spreadsheet with two tabs named squarespace profiles and shopify customers. Add headers that match your CSV export and the Shopify customer fields you plan to use.
5. Open the Append Squarespace profiles node. Select your Google Sheets credential, pick the spreadsheet, and choose the squarespace profiles tab. Keep operation as append or update and confirm the column mappings.
6. Open the Shopify Customers node. Select the same spreadsheet and the shopify customers tab. Review field mappings for email, phone, names, address, and tags. Confirm any unique key you rely on, such as email.
7. Open the Webhook node. Copy the Production URL and set HTTP method to POST. Keep Allowed Origins as needed. Activate the workflow to make the URL live.
8. Open the Extract items from webhook submission node. Make sure the binary property name is set to file so it matches the uploaded form field.
9. Send a test upload. Use a form tool or a REST client to POST a multipart form with a file field named file that contains your Squarespace CSV. Check the execution log and confirm rows appear in both tabs.
10. Use the Manual trigger path to backfill. Click Execute workflow on the manual trigger and confirm records from the squarespace profiles tab are written to the shopify customers tab.
11. If you see permission errors, share the Google Sheet with the Google account used in your credential. If columns do not match, align header names in the sheet with the node mappings. For very large files, adjust the batch size in the Loop Over Items node.
12. When satisfied, connect your live form or uploader to the webhook URL and keep the workflow active.