GPT-4 Mini、Google シート、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 Chat Model",
"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 Maps、SendGrid、AIを使用してB2Bリード獲得とメールマーケティングを自動化
If
Set
Code
+
If
Set
Code
141 ノードEzema Kingsley Chibuzo
リード獲得
Microsoft Teams会議分析をGPT-4.1、Outlook、Mem.aiを使用して自動化
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を使用して sales meeting の準備を自動化し、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で表示 →
このワークフローを共有