28 - 資金調達インサイトパイプライン

• •Airtable API Key
• •ターゲットAPIの認証情報が必要な場合あり
• •Google Sheets API認証情報

{
  "name": "28 - Funding Insights Pipeline",
  "nodes": [
    {
      "id": "4e26cbbf-8379-4aae-811a-853970151119",
      "name": "🕐 デイリーチェック",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -60,
        200
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "6ddcfc63-0cee-4e3f-9288-6b5f463f7bdb",
      "name": "📄 資金調達データ解析",
      "type": "n8n-nodes-base.code",
      "position": [
        380,
        200
      ],
      "parameters": {
        "jsCode": "// Parse and structure the funding data\nconst items = [];\n\nif ($input.first().json.entities) {\n  for (const entity of $input.first().json.entities) {\n    const properties = entity.properties;\n    const fundedOrg = properties.funded_organization_identifier;\n    \n    // Extract investor names\n    let investors = '';\n    if (properties.investor_identifiers && properties.investor_identifiers.length > 0) {\n      investors = properties.investor_identifiers.map(inv => inv.value).join(', ');\n    }\n    \n    // Extract categories\n    let categories = '';\n    if (fundedOrg && fundedOrg.categories && fundedOrg.categories.length > 0) {\n      categories = fundedOrg.categories.map(cat => cat.value).join(', ');\n    }\n    \n    // Format funding amount\n    let fundingAmount = 'N/A';\n    if (properties.funding_round_money_raised && properties.funding_round_money_raised.value_usd) {\n      fundingAmount = `$${(properties.funding_round_money_raised.value_usd / 1000000).toFixed(2)}M`;\n    }\n    \n    items.push({\n      json: {\n        company_name: fundedOrg ? fundedOrg.value : 'N/A',\n        funding_amount: fundingAmount,\n        funding_type: properties.investment_type ? properties.investment_type.value : 'N/A',\n        announced_date: properties.announced_on ? properties.announced_on.value : 'N/A',\n        description: fundedOrg && fundedOrg.short_description ? fundedOrg.short_description : 'N/A',\n        website: fundedOrg && fundedOrg.website ? fundedOrg.website.value : 'N/A',\n        industry: categories || 'N/A',\n        investors: investors || 'N/A',\n        crunchbase_url: fundedOrg ? `https://www.crunchbase.com/organization/${fundedOrg.permalink}` : 'N/A',\n        scraped_at: new Date().toISOString().split('T')[0]\n      }\n    });\n  }\n}\n\nreturn items;"
      },
      "typeVersion": 2
    },
    {
      "id": "de6857e8-7ec0-4433-b36e-50df001acbbb",
      "name": "📊 Google Sheetsへ保存",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        820,
        100
      ],
      "parameters": {
        "columns": {
          "values": {
            "Website": "={{$json.website}}",
            "Industry": "={{$json.industry}}",
            "Investors": "={{$json.investors}}",
            "Scraped At": "={{$json.scraped_at}}",
            "Description": "={{$json.description}}",
            "Company Name": "={{$json.company_name}}",
            "Funding Type": "={{$json.funding_type}}",
            "Crunchbase URL": "={{$json.crunchbase_url}}",
            "Date Announced": "={{$json.announced_date}}",
            "Funding Amount": "={{$json.funding_amount}}"
          },
          "mappingMode": "defineBelow"
        },
        "options": {
          "cellFormat": "USER_ENTERED"
        },
        "operation": "appendOrUpdate",
        "sheetName": "Funding Tracker",
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_GOOGLE_SHEET_ID"
        }
      },
      "typeVersion": 4.4
    },
    {
      "id": "05653b74-d30c-4af6-8b17-f4f9fba3cf38",
      "name": "🗂️ Airtableへ保存",
      "type": "n8n-nodes-base.airtable",
      "position": [
        820,
        300
      ],
      "parameters": {
        "table": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_AIRTABLE_TABLE_ID"
        },
        "options": {},
        "operation": "append",
        "application": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_AIRTABLE_APP_ID"
        },
        "authentication": "airtableOAuth2Api"
      },
      "typeVersion": 1
    },
    {
      "id": "0fcd4232-c492-4597-8751-874098f23427",
      "name": "ワークフロー情報",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -120,
        -140
      ],
      "parameters": {
        "color": 4,
        "width": 420,
        "height": 620,
        "content": "## 1. Workflow Trigger & Data Fetching (🕐 Daily Check + 📊 Fetch Recent Funding)\n\n*The workflow is scheduled to run daily.\n\nIt calls the Crunchbase API (funding_rounds endpoint) to fetch the latest 100 funding rounds, including company details, investors, categories, and funding amounts.\n\nAPI key must be filled in the request URL (user_key={{YOUR_CRUNCHBASE_API_KEY}}).*"
      },
      "typeVersion": 1
    },
    {
      "id": "31bcef8a-6b0b-40e6-acb8-a3ce53012dea",
      "name": "📅 最近（30日間）をフィルタ",
      "type": "n8n-nodes-base.filter",
      "position": [
        600,
        200
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "condition-filter",
              "operator": {
                "type": "dateTime",
                "operation": "after",
                "rightType": "expression"
              },
              "leftValue": "={{$json.announced_date}}",
              "rightValue": "={{DateTime.now().minus({days: 30}).toFormat('yyyy-MM-dd')}}"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "8f996c64-c96b-4e20-bb13-469a8e7e69cd",
      "name": "📊 最近の資金調達を取得",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        160,
        200
      ],
      "parameters": {
        "url": "https://api.crunchbase.com/api/v4/searches/funding_rounds?user_key={{YOUR_CRUNCHBASE_API_KEY}}",
        "method": "POST",
        "options": {
          "response": {
            "response": {
              "responseFormat": "json"
            }
          }
        },
        "sendBody": true,
        "bodyParameters": {
          "parameters": [
            {
              "name": "field_ids",
              "value": "[\"identifier\",\"funding_round_money_raised\",\"announced_on\",\"funded_organization_identifier\",\"funded_organization_description\",\"funded_organization_website\",\"funded_organization_categories\",\"investor_identifiers\",\"investment_type\"]"
            },
            {
              "name": "order",
              "value": "[{\"field_id\":\"announced_on\",\"sort_order\":\"desc\"}]"
            },
            {
              "name": "limit",
              "value": "100"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "dcdb1747-d79a-4845-bd63-198580af7ec6",
      "name": "ワークフロー情報1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        -140
      ],
      "parameters": {
        "width": 420,
        "height": 620,
        "content": "## 2. Data Processing (📄 Parse Funding Data + 📅 Filter Recent 30 days)\n\n*The raw Crunchbase response is parsed into a clean, structured format with readable fields. Only funding rounds announced in the last 30 days are kept, ensuring the dataset stays fresh and relevant.*"
      },
      "typeVersion": 1
    },
    {
      "id": "b9049419-7c57-4da7-9d72-0f4b037dc937",
      "name": "ワークフロー情報2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        760,
        -140
      ],
      "parameters": {
        "color": 3,
        "width": 340,
        "height": 620,
        "content": "## 3. Storage Outputs (📊 Save to Google Sheets + 🗂️ Save to Airtable)\n\n*Filtered funding records are saved into both Google Sheets (for easy sharing and reporting) and Airtable (for database-style management). Both outputs store the same standardized fields, ensuring consistency across tools.*"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "connections": {
    "4e26cbbf-8379-4aae-811a-853970151119": {
      "main": [
        [
          {
            "node": "8f996c64-c96b-4e20-bb13-469a8e7e69cd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6ddcfc63-0cee-4e3f-9288-6b5f463f7bdb": {
      "main": [
        [
          {
            "node": "31bcef8a-6b0b-40e6-acb8-a3ce53012dea",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "05653b74-d30c-4af6-8b17-f4f9fba3cf38": {
      "main": [
        []
      ]
    },
    "8f996c64-c96b-4e20-bb13-469a8e7e69cd": {
      "main": [
        [
          {
            "node": "6ddcfc63-0cee-4e3f-9288-6b5f463f7bdb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "de6857e8-7ec0-4433-b36e-50df001acbbb": {
      "main": [
        []
      ]
    },
    "31bcef8a-6b0b-40e6-acb8-a3ce53012dea": {
      "main": [
        [
          {
            "node": "de6857e8-7ec0-4433-b36e-50df001acbbb",
            "type": "main",
            "index": 0
          },
          {
            "node": "05653b74-d30c-4af6-8b17-f4f9fba3cf38",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}