GPT-4 미니, 구글 시트, Gmail을 사용하여 학술 출판물 추출 및 정리
고급
이것은자동화 워크플로우로, 26개의 노드를 포함합니다.주로 Html, Sort, Gmail, Switch, SplitOut 등의 노드를 사용하며. GPT-4 Mini, Google Sheets 및 Gmail을 사용하여 학술 출판물을 추출 및 정리합니다.
사전 요구사항
- •Google 계정 및 Gmail API 인증 정보
- •대상 API의 인증 정보가 필요할 수 있음
- •Google Sheets API 인증 정보
- •OpenAI API Key
사용된 노드 (26)
카테고리
-
워크플로우 미리보기
노드 연결 관계를 시각적으로 표시하며, 확대/축소 및 이동을 지원합니다
워크플로우 내보내기
다음 JSON 구성을 복사하여 n8n에 가져오면 이 워크플로우를 사용할 수 있습니다
{
"id": "RNryWSC0apJGzqyR",
"meta": {
"instanceId": "b91e510ebae4127f953fd2f5f8d40d58ca1e71c746d4500c12ae86aad04c1502",
"templateCredsSetupCompleted": true
},
"name": "Extract & Organize Academic Publications with GPT-4 Mini, Google Sheets & Gmail",
"tags": [
{
"id": "6j6b2V0RliqC08cJ",
"name": "web-scraping",
"createdAt": "2025-09-20T08:49:15.037Z",
"updatedAt": "2025-09-20T08:49:15.037Z"
},
{
"id": "cXtzhMFhVn8afG5q",
"name": "ai-extraction",
"createdAt": "2025-09-20T08:49:15.072Z",
"updatedAt": "2025-09-20T08:49:15.072Z"
},
{
"id": "gZQUGdjmN7e6kMwE",
"name": "academic-research",
"createdAt": "2025-09-20T08:49:15.090Z",
"updatedAt": "2025-09-20T08:49:15.090Z"
},
{
"id": "pG7av0aT43P2zPBn",
"name": "customizable",
"createdAt": "2025-09-20T10:09:47.065Z",
"updatedAt": "2025-09-20T10:09:47.065Z"
}
],
"nodes": [
{
"id": "db9e10d9-1c6b-4029-bd36-2f4251c45170",
"name": "웹사이트 콘텐츠 가져오기",
"type": "n8n-nodes-base.httpRequest",
"position": [
240,
336
],
"parameters": {
"url": "={{ $json.URL }}#publications ",
"options": {
"allowUnauthorizedCerts": true
}
},
"typeVersion": 4.1
},
{
"id": "ac9d664f-1a7a-4463-8e27-4afbfb3c6e88",
"name": "페이지에서 모든 출판물 추출",
"type": "n8n-nodes-base.html",
"position": [
464,
336
],
"parameters": {
"options": {
"cleanUpText": true
},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "summary",
"cssSelector": ".dropDownSummary.textArea h3 ",
"returnArray": true
},
{
"key": "publications",
"cssSelector": ".dropDownSummary.textArea ul ul li",
"returnArray": true
},
{
"key": "bio",
"cssSelector": ".dropDownSummary.textArea "
}
]
}
},
"typeVersion": 1.2
},
{
"id": "7f8666a0-1f5f-45b2-a8ae-4d1c681afb6c",
"name": "OpenAI 채팅 모델",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
992,
560
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "OGYj7DgYv5GFLFZk",
"name": "OpenAi account 2"
}
},
"typeVersion": 1.2
},
{
"id": "eeff0140-0ce9-4126-ba89-141028200e18",
"name": "폼 제출 시",
"type": "n8n-nodes-base.formTrigger",
"position": [
16,
336
],
"webhookId": "24dd166e-dbcc-477c-91aa-2ec77a0acbbc",
"parameters": {
"options": {},
"formTitle": "Academic Staff Publication",
"formFields": {
"values": [
{
"fieldLabel": "Staff Name"
},
{
"fieldLabel": "URL"
},
{
"fieldLabel": "Email"
},
{
"fieldLabel": "Google Scholar URL"
}
]
}
},
"typeVersion": 2.3
},
{
"id": "b354dcc3-831b-4c8b-93e2-ec5d934d839a",
"name": "스티커 노트3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-16,
192
],
"parameters": {
"color": 3,
"width": 1728,
"height": 544,
"content": "# \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nBy CSChin"
},
"typeVersion": 1
},
{
"id": "79bdf992-e9ea-4495-adf7-024278849d02",
"name": "스위치",
"type": "n8n-nodes-base.switch",
"position": [
1904,
688
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "journal_papers",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "e8f90d0e-ec6b-4598-8996-9908fb175db7",
"operator": {
"type": "string",
"operation": "regex"
},
"leftValue": "={{ $json.journal_conference_toLowerCase() }}",
"rightValue": "(journal|ieee transactions|ieee/acm transactions|ieee/asme transaction|energy|applied|advanced engineering informatics|ocean engineering|water|batteries|sensors|processes|soft computing|ieee access|advances in mechanical engineering|neuralcomputing|neural computing|engineering applications of artificial intelligence|energies|renewable|sustainable|review|letters|reports|annals|bulletin|quarterly|monthly|food chemistry|waste management|food bioscience|oil crop science|environmental science and pollution research|polymer composites|progress in organic coatings|carbon|marine pollution bulletin|proceedings|materials letters|acs applied materials and interfaces|acs sustainable chemistry|chemosphere|chemical engineering science|composite structures|data in brief|reinforced plastics|water science |applied clay science|jec composites magazine|computers in biology and medicine|biomechanics and modeling in mechanobiology|rsc advances|process biochemistry|fibers and polymers|lwt|polymers|fermentation|bioprinting|data inbrief|scientific data|chemengineering|polymer testing|composites|composite|polymer|animal|aging cell|advanced materials research|computational materials science|materials research express|chemical engineering and processing|structures|advanced bioceramics|mechanisms and machine science|natural mineral nanatubes|npj heritage science)"
}
]
},
"renameOutput": true
},
{
"outputKey": "conference_papers",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "5cbb30a1-f815-4466-84e0-a0cce000fbc3",
"operator": {
"type": "string",
"operation": "regex"
},
"leftValue": "={{ $json.journal_conference_toLowerCase() }}",
"rightValue": "(conference|symposium|workshop|proceedings|tencon|congress|supercomputingasia|summit|meeting|forum|seminar|colloquium|webinar|icmt|icam|pgsret|cirp|iultcs|fluidization|power generation|micro|nano|heat|mass transfer|computer aided|tolerancing|applied mechanics|experimental mechanics|applied learning|ocean|satec|global conference on materials science and engineering|cmse)"
}
]
},
"renameOutput": true
},
{
"outputKey": "books",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "87b84199-fd0c-4393-adb8-8131225c5061",
"operator": {
"type": "string",
"operation": "regex"
},
"leftValue": "={{ $json.journal_conference_toLowerCase() }}",
"rightValue": "(crc press|springer|publisher|iet|ios press|book|woodhead publishing|trans tech publications ltd)"
}
]
},
"renameOutput": true
},
{
"outputKey": "magazine",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "63e1c345-abb7-44b7-b0d2-eb5580be302c",
"operator": {
"type": "string",
"operation": "regex"
},
"leftValue": "={{ $json.journal_conference_toLowerCase() }}",
"rightValue": "(magazine|potential|news)"
}
]
},
"renameOutput": true
},
{
"outputKey": "patent",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "9592819a-9066-4f0a-b63f-9bc89dd8fcd6",
"operator": {
"type": "string",
"operation": "regex"
},
"leftValue": "={{ $json.journal_conference_toLowerCase() }}",
"rightValue": "(us|singapore)"
}
]
},
"renameOutput": true
}
]
},
"options": {
"fallbackOutput": "extra",
"renameFallbackOutput": "Others"
},
"looseTypeValidation": true
},
"typeVersion": 3.2
},
{
"id": "8a1f8b3e-6ea5-4d38-a142-a49736f2b3c7",
"name": "스티커 노트",
"type": "n8n-nodes-base.stickyNote",
"position": [
1728,
192
],
"parameters": {
"width": 816,
"height": 1200,
"content": "# Switch Node: Route by publication type"
},
"typeVersion": 1
},
{
"id": "86630849-d08f-4bda-98aa-fcf103c50636",
"name": "스티커 노트1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-832,
192
],
"parameters": {
"width": 784,
"height": 832,
"content": "**Source:** https://www.ncl.ac.uk/singapore/staff/profile/chengchin.html#publications\n\n## Overview\nAutomated workflow extracts and organizes academic publications from university profiles using AI. Auto-categorizes and stores in Google Sheets with email notifications.\n\n## Target Audience\nAcademic Researchers, University Administrators, Research Librarians, Department Heads, PhD Students\n\n## Use Cases\nTrack faculty research output • Maintain publication databases • Generate reports by category/year\n\n## Prerequisites\n**Google Sheets** - API access, Spreadsheet IDs | **OpenAI API** - API key, GPT-4/3.5 access | **Gmail** - OAuth2 credentials (optional)\n\n## Workflow Architecture\n**Main Flow:** Form submission → Fetch/parse HTML → Split publications → AI extracts data\n**Path A:** Save to master sheet → Route by type to category sheets (Journal, Conference, Book, Magazine, Preprints, Other)\n**Path B:** Convert to CSV → Send email\n\n## Setup Instructions\n**1. OpenAI:** Model: gpt-4-turbo, Temperature: 0.3, Prompt: Extract title, authors, year, type, venue, DOI, URL\n**2. Google Sheets:** Append to master and category sheets\n**3. Routing:** Route by publication type\n**4. Email:** Subject: Publications Scraped | Body: Summary + CSV\n\n## Customization\nAdd fields: Modify prompt • Change categories: Update routing • Multiple universities: Use URL patterns • AI models: GPT-4 or GPT-3.5 • Scheduling: Use Schedule Trigger"
},
"typeVersion": 1
},
{
"id": "20239bcb-0f32-4cdc-965a-2abeab138c1d",
"name": "각 출판물 분리",
"type": "n8n-nodes-base.splitOut",
"position": [
688,
336
],
"parameters": {
"include": "selectedOtherFields",
"options": {},
"fieldToSplitOut": "publications ",
"fieldsToInclude": "Year"
},
"typeVersion": 1
},
{
"id": "0dd69765-b766-4686-9412-106f264993d8",
"name": "마스터 시트에 모두 저장",
"type": "n8n-nodes-base.googleSheets",
"position": [
1264,
240
],
"parameters": {
"columns": {
"value": {
"year": "={{ $json.output.publications[0].year }}",
"authors": "={{ $json.output.publications[0].authors }}",
"journal_conference": "={{ $json.output.publications[0].journal_conference }}"
},
"schema": [
{
"id": "authors",
"type": "string",
"display": true,
"required": false,
"displayName": "authors",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "journal_conference",
"type": "string",
"display": true,
"required": false,
"displayName": "journal_conference",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "year",
"type": "string",
"display": true,
"required": false,
"displayName": "year",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 834341142,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit#gid=834341142",
"cachedResultName": "all"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit?usp=drivesdk",
"cachedResultName": "publication"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "hQFe8XTqJEiHL03Z",
"name": "Google Sheets account"
}
},
"typeVersion": 4.2
},
{
"id": "40942434-5fe1-4248-b373-863e1410e12a",
"name": "알림 이메일 전송",
"type": "n8n-nodes-base.gmail",
"position": [
1488,
432
],
"webhookId": "bb625b4b-3e1c-4e67-874d-0ad9da2ca108",
"parameters": {
"sendTo": "{{ $json.Email }}",
"message": "=Hey, here's the scraped data of your publication from your {{ $('On form submission').item.json.URL }}!",
"options": {
"attachmentsUi": {
"attachmentsBinary": [
{}
]
}
},
"subject": "=publication csv for {{ $('On form submission').item.json['Staff Name'] }}"
},
"credentials": {
"gmailOAuth2": {
"id": "TbUa3sBo9ouHTYFh",
"name": "Gmail account 3"
}
},
"typeVersion": 2.1
},
{
"id": "0efd2d3b-af35-4791-bb28-027a3ad88e3d",
"name": "CSV 내보내기 형식으로 지정",
"type": "n8n-nodes-base.convertToFile",
"position": [
1264,
432
],
"parameters": {
"options": {}
},
"typeVersion": 1.1
},
{
"id": "d4c47234-566c-44a3-a157-7d5b58c01148",
"name": "연도별 정렬(저널)",
"type": "n8n-nodes-base.sort",
"position": [
2128,
272
],
"parameters": {
"options": {},
"sortFieldsUi": {
"sortField": [
{
"order": "descending",
"fieldName": "year"
}
]
}
},
"typeVersion": 1
},
{
"id": "87d96dc4-fc62-4eb3-9147-6d0ec12f0afa",
"name": "연도별 정렬(컨퍼런스)",
"type": "n8n-nodes-base.sort",
"position": [
2128,
464
],
"parameters": {
"options": {},
"sortFieldsUi": {
"sortField": [
{
"order": "descending",
"fieldName": "year"
}
]
}
},
"typeVersion": 1
},
{
"id": "1d4d4253-e2da-4ccf-9bba-219225eebf4c",
"name": "연도별 정렬(도서)",
"type": "n8n-nodes-base.sort",
"position": [
2128,
656
],
"parameters": {
"options": {},
"sortFieldsUi": {
"sortField": [
{
"order": "descending",
"fieldName": "year"
}
]
}
},
"typeVersion": 1
},
{
"id": "733ab00d-d029-493d-947e-346e54336da2",
"name": "연도별 정렬(잡지)",
"type": "n8n-nodes-base.sort",
"position": [
2128,
848
],
"parameters": {
"options": {},
"sortFieldsUi": {
"sortField": [
{
"order": "descending",
"fieldName": "year"
}
]
}
},
"typeVersion": 1
},
{
"id": "4a140857-3012-4dbe-ace4-c02b2ab794d5",
"name": "연도별 정렬(특허)",
"type": "n8n-nodes-base.sort",
"position": [
2128,
1040
],
"parameters": {
"options": {},
"sortFieldsUi": {
"sortField": [
{
"order": "descending",
"fieldName": "year"
}
]
}
},
"typeVersion": 1
},
{
"id": "63a9925d-8223-4ecf-bb91-0b7e8d14dbe5",
"name": "연도별 정렬(기타)",
"type": "n8n-nodes-base.sort",
"position": [
2128,
1232
],
"parameters": {
"options": {},
"sortFieldsUi": {
"sortField": [
{
"order": "descending",
"fieldName": "year"
}
]
}
},
"typeVersion": 1
},
{
"id": "69edf87d-8d76-4991-9e29-d5ded3c9c895",
"name": "컨퍼런스 시트에 추가",
"type": "n8n-nodes-base.googleSheets",
"position": [
2352,
464
],
"parameters": {
"columns": {
"value": {
"year": "={{ $json.year }}",
"count": "={{ $json.count_journal_conference }}",
"conference": "={{ $json.journal_conference }}"
},
"schema": [
{
"id": "count",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "year",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "conference",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "conference",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"count"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 963306312,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit#gid=963306312",
"cachedResultName": "conference"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit?usp=drivesdk",
"cachedResultName": "publication"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "KBo80D4RMDyyBspg",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.7
},
{
"id": "1143a4fb-5f39-4ccb-89df-ea9302222afe",
"name": "요약 보고서 생성",
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"position": [
912,
336
],
"parameters": {
"text": "={{ $json.publications }}",
"options": {
"systemPromptTemplate": "You are an expert extraction algorithm.\nOnly extract author names, journal, conference and year information from the text.\nIf you do not know the value of an attribute asked to extract, you may omit the attribute's value."
},
"schemaType": "fromJson",
"jsonSchemaExample": "{\n \"publications\": [\n {\n \"authors\": \"Author1, Author2, Author3\",\n \"journal_conference\": \"Journal of Example Research\",\n \"year\": \"2023\"\n }\n ]\n}"
},
"typeVersion": 1.2
},
{
"id": "49669d21-3046-4a76-bbb4-8dfb9c3de5b6",
"name": "출판물 통계 계산(개수)",
"type": "n8n-nodes-base.summarize",
"position": [
1488,
240
],
"parameters": {
"options": {},
"fieldsToSplitBy": "journal_conference,year",
"fieldsToSummarize": {
"values": [
{
"field": "journal_conference"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "9e06c0d3-35e8-4724-90bf-f64071f1f4ab",
"name": "도서 시트에 추가",
"type": "n8n-nodes-base.googleSheets",
"position": [
2352,
656
],
"parameters": {
"columns": {
"value": {
"book": "={{ $json.journal_conference }}",
"year": "={{ $json.year }}",
"count": "={{ $json.count_journal_conference }}"
},
"schema": [
{
"id": "count",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "year",
"type": "string",
"display": true,
"required": false,
"displayName": "year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "book",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "book",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"count"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1003783807,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit#gid=1003783807",
"cachedResultName": "book"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit?usp=drivesdk",
"cachedResultName": "publication"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "KBo80D4RMDyyBspg",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.7
},
{
"id": "aba55bb1-e449-449b-8679-0fa2fb366c34",
"name": "잡지 시트에 추가",
"type": "n8n-nodes-base.googleSheets",
"position": [
2352,
848
],
"parameters": {
"columns": {
"value": {
"year": "={{ $json.year }}",
"journal_conference": "={{ $json.journal_conference }}",
"count_journal_conference": "={{ $json.count_journal_conference }}"
},
"schema": [
{
"id": "count_journal_conference",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "count_journal_conference",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "year",
"type": "string",
"display": true,
"required": false,
"displayName": "year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "journal_conference",
"type": "string",
"display": true,
"required": false,
"displayName": "journal_conference",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"count_journal_conference"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1439806152,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit#gid=1439806152",
"cachedResultName": "magazine"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit?usp=drivesdk",
"cachedResultName": "publication"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "KBo80D4RMDyyBspg",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.7
},
{
"id": "87cfc544-0139-4489-81aa-53f82479f0d9",
"name": "특허 시트에 추가",
"type": "n8n-nodes-base.googleSheets",
"position": [
2352,
1040
],
"parameters": {
"columns": {
"value": {
"year": "={{ $json.year }}",
"journal_conference": "={{ $json.journal_conference }}",
"count_journal_conference": "={{ $json.count_journal_conference }}"
},
"schema": [
{
"id": "count_journal_conference",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "count_journal_conference",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "year",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "journal_conference",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "journal_conference",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"count_journal_conference"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1401160945,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit#gid=1401160945",
"cachedResultName": "patent"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit?usp=drivesdk",
"cachedResultName": "publication"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "KBo80D4RMDyyBspg",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.7
},
{
"id": "508f2c4e-2de0-492a-b197-082dcc8634d9",
"name": "기타 시트에 추가",
"type": "n8n-nodes-base.googleSheets",
"position": [
2352,
1232
],
"parameters": {
"columns": {
"value": {
"year": "={{ $json.year }}",
"count": "={{ $json.count_journal_conference }}",
"others": "={{ $json.journal_conference }}"
},
"schema": [
{
"id": "count",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "year",
"type": "string",
"display": true,
"required": false,
"displayName": "year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "others",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "others",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"count"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1185425191,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit#gid=1185425191",
"cachedResultName": "others"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit?usp=drivesdk",
"cachedResultName": "publication"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "KBo80D4RMDyyBspg",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.7
},
{
"id": "56c6c7a3-0244-439a-a314-e025ee46725c",
"name": "저널 시트에 추가",
"type": "n8n-nodes-base.googleSheets",
"position": [
2352,
272
],
"parameters": {
"columns": {
"value": {
"year": "={{ $json.year }}",
"count": "={{ $json.count_journal_conference }}",
"journal": "={{ $json.journal_conference }}"
},
"schema": [
{
"id": "count",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "year",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "journal",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "journal",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"count"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1660356448,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit#gid=1660356448",
"cachedResultName": "journal"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nHcAN-Xq60MPBaLdCm7WsFuRMlyA2FjXwbRhOKsbq0k/edit?usp=drivesdk",
"cachedResultName": "publication"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "KBo80D4RMDyyBspg",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.7
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "9c531d58-08de-4534-a798-d9255593e46f",
"connections": {
"79bdf992-e9ea-4495-adf7-024278849d02": {
"main": [
[
{
"node": "d4c47234-566c-44a3-a157-7d5b58c01148",
"type": "main",
"index": 0
}
],
[
{
"node": "87d96dc4-fc62-4eb3-9147-6d0ec12f0afa",
"type": "main",
"index": 0
}
],
[
{
"node": "1d4d4253-e2da-4ccf-9bba-219225eebf4c",
"type": "main",
"index": 0
}
],
[
{
"node": "733ab00d-d029-493d-947e-346e54336da2",
"type": "main",
"index": 0
}
],
[
{
"node": "4a140857-3012-4dbe-ace4-c02b2ab794d5",
"type": "main",
"index": 0
}
],
[
{
"node": "63a9925d-8223-4ecf-bb91-0b7e8d14dbe5",
"type": "main",
"index": 0
}
]
]
},
"7f8666a0-1f5f-45b2-a8ae-4d1c681afb6c": {
"ai_languageModel": [
[
{
"node": "1143a4fb-5f39-4ccb-89df-ea9302222afe",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"eeff0140-0ce9-4126-ba89-141028200e18": {
"main": [
[
{
"node": "db9e10d9-1c6b-4029-bd36-2f4251c45170",
"type": "main",
"index": 0
}
]
]
},
"1d4d4253-e2da-4ccf-9bba-219225eebf4c": {
"main": [
[
{
"node": "9e06c0d3-35e8-4724-90bf-f64071f1f4ab",
"type": "main",
"index": 0
}
]
]
},
"0efd2d3b-af35-4791-bb28-027a3ad88e3d": {
"main": [
[
{
"node": "40942434-5fe1-4248-b373-863e1410e12a",
"type": "main",
"index": 0
}
]
]
},
"63a9925d-8223-4ecf-bb91-0b7e8d14dbe5": {
"main": [
[
{
"node": "508f2c4e-2de0-492a-b197-082dcc8634d9",
"type": "main",
"index": 0
}
]
]
},
"db9e10d9-1c6b-4029-bd36-2f4251c45170": {
"main": [
[
{
"node": "ac9d664f-1a7a-4463-8e27-4afbfb3c6e88",
"type": "main",
"index": 0
}
]
]
},
"4a140857-3012-4dbe-ace4-c02b2ab794d5": {
"main": [
[
{
"node": "87cfc544-0139-4489-81aa-53f82479f0d9",
"type": "main",
"index": 0
}
]
]
},
"d4c47234-566c-44a3-a157-7d5b58c01148": {
"main": [
[
{
"node": "56c6c7a3-0244-439a-a314-e025ee46725c",
"type": "main",
"index": 0
}
]
]
},
"1143a4fb-5f39-4ccb-89df-ea9302222afe": {
"main": [
[
{
"node": "0efd2d3b-af35-4791-bb28-027a3ad88e3d",
"type": "main",
"index": 0
},
{
"node": "0dd69765-b766-4686-9412-106f264993d8",
"type": "main",
"index": 0
}
]
]
},
"733ab00d-d029-493d-947e-346e54336da2": {
"main": [
[
{
"node": "aba55bb1-e449-449b-8679-0fa2fb366c34",
"type": "main",
"index": 0
}
]
]
},
"0dd69765-b766-4686-9412-106f264993d8": {
"main": [
[
{
"node": "49669d21-3046-4a76-bbb4-8dfb9c3de5b6",
"type": "main",
"index": 0
}
]
]
},
"20239bcb-0f32-4cdc-965a-2abeab138c1d": {
"main": [
[
{
"node": "1143a4fb-5f39-4ccb-89df-ea9302222afe",
"type": "main",
"index": 0
}
]
]
},
"87d96dc4-fc62-4eb3-9147-6d0ec12f0afa": {
"main": [
[
{
"node": "69edf87d-8d76-4991-9e29-d5ded3c9c895",
"type": "main",
"index": 0
}
]
]
},
"ac9d664f-1a7a-4463-8e27-4afbfb3c6e88": {
"main": [
[
{
"node": "20239bcb-0f32-4cdc-965a-2abeab138c1d",
"type": "main",
"index": 0
}
]
]
},
"49669d21-3046-4a76-bbb4-8dfb9c3de5b6": {
"main": [
[
{
"node": "79bdf992-e9ea-4495-adf7-024278849d02",
"type": "main",
"index": 0
}
]
]
}
}
}자주 묻는 질문
이 워크플로우를 어떻게 사용하나요?
위의 JSON 구성 코드를 복사하여 n8n 인스턴스에서 새 워크플로우를 생성하고 "JSON에서 가져오기"를 선택한 후, 구성을 붙여넣고 필요에 따라 인증 설정을 수정하세요.
이 워크플로우는 어떤 시나리오에 적합한가요?
고급
유료인가요?
이 워크플로우는 완전히 무료이며 직접 가져와 사용할 수 있습니다. 다만, 워크플로우에서 사용하는 타사 서비스(예: OpenAI API)는 사용자 직접 비용을 지불해야 할 수 있습니다.
관련 워크플로우 추천
시각화 참조 라이브러리에서 n8n 노드를 탐색
可视化 참조 라이브러리에서 n8n 노드를 탐색
If
Ftp
Set
+
If
Ftp
Set
113 노드I versus AI
기타
PDF 일정 추출하여 Google 스프레드시트에 저장（GPT-4.1-Mini + Gmail 알림）
GPT-4.1-Mini를 사용하여 PDF 일정을 Google 스프레드시트로 추출하고 Gmail을 통해 알림을 보냅니다
Gmail
Split Out
Form Trigger
+
Gmail
Split Out
Form Trigger
9 노드Cheng Siong Chin
리드 생성 및 이메일 워크플로
Google 지도, SendGrid 및 AI를 사용한 B2B 잠재 고객 개발 및 이메일 마케팅 자동화
If
Set
Code
+
If
Set
Code
141 노드Ezema Kingsley Chibuzo
리드 생성
GPT-4.1, Outlook 및 Mem.ai를 사용한 Microsoft Teams 회의 분석 자동화
GPT-4.1, Outlook 및 Mem.ai를 사용한 자동화된 Microsoft Teams 회의 분석
If
Set
Code
+
If
Set
Code
61 노드Wayne Simpson
인사
WordPress 블로그 자동화 프로페셔널 에디션(심층 연구) v2.1 마켓
GPT-4o, Perplexity AI 및 다국어 지원을 사용한 SEO 최적화 블로그 생성 자동화
If
Set
Xml
+
If
Set
Xml
125 노드Daniel Ng
콘텐츠 제작
AI와 APIFY를 사용한 영업 회의 준비 자동화 및 WhatsApp으로 발송
AI 및 APIFY를 사용한 영업 회의 준비 및 WhatsApp 전송 자동화
If
Set
Html
+
If
Set
Html
61 노드Jimleuk
영업
워크플로우 정보
난이도
고급
노드 수26
카테고리-
노드 유형13
저자
Cheng Siong Chin
@cschinProf. Cheng Siong CHIN serves as Chair Professor in Intelligent Systems Modelling and Simulation in Newcastle University, Singapore. His academic credentials include an M.Sc. in Advanced Control and Systems Engineering from The University of Manchester and a Ph.D. in Robotics from Nanyang Technological University.
외부 링크
n8n.io에서 보기 →
이 워크플로우 공유