Requêtes groupées Airtable, avec une augmentation de 9 fois de la vitesse de transfert de données

Name: Requêtes groupées Airtable, avec une augmentation de 9 fois de la vitesse de transfert de données
Rating: 4.5 (10 reviews)
Author: Brahim HAMICHAN

Intermédiaire

Ceci est unBuilding Blocksworkflow d'automatisation du domainecontenant 14 nœuds.Utilise principalement des nœuds comme Set, Switch, Summarize, HttpRequest, SplitInBatches. Requêtes groupées Airtable avec une vitesse de transfert de données 9 fois supérieure

Prérequis

•Peut nécessiter les informations d'identification d'authentification de l'API cible

Nœuds utilisés (14)

ExecuteWorkflowTrigger

Catégorie

Blocs de construction

Aperçu du workflow

Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement

Batch_Airtable

upsert_airtable

mode

insert_airtable

Airtable_Batch_Processor

set_Batching_vars

compile_records

compile_records1

Each_10_items1

Each_10_items

React Flow

Exporter le workflow

Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow

{
  "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": "Note adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        240,
        300
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "bc9cb95d-5991-42f2-8655-bae03f73cc5b",
      "name": "Note adhésive2",
      "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": "Note adhésive3",
      "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": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        300
      ],
      "parameters": {},
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "d1002a23-8cdf-42dd-b61e-d29bea2736e9": {
      "main": [
        [
          {
            "node": "0d1df228-d1fa-4c78-b4c2-f863a30d6378",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "a496f118-02b7-4643-987c-dc2f27e04081",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0d1df228-d1fa-4c78-b4c2-f863a30d6378": {
      "main": [
        [],
        [
          {
            "node": "93713202-fc35-424f-9e4c-e46a1f78a4be",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9c2d2c7f-aece-4909-a637-30548895b481": {
      "main": [
        [
          {
            "node": "d1002a23-8cdf-42dd-b61e-d29bea2736e9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a496f118-02b7-4643-987c-dc2f27e04081": {
      "main": [
        [],
        [
          {
            "node": "372ea9fe-9bd6-4dea-9b10-9cfb924ced54",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "93713202-fc35-424f-9e4c-e46a1f78a4be": {
      "main": [
        [
          {
            "node": "20f01c04-89c6-4bac-9d9d-0a1901f7f256",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "20f01c04-89c6-4bac-9d9d-0a1901f7f256": {
      "main": [
        [
          {
            "node": "0d1df228-d1fa-4c78-b4c2-f863a30d6378",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b6c42ddd-5d3f-4b5d-a925-baf2aa3ebead": {
      "main": [
        [
          {
            "node": "a496f118-02b7-4643-987c-dc2f27e04081",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "372ea9fe-9bd6-4dea-9b10-9cfb924ced54": {
      "main": [
        [
          {
            "node": "b6c42ddd-5d3f-4b5d-a925-baf2aa3ebead",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "638891d8-9628-45ef-abe5-94e8d4bbfca5": {
      "main": [
        [
          {
            "node": "812d052a-086c-4c8f-a7cc-56b1e120804a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Intermédiaire - Blocs de construction

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.