CallForge - 02 - Sheets와 Notion을 사용하여 Gong 통화를 준비하여 AI 요약
고급
이것은Sales, Product, AI분야의자동화 워크플로우로, 26개의 노드를 포함합니다.주로 Set, Gong, Merge, Notion, SplitOut 등의 노드를 사용하며인공지능 기술을 결합하여 스마트 자동화를 구현합니다. CallForge - 02 - Sheets와 Notion을 사용하여 Gong 통화를 준비하고 AI 요약을 생성합니다.
사전 요구사항
- •Notion API Key
- •Google Sheets API 인증 정보
사용된 노드 (26)
워크플로우 미리보기
노드 연결 관계를 시각적으로 표시하며, 확대/축소 및 이동을 지원합니다
워크플로우 내보내기
다음 JSON 구성을 복사하여 n8n에 가져오면 이 워크플로우를 사용할 수 있습니다
{
"meta": {
"instanceId": "cb484ba7b742928a2048bf8829668bed5b5ad9787579adea888f05980292a4a7",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "25fb4302-853a-421d-8e4f-4a18d723c4a0",
"name": "‘Test workflow’ 클릭 시",
"type": "n8n-nodes-base.manualTrigger",
"disabled": true,
"position": [
-860,
380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "acb8e29a-75b8-4ccb-aca8-20d5a7053334",
"name": "Gong",
"type": "n8n-nodes-base.gong",
"disabled": true,
"position": [
-440,
120
],
"parameters": {
"filters": {
"toDateTime": "={{ $now.toISO() }}",
"fromDateTime": "={{ $now.minus({ days: 2 }).toISO() }}"
},
"options": {},
"returnAll": true,
"requestOptions": {}
},
"credentials": {
"gongApi": {
"id": "EchfvOC4rjw8MUkr",
"name": "Liam Gong Cred"
}
},
"typeVersion": 1
},
{
"id": "930a7fc9-64a1-4966-be0d-c58132b735e5",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-700,
-60
],
"parameters": {
"color": 7,
"width": 1080,
"height": 920,
"content": "## Get Gong Calls and Supporting Data\nBesides the phone calls, integration and competitor data is extracted to supplement the AI prompt with accurate data to compare against mispronunciations. "
},
"typeVersion": 1
},
{
"id": "f21ae8cc-eed1-4d31-8b1f-cc731e3dc642",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-60
],
"parameters": {
"color": 7,
"width": 880,
"height": 920,
"content": "## Remove Duplicates from Queue\nChecks notion for already processed calls and removes them from the processing queue ensuring data is not duplicated. "
},
"typeVersion": 1
},
{
"id": "d796312a-2a7f-429f-8550-d4af6d81a26d",
"name": "Transcript Processor",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
2200,
640
],
"parameters": {
"options": {},
"workflowId": {
"__rl": true,
"mode": "list",
"value": "7BAQDjnHQVYO1SWG",
"cachedResultName": "Transcript Processor Demo"
}
},
"typeVersion": 1.1
},
{
"id": "b381f944-d865-450e-a24d-31d394a01b36",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1820,
420
],
"parameters": {
"color": 7,
"width": 700,
"height": 440,
"content": "## Generate Clean Transcript \nAllows for reduced prompting in the OpenAI node. "
},
"typeVersion": 1
},
{
"id": "7a87e6a0-0009-4776-bf2e-bea68702c808",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1820,
-40
],
"parameters": {
"color": 7,
"width": 700,
"height": 440,
"content": "## Pass Call Transcripts to Call Processor\nThe OpenAI node handles this process and outputs in structured JSON."
},
"typeVersion": 1
},
{
"id": "4c3b5280-c5e1-49d1-9651-e3fdd45978f7",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1300,
-60
],
"parameters": {
"color": 7,
"width": 500,
"height": 920,
"content": "## Loop through all calls to get enrichment\nAllows for easier processing due to complexity "
},
"typeVersion": 1
},
{
"id": "ce942178-c93e-490a-9b4e-0798f8c5c742",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1080,
-340
],
"parameters": {
"color": 5,
"width": 360,
"height": 1200,
"content": "\n## CallForge - The AI Gong Sales Call Processor\nCallForge allows you to extract important information for different departments from your Sales Gong Calls. \n\n### Call PreProcessor\nThis workflow preps the calls to pass into the call processor. It also pulls data from the product in order to enrich the AI Prompt to catch typos in the Gong call transcript. It then cleans up the transcript into a single string and then sends it to the call processor."
},
"typeVersion": 1
},
{
"id": "41f3d049-e25b-453a-bf98-501af7f177d0",
"name": "Execute Workflow Trigger",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
-860,
580
],
"parameters": {},
"typeVersion": 1
},
{
"id": "02265963-ab06-4bf5-8b0b-5299cd3330c9",
"name": "Call Aggregator",
"type": "n8n-nodes-base.aggregate",
"position": [
-100,
120
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData",
"destinationFieldName": "calls"
},
"typeVersion": 1
},
{
"id": "044e1b65-059c-4084-b85a-e10e6149be34",
"name": "Integration Aggregator",
"type": "n8n-nodes-base.aggregate",
"position": [
-240,
380
],
"parameters": {
"options": {},
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "Google Sheets"
}
]
}
},
"typeVersion": 1
},
{
"id": "31df099f-45ec-4dff-b968-a90e7eaa67b5",
"name": "Get Integrations",
"type": "n8n-nodes-base.googleSheets",
"position": [
-460,
380
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1859794756,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DKrLntdoNScMey5Bb4ggSpS8NFHlYN3kuTJQbrbJU7I/edit#gid=1859794756",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1DKrLntdoNScMey5Bb4ggSpS8NFHlYN3kuTJQbrbJU7I",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DKrLntdoNScMey5Bb4ggSpS8NFHlYN3kuTJQbrbJU7I/edit?usp=drivesdk",
"cachedResultName": "Most Popular Node Combos"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "4ZBfVX71VUd6pRy3",
"name": "Google Sheets Angel Access"
}
},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "42a8299e-d2e4-48a9-bba9-1c5e419d8c0c",
"name": "Comma Separate Integrations",
"type": "n8n-nodes-base.set",
"position": [
-20,
380
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "39dfde65-e5e0-46d8-8596-af7ea31fcd3b",
"name": "integrations",
"type": "string",
"value": "={{ $json[\"Google Sheets\"].join() }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "4226f79a-8b28-46d7-8b3b-972ef41d9535",
"name": "Comma separate competitors",
"type": "n8n-nodes-base.set",
"position": [
-20,
580
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "c419af9b-f161-4aac-863f-3a450aaf759f",
"name": "competitors",
"type": "string",
"value": "={{ $jmespath($json.properties['Competitor vs.'].select.options, '[].name').join() }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "cce3fab9-63fb-49de-8e3f-4fb7956d0b80",
"name": "Get list of Competitors",
"type": "n8n-nodes-base.notion",
"position": [
-460,
580
],
"parameters": {
"simple": false,
"resource": "database",
"databaseId": {
"__rl": true,
"mode": "list",
"value": "2cb8596f-2029-4d15-bf56-7001652f6fcf",
"cachedResultUrl": "https://www.notion.so/2cb8596f20294d15bf567001652f6fcf",
"cachedResultName": "n8n vs."
}
},
"credentials": {
"notionApi": {
"id": "80",
"name": "Notion david-internal"
}
},
"retryOnFail": true,
"typeVersion": 2.2,
"waitBetweenTries": 3000
},
{
"id": "05e82483-ed91-4733-a8a7-621d8cf6f3f1",
"name": "Merge 3 objects into one",
"type": "n8n-nodes-base.merge",
"position": [
260,
380
],
"parameters": {
"numberInputs": 3
},
"typeVersion": 3
},
{
"id": "f01f839a-b0b5-4368-8cd3-3466f3cd44a4",
"name": "Aggregate Call Data",
"type": "n8n-nodes-base.aggregate",
"position": [
560,
240
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData",
"destinationFieldName": "calldata"
},
"typeVersion": 1
},
{
"id": "c89b9deb-7f52-4d0d-8cdf-ce1b2a1771d2",
"name": "Split Out Call Data and Competitors",
"type": "n8n-nodes-base.splitOut",
"position": [
760,
240
],
"parameters": {
"include": "selectedOtherFields",
"options": {},
"fieldToSplitOut": "calldata[0].calls",
"fieldsToInclude": "calldata[1].integrations, , calldata[2].competitors"
},
"typeVersion": 1
},
{
"id": "c5c90fd2-03f4-425c-9a49-b26887705c6c",
"name": "Reduce down to 1 object",
"type": "n8n-nodes-base.aggregate",
"position": [
480,
580
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "3835aeb8-589c-49b5-995a-2bf0bc0698a8",
"name": "Get Previous Phone Calls",
"type": "n8n-nodes-base.notion",
"position": [
700,
580
],
"parameters": {
"options": {},
"resource": "databasePage",
"operation": "getAll",
"returnAll": true,
"databaseId": {
"__rl": true,
"mode": "list",
"value": "1a85b6e0-c94f-81a3-aa21-e3ccf8296d72",
"cachedResultUrl": "https://www.notion.so/1a85b6e0c94f81a3aa21e3ccf8296d72",
"cachedResultName": "Sales Call Summaries Demo"
}
},
"credentials": {
"notionApi": {
"id": "2B3YIiD4FMsF9Rjn",
"name": "Angelbot Notion"
}
},
"retryOnFail": true,
"typeVersion": 2.2,
"waitBetweenTries": 3000
},
{
"id": "9b7d60bd-d08a-4529-aefb-c89f277fcd8f",
"name": "Isolate Only Call IDs",
"type": "n8n-nodes-base.set",
"position": [
900,
580
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "328e6ac8-88f3-4c2f-b8e8-d4a0756efd24",
"name": "Call ID",
"type": "string",
"value": "={{ $json.property_gong_call_id ? $json.property_gong_call_id : \"none\" }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "3eb7613c-2eaa-430a-9f67-5fc486b84ff0",
"name": "Only Process New Calls",
"type": "n8n-nodes-base.compareDatasets",
"position": [
1120,
420
],
"parameters": {
"options": {},
"resolve": "preferInput1",
"mergeByFields": {
"values": [
{
"field1": "['calldata[0].calls'].id",
"field2": "Call ID"
}
]
}
},
"typeVersion": 2.3
},
{
"id": "5e69b2a1-eb6a-4bb4-a126-0605f60ff95b",
"name": "Loop Over Calls",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1500,
400
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "6b170ccb-d492-4e7e-9aeb-13c769d36040",
"name": "Process All Call Transcripts",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
2200,
140
],
"parameters": {
"options": {},
"workflowId": {
"__rl": true,
"mode": "list",
"value": "cg4Eo7yZlhWkqHCB",
"cachedResultName": "Call Processor Demo"
}
},
"typeVersion": 1.1
},
{
"id": "3107c6d8-0c8c-4dad-bcbc-c897b0be45b9",
"name": "Receive all Transcripts",
"type": "n8n-nodes-base.noOp",
"position": [
1920,
140
],
"parameters": {},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"acb8e29a-75b8-4ccb-aca8-20d5a7053334": {
"main": [
[
{
"node": "02265963-ab06-4bf5-8b0b-5299cd3330c9",
"type": "main",
"index": 0
}
]
]
},
"02265963-ab06-4bf5-8b0b-5299cd3330c9": {
"main": [
[
{
"node": "05e82483-ed91-4733-a8a7-621d8cf6f3f1",
"type": "main",
"index": 0
}
]
]
},
"5e69b2a1-eb6a-4bb4-a126-0605f60ff95b": {
"main": [
[
{
"node": "3107c6d8-0c8c-4dad-bcbc-c897b0be45b9",
"type": "main",
"index": 0
}
],
[
{
"node": "d796312a-2a7f-429f-8550-d4af6d81a26d",
"type": "main",
"index": 0
}
]
]
},
"31df099f-45ec-4dff-b968-a90e7eaa67b5": {
"main": [
[
{
"node": "044e1b65-059c-4084-b85a-e10e6149be34",
"type": "main",
"index": 0
}
]
]
},
"f01f839a-b0b5-4368-8cd3-3466f3cd44a4": {
"main": [
[
{
"node": "c89b9deb-7f52-4d0d-8cdf-ce1b2a1771d2",
"type": "main",
"index": 0
}
]
]
},
"d796312a-2a7f-429f-8550-d4af6d81a26d": {
"main": [
[
{
"node": "5e69b2a1-eb6a-4bb4-a126-0605f60ff95b",
"type": "main",
"index": 0
}
]
]
},
"9b7d60bd-d08a-4529-aefb-c89f277fcd8f": {
"main": [
[
{
"node": "3eb7613c-2eaa-430a-9f67-5fc486b84ff0",
"type": "main",
"index": 1
}
]
]
},
"044e1b65-059c-4084-b85a-e10e6149be34": {
"main": [
[
{
"node": "42a8299e-d2e4-48a9-bba9-1c5e419d8c0c",
"type": "main",
"index": 0
}
]
]
},
"3eb7613c-2eaa-430a-9f67-5fc486b84ff0": {
"main": [
[
{
"node": "5e69b2a1-eb6a-4bb4-a126-0605f60ff95b",
"type": "main",
"index": 0
}
]
]
},
"cce3fab9-63fb-49de-8e3f-4fb7956d0b80": {
"main": [
[
{
"node": "4226f79a-8b28-46d7-8b3b-972ef41d9535",
"type": "main",
"index": 0
}
]
]
},
"3107c6d8-0c8c-4dad-bcbc-c897b0be45b9": {
"main": [
[
{
"node": "6b170ccb-d492-4e7e-9aeb-13c769d36040",
"type": "main",
"index": 0
}
]
]
},
"c5c90fd2-03f4-425c-9a49-b26887705c6c": {
"main": [
[
{
"node": "3835aeb8-589c-49b5-995a-2bf0bc0698a8",
"type": "main",
"index": 0
}
]
]
},
"41f3d049-e25b-453a-bf98-501af7f177d0": {
"main": [
[
{
"node": "acb8e29a-75b8-4ccb-aca8-20d5a7053334",
"type": "main",
"index": 0
},
{
"node": "cce3fab9-63fb-49de-8e3f-4fb7956d0b80",
"type": "main",
"index": 0
},
{
"node": "31df099f-45ec-4dff-b968-a90e7eaa67b5",
"type": "main",
"index": 0
}
]
]
},
"3835aeb8-589c-49b5-995a-2bf0bc0698a8": {
"main": [
[
{
"node": "9b7d60bd-d08a-4529-aefb-c89f277fcd8f",
"type": "main",
"index": 0
}
]
]
},
"05e82483-ed91-4733-a8a7-621d8cf6f3f1": {
"main": [
[
{
"node": "f01f839a-b0b5-4368-8cd3-3466f3cd44a4",
"type": "main",
"index": 0
},
{
"node": "c5c90fd2-03f4-425c-9a49-b26887705c6c",
"type": "main",
"index": 0
}
]
]
},
"4226f79a-8b28-46d7-8b3b-972ef41d9535": {
"main": [
[
{
"node": "05e82483-ed91-4733-a8a7-621d8cf6f3f1",
"type": "main",
"index": 2
}
]
]
},
"42a8299e-d2e4-48a9-bba9-1c5e419d8c0c": {
"main": [
[
{
"node": "05e82483-ed91-4733-a8a7-621d8cf6f3f1",
"type": "main",
"index": 1
}
]
]
},
"25fb4302-853a-421d-8e4f-4a18d723c4a0": {
"main": [
[
{
"node": "acb8e29a-75b8-4ccb-aca8-20d5a7053334",
"type": "main",
"index": 0
},
{
"node": "31df099f-45ec-4dff-b968-a90e7eaa67b5",
"type": "main",
"index": 0
},
{
"node": "cce3fab9-63fb-49de-8e3f-4fb7956d0b80",
"type": "main",
"index": 0
}
]
]
},
"c89b9deb-7f52-4d0d-8cdf-ce1b2a1771d2": {
"main": [
[
{
"node": "3eb7613c-2eaa-430a-9f67-5fc486b84ff0",
"type": "main",
"index": 0
}
]
]
}
}
}자주 묻는 질문
이 워크플로우를 어떻게 사용하나요?
위의 JSON 구성 코드를 복사하여 n8n 인스턴스에서 새 워크플로우를 생성하고 "JSON에서 가져오기"를 선택한 후, 구성을 붙여넣고 필요에 따라 인증 설정을 수정하세요.
이 워크플로우는 어떤 시나리오에 적합한가요?
고급 - 영업, 제품, 인공지능
유료인가요?
이 워크플로우는 완전히 무료이며 직접 가져와 사용할 수 있습니다. 다만, 워크플로우에서 사용하는 타사 서비스(예: OpenAI API)는 사용자 직접 비용을 지불해야 할 수 있습니다.
관련 워크플로우 추천
CallForge - 04 - Gong.io 판매 통화 AI 워크플로우
CallForge - 04 - Gong.io 판매 통화 AI 워크플로우
Set
Merge
Slack
+
Set
Merge
Slack
25 노드Angel Menendez
영업
CallForge - 03 - Gong 트랜스크립션 프로세서와 Salesforce 강화기
CallForge - 03 - Gong 트랜스크립션 프로세서와 Salesforce 강화기
Set
Code
Merge
+
Set
Code
Merge
23 노드Angel Menendez
영업
CallForge - 05 - Gong.io 통화 분석(Azure AI와 CRM 동기화)
CallForge - 05 - Gong.io 통화 분석(Azure AI와 CRM 동기화)
Set
Merge
Aggregate
+
Set
Merge
Aggregate
27 노드Angel Menendez
영업
CallForge - 06 - Gong.io, Notion, AI를 사용하여 판매 통찰력 자동화
CallForge - 06 - Gong.io, Notion, AI를 사용하여 판매 통찰력 자동화
If
Set
Wait
+
If
Set
Wait
37 노드Angel Menendez
영업
CallForge - 07 - Gong과 Notion을 사용한 AI 마케팅 데이터 처리
CallForge - 07 - Gong과 Notion을 사용하여 AI 마케팅 데이터 처리
If
Set
Wait
+
If
Set
Wait
24 노드Angel Menendez
영업
API 아키텍처 추출기
API 아키텍처 추출기
If
Set
Code
+
If
Set
Code
88 노드Polina Medvedieva
엔지니어링
워크플로우 정보
난이도
고급
노드 수26
카테고리3
노드 유형14
저자
Angel Menendez
@djangelicAngel Menendez is a Staff Developer Advocate at n8n.io, specializing in low-code tools for cybersecurity workflows. From Puerto Rico, Angel's tech journey began by helping his father translate technical books. He later started a web development business and transitioned from a career as a flight attendant to cybersecurity engineering. His workflows have saved companies significant time. Outside work, Angel enjoys time with his two sons, riding electric bikes, reading, and exploring new places.
외부 링크
n8n.io에서 보기 →
이 워크플로우 공유