8
n8n 中文网amn8n.com

导入多个CSV到GoogleSheet

初级

这是一个Building Blocks领域的自动化工作流，包含 0 个节点。 导入多个CSV到Google Sheets

前置要求
  • •无特殊前置要求，导入即可使用

使用的节点 (0)

没有找到匹配的工作流

分类

构建模块
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 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": {
    "Read CSV": {
      "main": [
        [
          {
            "node": "Assign source file name",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sort by date": {
      "main": [
        [
          {
            "node": "Upload to spreadsheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split In Batches": {
      "main": [
        [
          {
            "node": "Read CSV",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Remove duplicates",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Binary Files": {
      "main": [
        [
          {
            "node": "Split In Batches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Remove duplicates": {
      "main": [
        [
          {
            "node": "Keep only subscribers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Keep only subscribers": {
      "main": [
        [
          {
            "node": "Sort by date",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Assign source file name": {
      "main": [
        [
          {
            "node": "Split In Batches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking \"Execute Workflow\"": {
      "main": [
        [
          {
            "node": "Read Binary Files",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

初级 - 构建模块

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

从URL导入CSV到GoogleSheet
从URL导入CSV到Google Sheets
0 节点n8n Team
构建模块
基于语言合并用户问候语
根据语言合并用户问候语
Merge
Function
Manual Trigger
4 节点n8n Team
构建模块
使用简单向量存储、表单触发器和OpenAI的RAG入门模板
使用简单向量存储、表单触发器和OpenAI的RAG入门模板
Form Trigger
Agent
Chat Trigger
+5
12 节点n8n Team
构建模块
将带标签的邮件发送到Notion数据库
将带标签的邮件发送到Notion数据库
0 节点n8n Team
构建模块
在 Stripe 和 Pipedrive 之间同步支付和客户数据
在 Stripe 和 Pipedrive 之间同步支付和客户数据
Set
Cron
Merge
+5
11 节点n8n Team
销售
将 Todoist 任务同步到 Notion
自动将任务从 Todoist 同步到 Notion
If
Notion
Todoist
+2
6 节点n8n Team
构建模块
工作流信息
难度等级
初级
节点数量0
分类1
节点类型0
难度说明

适合 n8n 新手，包含 1-5 个节点的简单工作流

作者
n8n Team

n8n Team

@n8n-team

Meet the official n8n team. We specialize in building workflows that transform intricate tasks into seamless operations.

外部链接
在 n8n.io 查看 →

分享此工作流