Squarespace データを Google Sheets に Shopify 顧客に変換
中級
これはSales, Marketing分野の自動化ワークフローで、8個のノードを含みます。主にWebhook, GoogleSheets, ManualTrigger, SplitInBatches, ExtractFromFileなどのノードを使用。 Squarespace データを Google Sheets の Shopify カスタマーに変換する
前提条件
- •HTTP Webhookエンドポイント（n8nが自動生成）
- •Google Sheets API認証情報
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定を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プロファイルを読み取る",
"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プロファイルを追加",
"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": "アイテムをループ処理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-360,
-420
],
"parameters": {
"options": {},
"batchSize": 1000
},
"typeVersion": 3
},
{
"id": "b319cb05-6b8b-48cb-b7c9-4badee6bbf57",
"name": "付箋メモ",
"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": "webhook送信からアイテムを抽出",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-580,
-420
],
"parameters": {
"options": {},
"binaryPropertyName": "file"
},
"typeVersion": 1
},
{
"id": "ce82f958-081b-4a55-a0d1-8ffb69dee68b",
"name": "手動トリガー",
"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
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - 営業, マーケティング
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
Squarespaceのすべての注文をGoogleスプレッドシートに取得
Squarespaceの全注文をGoogleスプレッドシートに取得
Set
Split Out
Http Request
+
Set
Split Out
Http Request
8 ノードbangank36
営業
大規模超パーソナライズドアウトーチをBright DataとLLMで自動化
Bright Dataと大規模言語モデルを通じた大規模超パーソナライズドアッティングの自動化
If
Set
Wait
+
If
Set
Wait
21 ノードYaron Been
営業
BrowserflowとGoogle Sheetsを活用したLinkedInリクエストとア破冰メッセージの自動化
Browserflow と Google Sheets を使って LinkedIn リクエストとブレイクアウトメッセージを自動化
If
Set
Sort
+
If
Set
Sort
44 ノードPollupAI
営業
> 潜在顧客リサーチャーLinkedIn
自動 prospective客調査 - LinkedIn から送信可能なレポートへ
If
Set
Wait
+
If
Set
Wait
36 ノードLukaszB
営業
私のワークフロー5
AIメールパーソナライゼーションを使用した自動LinkedInリード生成（未完了）
If
Set
Code
+
If
Set
Code
37 ノードMatthieu
営業
HDWリードジェットバグ
AIエージェントを使用した自動LinkedInリード生成、スコアリング、コミュニケーション
If
Code
Sort
+
If
Code
Sort
86 ノードAndrey
営業
ワークフロー情報
難易度
中級
ノード数8
カテゴリー2
ノードタイプ6
作成者
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.
外部リンク
n8n.ioで表示 →
このワークフローを共有