导入多个CSV到GoogleSheet
初级
这是一个Building Blocks领域的自动化工作流，包含 0 个节点。 导入多个CSV到Google Sheets
前置要求
- •无特殊前置要求，导入即可使用
使用的节点 (0)
没有找到匹配的工作流
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "zic2ZEHvxHR4UAYI",
"meta": {
"instanceId": "fb924c73af8f703905bc09c9ee8076f48c17b596ed05b18c0ff86915ef8a7c4a"
},
"name": "导入多个 CSV 到 GoogleSheet",
"tags": [],
"nodes": [
{
"id": "cd5adfcc-5b92-4a75-8e78-c2c1218d946a",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
920,
380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "17305629-bb19-4b55-964e-689ab5f4d557",
"name": "读取二进制文件",
"type": "n8n-nodes-base.readBinaryFiles",
"position": [
1120,
380
],
"parameters": {
"fileSelector": "=./.n8n/*.csv"
},
"typeVersion": 1
},
{
"id": "d3055f63-67fa-4dcd-886d-fe6f56fb7058",
"name": "分批处理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1320,
380
],
"parameters": {
"options": {},
"batchSize": 1
},
"typeVersion": 2
},
{
"id": "597e9b14-1a8c-4fbb-b5df-c965db1e0e16",
"name": "读取 CSV",
"type": "n8n-nodes-base.spreadsheetFile",
"position": [
1520,
360
],
"parameters": {
"options": {
"rawData": true,
"headerRow": true,
"readAsString": true,
"includeEmptyCells": false
},
"fileFormat": "csv"
},
"typeVersion": 2
},
{
"id": "90d5ccac-f2a3-42b6-8fa3-d05450ffa67b",
"name": "移除重复项",
"type": "n8n-nodes-base.itemLists",
"position": [
1520,
600
],
"parameters": {
"compare": "selectedFields",
"options": {},
"operation": "removeDuplicates",
"fieldsToCompare": "user_name"
},
"typeVersion": 3
},
{
"id": "2bddcd85-1c99-41ec-8e16-ab75631c3fb9",
"name": "仅保留订阅者",
"type": "n8n-nodes-base.filter",
"position": [
1720,
600
],
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.subscribed }}",
"value2": "TRUE"
}
]
}
},
"typeVersion": 1
},
{
"id": "4ac13e9d-8523-4ff3-b778-1d9f0dc744e3",
"name": "按日期排序",
"type": "n8n-nodes-base.itemLists",
"position": [
1920,
600
],
"parameters": {
"options": {},
"operation": "sort",
"sortFieldsUi": {
"sortField": [
{
"fieldName": "date_subscribed"
}
]
}
},
"typeVersion": 3
},
{
"id": "862a7ded-0199-48bb-8183-10f9ae06724b",
"name": "上传到电子表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
2120,
600
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "user_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "user_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "user_email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "user_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subscribed",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "subscribed",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_subscribed",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "date_subscribed",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"user_name"
]
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 2042396108,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/13YYuEJ1cDf-t8P2MSTFWnnNHCreQ6Zo8oPSp7WeNnbY/edit#gid=2042396108",
"cachedResultName": "n8n-sheet"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "https://docs.google.com/spreadsheets/d/13YYuEJ1cDf-t8P2MSTFWnnNHCreQ6Zo8oPSp7WeNnbY"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "54",
"name": "Google Sheets account"
}
},
"typeVersion": 4
},
{
"id": "95b499b4-024d-49a5-887f-f2f74bd1b9a1",
"name": "分配源文件名",
"type": "n8n-nodes-base.set",
"position": [
1720,
360
],
"parameters": {
"fields": {
"values": [
{
"name": "Source",
"stringValue": "={{ $('Split In Batches').item.binary.data.fileName }}"
}
]
},
"options": {}
},
"typeVersion": 3
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "a6ccb0b8-04bd-407d-b5ca-010c68bb2128",
"connections": {
"597e9b14-1a8c-4fbb-b5df-c965db1e0e16": {
"main": [
[
{
"node": "95b499b4-024d-49a5-887f-f2f74bd1b9a1",
"type": "main",
"index": 0
}
]
]
},
"4ac13e9d-8523-4ff3-b778-1d9f0dc744e3": {
"main": [
[
{
"node": "862a7ded-0199-48bb-8183-10f9ae06724b",
"type": "main",
"index": 0
}
]
]
},
"d3055f63-67fa-4dcd-886d-fe6f56fb7058": {
"main": [
[
{
"node": "597e9b14-1a8c-4fbb-b5df-c965db1e0e16",
"type": "main",
"index": 0
}
],
[
{
"node": "90d5ccac-f2a3-42b6-8fa3-d05450ffa67b",
"type": "main",
"index": 0
}
]
]
},
"17305629-bb19-4b55-964e-689ab5f4d557": {
"main": [
[
{
"node": "d3055f63-67fa-4dcd-886d-fe6f56fb7058",
"type": "main",
"index": 0
}
]
]
},
"90d5ccac-f2a3-42b6-8fa3-d05450ffa67b": {
"main": [
[
{
"node": "2bddcd85-1c99-41ec-8e16-ab75631c3fb9",
"type": "main",
"index": 0
}
]
]
},
"2bddcd85-1c99-41ec-8e16-ab75631c3fb9": {
"main": [
[
{
"node": "4ac13e9d-8523-4ff3-b778-1d9f0dc744e3",
"type": "main",
"index": 0
}
]
]
},
"95b499b4-024d-49a5-887f-f2f74bd1b9a1": {
"main": [
[
{
"node": "d3055f63-67fa-4dcd-886d-fe6f56fb7058",
"type": "main",
"index": 0
}
]
]
},
"cd5adfcc-5b92-4a75-8e78-c2c1218d946a": {
"main": [
[
{
"node": "17305629-bb19-4b55-964e-689ab5f4d557",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
初级 - 构建模块
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
从URL导入CSV到GoogleSheet
从URL导入CSV到Google Sheets
0 节点n8n Team
构建模块
基于语言合并用户问候语
根据语言合并用户问候语
Merge
Function
Manual Trigger
Merge
Function
Manual Trigger
4 节点n8n Team
构建模块
itemMatching()示例
itemMatching()使用示例
0 节点n8n Team
构建模块
AI代理聊天系统
AI代理聊天系统
Agent
Chat Trigger
Tool Serp Api
+
Agent
Chat Trigger
Tool Serp Api
5 节点n8n Team
人工智能
基于fal.ai的文本转AI图像生成器
基于fal.ai平台的文本转AI图像生成器
If
Wait
Webhook
+
If
Wait
Webhook
12 节点n8n Team
Pipedrive中添加产品时在Stripe中添加新产品
Pipedrive中添加产品时在Stripe中添加新产品
Set
Merge
Item Lists
+
Set
Merge
Item Lists
7 节点n8n Team
销售
工作流信息
难度等级
初级
节点数量0
分类1
节点类型0
作者
n8n Team
@n8n-teamMeet the official n8n team. We specialize in building workflows that transform intricate tasks into seamless operations.
外部链接
在 n8n.io 查看 →
分享此工作流