会议反馈收集与Excel OneDrive记录及Outlook通知
中级
这是一个Marketing领域的自动化工作流，包含 13 个节点。主要使用 If, Set, Code, FormTrigger, ConvertToFile 等节点。 通过表单收集会议反馈，记录到Excel OneDrive，并发送Outlook通知
前置要求
- •无特殊前置要求，导入即可使用
使用的节点 (13)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "7d8066d2f56a07000fe7d753d3eeabf0ecdf68413466f30d10afe0906f058427",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "0061ae9c-dd06-4ea7-b05f-7b71e9368d94",
"name": "表单提交时",
"type": "n8n-nodes-base.formTrigger",
"position": [
-80,
-125
],
"webhookId": "174827bd-4783-4b89-8b60-1bc15f8fb8d6",
"parameters": {
"options": {
"path": "feedback",
"buttonLabel": "Submit",
"appendAttribution": false,
"useWorkflowTimezone": true
},
"formTitle": "Conference Feedback Form",
"formFields": {
"values": [
{
"fieldLabel": "Full Name",
"placeholder": "eg: John Doe",
"requiredField": true
},
{
"fieldType": "email",
"fieldLabel": "Email",
"placeholder": "eg: johndoe@gmail.com",
"requiredField": true
},
{
"fieldLabel": "Company Name",
"placeholder": "eg: Apple Inc"
},
{
"fieldLabel": "Job Title",
"placeholder": "eg: CEO"
},
{
"fieldType": "dropdown",
"fieldLabel": "How did you hear about the conference?",
"fieldOptions": {
"values": [
{
"option": "Email"
},
{
"option": "Social Media"
},
{
"option": "Colleague/Friend"
},
{
"option": "Website"
},
{
"option": "Other"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "How would you rate the overall experience?",
"fieldOptions": {
"values": [
{
"option": "⭐⭐⭐⭐⭐"
},
{
"option": "⭐⭐⭐⭐"
},
{
"option": "⭐⭐⭐"
},
{
"option": "⭐⭐"
},
{
"option": "⭐"
}
]
},
"requiredField": true
},
{
"fieldType": "textarea",
"fieldLabel": "Which sessions or speakers did you enjoy the most?"
},
{
"fieldType": "dropdown",
"fieldLabel": "Was the content relevant to your interests or work?",
"fieldOptions": {
"values": [
{
"option": "Very relevant"
},
{
"option": "Somewhat relevant"
},
{
"option": "Not really"
},
{
"option": "Not at all"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "Did you have enough networking opportunities?",
"fieldOptions": {
"values": [
{
"option": "Yes"
},
{
"option": "No"
},
{
"option": "Not sure / Didn't participate"
}
]
},
"requiredField": true
},
{
"fieldType": "textarea",
"fieldLabel": "What could we improve for next time?"
},
{
"fieldType": "textarea",
"fieldLabel": "Are there any topics or speakers you'd like to see in the future?"
},
{
"fieldType": "dropdown",
"fieldLabel": "Would you attend this conference again?",
"fieldOptions": {
"values": [
{
"option": "Definitely"
},
{
"option": "Maybe"
},
{
"option": "Probably not"
}
]
},
"requiredField": true
},
{
"fieldType": "textarea",
"fieldLabel": "Any other comments or feedback you'd like to share?"
},
{
"fieldType": "dropdown",
"fieldLabel": "Would you be open to being contacted for follow-up or future events?",
"fieldOptions": {
"values": [
{
"option": "Yes"
},
{
"option": "No"
}
]
},
"requiredField": true
}
]
},
"formDescription": "\nThanks for joining us at the conference! 🎉\n\nWe’d love to hear your thoughts — the good, the great, and anything we can improve.\n\n\n"
},
"typeVersion": 2.2
},
{
"id": "e6dc4e27-827d-47c4-ab9d-96846995f2cc",
"name": "解析数据",
"type": "n8n-nodes-base.set",
"position": [
140,
-125
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "f77a031d-6be7-406b-8134-84eccdbd402e",
"name": "full_name",
"type": "string",
"value": "={{ $json['Full Name'] }}"
},
{
"id": "0779d779-9d65-4861-89d2-3c343b46e381",
"name": "email",
"type": "string",
"value": "={{ $json.Email }}"
},
{
"id": "3e99e9af-6de0-497c-9b96-19f887ac4cbe",
"name": "company_name",
"type": "string",
"value": "={{ $json['Company Name'] }}"
},
{
"id": "7a7bd49b-9665-4668-9b30-97dd5eb154fe",
"name": "job_title",
"type": "string",
"value": "={{ $json['Job Title'] }}"
},
{
"id": "f31f2aec-72aa-4310-9441-d32407ccf711",
"name": "referral_source",
"type": "string",
"value": "={{ $json['How did you hear about the conference?'] }}"
},
{
"id": "ef146ca5-f3c2-40bf-bd92-7346d166e10b",
"name": "rating",
"type": "string",
"value": "={{ $json['How would you rate the overall experience?'] }}"
},
{
"id": "d009ac9d-c9f6-49f7-a47e-b8098f3ae845",
"name": "preferred_sessions",
"type": "string",
"value": "={{ $json['Which sessions or speakers did you enjoy the most?'] }}"
},
{
"id": "00eac176-896f-451f-a4bc-970c1f01c715",
"name": "content_relevancy",
"type": "string",
"value": "={{ $json['Was the content relevant to your interests or work?'] }}"
},
{
"id": "8844f08f-93c5-4380-bd04-02d1b5da27ac",
"name": "networking_opportunities",
"type": "string",
"value": "={{ $json['Did you have enough networking opportunities?'] }}"
},
{
"id": "53fcb77e-4b29-410f-b5ca-a24e87a1e382",
"name": "improvement_suggestions",
"type": "string",
"value": "={{ $json['What could we improve for next time?'] }}"
},
{
"id": "5c375c10-5e11-4242-97eb-053eb0837b87",
"name": "future_suggestions",
"type": "string",
"value": "={{ $json['Are there any topics or speakers you\\'d like to see in the future?'] }}"
},
{
"id": "9615ec66-d0b8-4100-85c9-b055238a5640",
"name": "would_attend_again",
"type": "string",
"value": "={{ $json['Would you attend this conference again?'] }}"
},
{
"id": "e7cacd7b-c9f6-4d7a-b5e2-1ab1736f018d",
"name": "additional_comments",
"type": "string",
"value": "={{ $json['Any other comments or feedback you\\'d like to share?'] }}"
},
{
"id": "5bb69825-ce98-41d2-a359-2cd669f648c5",
"name": "open_to_contact",
"type": "string",
"value": "={{ $json['Would you be open to being contacted for follow-up or future events?'] }}"
},
{
"id": "bc0c50ca-18c5-412f-916f-7839ead8bd02",
"name": "submitted_at",
"type": "string",
"value": "={{ $json.submittedAt }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "f6960053-bb48-44e9-9655-77bd79ca14b9",
"name": "搜索文档",
"type": "n8n-nodes-base.microsoftOneDrive",
"position": [
580,
-125
],
"parameters": {
"query": "test-n8n-feedback-form-data.xlsx",
"operation": "search"
},
"credentials": {
"microsoftOneDriveOAuth2Api": {
"id": "eLq62M68naYY5BsN",
"name": "Microsoft Drive account"
}
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "e37e133d-c374-4d28-9655-4d83df99e020",
"name": "构建表格数据",
"type": "n8n-nodes-base.set",
"position": [
1240,
-200
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "35e322bd-ea8b-4e8a-aba1-0d169a50514b",
"name": "full_name",
"type": "string",
"value": "={{ $('Parse Data').item.json.full_name }}"
},
{
"id": "e78a4c71-30ba-481b-bda6-4a734a071944",
"name": "email",
"type": "string",
"value": "={{ $('Parse Data').item.json.email }}"
},
{
"id": "837979e5-c26a-4e91-a954-0bed27e33407",
"name": "company_name",
"type": "string",
"value": "={{ $('Parse Data').item.json.company_name }}"
},
{
"id": "3d8493e2-f4d3-4374-9e85-5349382ff5a9",
"name": "job_title",
"type": "string",
"value": "={{ $('Parse Data').item.json.job_title }}"
},
{
"id": "6c8a4ef9-4334-4307-8633-88551720690a",
"name": "referral_source",
"type": "string",
"value": "={{ $('Parse Data').item.json.referral_source }}"
},
{
"id": "b47ff6ef-28e4-4d17-80b8-d1e8b45542e3",
"name": "rating",
"type": "string",
"value": "={{ $('Parse Data').item.json.rating }}"
},
{
"id": "be5630e6-6e6b-4c3b-a2ff-e2dd83e58754",
"name": "preferred_sessions",
"type": "string",
"value": "={{ $('Parse Data').item.json.preferred_sessions }}"
},
{
"id": "0bf1d1db-a760-4c8f-911c-2eab45f98dc2",
"name": "content_relevancy",
"type": "string",
"value": "={{ $('Parse Data').item.json.content_relevancy }}"
},
{
"id": "e1c61815-f86f-4065-b66c-cfab3a7d7f7e",
"name": "networking_opportunities",
"type": "string",
"value": "={{ $('Parse Data').item.json.networking_opportunities }}"
},
{
"id": "1f85ea63-bfd7-4408-8948-1f913fccea0c",
"name": "improvement_suggestions",
"type": "string",
"value": "={{ $('Parse Data').item.json.improvement_suggestions }}"
},
{
"id": "caf82dce-54d9-4f03-a056-18ccd63cdf09",
"name": "future_suggestions",
"type": "string",
"value": "={{ $('Parse Data').item.json.future_suggestions }}"
},
{
"id": "c5cf63e6-4ecb-41e2-be7d-b85b542d664a",
"name": "would_attend_again",
"type": "string",
"value": "={{ $('Parse Data').item.json.would_attend_again }}"
},
{
"id": "3bd3e6b9-8d2c-49f9-a3c8-4b60e1b00b2a",
"name": "additional_comments",
"type": "string",
"value": "={{ $('Parse Data').item.json.additional_comments }}"
},
{
"id": "7e4b9e19-43e5-4a01-9346-c33f34d29bc2",
"name": "open_to_contact",
"type": "string",
"value": "={{ $('Parse Data').item.json.open_to_contact }}"
},
{
"id": "4963e022-973c-408f-a5b1-714f4ea246f3",
"name": "submitted_at",
"type": "string",
"value": "={{ $('Parse Data').item.json.submitted_at }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "1feabf8b-6726-4d9d-8b13-081dc7555a11",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
800,
-125
],
"parameters": {
"jsCode": "const id = $input.first().json.id;\n\nif (id !== undefined && id !== null && id !== '') {\n return [\n {\n json: {\n id: id\n }\n }\n ];\n}\n\nreturn [\n {\n json: {\n id: null\n }\n }\n];\n"
},
"typeVersion": 2
},
{
"id": "e9d702d3-1441-4215-bab0-399210a5f3f2",
"name": "如果文档存在",
"type": "n8n-nodes-base.if",
"position": [
1020,
-125
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "77cb5676-cea9-48df-b584-97b9e89b9cc8",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.id }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "a6c8f2d0-5957-44db-8dd1-1a1cfa53fc81",
"name": "追加数据",
"type": "n8n-nodes-base.microsoftExcel",
"position": [
1460,
-200
],
"parameters": {
"options": {
"rawData": true
},
"dataMode": "autoMap",
"resource": "worksheet",
"workbook": {
"__rl": true,
"mode": "id",
"value": "={{ $('Code').item.json.id }}"
},
"operation": "append",
"worksheet": {
"__rl": true,
"mode": "list",
"value": "{00000000-0001-0000-0000-000000000000}",
"cachedResultName": "Sheet1"
}
},
"credentials": {
"microsoftExcelOAuth2Api": {
"id": "bMuPdHl1l2TEFO5I",
"name": "Microsoft Excel account"
}
},
"typeVersion": 2.1
},
{
"id": "ba6e76d2-86ae-41fd-9c24-352cbab3a08b",
"name": "结束工作流",
"type": "n8n-nodes-base.noOp",
"position": [
1900,
-125
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2407a47e-b5be-4d2b-a6a1-5d599c0e3f98",
"name": "通知支持人员",
"type": "n8n-nodes-base.microsoftOutlook",
"position": [
1680,
-125
],
"webhookId": "a80cbb77-8027-49b0-a421-02cb0e4efe0b",
"parameters": {
"subject": "New Feedback Submission Received",
"bodyContent": "=Hi Support Team,\n\n📝 You’ve received new feedback from a user. Here are the details:\n\n---\n\nSubmitted At: {{ $('Parse Data').item.json.submitted_at }}\nName: {{ $('Parse Data').item.json.full_name }}\nEmail: {{ $('Parse Data').item.json.email }}\nRating: {{ $('Parse Data').item.json.rating }}\nFeedback:\n{{ $('Parse Data').item.json.additional_comments }}\n\n---\n\nYou can view this feedback in your system or tracker.\n\nThank you, \nFeedback Notification System",
"toRecipients": "akhilgadiraju@gmail.com",
"additionalFields": {}
},
"credentials": {
"microsoftOutlookOAuth2Api": {
"id": "tAxWsrpJgc2T0Cdm",
"name": "Outlook - Akhil"
}
},
"typeVersion": 2
},
{
"id": "598dcce2-9c13-4d08-8193-e560937ac9c7",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
520,
40
],
"parameters": {
"color": 4,
"height": 120,
"content": "### 📁 更新文件名"
},
"typeVersion": 1
},
{
"id": "88b7a910-459c-4f5a-9b83-6097332fe578",
"name": "示例文件",
"type": "n8n-nodes-base.convertToFile",
"position": [
360,
-125
],
"parameters": {
"options": {
"fileName": "test-n8n-feedback-form-data.xlsx"
},
"operation": "xlsx"
},
"typeVersion": 1.1
},
{
"id": "5e06cc88-97c7-46a3-b090-e7a6abe34019",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
280,
-400
],
"parameters": {
"color": 3,
"width": 280,
"height": 260,
"content": "### 📄 示例文档说明"
},
"typeVersion": 1
},
{
"id": "e79b44b5-8285-467e-bf67-958269317688",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1600,
40
],
"parameters": {
"width": 280,
"height": 240,
"content": "### ✉️ 自定义邮件设置"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Code": {
"main": [
[
{
"node": "If Document Exists",
"type": "main",
"index": 0
}
]
]
},
"Parse Data": {
"main": [
[
{
"node": "Sample File",
"type": "main",
"index": 0
}
]
]
},
"Append Data": {
"main": [
[
{
"node": "Notify Support",
"type": "main",
"index": 0
}
]
]
},
"Sample File": {
"main": [
[
{
"node": "Search Document",
"type": "main",
"index": 0
}
]
]
},
"Notify Support": {
"main": [
[
{
"node": "End Workflow",
"type": "main",
"index": 0
}
]
]
},
"Search Document": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Build Sheet Data": {
"main": [
[
{
"node": "Append Data",
"type": "main",
"index": 0
}
]
]
},
"If Document Exists": {
"main": [
[
{
"node": "Build Sheet Data",
"type": "main",
"index": 0
}
],
[
{
"node": "Notify Support",
"type": "main",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "Parse Data",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
批量删除上传Excel/CSV文件中的HubSpot联系人
批量删除上传Excel/CSV文件中的HubSpot联系人
If
Set
Hubspot
+5
11 节点Akhil Varma Gadiraju
销售
基于表单的X/Twitter发布器
基于表单的X/Twitter发布器
If
Code
Form
+4
8 节点Akhil Varma Gadiraju
营销
使用Excel、Outlook和AI的每日新闻简报服务
使用Excel、Outlook和AI的每日新闻简报服务
If
Set
Html
+13
33 节点Jimleuk
人工智能
Gmail到Google Drive邮件导出工作流
Gmail到Google Drive邮件导出工作流
Set
Code
Gmail
+5
13 节点Akhil Varma Gadiraju
IT 运维
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
实时Notion Todoist双向同步模板
使用Redis的Notion Todoist实时双向同步
If
Set
Code
+26
246 节点Mario
销售
