8
n8n 中文网amn8n.com

批量 Airtable 请求,数据传输速度提升 9 倍

中级

这是一个Building Blocks领域的自动化工作流,包含 14 个节点。主要使用 Set, Switch, Summarize, HttpRequest, SplitInBatches 等节点。 批量 Airtable 请求,数据传输速度提升 9 倍

前置要求
  • 可能需要目标 API 的认证凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "e0353a254d65bb2bf600af5dfe7bdac3ba3c2749a7116d36eca79da571f830ec",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "9c2d2c7f-aece-4909-a637-30548895b481",
      "name": "Batch_Airtable",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "position": [
        -20,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "b6c42ddd-5d3f-4b5d-a925-baf2aa3ebead",
      "name": "upsert_airtable",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        700,
        80
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 4.2
    },
    {
      "id": "24dc1892-2f81-48a6-bf45-4f5ceb62eb27",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        240,
        300
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "bc9cb95d-5991-42f2-8655-bae03f73cc5b",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        580,
        300
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d1002a23-8cdf-42dd-b61e-d29bea2736e9",
      "name": "mode",
      "type": "n8n-nodes-base.switch",
      "position": [
        160,
        0
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 3.2
    },
    {
      "id": "20f01c04-89c6-4bac-9d9d-0a1901f7f256",
      "name": "insert_airtable",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        700,
        -120
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 4.2
    },
    {
      "id": "812d052a-086c-4c8f-a7cc-56b1e120804a",
      "name": "Airtable_Batch_Processor",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        680,
        420
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 1.2
    },
    {
      "id": "638891d8-9628-45ef-abe5-94e8d4bbfca5",
      "name": "set_Batching_vars",
      "type": "n8n-nodes-base.set",
      "position": [
        340,
        420
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 3.4
    },
    {
      "id": "225bd85e-a50c-4700-b0c6-0a285180aff6",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        -180
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "93713202-fc35-424f-9e4c-e46a1f78a4be",
      "name": "compile_records",
      "type": "n8n-nodes-base.summarize",
      "position": [
        540,
        -120
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "372ea9fe-9bd6-4dea-9b10-9cfb924ced54",
      "name": "compile_records1",
      "type": "n8n-nodes-base.summarize",
      "position": [
        540,
        80
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a496f118-02b7-4643-987c-dc2f27e04081",
      "name": "Each_10_items1",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        380,
        80
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "0d1df228-d1fa-4c78-b4c2-f863a30d6378",
      "name": "Each_10_items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        380,
        -120
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "e3c28fef-05fd-40a9-b2da-5131c86b7e16",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        300
      ],
      "parameters": {},
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "mode": {
      "main": [
        [
          {
            "node": "Each_10_items",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Each_10_items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Each_10_items": {
      "main": [
        [],
        [
          {
            "node": "compile_records",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Batch_Airtable": {
      "main": [
        [
          {
            "node": "mode",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Each_10_items1": {
      "main": [
        [],
        [
          {
            "node": "compile_records1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "compile_records": {
      "main": [
        [
          {
            "node": "insert_airtable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "insert_airtable": {
      "main": [
        [
          {
            "node": "Each_10_items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "upsert_airtable": {
      "main": [
        [
          {
            "node": "Each_10_items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "compile_records1": {
      "main": [
        [
          {
            "node": "upsert_airtable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "set_Batching_vars": {
      "main": [
        [
          {
            "node": "Airtable_Batch_Processor",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

中级 - 构建模块

需要付费吗?

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

工作流信息
难度等级
中级
节点数量14
分类1
节点类型8
难度说明

适合有一定经验的用户,包含 6-15 个节点的中等复杂度工作流

作者
Brahim HAMICHAN

Brahim HAMICHAN

@brahimh

Business Automation & Optimization, Digital marketing, Web dev 💻

外部链接
在 n8n.io 查看

分享此工作流