8
n8n 中文网amn8n.com

从URL导入CSV到GoogleSheet

初级

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

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

使用的节点 (0)

没有找到匹配的工作流

分类

构建模块
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "NLVfecejH0cTtcdd",
  "meta": {
    "instanceId": "fb924c73af8f703905bc09c9ee8076f48c17b596ed05b18c0ff86915ef8a7c4a"
  },
  "name": "从 URL 导入 CSV 到 GoogleSheet",
  "tags": [],
  "nodes": [
    {
      "id": "90cced3d-b03b-4b51-b1f7-4cbd2dac25eb",
      "name": "当点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        860,
        380
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "df9519b6-937e-4a9e-bdb9-86fb722ca3c1",
      "name": "上传到电子表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1880,
        380
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "unique_key",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "unique_key",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "country",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "country",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "country_code",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "country_code",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "year_week",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "year_week",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "level",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "level",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "region",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "region",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "region_name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "region_name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "new_cases",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "new_cases",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "tests_done",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "tests_done",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "population",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "population",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "testing_rate",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "testing_rate",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "positivity_rate",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "positivity_rate",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "testing_data_source",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "testing_data_source",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [
            "unique_key"
          ]
        },
        "options": {
          "cellFormat": "USER_ENTERED"
        },
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 383583634,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/13YYuEJ1cDf-t8P2MSTFWnnNHCreQ6Zo8oPSp7WeNnbY/edit#gid=383583634",
          "cachedResultName": "COVID-weekly"
        },
        "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": "8298b29e-8784-4e15-902f-dc073fa73668",
      "name": "添加唯一字段",
      "type": "n8n-nodes-base.set",
      "position": [
        1460,
        380
      ],
      "parameters": {
        "fields": {
          "values": [
            {
              "name": "unique_key",
              "stringValue": "={{ $json.country_code }}-{{ $json.year_week }}"
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "b71bb998-4df2-4311-ae98-42c3e5e41d58",
      "name": "导入 CSV",
      "type": "n8n-nodes-base.spreadsheetFile",
      "position": [
        1260,
        380
      ],
      "parameters": {
        "options": {
          "headerRow": true
        },
        "fileFormat": "csv"
      },
      "typeVersion": 2
    },
    {
      "id": "36204081-3995-46d4-ac8f-3408cbaed657",
      "name": "下载 CSV",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1060,
        380
      ],
      "parameters": {
        "url": "https://opendata.ecdc.europa.eu/covid19/testing/csv/data.csv",
        "options": {
          "response": {
            "response": {
              "responseFormat": "file"
            }
          }
        }
      },
      "typeVersion": 4.1
    },
    {
      "id": "b1a78d2e-1a8b-4d98-b130-080b3017192d",
      "name": "仅保留 2023 年 DACH 地区",
      "type": "n8n-nodes-base.filter",
      "position": [
        1680,
        380
      ],
      "parameters": {
        "conditions": {
          "string": [
            {
              "value1": "={{ $json.year_week }}",
              "value2": "2023",
              "operation": "startsWith"
            }
          ],
          "boolean": [
            {
              "value1": "={{ ['DE', 'AT', 'CH'].includes($json.country_code )}}",
              "value2": true
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "c5a3af9b-30a0-4337-bbb7-cff54007b22f",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1620,
        241
      ],
      "parameters": {
        "width": 460,
        "height": 293,
        "content": "### Google API 对读写操作有速率限制，这就是为什么我们只取数据子集的原因"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "d49a3f54-a422-4e76-b410-f8c12b4dd78b",
  "connections": {
    "Import CSV": {
      "main": [
        [
          {
            "node": "Add unique field",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download CSV": {
      "main": [
        [
          {
            "node": "Import CSV",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add unique field": {
      "main": [
        [
          {
            "node": "Keep only DACH in 2023",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Keep only DACH in 2023": {
      "main": [
        [
          {
            "node": "Upload to spreadsheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking \"Execute Workflow\"": {
      "main": [
        [
          {
            "node": "Download CSV",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

初级 - 构建模块

需要付费吗？

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

相关工作流推荐

导入多个CSV到GoogleSheet
导入多个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 查看 →

分享此工作流