GoogleスプレッドシートからCSVへ

Name: GoogleスプレッドシートからCSVへ
Rating: 4.5 (10 reviews)
Author: Alok Singh

初級

これはFile Management, Multimodal AI分野の自動化ワークフローで、5個のノードを含みます。主にSlack, Function, GoogleSheets, SlackTrigger, SpreadsheetFileなどのノードを使用。 SlackメッセージでGoogleスプレッドシートをCSVに自動変換

前提条件

•Slack Bot Token または Webhook URL
•Google Sheets API認証情報

使用ノード (5)

カテゴリー

ファイル管理

マルチモーダルAI

ワークフロープレビュー

ノード接続関係を可視化、ズームとパンをサポート

Slackトリガー

シートIDを抽出

Googleシートを読み取り

CSVに変換

Slackにアップロード

React Flow

ワークフローをエクスポート

以下のJSON設定をn8nにインポートして、このワークフローを使用できます

{
  "id": "ew7HeWnZvNhCglFr",
  "meta": {
    "instanceId": "aed99ab7f3ef2fea923e1a45328dd772df5d92f365b784dbfc8daab7ad485413",
    "templateCredsSetupCompleted": true
  },
  "name": "Googlesheet to CSV",
  "tags": [],
  "nodes": [
    {
      "id": "6267431f-93f5-447c-8a9c-aa315bcd1d90",
      "name": "Slackトリガー",
      "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": "シートIDを抽出",
      "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": "Googleシートを読み取り",
      "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": "CSVに変換",
      "type": "n8n-nodes-base.spreadsheetFile",
      "position": [
        608,
        0
      ],
      "parameters": {
        "options": {},
        "operation": "toFile",
        "fileFormat": "csv"
      },
      "typeVersion": 1
    },
    {
      "id": "901abfb2-2893-4bf5-9d1d-9414c4cb68ef",
      "name": "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
          }
        ]
      ]
    }
  }
}

よくある質問