Google Sheets vers CSV

Name: Google Sheets vers CSV
Rating: 4.5 (10 reviews)
Author: Alok Singh

Débutant

Ceci est unFile Management, Multimodal AIworkflow d'automatisation du domainecontenant 5 nœuds.Utilise principalement des nœuds comme Slack, Function, GoogleSheets, SlackTrigger, SpreadsheetFile. Conversion automatique de Google Sheets en CSV via des messages Slack

Prérequis

•Token Bot Slack ou URL Webhook
•Informations d'identification Google Sheets API

Nœuds utilisés (5)

Catégorie

Gestion de fichiers

IA Multimodale

Aperçu du workflow

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

Slack Trigger

Extraire l'ID de la feuille

Lire Google Sheet

Convertir en CSV

Téléverser vers Slack

React Flow

Exporter le workflow

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

{
  "id": "ew7HeWnZvNhCglFr",
  "meta": {
    "instanceId": "aed99ab7f3ef2fea923e1a45328dd772df5d92f365b784dbfc8daab7ad485413",
    "templateCredsSetupCompleted": true
  },
  "name": "Googlesheet to CSV",
  "tags": [],
  "nodes": [
    {
      "id": "6267431f-93f5-447c-8a9c-aa315bcd1d90",
      "name": "Slack Trigger",
      "type": "n8n-nodes-base.slackTrigger",
      "position": [
        0,
        0
      ],
      "webhookId": "f7efbda6-dbab-4a0a-aff1-d0e162ff8824",
      "parameters": {
        "options": {},
        "trigger": [
          "any_event",
          "app_mention"
        ],
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "C099B0PKEF2",
          "cachedResultName": "googlesheet-to-csv"
        }
      },
      "credentials": {
        "slackApi": {
          "id": "GX0V2cTfAdqyPf4D",
          "name": "Slack account 4"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "a31b6810-779d-4182-a159-7482e2e6c28c",
      "name": "Extraire l'ID de la feuille",
      "type": "n8n-nodes-base.function",
      "position": [
        208,
        0
      ],
      "parameters": {
        "functionCode": "const regex = /https:\\/\\/docs\\.google\\.com\\/spreadsheets\\/d\\/([a-zA-Z0-9-_]+)/;\nconst match = regex.exec($json.text);\nif (match) {\n  return [{\n    sheetId: match[1],\n    channel: $json.channel\n  }];\n}\nreturn [];"
      },
      "typeVersion": 1
    },
    {
      "id": "44faf26c-07cf-4620-9631-291fb7f20dcf",
      "name": "Lire Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        400,
        0
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 253150622,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/17nQYzOoH2SfxNlNvYs8fJ9RJzGr_UCtEtfBTINxDteI/edit#gid=253150622",
          "cachedResultName": "Sheet4"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $json.sheetId }}"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "EQKNLxahxnebnTEv",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "5599139b-0950-4e50-83f7-0b08a22bbf6b",
      "name": "Convertir en CSV",
      "type": "n8n-nodes-base.spreadsheetFile",
      "position": [
        608,
        0
      ],
      "parameters": {
        "options": {},
        "operation": "toFile",
        "fileFormat": "csv"
      },
      "typeVersion": 1
    },
    {
      "id": "901abfb2-2893-4bf5-9d1d-9414c4cb68ef",
      "name": "Téléverser vers Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        800,
        0
      ],
      "parameters": {
        "options": {
          "fileName": "Converted CSV",
          "channelIds": [
            "C099B0PKEF2"
          ]
        },
        "resource": "file",
        "binaryData": true,
        "authentication": "oAuth2"
      },
      "credentials": {
        "slackOAuth2Api": {
          "id": "HF9WCfi7VKsh433D",
          "name": "Slack account 3"
        }
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "b9c9ac20-c803-401d-a451-cd28e0254070",
  "connections": {
    "6267431f-93f5-447c-8a9c-aa315bcd1d90": {
      "main": [
        [
          {
            "node": "a31b6810-779d-4182-a159-7482e2e6c28c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5599139b-0950-4e50-83f7-0b08a22bbf6b": {
      "main": [
        [
          {
            "node": "901abfb2-2893-4bf5-9d1d-9414c4cb68ef",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a31b6810-779d-4182-a159-7482e2e6c28c": {
      "main": [
        [
          {
            "node": "44faf26c-07cf-4620-9631-291fb7f20dcf",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "44faf26c-07cf-4620-9631-291fb7f20dcf": {
      "main": [
        [
          {
            "node": "5599139b-0950-4e50-83f7-0b08a22bbf6b",
            "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 - Gestion de fichiers, IA Multimodale

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.