Freshdesk CSAT 설문 조사 자동화 및 응답을 Google Sheets에 저장
고급
이것은Support분야의자동화 워크플로우로, 21개의 노드를 포함합니다.주로 If, Set, Markdown, EmailSend, Freshdesk 등의 노드를 사용하며. Freshdesk를 사용한 CSAT 설문 조사 자동화 및 응답을 Google Sheets에 저장
사전 요구사항
- •Google Sheets API 인증 정보
사용된 노드 (21)
카테고리
워크플로우 미리보기
노드 연결 관계를 시각적으로 표시하며, 확대/축소 및 이동을 지원합니다
워크플로우 내보내기
다음 JSON 구성을 복사하여 n8n에 가져오면 이 워크플로우를 사용할 수 있습니다
{
"nodes": [
{
"id": "7e821a77-1db8-4d91-8500-7785b195151b",
"name": "워크플로 '테스트' 클릭 시",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
-260
],
"parameters": {},
"typeVersion": 1
},
{
"id": "999e52f3-c10d-450a-ab13-f0d01318f1b4",
"name": "티켓이 해결된 경우",
"type": "n8n-nodes-base.if",
"position": [
880,
-360
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "e70ba235-bc7d-400f-a0e1-8e0baa815918",
"operator": {
"type": "number",
"operation": "notEquals"
},
"leftValue": "={{ $('get tickets').item.json.status }}",
"rightValue": "={{ $('get existing tickets').item.json.status }}"
},
{
"id": "82e34950-8e33-4f13-b562-c73b79c584fa",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('get tickets').item.json.status }}",
"rightValue": 4
}
]
},
"looseTypeValidation": true
},
"typeVersion": 2.2
},
{
"id": "fbe9f747-e591-491e-b47d-4a1875daa898",
"name": "이메일 보내기",
"type": "n8n-nodes-base.emailSend",
"position": [
1980,
-360
],
"webhookId": "28ebac0e-0387-4f8a-a574-a867e51de272",
"parameters": {
"html": "={{ $json.data }}",
"options": {
"appendAttribution": false
},
"subject": "={{ $json.subject }}",
"toEmail": "={{ $('get client').first().json.email }}",
"fromEmail": "thomas@pollup.net"
},
"credentials": {
"smtp": {
"id": "yrsGGdbYvSB8u7sx",
"name": "SMTP account"
}
},
"typeVersion": 2.1
},
{
"id": "fdc22898-b6ad-4489-8562-fe29e68a0832",
"name": "고객 정보 가져오기",
"type": "n8n-nodes-base.freshdesk",
"position": [
1320,
-360
],
"parameters": {
"resource": "contact",
"contactId": "={{ $('get tickets').item.json.requester_id }}",
"operation": "get"
},
"credentials": {
"freshdeskApi": {
"id": "op9AMlUqPbk3ZD8n",
"name": "Freshdesk account"
}
},
"typeVersion": 1
},
{
"id": "e9001b35-1d1f-4d23-bd84-92a471a043e5",
"name": "티켓 가져오기",
"type": "n8n-nodes-base.freshdesk",
"position": [
660,
-360
],
"parameters": {
"options": {},
"operation": "getAll"
},
"credentials": {
"freshdeskApi": {
"id": "op9AMlUqPbk3ZD8n",
"name": "Freshdesk account"
}
},
"typeVersion": 1
},
{
"id": "053a1afe-5f25-418e-936a-7770d9bb487e",
"name": "상태 업데이트",
"type": "n8n-nodes-base.googleSheets",
"position": [
1100,
-360
],
"parameters": {
"columns": {
"value": {
"status": "={{ $('get tickets').item.json.status }}",
"row_number": "={{ $('get existing tickets').item.json.row_number }}"
},
"schema": [
{
"id": "cc_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "cc_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "fwd_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "fwd_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reply_cc_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "reply_cc_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ticket_cc_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "ticket_cc_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ticket_bcc_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "ticket_bcc_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "fr_escalated",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "fr_escalated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "spam",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "spam",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_config_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email_config_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "group_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "group_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "priority",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "priority",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "requester_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "requester_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "responder_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "responder_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "source",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subject",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "association_type",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "association_type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "support_email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "support_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "to_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "to_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "product_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "product_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "type",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "due_by",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "due_by",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "fr_due_by",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "fr_due_by",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_escalated",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "is_escalated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "custom_fields",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "custom_fields",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "created_at",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "created_at",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "updated_at",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "updated_at",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "associated_tickets_count",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "associated_tickets_count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tags",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "tags",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "structured_description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "structured_description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sentiment_score",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "sentiment_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "initial_sentiment_score",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "initial_sentiment_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "nr_due_by",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "nr_due_by",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "nr_escalated",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "nr_escalated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "active",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "active",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "language",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "language",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "mobile",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "mobile",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "time_zone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "time_zone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "twitter_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "twitter_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "other_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "other_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "facebook_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "csat_rating",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "csat_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "preferred_source",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "preferred_source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "view_all_tickets",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "view_all_tickets",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "other_companies",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "other_companies",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "unique_external_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "unique_external_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "avatar",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "avatar",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"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": "visitor_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "visitor_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "org_contact_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "org_contact_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "other_phone_numbers",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "other_phone_numbers",
"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": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8/edit?usp=drivesdk",
"cachedResultName": "Freshdesk Tickets"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "2f192048-9b73-4687-a357-e84d1818209e",
"name": "스케줄 트리거",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
-460
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "b6690a95-d6b9-4283-a709-ad1a6b8502fe",
"name": "데이터 설정",
"type": "n8n-nodes-base.set",
"position": [
220,
-360
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d372b3e3-31bf-45f7-a407-b59916c38bee",
"name": "your name",
"type": "string",
"value": "Thomas Vié"
},
{
"id": "96626d9c-77f1-44e1-aa6f-f2df9f5680ac",
"name": "Your email",
"type": "string",
"value": "thomas@pollup.net"
},
{
"id": "48de3b9d-e582-4d31-9e24-9600c64ef20b",
"name": "your company name",
"type": "string",
"value": "Pollup Data services"
},
{
"id": "c83824e8-498d-4957-a7a9-12c939d7f989",
"name": "your position",
"type": "string",
"value": "C.T.O."
},
{
"id": "09065360-22c6-4c92-be2a-c6129b4dd3a0",
"name": "survey link",
"type": "string",
"value": "https://n8n.pollup.net/form/a05aa4bc-20a7-488d-8249-4d79a94c3a69"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "013c1ba5-d3ff-4304-88c5-ec824686a372",
"name": "메모",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-540
],
"parameters": {
"color": 4,
"height": 340,
"content": "## Set your data here\n- Put as Survey link the Production URL of the \"Survey\" Node and set the workflow to \"Active\""
},
"typeVersion": 1
},
{
"id": "cfcc442f-e885-43dc-ae0e-0bf27443c6ac",
"name": "설문조사",
"type": "n8n-nodes-base.formTrigger",
"position": [
0,
0
],
"webhookId": "a05aa4bc-20a7-488d-8249-4d79a94c3a69",
"parameters": {
"options": {},
"formTitle": "Quick Feedback",
"formFields": {
"values": [
{
"fieldType": "dropdown",
"fieldLabel": "On a scale of 1-5, how satisfied are you with the support you received?",
"fieldOptions": {
"values": [
{
"option": "1"
},
{
"option": "2"
},
{
"option": "3"
},
{
"option": "4"
},
{
"option": "5"
}
]
},
"requiredField": true
},
{
"fieldType": "textarea",
"fieldLabel": "Could you share what went wrong so we can improve?",
"requiredField": true
}
]
},
"formDescription": "Help Us Improve!"
},
"typeVersion": 2.2
},
{
"id": "cc3f18ff-6967-42f4-aa2a-23ec503a9b43",
"name": "기존 티켓 가져오기",
"type": "n8n-nodes-base.googleSheets",
"position": [
440,
-360
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8/edit?usp=drivesdk",
"cachedResultName": "Freshdesk Tickets"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "a6590283-4b5c-44d7-9384-40708e38a8e4",
"name": "메모1",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-540
],
"parameters": {
"color": 4,
"width": 180,
"height": 340,
"content": "## Save tickets\n- Create an empty google sheet and put it here"
},
"typeVersion": 1
},
{
"id": "878ba0f7-cad0-443a-884e-8ff1259fa02f",
"name": "메모2",
"type": "n8n-nodes-base.stickyNote",
"position": [
600,
-540
],
"parameters": {
"color": 4,
"width": 200,
"height": 340,
"content": "## Get tickets\n- Connect here to Freshdesk with your credentials"
},
"typeVersion": 1
},
{
"id": "c114af56-5686-40fa-b63d-158d14f87131",
"name": "이메일 텍스트 생성",
"type": "n8n-nodes-base.set",
"position": [
1540,
-360
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "63d258ad-77b4-4aab-9380-3a66152ac133",
"name": "subject",
"type": "string",
"value": "=Quick Feedback? Help Us Improve"
},
{
"id": "54baa177-0163-47d1-937a-b58547cc4767",
"name": "body",
"type": "string",
"value": "=Hi,\n\nWe recently closed the ticket \"{{ $('get tickets').item.json.subject }}\". How satisfied were you with your recent support experience? Could you answer a [very fast survey]({{ $('Set your data').item.json['survey link'] }})?\n\nThank you for your time — we value your voice.\n\nBest regards,\n\n{{ $('Set your data').item.json['your name'] }}\n{{ $('Set your data').item.json['your position'] }}\n{{ $('Set your data').item.json['your company name'] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "c5c217d5-7d2e-4c27-828f-a758a35c0f9c",
"name": "이메일 텍스트를 HTML로 변환",
"type": "n8n-nodes-base.markdown",
"position": [
1760,
-360
],
"parameters": {
"mode": "markdownToHtml",
"options": {},
"markdown": "={{ $json.body }}"
},
"typeVersion": 1
},
{
"id": "64bebbc9-a8a3-459f-8938-d9b17b1c64a2",
"name": "메모3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1920,
-540
],
"parameters": {
"color": 6,
"width": 200,
"height": 340,
"content": "## Email send settings\n- Here you can change this node for a gmail node for eaxmple. "
},
"typeVersion": 1
},
{
"id": "1372a887-042f-401c-bc39-38bccdb943e8",
"name": "메모4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1260,
-540
],
"parameters": {
"color": 4,
"width": 200,
"height": 340,
"content": "## Get Client\n- Connect here to Freshdesk with your credentials"
},
"typeVersion": 1
},
{
"id": "07287a6a-16e8-40da-a45e-bdc0e01f14d5",
"name": "설문조사 결과를 Google 시트에 저장",
"type": "n8n-nodes-base.googleSheets",
"position": [
200,
0
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "On a scale of 1-5, how satisfied are you with the support you received?",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "On a scale of 1-5, how satisfied are you with the support you received?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Could you share what went wrong so we can improve?",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Could you share what went wrong so we can improve?",
"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
}
],
"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/1owSLNTGyoDUw0IB6RFqRYyF_P-KFPiIvS8MM-RrDPjI/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1owSLNTGyoDUw0IB6RFqRYyF_P-KFPiIvS8MM-RrDPjI",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1owSLNTGyoDUw0IB6RFqRYyF_P-KFPiIvS8MM-RrDPjI/edit?usp=drivesdk",
"cachedResultName": "Feedback freshdesk"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "78fa9cde-7135-4dd2-8d74-9b6c826fbd6b",
"name": "메모5",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-100
],
"parameters": {
"color": 4,
"width": 220,
"height": 340,
"content": "## Save survey\n- Create an empty google sheet and put it here"
},
"typeVersion": 1
},
{
"id": "001ff1c0-515c-410f-a460-c52867af8cb9",
"name": "메모7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-780
],
"parameters": {
"width": 880,
"height": 220,
"content": "## Contact me\n- If you need any modification to this workflow\n- if you need some help with this workflow\n- Or if you need any workflow in n8n, Make, or Langchain / Langgraph\n\nWrite to me: [thomas@pollup.net](mailto:thomas@pollup.net)\n\n**Take a look at my others workflows [here](https://n8n.io/creators/zeerobug/)**\n\n"
},
"typeVersion": 1
},
{
"id": "e5420f8a-b734-4d7c-af02-204c3d263457",
"name": "메모6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
-100
],
"parameters": {
"color": 6,
"width": 220,
"height": 340,
"content": "## Modify Survey\n- Set all the survey's question you need here"
},
"typeVersion": 1
}
],
"connections": {
"cfcc442f-e885-43dc-ae0e-0bf27443c6ac": {
"main": [
[
{
"node": "07287a6a-16e8-40da-a45e-bdc0e01f14d5",
"type": "main",
"index": 0
}
]
]
},
"fdc22898-b6ad-4489-8562-fe29e68a0832": {
"main": [
[
{
"node": "c114af56-5686-40fa-b63d-158d14f87131",
"type": "main",
"index": 0
}
]
]
},
"e9001b35-1d1f-4d23-bd84-92a471a043e5": {
"main": [
[
{
"node": "999e52f3-c10d-450a-ab13-f0d01318f1b4",
"type": "main",
"index": 0
}
]
]
},
"b6690a95-d6b9-4283-a709-ad1a6b8502fe": {
"main": [
[
{
"node": "cc3f18ff-6967-42f4-aa2a-23ec503a9b43",
"type": "main",
"index": 0
}
]
]
},
"053a1afe-5f25-418e-936a-7770d9bb487e": {
"main": [
[
{
"node": "fdc22898-b6ad-4489-8562-fe29e68a0832",
"type": "main",
"index": 0
}
]
]
},
"2f192048-9b73-4687-a357-e84d1818209e": {
"main": [
[
{
"node": "b6690a95-d6b9-4283-a709-ad1a6b8502fe",
"type": "main",
"index": 0
}
]
]
},
"999e52f3-c10d-450a-ab13-f0d01318f1b4": {
"main": [
[
{
"node": "053a1afe-5f25-418e-936a-7770d9bb487e",
"type": "main",
"index": 0
}
]
]
},
"cc3f18ff-6967-42f4-aa2a-23ec503a9b43": {
"main": [
[
{
"node": "e9001b35-1d1f-4d23-bd84-92a471a043e5",
"type": "main",
"index": 0
}
]
]
},
"c114af56-5686-40fa-b63d-158d14f87131": {
"main": [
[
{
"node": "c5c217d5-7d2e-4c27-828f-a758a35c0f9c",
"type": "main",
"index": 0
}
]
]
},
"c5c217d5-7d2e-4c27-828f-a758a35c0f9c": {
"main": [
[
{
"node": "fbe9f747-e591-491e-b47d-4a1875daa898",
"type": "main",
"index": 0
}
]
]
},
"7e821a77-1db8-4d91-8500-7785b195151b": {
"main": [
[
{
"node": "b6690a95-d6b9-4283-a709-ad1a6b8502fe",
"type": "main",
"index": 0
}
]
]
}
}
}자주 묻는 질문
이 워크플로우를 어떻게 사용하나요?
위의 JSON 구성 코드를 복사하여 n8n 인스턴스에서 새 워크플로우를 생성하고 "JSON에서 가져오기"를 선택한 후, 구성을 붙여넣고 필요에 따라 인증 설정을 수정하세요.
이 워크플로우는 어떤 시나리오에 적합한가요?
고급 - 지원
유료인가요?
이 워크플로우는 완전히 무료이며 직접 가져와 사용할 수 있습니다. 다만, 워크플로우에서 사용하는 타사 서비스(예: OpenAI API)는 사용자 직접 비용을 지불해야 할 수 있습니다.
관련 워크플로우 추천
Google Sheets, Forms 및 Gmail 알림을 사용한 다단계 온보딩 프로세스 자동화
Google Sheets, Forms 및 Gmail 알림을 사용한 자동화된 다단계 온보딩 프로세스
If
Set
Code
+
If
Set
Code
31 노드PollupAI
인사
Noco 칸반과 AI 우선순위 지정
AI를 사용하여 요청 할당 및 NocoDB 칸반 상태에 따른 알림 전송
If
Set
Slack
+
If
Set
Slack
27 노드Łukasz
지원
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
영업
CSV를 HubSpot에 업로드기 (동적 필드 맵핑 및 Google 스프레드시트 통합)
동적 필드 맵핑과 Google Sheets 통합을 포함한 CSV에서 HubSpot 업로드
If
Set
Code
+
If
Set
Code
36 노드PollupAI
인공지능
리드 생성 및 이메일 워크플로
Google 지도, SendGrid 및 AI를 사용한 B2B 잠재 고객 개발 및 이메일 마케팅 자동화
If
Set
Code
+
If
Set
Code
141 노드Ezema Kingsley Chibuzo
리드 생성
워크플로우 정보
난이도
고급
노드 수21
카테고리1
노드 유형10
저자
PollupAI
@zeerobugWe create bespoke AI solutions, automations and agents that help your business as it scales.
외부 링크
n8n.io에서 보기 →
이 워크플로우 공유