Importer plusieurs fichiers CSV dans GoogleSheet

Name: Importer plusieurs fichiers CSV dans GoogleSheet
Rating: 4.5 (10 reviews)
Author: n8n Team

Débutant

Ceci est unBuilding Blocksworkflow d'automatisation du domainecontenant 0 nœuds. Importer plusieurs fichiers CSV dans Google Sheets

Prérequis

•Aucun prérequis spécial, prêt à l'emploi après importation

Nœuds utilisés (0)

Aucun workflow correspondant trouvé

Catégorie

Blocs de construction

Aperçu du workflow

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

Lors du clic sur "Exécuter le workflow"

Lire les fichiers binaires

Diviser en lots

Read CSV

Supprimer les doublons

Conserver uniquement les abonnés

Trier par date

Téléverser dans la feuille de calcul

Assigner le nom du fichier source

React Flow

Exporter le workflow

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

{
  "id": "zic2ZEHvxHR4UAYI",
  "meta": {
    "instanceId": "fb924c73af8f703905bc09c9ee8076f48c17b596ed05b18c0ff86915ef8a7c4a"
  },
  "name": "Import multiple CSV to GoogleSheet",
  "tags": [],
  "nodes": [
    {
      "id": "cd5adfcc-5b92-4a75-8e78-c2c1218d946a",
      "name": "Lors du clic sur \"Exécuter le workflow\"",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        920,
        380
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "17305629-bb19-4b55-964e-689ab5f4d557",
      "name": "Lire les fichiers binaires",
      "type": "n8n-nodes-base.readBinaryFiles",
      "position": [
        1120,
        380
      ],
      "parameters": {
        "fileSelector": "=./.n8n/*.csv"
      },
      "typeVersion": 1
    },
    {
      "id": "d3055f63-67fa-4dcd-886d-fe6f56fb7058",
      "name": "Diviser en lots",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1320,
        380
      ],
      "parameters": {
        "options": {},
        "batchSize": 1
      },
      "typeVersion": 2
    },
    {
      "id": "597e9b14-1a8c-4fbb-b5df-c965db1e0e16",
      "name": "Read 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": "Supprimer les doublons",
      "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": "Conserver uniquement les abonnés",
      "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": "Trier par date",
      "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": "Téléverser dans la feuille de calcul",
      "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": "Assigner le nom du fichier source",
      "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
          }
        ]
      ]
    }
  }
}

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é ?

Débutant - 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.