AIを使ってPDFから送付書データを抽出 - Google Sheetsとメール通知

• •Googleアカウント + Gmail API認証情報
• •Google Drive API認証情報
• •Google Sheets API認証情報
• •OpenAI API Key

{
  "meta": {
    "instanceId": "473ff4054f1a6c3ed6f17a2b4a2e55676fe5b921cceb87b2256e6c416c158559"
  },
  "nodes": [
    {
      "id": "76600f2a-f77c-4c95-8df6-e4d44a2d9e9e",
      "name": "情報抽出器",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        1420,
        40
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c96acdd1-a755-4700-86b5-c29e8cb5d32d",
      "name": "メール送信",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1360,
        420
      ],
      "webhookId": "da2aa524-25e5-47e2-bd1a-fe7a97edf8a7",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "ef869446-c764-4957-8c27-4f51410c80c9",
      "name": "何もしない操作",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1580,
        440
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "8e257d7c-bd82-44c4-901f-1b35d6ed1033",
      "name": "Ollama モデル",
      "type": "@n8n/n8n-nodes-langchain.lmOllama",
      "position": [
        1440,
        300
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "2e5babac-d216-48d5-97c5-7b528078a52a",
      "name": "Postgres PGVector ストア",
      "type": "@n8n/n8n-nodes-langchain.vectorStorePGVector",
      "position": [
        1380,
        680
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "0348c94a-d362-4c1f-8679-3d4e0a42ddfb",
      "name": "付箋ノート",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -60,
        -80
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fc19ba2d-a2ee-424b-a2f8-49690f1a2f74",
      "name": "Google Drive トリガー - ファイル作成",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "f081fb04-9a51-42f5-8664-9fd866de9cf1",
      "name": "バイナリダウンロード - ファイル",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        220,
        0
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "470c9772-00cf-420e-876f-7efad7274ca9",
      "name": "PDFから抽出",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        800,
        20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "1cc7eae0-ccab-4c8a-a469-b27a7057d22a",
      "name": "メールエージェント作成",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1020,
        420
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "42588358-40ba-46f7-bb97-38c67c676901",
      "name": "DB更新 - スプレッドシート",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1100,
        600
      ],
      "parameters": {},
      "typeVersion": 4.5
    }
  ],
  "pinData": {},
  "connections": {
    "c96acdd1-a755-4700-86b5-c29e8cb5d32d": {
      "main": [
        [
          {
            "node": "ef869446-c764-4957-8c27-4f51410c80c9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8e257d7c-bd82-44c4-901f-1b35d6ed1033": {
      "ai_languageModel": [
        [
          {
            "node": "76600f2a-f77c-4c95-8df6-e4d44a2d9e9e",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "470c9772-00cf-420e-876f-7efad7274ca9": {
      "main": [
        [
          {
            "node": "76600f2a-f77c-4c95-8df6-e4d44a2d9e9e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1cc7eae0-ccab-4c8a-a469-b27a7057d22a": {
      "main": [
        [
          {
            "node": "c96acdd1-a755-4700-86b5-c29e8cb5d32d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "76600f2a-f77c-4c95-8df6-e4d44a2d9e9e": {
      "main": [
        [
          {
            "node": "42588358-40ba-46f7-bb97-38c67c676901",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f081fb04-9a51-42f5-8664-9fd866de9cf1": {
      "main": [
        [
          {
            "node": "470c9772-00cf-420e-876f-7efad7274ca9",
            "type": "main",
            "index": 0
          },
          {
            "node": "42588358-40ba-46f7-bb97-38c67c676901",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2e5babac-d216-48d5-97c5-7b528078a52a": {
      "ai_tool": [
        [
          {
            "node": "1cc7eae0-ccab-4c8a-a469-b27a7057d22a",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "42588358-40ba-46f7-bb97-38c67c676901": {
      "main": [
        [
          {
            "node": "1cc7eae0-ccab-4c8a-a469-b27a7057d22a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fc19ba2d-a2ee-424b-a2f8-49690f1a2f74": {
      "main": [
        [
          {
            "node": "f081fb04-9a51-42f5-8664-9fd866de9cf1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}