Google Sheets, Forms 및 Gmail 알림을 사용한 다단계 온보딩 프로세스 자동화
고급
이것은HR, Multimodal AI분야의자동화 워크플로우로, 31개의 노드를 포함합니다.주로 If, Set, Code, Form, Gmail 등의 노드를 사용하며. Google Sheets, Forms 및 Gmail 알림을 사용한 자동화된 다단계 온보딩 프로세스
사전 요구사항
- •Google 계정 및 Gmail API 인증 정보
- •Google Sheets API 인증 정보
사용된 노드 (31)
워크플로우 미리보기
노드 연결 관계를 시각적으로 표시하며, 확대/축소 및 이동을 지원합니다
워크플로우 내보내기
다음 JSON 구성을 복사하여 n8n에 가져오면 이 워크플로우를 사용할 수 있습니다
{
"nodes": [
{
"id": "bdb2c014-ce81-4e05-bfd1-e6ca9a42fb0f",
"name": "워크플로 실행 시",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-2240,
2462
],
"parameters": {},
"typeVersion": 1
},
{
"id": "73376d8c-21d3-47b3-af14-3872147ce7af",
"name": "메시지 테이블 생성",
"type": "n8n-nodes-base.code",
"position": [
-1800,
2362
],
"parameters": {
"jsCode": "const steps = $input.all().map((item) => item.json);\n\nconst result = steps.reduce((acc, step) => {\n const { step: stepIndex, Type, ...rest } = step;\n if (!acc[stepIndex]) {\n acc[stepIndex] = {};\n }\n if (!acc[stepIndex][Type]) {\n acc[stepIndex][Type] = {};\n }\n acc[stepIndex][Type] = rest;\n return acc;\n}, {});\n\nreturn result;\n"
},
"typeVersion": 2
},
{
"id": "46747e54-1288-4887-aa08-d37cc835f57e",
"name": "MSG 상태 행 읽기",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1580,
2362
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit?usp=drivesdk",
"cachedResultName": "Standardized messages status"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"executeOnce": true,
"typeVersion": 4.6
},
{
"id": "0d67cbd3-d0f5-45a7-9057-289a97be871a",
"name": "트리거 예약",
"type": "n8n-nodes-base.scheduleTrigger",
"disabled": true,
"position": [
-2240,
2262
],
"parameters": {
"rule": {
"interval": [
{
"field": "minutes"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "2526926e-8a12-4e5c-a588-03e9f03bb334",
"name": "completed4인 경우",
"type": "n8n-nodes-base.if",
"position": [
-260,
2562
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "02a63c32-dbed-48d6-a459-2d12969c6524",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.check }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "75188ae4-001c-4a84-89fd-b9d9f3d9f608",
"name": "Form",
"type": "n8n-nodes-base.form",
"position": [
-1800,
1860
],
"webhookId": "77ad7d58-abf8-4133-96f7-0a117a157b59",
"parameters": {
"options": {},
"operation": "completion",
"completionTitle": "Thanks a lot for entering your information"
},
"typeVersion": 1
},
{
"id": "2db39637-6703-4691-ad62-1aabb8429357",
"name": "등록 데이터 저장",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2020,
1860
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"removed": false,
"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": "submittedAt",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "submittedAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "formMode",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "formMode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "step",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "step",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit?usp=drivesdk",
"cachedResultName": "Standardized messages status"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "824c1b36-bff3-4165-821a-9e2425c0a067",
"name": "메시지 읽기",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2020,
2362
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/17_fUSV9zJo8Ya6ulvCOon2wjoeEmOwDFrpK1Xxa9gmw/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "17_fUSV9zJo8Ya6ulvCOon2wjoeEmOwDFrpK1Xxa9gmw",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/17_fUSV9zJo8Ya6ulvCOon2wjoeEmOwDFrpK1Xxa9gmw/edit?usp=drivesdk",
"cachedResultName": "Standardized Messages"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"executeOnce": true,
"typeVersion": 4.6
},
{
"id": "d3dcba73-305b-4faf-94ae-8f6d53a9f708",
"name": "행을 completed로 업데이트",
"type": "n8n-nodes-base.googleSheets",
"position": [
-260,
2120
],
"parameters": {
"columns": {
"value": {
"status": "completed",
"row_number": "={{ $('Read MSG status Rows').item.json.row_number }}"
},
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "submittedAt",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "submittedAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "formMode",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "formMode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "step",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "step",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit?usp=drivesdk",
"cachedResultName": "Standardized messages status"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "VVX0td9tCoaQ6bwK",
"name": "New credentials to new project"
}
},
"typeVersion": 4.6
},
{
"id": "8a89a0c4-0dae-4139-91c3-b05678722d10",
"name": "일부 작업 수행",
"type": "n8n-nodes-base.noOp",
"position": [
-700,
2220
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e336dac1-00e4-4149-8e00-d3e207a99549",
"name": "작업 완료 여부 확인",
"type": "n8n-nodes-base.noOp",
"position": [
-700,
2562
],
"parameters": {},
"typeVersion": 1
},
{
"id": "159ebeb8-efc0-4489-be43-7fe7e05597ca",
"name": "다음 단계 생성",
"type": "n8n-nodes-base.googleSheets",
"position": [
400,
2462
],
"parameters": {
"columns": {
"value": {
"step": "={{ $('Read MSG status Rows').item.json.step + 1 }}",
"Email": "={{ $('Read MSG status Rows').item.json.Email }}",
"status": "=sent",
"Last Name": "={{ $('Read MSG status Rows').item.json['Last Name'] }}",
"First Name": "={{ $('Read MSG status Rows').item.json['First Name'] }}"
},
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"removed": false,
"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": "submittedAt",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "submittedAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "formMode",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "formMode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "step",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "step",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yJ1JaUq4BNMWpBKl9E6Z-lkwcnZA7xQxc-zy4-TDeM0/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit?usp=drivesdk",
"cachedResultName": "Standardized messages status"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "082323c8-a6ec-475d-ad37-74df2cad4757",
"name": "메시지 전송",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
-2240,
2960
],
"parameters": {
"workflowInputs": {
"values": [
{
"name": "email"
},
{
"name": "subject"
},
{
"name": "content"
},
{
"name": "variables",
"type": "object"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "fccbeab1-3536-409a-b68a-4bcf63a14f05",
"name": "Gmail2",
"type": "n8n-nodes-base.gmail",
"position": [
-1800,
2960
],
"webhookId": "4deca0da-c9ea-4707-bd1e-7f334b86a4a4",
"parameters": {
"sendTo": "={{ $('Send message').item.json.email }}",
"message": "={{ $json.msg }}",
"options": {
"appendAttribution": false
},
"subject": "={{ $('Send message').item.json.subject }}"
},
"credentials": {
"gmailOAuth2": {
"id": "DLjspol9TLgpGaXa",
"name": "Gmail account 2"
}
},
"typeVersion": 2.1
},
{
"id": "15c53cfe-963c-4ff3-8126-204c9c01f00e",
"name": "사용자에게 메시지 전송",
"type": "n8n-nodes-base.executeWorkflow",
"onError": "continueErrorOutput",
"position": [
-480,
2220
],
"parameters": {
"mode": "each",
"options": {},
"workflowId": {
"__rl": true,
"mode": "id",
"value": "EORpbQwSc80AYgSs"
},
"workflowInputs": {
"value": {
"email": "={{ $('Read MSG status Rows').item.json.Email }}",
"content": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].sent.Content }}",
"subject": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].sent['Email subject'] }}",
"variables": "={{ $('Set variables').item.json.variables }}"
},
"schema": [
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subject",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "content",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "variables",
"type": "object",
"display": true,
"removed": false,
"required": false,
"displayName": "variables",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": true,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "17b9e0b9-9be8-4086-86d2-6b5f3e43096e",
"name": "관리자에게 메시지 전송",
"type": "n8n-nodes-base.executeWorkflow",
"onError": "continueErrorOutput",
"position": [
-260,
2320
],
"parameters": {
"options": {},
"workflowId": {
"__rl": true,
"mode": "id",
"value": "EORpbQwSc80AYgSs"
},
"workflowInputs": {
"value": {
"email": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].error['Email Reponsible'] }}",
"content": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].error.Content }}",
"subject": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].error['Email subject'] }}",
"variables": "={{ $('Set variables').item.json.variables }}"
},
"schema": [
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subject",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "content",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "variables",
"type": "object",
"display": true,
"removed": false,
"required": false,
"displayName": "variables",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "a007cd85-93d8-48bb-8921-ffdb5b653491",
"name": "사용자1에게 메시지 전송",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
-40,
2462
],
"parameters": {
"mode": "each",
"options": {},
"workflowId": {
"__rl": true,
"mode": "id",
"value": "EORpbQwSc80AYgSs"
},
"workflowInputs": {
"value": {
"email": "={{ $('Read MSG status Rows').item.json.Email }}",
"content": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].completed['Content'] }}",
"subject": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].completed['Email subject'] }}",
"variables": "={{ $('Set variables').item.json.variables }}"
},
"schema": [
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subject",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "content",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "variables",
"type": "object",
"display": true,
"removed": false,
"required": false,
"displayName": "variables",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "9fc1fc41-0776-4fc5-a4c1-efc5129e3b12",
"name": "변수 설정",
"type": "n8n-nodes-base.set",
"position": [
-1360,
2362
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7bcd18e7-d1aa-4f9b-8bc6-3114cee5a2b2",
"name": "variables",
"type": "object",
"value": "={{ { email: $('Read MSG status Rows').item.json['First Name']+'.'+$('Read MSG status Rows').item.json['Last Name'] +'@yourcompany.com', error: \"This has been ean error\" } }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "72bd115d-d8ec-43d4-93d0-bbd3eedbbba1",
"name": "Code",
"type": "n8n-nodes-base.code",
"position": [
-2020,
2960
],
"parameters": {
"jsCode": "\nlet template = $input.first().json.content\nlet variables = $input.first().json.variables\nlet msg = template.replace(/\\{\\{\\s*(\\w+)\\s*\\}\\}/g, (match, variableName) => {\n return variables.hasOwnProperty(variableName) \n ? variables[variableName] \n : match; // if variable not found, leave as is\n});\n\nreturn {msg}"
},
"typeVersion": 2
},
{
"id": "99146b8e-8f06-4c1c-94ff-abf68cf2fa29",
"name": "관리자1에게 메시지 전송",
"type": "n8n-nodes-base.executeWorkflow",
"onError": "continueErrorOutput",
"position": [
-40,
2662
],
"parameters": {
"options": {},
"workflowId": {
"__rl": true,
"mode": "id",
"value": "EORpbQwSc80AYgSs"
},
"workflowInputs": {
"value": {
"email": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].error['Email Reponsible'] }}",
"content": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].error['Content'] }}",
"subject": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].error['Email subject'] }}",
"variables": "={{ $('Set variables').item.json.variables }}"
},
"schema": [
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subject",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "content",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "variables",
"type": "object",
"display": true,
"removed": false,
"required": false,
"displayName": "variables",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "691dc84a-67aa-4df2-9ccf-43b24ef21a4d",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2300,
1680
],
"parameters": {
"color": 4,
"width": 680,
"height": 340,
"content": "## This is the starting point\n- You can send the link by email to the person\n- On ce it will fill it it will create the Step 1"
},
"typeVersion": 1
},
{
"id": "fe9f14e5-6ddf-4354-9596-d4cb3f933664",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"position": [
-920,
2178
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Step 1",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e27fcf86-b911-4fb8-b578-5e634dcaa652",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 1
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 2",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "1e77bdfb-5aad-45c5-a9ef-6882d0c448e9",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 2
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 3",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "6cb7728e-4ee2-446a-8822-12c1b98d5aca",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 3
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 4",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "193098e4-0fa4-4805-ac37-8512bd8ce33b",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 4
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 5",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "efe9e13c-4a52-456a-b927-29694fe9b0da",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 5
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "7fef0239-7179-4ac2-8b6b-df3e0ff68ba6",
"name": "Switch1",
"type": "n8n-nodes-base.switch",
"position": [
-920,
2520
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Step 1",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e27fcf86-b911-4fb8-b578-5e634dcaa652",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 1
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 2",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "1e77bdfb-5aad-45c5-a9ef-6882d0c448e9",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 2
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 3",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "6cb7728e-4ee2-446a-8822-12c1b98d5aca",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 3
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 4",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "193098e4-0fa4-4805-ac37-8512bd8ce33b",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 4
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 5",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "efe9e13c-4a52-456a-b927-29694fe9b0da",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 5
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "add73124-2a49-4b9b-b732-ff51c519b631",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-980,
2060
],
"parameters": {
"height": 340,
"content": "## Case setting \nHere you can set the distinct action for each step"
},
"typeVersion": 1
},
{
"id": "6ad12fb7-9e21-443a-bc2a-1f3f582fbe95",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-980,
2420
],
"parameters": {
"height": 400,
"content": "## Case setting \nHere you can set the distinct verifications for each step"
},
"typeVersion": 1
},
{
"id": "e25b6577-80ef-4419-ba65-8d7baa5c7bb4",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2300,
2040
],
"parameters": {
"color": 4,
"width": 2940,
"height": 800,
"content": "## Main workflow\n"
},
"typeVersion": 1
},
{
"id": "61697f64-a7f5-44b3-97f2-aa99104d61e0",
"name": "단계 유형 전환",
"type": "n8n-nodes-base.switch",
"position": [
-1140,
2362
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "sent",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d2891710-d6d4-47d9-aecd-8e3a9e1f8454",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.status }}",
"rightValue": "=sent"
}
]
},
"renameOutput": true
},
{
"outputKey": "completed",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "9713a3ff-b93b-4b18-9e12-666d398351b6",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.status }}",
"rightValue": "completed"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "c35de795-5fc3-4e6d-a87b-a98d467e7f74",
"name": "디버그 모드 결과 설정",
"type": "n8n-nodes-base.set",
"position": [
-480,
2562
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "c5376105-41c5-4cee-ac3f-665bda0a996d",
"name": "check",
"type": "boolean",
"value": true
}
]
}
},
"typeVersion": 3.4
},
{
"id": "3d3ce9ce-83d1-4e07-8f09-a4248e9e8759",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2300,
2860
],
"parameters": {
"color": 4,
"width": 680,
"height": 260,
"content": "## Sub Workflow \n- replace the variables enclosed in {{ }} by its corresponding value set in \"Set variables node\".\n- Send messages, here you can set a slack or telegram nessage"
},
"typeVersion": 1
},
{
"id": "e0a9ac24-c20a-4209-a896-55da6dd158e3",
"name": "행을 passed로 업데이트",
"type": "n8n-nodes-base.googleSheets",
"position": [
180,
2460
],
"parameters": {
"columns": {
"value": {
"status": "passed",
"row_number": "={{ $('Read MSG status Rows').item.json.row_number }}"
},
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "submittedAt",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "submittedAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "formMode",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "formMode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "step",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "step",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yJ1JaUq4BNMWpBKl9E6Z-lkwcnZA7xQxc-zy4-TDeM0/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit?usp=drivesdk",
"cachedResultName": "Standardized messages status"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "9d5ca28d-01a3-405c-a3a9-f9de83ba174e",
"name": "Registration",
"type": "n8n-nodes-base.formTrigger",
"position": [
-2240,
1860
],
"webhookId": "fc69bf4d-938e-48e4-a2e1-91f599c0d61a",
"parameters": {
"options": {
"path": "onboarding"
},
"formTitle": "Welcome to our company",
"formFields": {
"values": [
{
"fieldLabel": "First Name",
"requiredField": true
},
{
"fieldLabel": "Last Name",
"requiredField": true
},
{
"fieldLabel": "Email",
"requiredField": true
},
{
"fieldName": "step",
"fieldType": "hiddenField",
"fieldValue": "1"
},
{
"fieldName": "status",
"fieldType": "hiddenField",
"fieldValue": "sent"
}
]
},
"formDescription": "Please enter you data here"
},
"typeVersion": 2.2
}
],
"connections": {
"72bd115d-d8ec-43d4-93d0-bbd3eedbbba1": {
"main": [
[
{
"node": "fccbeab1-3536-409a-b68a-4bcf63a14f05",
"type": "main",
"index": 0
}
]
]
},
"fe9f14e5-6ddf-4354-9596-d4cb3f933664": {
"main": [
[
{
"node": "8a89a0c4-0dae-4139-91c3-b05678722d10",
"type": "main",
"index": 0
}
],
[
{
"node": "8a89a0c4-0dae-4139-91c3-b05678722d10",
"type": "main",
"index": 0
}
],
[
{
"node": "8a89a0c4-0dae-4139-91c3-b05678722d10",
"type": "main",
"index": 0
}
],
[
{
"node": "8a89a0c4-0dae-4139-91c3-b05678722d10",
"type": "main",
"index": 0
}
],
[
{
"node": "8a89a0c4-0dae-4139-91c3-b05678722d10",
"type": "main",
"index": 0
}
]
]
},
"7fef0239-7179-4ac2-8b6b-df3e0ff68ba6": {
"main": [
[
{
"node": "e336dac1-00e4-4149-8e00-d3e207a99549",
"type": "main",
"index": 0
}
],
[
{
"node": "e336dac1-00e4-4149-8e00-d3e207a99549",
"type": "main",
"index": 0
}
],
[
{
"node": "e336dac1-00e4-4149-8e00-d3e207a99549",
"type": "main",
"index": 0
}
],
[
{
"node": "e336dac1-00e4-4149-8e00-d3e207a99549",
"type": "main",
"index": 0
}
],
[
{
"node": "e336dac1-00e4-4149-8e00-d3e207a99549",
"type": "main",
"index": 0
}
]
]
},
"9d5ca28d-01a3-405c-a3a9-f9de83ba174e": {
"main": [
[
{
"node": "2db39637-6703-4691-ad62-1aabb8429357",
"type": "main",
"index": 0
}
]
]
},
"082323c8-a6ec-475d-ad37-74df2cad4757": {
"main": [
[
{
"node": "72bd115d-d8ec-43d4-93d0-bbd3eedbbba1",
"type": "main",
"index": 0
}
]
]
},
"2526926e-8a12-4e5c-a588-03e9f03bb334": {
"main": [
[
{
"node": "a007cd85-93d8-48bb-8921-ffdb5b653491",
"type": "main",
"index": 0
}
],
[
{
"node": "99146b8e-8f06-4c1c-94ff-abf68cf2fa29",
"type": "main",
"index": 0
}
]
]
},
"824c1b36-bff3-4165-821a-9e2425c0a067": {
"main": [
[
{
"node": "73376d8c-21d3-47b3-af14-3872147ce7af",
"type": "main",
"index": 0
}
]
]
},
"9fc1fc41-0776-4fc5-a4c1-efc5129e3b12": {
"main": [
[
{
"node": "61697f64-a7f5-44b3-97f2-aa99104d61e0",
"type": "main",
"index": 0
}
]
]
},
"8a89a0c4-0dae-4139-91c3-b05678722d10": {
"main": [
[
{
"node": "15c53cfe-963c-4ff3-8126-204c9c01f00e",
"type": "main",
"index": 0
}
]
]
},
"159ebeb8-efc0-4489-be43-7fe7e05597ca": {
"main": [
[]
]
},
"0d67cbd3-d0f5-45a7-9057-289a97be871a": {
"main": [
[
{
"node": "824c1b36-bff3-4165-821a-9e2425c0a067",
"type": "main",
"index": 0
}
]
]
},
"15c53cfe-963c-4ff3-8126-204c9c01f00e": {
"main": [
[
{
"node": "d3dcba73-305b-4faf-94ae-8f6d53a9f708",
"type": "main",
"index": 0
}
],
[
{
"node": "17b9e0b9-9be8-4086-86d2-6b5f3e43096e",
"type": "main",
"index": 0
}
]
]
},
"a007cd85-93d8-48bb-8921-ffdb5b653491": {
"main": [
[
{
"node": "e0a9ac24-c20a-4209-a896-55da6dd158e3",
"type": "main",
"index": 0
}
]
]
},
"61697f64-a7f5-44b3-97f2-aa99104d61e0": {
"main": [
[
{
"node": "fe9f14e5-6ddf-4354-9596-d4cb3f933664",
"type": "main",
"index": 0
}
],
[
{
"node": "7fef0239-7179-4ac2-8b6b-df3e0ff68ba6",
"type": "main",
"index": 0
}
]
]
},
"e336dac1-00e4-4149-8e00-d3e207a99549": {
"main": [
[
{
"node": "c35de795-5fc3-4e6d-a87b-a98d467e7f74",
"type": "main",
"index": 0
}
]
]
},
"46747e54-1288-4887-aa08-d37cc835f57e": {
"main": [
[
{
"node": "9fc1fc41-0776-4fc5-a4c1-efc5129e3b12",
"type": "main",
"index": 0
}
]
]
},
"e0a9ac24-c20a-4209-a896-55da6dd158e3": {
"main": [
[
{
"node": "159ebeb8-efc0-4489-be43-7fe7e05597ca",
"type": "main",
"index": 0
}
]
]
},
"c35de795-5fc3-4e6d-a87b-a98d467e7f74": {
"main": [
[
{
"node": "2526926e-8a12-4e5c-a588-03e9f03bb334",
"type": "main",
"index": 0
}
]
]
},
"73376d8c-21d3-47b3-af14-3872147ce7af": {
"main": [
[
{
"node": "46747e54-1288-4887-aa08-d37cc835f57e",
"type": "main",
"index": 0
}
]
]
},
"2db39637-6703-4691-ad62-1aabb8429357": {
"main": [
[
{
"node": "75188ae4-001c-4a84-89fd-b9d9f3d9f608",
"type": "main",
"index": 0
}
]
]
},
"d3dcba73-305b-4faf-94ae-8f6d53a9f708": {
"main": [
[]
]
},
"bdb2c014-ce81-4e05-bfd1-e6ca9a42fb0f": {
"main": [
[
{
"node": "824c1b36-bff3-4165-821a-9e2425c0a067",
"type": "main",
"index": 0
}
]
]
}
}
}자주 묻는 질문
이 워크플로우를 어떻게 사용하나요?
위의 JSON 구성 코드를 복사하여 n8n 인스턴스에서 새 워크플로우를 생성하고 "JSON에서 가져오기"를 선택한 후, 구성을 붙여넣고 필요에 따라 인증 설정을 수정하세요.
이 워크플로우는 어떤 시나리오에 적합한가요?
고급 - 인사, 멀티모달 AI
유료인가요?
이 워크플로우는 완전히 무료이며 직접 가져와 사용할 수 있습니다. 다만, 워크플로우에서 사용하는 타사 서비스(예: OpenAI API)는 사용자 직접 비용을 지불해야 할 수 있습니다.
관련 워크플로우 추천
Unipile과 Google Sheets를 사용한 LinkedIn 연결 요청 및 첫 메시지 자동 발송
Unipile 및 Google Sheets를 사용하여 LinkedIn 연결 요청 및 아이스브레이킹 메시지 자동 전송
If
Set
Code
+
If
Set
Code
44 노드PollupAI
기타
Browserflow와 Google Sheets를 사용한 LinkedIn 요청 및 첫 메시지 자동화
Browserflow 및 Google Sheets를 사용한 자동화된 LinkedIn 요청 및 아이스브레이킹 메시지
If
Set
Sort
+
If
Set
Sort
44 노드PollupAI
영업
시각화 참조 라이브러리에서 n8n 노드를 탐색
可视化 참조 라이브러리에서 n8n 노드를 탐색
If
Ftp
Set
+
If
Ftp
Set
113 노드I versus AI
기타
WordPress 블로그 자동화 프로페셔널 에디션(심층 연구) v2.1 마켓
GPT-4o, Perplexity AI 및 다국어 지원을 사용한 SEO 최적화 블로그 생성 자동화
If
Set
Xml
+
If
Set
Xml
125 노드Daniel Ng
콘텐츠 제작
리드 생성 및 이메일 워크플로
Google 지도, SendGrid 및 AI를 사용한 B2B 잠재 고객 개발 및 이메일 마케팅 자동화
If
Set
Code
+
If
Set
Code
141 노드Ezema Kingsley Chibuzo
리드 생성
LinkedIn 및 X 바이럴 콘텐츠 자동 엔진
사용AI생성및게시자동생성LinkedIn및X의病毒콘텐츠
If
Set
Wait
+
If
Set
Wait
156 노드Diptamoy Barman
콘텐츠 제작
워크플로우 정보
난이도
고급
노드 수31
카테고리2
노드 유형14
저자
PollupAI
@zeerobugWe create bespoke AI solutions, automations and agents that help your business as it scales.
외부 링크
n8n.io에서 보기 →
이 워크플로우 공유