Squarespace-Daten in Shopify-Kunden in Google Sheets umwandeln
Fortgeschritten
Dies ist ein Sales, Marketing-Bereich Automatisierungsworkflow mit 8 Nodes. Hauptsächlich werden Webhook, GoogleSheets, ManualTrigger, SplitInBatches, ExtractFromFile und andere Nodes verwendet. Verwandeln Sie Squarespace-Profilinformationen in Shopify-Kunden in Google Sheets
Voraussetzungen
- •HTTP Webhook-Endpunkt (wird von n8n automatisch generiert)
- •Google Sheets API-Anmeldedaten
Verwendete Nodes (8)
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"id": "7Gw4IfHaVMDSj70o",
"meta": {
"instanceId": "e634e668fe1fc93a75c4f2a7fc0dad807ca318b79654157eadb9578496acbc76",
"templateCredsSetupCompleted": true
},
"name": "Convert Squarespace Profiles to Shopify Customers in Google Sheets",
"tags": [],
"nodes": [
{
"id": "17b7e952-ba9b-4067-9c98-a69ea09f7e69",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
-800,
-420
],
"webhookId": "e09976b5-7525-422b-9834-3bc6e1c4a1b6",
"parameters": {
"path": "submit-profiles",
"options": {
"allowedOrigins": "*"
},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "7e149be3-19da-4320-8910-40ef0900628a",
"name": "Shopify Customers",
"type": "n8n-nodes-base.googleSheets",
"position": [
420,
-220
],
"parameters": {
"columns": {
"value": {
"Tags": "=n8n, squarespace, {{ $json['Last Order Date'] ? \"ground-control,\" : \"\" }}",
"Email": "={{ $json.Email }}",
"Phone": "={{ $json['Billing Phone Number'] }}",
"Last Name": "={{ $json['Last Name'] }}",
"First Name": "={{ $json['First Name'] }}",
"Default Address Zip": "={{ $json['Billing Zip'] }}",
"Default Address City": "={{ $json['Billing City'] }}",
"Default Address Phone": "={{ $json['Billing Phone Number'] }}",
"Accepts Email Marketing": "yes",
"Default Address Company": "={{ $json['Billing Name'] }}",
"Default Address Address1": "={{ $json['Billing Address 1'] }}",
"Default Address Address2": "={{ $json['Billing Address 2'] }}",
"Default Address Country Code": "={{ $json['Billing Country'] }}",
"Default Address Province Code": "={{ $json['Billing Province/State'] }}"
},
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Accepts Email Marketing",
"type": "string",
"display": true,
"required": false,
"displayName": "Accepts Email Marketing",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address Company",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address Address1",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address Address1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address Address2",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address Address2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address City",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address City",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address Province Code",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address Province Code",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address Country Code",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address Country Code",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address Zip",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address Zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address Phone",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Accepts SMS Marketing",
"type": "string",
"display": true,
"required": false,
"displayName": "Accepts SMS Marketing",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tags",
"type": "string",
"display": true,
"required": false,
"displayName": "Tags",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Note",
"type": "string",
"display": true,
"required": false,
"displayName": "Note",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tax Exempt",
"type": "string",
"display": true,
"required": false,
"displayName": "Tax Exempt",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 15798644,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM/edit#gid=15798644",
"cachedResultName": "shopify_template"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM/edit?usp=drivesdk",
"cachedResultName": "Make.com template"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JgI9maibw5DnBXRP",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "e04f9a9e-b699-4cf2-aa91-56e6bfa30faa",
"name": "Squarespace-Profile lesen",
"type": "n8n-nodes-base.googleSheets",
"position": [
-180,
0
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 144532755,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM/edit#gid=144532755",
"cachedResultName": "squarespace_profiles"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM/edit?usp=drivesdk",
"cachedResultName": "Squarespace automation"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JgI9maibw5DnBXRP",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "ffebc458-bd3c-4145-a5ef-1677815f210e",
"name": "Squarespace-Profile anhängen",
"type": "n8n-nodes-base.googleSheets",
"position": [
-200,
-420
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $json.Email }}",
"Last Name": "={{ $json['Last Name'] }}",
"Created On": "={{ $json['Created On'] }}",
"First Name": "={{ $json['First Name'] }}",
"Billing Zip": "={{ $json['Billing Zip'] }}",
"Order Count": "={{ $json['Order Count'] }}",
"Total Spent": "={{ $json['Total Spent'] }}",
"Billing City": "={{ $json['Billing City'] }}",
"Billing Name": "={{ $json['Billing Name'] }}",
"Shipping Zip": "={{ $json['Billing Zip'] }}",
"Shipping City": "={{ $json['Billing City'] }}",
"Shipping Name": "={{ $json['Billing Name'] }}",
"Billing Country": "={{ $json['Billing Country'] }}",
"Last Order Date": "={{ $json['Last Order Date'] }}",
"Shipping Country": "={{ $json['Billing Country'] }}",
"Subscriber Since": "={{ $json['Subscriber Since'] }}",
"Billing Address 1": "={{ $json['Billing Address 1'] }}",
"Billing Address 2": "={{ $json['Billing Address 2'] }}",
"Subscriber Source": "={{ $json['Subscriber Source'] }}",
"Shipping Address 1": "={{ $json['Billing Address 1'] }}",
"Shipping Address 2": "={{ $json['Billing Address 2'] }}",
"Billing Phone Number": "={{ $json['Billing Phone Number'] }}",
"Shipping Phone Number": "={{ $json['Billing Phone Number'] }}",
"Billing Province/State": "={{ $json['Billing Province/State'] }}",
"Shipping Province/State": "={{ $json['Billing Province/State'] }}"
},
"schema": [
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "First Name",
"type": "string",
"display": true,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created On",
"type": "string",
"display": true,
"required": false,
"displayName": "Created On",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Order Count",
"type": "string",
"display": true,
"required": false,
"displayName": "Order Count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Order Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Order Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Total Spent",
"type": "string",
"display": true,
"required": false,
"displayName": "Total Spent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Member Since",
"type": "string",
"display": true,
"required": false,
"displayName": "Member Since",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Subscriber Since",
"type": "string",
"display": true,
"required": false,
"displayName": "Subscriber Since",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Subscriber Source",
"type": "string",
"display": true,
"required": false,
"displayName": "Subscriber Source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tags",
"type": "string",
"display": true,
"required": false,
"displayName": "Tags",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Mailing Lists",
"type": "string",
"display": true,
"required": false,
"displayName": "Mailing Lists",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Member Areas",
"type": "string",
"display": true,
"required": false,
"displayName": "Member Areas",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Donation Count",
"type": "string",
"display": true,
"required": false,
"displayName": "Donation Count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Donation Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Donation Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Total Donation Amount",
"type": "string",
"display": true,
"required": false,
"displayName": "Total Donation Amount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Has Account",
"type": "string",
"display": true,
"required": false,
"displayName": "Has Account",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Customer Since",
"type": "string",
"display": true,
"required": false,
"displayName": "Customer Since",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping Address 1",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping Address 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping Address 2",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping Address 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping City",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping City",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping Zip",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping Zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping Province/State",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping Province/State",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping Country",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping Phone Number",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping Phone Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Address 1",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing Address 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Address 2",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing Address 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing City",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing City",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Zip",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing Zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Province/State",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing Province/State",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Country",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Phone Number",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing Phone Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Accepts Marketing",
"type": "string",
"display": true,
"required": false,
"displayName": "Accepts Marketing",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 144532755,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM/edit#gid=144532755",
"cachedResultName": "squarespace_profiles"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM/edit?usp=drivesdk",
"cachedResultName": "Squarespace automation"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JgI9maibw5DnBXRP",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "dc5cfb81-0d9b-47fb-a97a-fa20c673283b",
"name": "Über Elemente iterieren",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-360,
-420
],
"parameters": {
"options": {},
"batchSize": 1000
},
"typeVersion": 3
},
{
"id": "b319cb05-6b8b-48cb-b7c9-4badee6bbf57",
"name": "Haftnotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1240,
-580
],
"parameters": {
"width": 340,
"height": 280,
"content": "## Convert Squarespace profiles\nConvert exported profile from Squarespace to compatible Shopify customers data in csv format\nSample Spreadsheet template\nhttps://docs.google.com/spreadsheets/d/1ZUP7RySMCjQUBAvlZhSE1rOul1FMVHvTSF0QexuV7mQ\n- Squarespace profiles\n- Shopify customers"
},
"typeVersion": 1
},
{
"id": "8b9d6f85-af6e-43b8-a3f1-c63c7893e064",
"name": "Elemente aus webhook-Übermittlung extrahieren",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-580,
-420
],
"parameters": {
"options": {},
"binaryPropertyName": "file"
},
"typeVersion": 1
},
{
"id": "ce82f958-081b-4a55-a0d1-8ffb69dee68b",
"name": "Manueller Auslöser",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-580,
0
],
"parameters": {},
"typeVersion": 1
}
],
"active": true,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "05db75a8-16f8-4191-b60b-d515d062bef9",
"connections": {
"17b7e952-ba9b-4067-9c98-a69ea09f7e69": {
"main": [
[
{
"node": "8b9d6f85-af6e-43b8-a3f1-c63c7893e064",
"type": "main",
"index": 0
}
]
]
},
"ce82f958-081b-4a55-a0d1-8ffb69dee68b": {
"main": [
[
{
"node": "e04f9a9e-b699-4cf2-aa91-56e6bfa30faa",
"type": "main",
"index": 0
}
]
]
},
"dc5cfb81-0d9b-47fb-a97a-fa20c673283b": {
"main": [
[
{
"node": "7e149be3-19da-4320-8910-40ef0900628a",
"type": "main",
"index": 0
}
],
[
{
"node": "ffebc458-bd3c-4145-a5ef-1677815f210e",
"type": "main",
"index": 0
}
]
]
},
"e04f9a9e-b699-4cf2-aa91-56e6bfa30faa": {
"main": [
[
{
"node": "7e149be3-19da-4320-8910-40ef0900628a",
"type": "main",
"index": 0
}
]
]
},
"ffebc458-bd3c-4145-a5ef-1677815f210e": {
"main": [
[
{
"node": "dc5cfb81-0d9b-47fb-a97a-fa20c673283b",
"type": "main",
"index": 0
}
]
]
},
"8b9d6f85-af6e-43b8-a3f1-c63c7893e064": {
"main": [
[
{
"node": "dc5cfb81-0d9b-47fb-a97a-fa20c673283b",
"type": "main",
"index": 0
}
]
]
}
}
}Häufig gestellte Fragen
Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Fortgeschritten - Vertrieb, Marketing
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
Alle Squarespace-Bestellungen in Google Sheets abrufen
Alle Squarespace-Bestellungen in eine Google-Tabelle abrufen
Set
Split Out
Http Request
+
Set
Split Out
Http Request
8 Nodesbangank36
Vertrieb
Massenindividualisierte Outreach-Automatisierung mit Bright Data und LLMs
Großskalige Hyper-Personalisierung und Outreach-Automatisierung durch Bright Data und Large Language Models
If
Set
Wait
+
If
Set
Wait
21 NodesYaron Been
Vertrieb
Automatisierung von LinkedIn-Anfragen und Einstiegsnachrichten mit Browserflow und Google Sheets
Automatisierte LinkedIn-Anfragen und Eisbrecher-Nachrichten mit Browserflow und Google Sheets
If
Set
Sort
+
If
Set
Sort
44 NodesPollupAI
Vertrieb
Lead-Forscher LinkedIn
Automatisierte Lead-Recherche - von LinkedIn zu sendbaren Berichten
If
Set
Wait
+
If
Set
Wait
36 NodesLukaszB
Vertrieb
Mein Workflow 5
Automatisierte LinkedIn-Lead-Generierung mit personalisierter E-Mail-KI (unvollendet)
If
Set
Code
+
If
Set
Code
37 NodesMatthieu
Vertrieb
HDW-Lead-Jeep
Automatisierte LinkedIn-Lead-Generierung, -Bewertung und -Kommunikation mit KI-Agenten
If
Code
Sort
+
If
Code
Sort
86 NodesAndrey
Vertrieb
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes8
Kategorie2
Node-Typen6
Autor
bangank36
@bangank36Automation specialist with 10+ years of experience helping SME website owners streamline their workflows—specializing in Squarespace, Shopify, and WordPress. Book an initial consultation for custom n8n automation using my link.
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen