8
n8n 한국어amn8n.com

GPT-4o-mini를 사용하여 매일 Pipedrive 거래 요약 생성

중급

이것은AI Summarization, Multimodal AI분야의자동화 워크플로우로, 14개의 노드를 포함합니다.주로 Set, Code, Aggregate, Pipedrive, Summarize 등의 노드를 사용하며. 사용자 GPT-4o-mini를 통해 매일 Pipedrive 거래 요약 생성

사전 요구사항
  • OpenAI API Key
워크플로우 미리보기
노드 연결 관계를 시각적으로 표시하며, 확대/축소 및 이동을 지원합니다
워크플로우 내보내기
다음 JSON 구성을 복사하여 n8n에 가져오면 이 워크플로우를 사용할 수 있습니다
{
  "meta": {
    "instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "165f2d3a-d197-4112-91ed-b8397cc6194d",
      "name": "워크플로 실행 시",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -416,
        1952
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d6630b97-9d30-4dd1-a6e4-c547499bd2b6",
      "name": "다수 거래 조회",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        -192,
        2480
      ],
      "parameters": {
        "filters": {},
        "operation": "getAll",
        "returnAll": true
      },
      "credentials": {
        "pipedriveApi": {
          "id": "Tk6DUhlSCIuPlg0c",
          "name": "Pipedrive account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "3487ab2c-d87a-499a-9cd7-860100ad31fb",
      "name": "다수 노트 조회",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        240,
        1920
      ],
      "parameters": {
        "resource": "note",
        "operation": "getAll",
        "returnAll": true,
        "additionalFields": {
          "deal_id": "={{ $json.id }}"
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "Tk6DUhlSCIuPlg0c",
          "name": "Pipedrive account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "2620c098-2507-4884-9392-905ece30ecab",
      "name": "코드",
      "type": "n8n-nodes-base.code",
      "position": [
        48,
        1952
      ],
      "parameters": {
        "jsCode": "// Code node: Rename stage_id numbers to names\n// Input: items with item.json.stage_id\n// Output: item.json.stage_name (string)\n\nconst stageMap = {\n  1: \"Prospecting\",\n  2: \"Qualified\",\n  3: \"Proposal Sent\",\n  4: \"Negotiation\",\n  5: \"Closed Won\"\n};\n\nreturn items.map(item => {\n  const stageId = item.json.stage_id;\n  item.json.stage_name = stageMap[stageId] || `Unknown (${stageId})`;\n  return item;\n});\n"
      },
      "typeVersion": 2
    },
    {
      "id": "e5925254-2fa0-4c4e-96ad-44a4f7afc2c9",
      "name": "OpenAI Chat Model3",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1104,
        2416
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini",
          "cachedResultName": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "4l6TDfLZVFS24g3X",
          "name": "OpenAi account 4"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "f57e1044-3d56-438a-957e-d09de9c48f1e",
      "name": "스티커 노트8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -912,
        1760
      ],
      "parameters": {
        "width": 400,
        "height": 912,
        "content": "\n## ⚙️ Setup Instructions\n\n### 1️⃣ Set Up OpenAI Connection\n1. Go to [OpenAI Platform](https://platform.openai.com/api-keys)  \n2. Navigate to [OpenAI Billing](https://platform.openai.com/settings/organization/billing/overview)  \n3. Add funds to your billing account  \n4. Copy your API key into the **OpenAI credentials** in n8n  \n\n### 2️⃣ Connect Pipedrive\n1. In **Pipedrive** → **Personal preferences → API** → copy your **API token**  \n   - URL shortcut: `https://{your-company}.pipedrive.com/settings/personal/api`  \n2. In **n8n** → **Credentials → New → Pipedrive API**  \n   - **Company domain**: `{your-company}` (the subdomain in your Pipedrive URL)  \n   - **API Token**: paste the token from step 1 → **Save**  \n3. In the **Pipedrive nodes**, select your Pipedrive credential and (optionally) set filters (e.g., owner, label, created time).\n\n\n\n## 📬 Contact\nNeed help extending this (e.g., send summaries by Slack/Email, or auto-create tasks in Pipedrive)?\n\n- 📧 **robert@ynteractive.com**  \n- 🔗 **[Robert Breen](https://www.linkedin.com/in/robert-breen-29429625/)**  \n- 🌐 **[ynteractive.com](https://ynteractive.com)**\n"
      },
      "typeVersion": 1
    },
    {
      "id": "5a4cc9ef-73a0-4137-bfa8-be951faddf98",
      "name": "스티커 노트56",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -480,
        1760
      ],
      "parameters": {
        "color": 7,
        "width": 1984,
        "height": 912,
        "content": "# 📊 Pipedrive Deals Daily Summary (n8n + OpenAI)\n\nThis workflow fetches **deals and their notes from Pipedrive**, cleans up stage IDs into names, aggregates the information, and uses **OpenAI** to generate a daily summary of your funnel.\n\n---"
      },
      "typeVersion": 1
    },
    {
      "id": "4c55d8b2-a416-4c2b-b4f4-2505ac3a1d75",
      "name": "스티커 노트9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -288,
        2080
      ],
      "parameters": {
        "color": 3,
        "width": 288,
        "height": 544,
        "content": "### 2️⃣ Connect Pipedrive\n1. In **Pipedrive** → **Personal preferences → API** → copy your **API token**  \n   - URL shortcut: `https://{your-company}.pipedrive.com/settings/personal/api`  \n2. In **n8n** → **Credentials → New → Pipedrive API**  \n   - **Company domain**: `{your-company}` (the subdomain in your Pipedrive URL)  \n   - **API Token**: paste the token from step 1 → **Save**  \n3. In the **Pipedrive Tool** node, select your Pipedrive credential and (optionally) set filters (e.g., owner, label, created time).\n"
      },
      "typeVersion": 1
    },
    {
      "id": "48b1c9e1-576b-475a-8f64-d237fdb5bc12",
      "name": "스티커 노트11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        992,
        2256
      ],
      "parameters": {
        "color": 3,
        "width": 288,
        "height": 304,
        "content": "### 1️⃣ Set Up OpenAI Connection\n1. Go to [OpenAI Platform](https://platform.openai.com/api-keys)  \n2. Navigate to [OpenAI Billing](https://platform.openai.com/settings/organization/billing/overview)  \n3. Add funds to your billing account  \n4. Copy your API key into the **OpenAI credentials** in n8n  "
      },
      "typeVersion": 1
    },
    {
      "id": "ce5d2198-e82a-4cec-9367-874798dbee30",
      "name": "노트 통합",
      "type": "n8n-nodes-base.summarize",
      "position": [
        336,
        2304
      ],
      "parameters": {
        "options": {},
        "fieldsToSplitBy": "deal_id",
        "fieldsToSummarize": {
          "values": [
            {
              "field": "content",
              "separateBy": "=,",
              "aggregation": "concatenate"
            },
            {
              "field": "deal.title",
              "aggregation": "max"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "477886ba-3c21-4b1c-badd-c802f63bbcd4",
      "name": "필드명 설정",
      "type": "n8n-nodes-base.set",
      "position": [
        528,
        2144
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "1d2af38f-855d-435a-b70c-24cf560d103f",
              "name": "stage_name",
              "type": "string",
              "value": "={{ $('Code').item.json.stage_name }}"
            },
            {
              "id": "eb58ba6e-4722-4cc5-be7c-031a823a3488",
              "name": "deal.title",
              "type": "string",
              "value": "={{ $json.max_deal_title }}"
            },
            {
              "id": "d4fe6419-7954-450d-87ab-788149086bd5",
              "name": "content",
              "type": "string",
              "value": "={{ $json.concatenated_content }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "1bde07e2-8487-4589-9b96-6b10fc19612a",
      "name": "에이전트용 집계",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        688,
        2032
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "63f75533-fb6e-47eb-82e0-34ed04e2dd58",
      "name": "객체 텍스트 변환",
      "type": "n8n-nodes-base.set",
      "position": [
        896,
        1968
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "9578adb8-b0e3-4629-a375-8ac9585022f2",
              "name": "data",
              "type": "string",
              "value": "={{ $json.data }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "5c9c8df3-4038-4aa6-8555-aa52abfe0572",
      "name": "Pipedrive 요약",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1152,
        1936
      ],
      "parameters": {
        "text": "=Deals: {{ $json.data }}",
        "options": {
          "systemMessage": "You are a helpful assistant. Do a daily summary of the deals in our pipedrive funnel. "
        },
        "promptType": "define"
      },
      "typeVersion": 2.2
    }
  ],
  "pinData": {},
  "connections": {
    "2620c098-2507-4884-9392-905ece30ecab": {
      "main": [
        [
          {
            "node": "3487ab2c-d87a-499a-9cd7-860100ad31fb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ce5d2198-e82a-4cec-9367-874798dbee30": {
      "main": [
        [
          {
            "node": "477886ba-3c21-4b1c-badd-c802f63bbcd4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d6630b97-9d30-4dd1-a6e4-c547499bd2b6": {
      "main": [
        [
          {
            "node": "2620c098-2507-4884-9392-905ece30ecab",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3487ab2c-d87a-499a-9cd7-860100ad31fb": {
      "main": [
        [
          {
            "node": "ce5d2198-e82a-4cec-9367-874798dbee30",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "477886ba-3c21-4b1c-badd-c802f63bbcd4": {
      "main": [
        [
          {
            "node": "1bde07e2-8487-4589-9b96-6b10fc19612a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e5925254-2fa0-4c4e-96ad-44a4f7afc2c9": {
      "ai_languageModel": [
        [
          {
            "node": "5c9c8df3-4038-4aa6-8555-aa52abfe0572",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "1bde07e2-8487-4589-9b96-6b10fc19612a": {
      "main": [
        [
          {
            "node": "63f75533-fb6e-47eb-82e0-34ed04e2dd58",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "63f75533-fb6e-47eb-82e0-34ed04e2dd58": {
      "main": [
        [
          {
            "node": "5c9c8df3-4038-4aa6-8555-aa52abfe0572",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "165f2d3a-d197-4112-91ed-b8397cc6194d": {
      "main": [
        [
          {
            "node": "d6630b97-9d30-4dd1-a6e4-c547499bd2b6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
자주 묻는 질문

이 워크플로우를 어떻게 사용하나요?

위의 JSON 구성 코드를 복사하여 n8n 인스턴스에서 새 워크플로우를 생성하고 "JSON에서 가져오기"를 선택한 후, 구성을 붙여넣고 필요에 따라 인증 설정을 수정하세요.

이 워크플로우는 어떤 시나리오에 적합한가요?

중급 - AI 요약, 멀티모달 AI

유료인가요?

이 워크플로우는 완전히 무료이며 직접 가져와 사용할 수 있습니다. 다만, 워크플로우에서 사용하는 타사 서비스(예: OpenAI API)는 사용자 직접 비용을 지불해야 할 수 있습니다.

워크플로우 정보
난이도
중급
노드 수14
카테고리2
노드 유형9
난이도 설명

일정 경험을 가진 사용자를 위한 6-15개 노드의 중간 복잡도 워크플로우

저자
Robert Breen

Robert Breen

@rbreen

Professional services consultant with over 10 years of experience solving complex business problems across industries. I specialize in n8n and process automation—designing custom workflows that integrate tools like Google Calendar, Airtable, GPT, and internal systems. Whether you need to automate scheduling, sync data, or streamline operations, I build solutions that save time and drive results.

외부 링크
n8n.io에서 보기

이 워크플로우 공유

카테고리

카테고리: 34