8
n8n 한국어amn8n.com

Telegram-Google Sheets를 사용하여 GPT-4.1 자동화합니다.

고급

이것은Content Creation, Multimodal AI분야의자동화 워크플로우로, 16개의 노드를 포함합니다.주로 If, Set, Filter, Telegram, Aggregate 등의 노드를 사용하며. GPT-4.1을 사용한 Telegram/Google Sheets 자동화.

사전 요구사항
  • Telegram Bot Token
  • Google Sheets API 인증 정보
  • OpenAI API Key
워크플로우 미리보기
노드 연결 관계를 시각적으로 표시하며, 확대/축소 및 이동을 지원합니다
워크플로우 내보내기
다음 JSON 구성을 복사하여 n8n에 가져오면 이 워크플로우를 사용할 수 있습니다
{
  "meta": {
    "instanceId": "40f29e455b10b3ef07629363459d0fa6954887d44ddad18e74a5539a487f2eee",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "df2d582a-6922-40a5-a37f-4e986b59fc20",
      "name": "Freelancer.com RSS 가져오기",
      "type": "n8n-nodes-base.rssFeedRead",
      "notes": "🌐 RSS FETCH — Setup\nFetches the latest jobs from Freelancer.com.\n\nCUSTOMIZE URL:\n• ?keyword=wordpress\n• &min_price=500\n• &max_price=5000\n\nExample:\nhttps://www.freelancer.com/rss.xml?keyword=wordpress&min_price=500\n\n💡 Use multiple RSS nodes for multiple keywords.",
      "position": [
        96,
        704
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 1.2
    },
    {
      "id": "d4650966-00dc-4f5f-9cdc-eecb0e8622d1",
      "name": "작업 품질 필터링",
      "type": "n8n-nodes-base.filter",
      "notes": "✅ QUALITY FILTER — Customize\nCurrent rules:\n• Description > 100 chars\n• Posted within last 2 hours\n\nOPTIONAL:\n• Budget thresholds (if present in feed)\n• Required/excluded keywords\n\nTIP: Start loose, tighten after 1–2 days.",
      "position": [
        544,
        704
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 2
    },
    {
      "id": "4efcab46-f278-401e-9161-78eda3c4c5b6",
      "name": "AI 작업 분석기",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "notes": "🧠 AI ANALYZER — Setup\nScores the job 1–10, explains reasoning, flags risks, and classifies client type.\n\nTIP: Keep wishlist specific to reduce noise.",
      "position": [
        768,
        704
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 2.2
    },
    {
      "id": "3b3698b9-f690-4d8e-981d-ead12a0e3061",
      "name": "구조화된 출력 파서",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "notes": "🧩 OUTPUT PARSER — Stability\nForces strict JSON so downstream filters/logging never break.",
      "position": [
        928,
        1008
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 1.3
    },
    {
      "id": "ec090484-ec95-4880-a441-42a8707af572",
      "name": "AI 제안서 생성기",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "notes": "✍️ PROPOSAL WRITER — Customize\nEdit \"My Skills\" / \"My Experience\" and drop one relevant portfolio link.\n\n💡 90% done by AI → add 10% personal touch.",
      "position": [
        1344,
        704
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 1.3
    },
    {
      "id": "a97989f9-d7d6-4e79-9f26-802372548099",
      "name": "Google Sheets에 기록",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "📊 JOB LOGGER — Setup\nAppend/Update by Link to avoid duplicates.\n\nRecommended columns: Timestamp | Job | Description | Link | AI Score | Reasoning | Red Flags | Client Type | AI Proposal | Alert Timestamp.",
      "position": [
        1696,
        704
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 4.4
    },
    {
      "id": "5770b44f-d639-4852-a80e-469474e23966",
      "name": "Telegram 알림 보내기",
      "type": "n8n-nodes-base.telegram",
      "notes": "📱 TELEGRAM — Setup\nCreate bot with @BotFather → add token in credentials → DM your bot → get Chat ID via @userinfobot and paste here.\n\nTIP: Add buttons via your own webhook for Skip / Applied.",
      "position": [
        1920,
        704
      ],
      "webhookId": "89db660a-6dd5-482f-bdeb-df44a2508245",
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 1.2
    },
    {
      "id": "f18bd2e8-d87e-42b8-887a-f7b67fd259c7",
      "name": "고정: 설정 시작",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -912,
        432
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a12e9052-8c1d-406b-95d1-7addfd5a6b31",
      "name": "예약: 5분마다 실행",
      "type": "n8n-nodes-base.scheduleTrigger",
      "notes": "⏰ TRIGGER — Schedule\nRuns this workflow every 5 minutes.\n\n✏️ CUSTOMIZE:\n• 3 min = ultra-competitive niches\n• 10–15 min = lower API cost\n\n💡 TIP: Start at 5 min and tune after 1–2 days based on alert volume.",
      "position": [
        -800,
        704
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 1.1
    },
    {
      "id": "8162d357-6dfb-40ad-9623-bb68e2b9eb9a",
      "name": "설정 (키워드 및 위시리스트)",
      "type": "n8n-nodes-base.set",
      "notes": "⚙️ SETTINGS — Setup\nDefine your main keyword and your \"wish list\" criteria.\n\nExamples:\n• Job Keyword: shopify, react, seo\n• Wishlist: \"Budget > $500, clear scope, no vague fixed-price\"\n\n💡 TIP: Clone this node to run multiple keywords in parallel (merge later).",
      "position": [
        -576,
        704
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 3.4
    },
    {
      "id": "747c51cd-4009-4593-8b9f-676571342cbf",
      "name": "확인된 링크 불러오기 (Google Sheets)",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "📥 DEDUPE SOURCE — Setup\nLoads previously processed links from your tracking sheet.\n\nSETUP:\n• Use the same spreadsheet as the logger\n• Column \"Link\" must exist\n\n🔒 Prevents duplicate alerts.",
      "position": [
        -352,
        704
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 4.4,
      "alwaysOutputData": true
    },
    {
      "id": "49826d1a-879b-49df-9cdc-e6dea41b34e4",
      "name": "확인된 링크 수집",
      "type": "n8n-nodes-base.aggregate",
      "notes": "🧮 AGGREGATE — Setup\nBuilds a quick lookup of already seen links for the dedupe filter.",
      "position": [
        -128,
        704
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "8482790d-f432-40bc-b7e6-a4184b4e7311",
      "name": "링크 중복 제거",
      "type": "n8n-nodes-base.filter",
      "notes": "🚫 DEDUPE — Customize\nOnly pass jobs whose link is not already in your sheet.\n\nTIP: If your source has unstable links, switch to a hash of (title+date).",
      "position": [
        320,
        704
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 2.2
    },
    {
      "id": "b19632af-88ae-4e2b-b731-df8b4124545a",
      "name": "LLM (OpenAI)",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "notes": "⚙️ LLM BACKEND — Setup\nUsed by Analyzer & Proposal nodes.\n\nTIP: Use gpt-4o-mini for speed/cost unless you need richer reasoning.",
      "position": [
        800,
        1008
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 1.2
    },
    {
      "id": "482ded64-e1b3-472c-bb24-20c3fdf7bd93",
      "name": "게이트: 점수 ≥",
      "type": "n8n-nodes-base.if",
      "notes": "🎯 SCORE GATE — Customize\nOnly pass jobs with score ≥ 7.\n\n6 = more alerts, 8 = only premium.",
      "position": [
        1120,
        704
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 2
    },
    {
      "id": "d5802bc6-46df-4658-9386-944b92aed5bf",
      "name": "CV (Sheets 도구)",
      "type": "n8n-nodes-base.googleSheetsTool",
      "notes": "🛠️ SHEETS TOOL — Optional\nFor advanced automations (e.g., pulling portfolio snippets). Safe to disable initially.",
      "position": [
        1424,
        928
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 4.7
    }
  ],
  "pinData": {},
  "connections": {
    "b19632af-88ae-4e2b-b731-df8b4124545a": {
      "ai_languageModel": [
        [
          {
            "node": "4efcab46-f278-401e-9161-78eda3c4c5b6",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "4efcab46-f278-401e-9161-78eda3c4c5b6": {
      "main": [
        [
          {
            "node": "482ded64-e1b3-472c-bb24-20c3fdf7bd93",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "482ded64-e1b3-472c-bb24-20c3fdf7bd93": {
      "main": [
        [
          {
            "node": "ec090484-ec95-4880-a441-42a8707af572",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d5802bc6-46df-4658-9386-944b92aed5bf": {
      "ai_tool": [
        [
          {
            "node": "ec090484-ec95-4880-a441-42a8707af572",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "d4650966-00dc-4f5f-9cdc-eecb0e8622d1": {
      "main": [
        [
          {
            "node": "4efcab46-f278-401e-9161-78eda3c4c5b6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "49826d1a-879b-49df-9cdc-e6dea41b34e4": {
      "main": [
        [
          {
            "node": "df2d582a-6922-40a5-a37f-4e986b59fc20",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a97989f9-d7d6-4e79-9f26-802372548099": {
      "main": [
        [
          {
            "node": "5770b44f-d639-4852-a80e-469474e23966",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ec090484-ec95-4880-a441-42a8707af572": {
      "main": [
        [
          {
            "node": "a97989f9-d7d6-4e79-9f26-802372548099",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8482790d-f432-40bc-b7e6-a4184b4e7311": {
      "main": [
        [
          {
            "node": "d4650966-00dc-4f5f-9cdc-eecb0e8622d1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "df2d582a-6922-40a5-a37f-4e986b59fc20": {
      "main": [
        [
          {
            "node": "8482790d-f432-40bc-b7e6-a4184b4e7311",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3b3698b9-f690-4d8e-981d-ead12a0e3061": {
      "ai_outputParser": [
        [
          {
            "node": "4efcab46-f278-401e-9161-78eda3c4c5b6",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "a12e9052-8c1d-406b-95d1-7addfd5a6b31": {
      "main": [
        [
          {
            "node": "8162d357-6dfb-40ad-9623-bb68e2b9eb9a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8162d357-6dfb-40ad-9623-bb68e2b9eb9a": {
      "main": [
        [
          {
            "node": "747c51cd-4009-4593-8b9f-676571342cbf",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "747c51cd-4009-4593-8b9f-676571342cbf": {
      "main": [
        [
          {
            "node": "49826d1a-879b-49df-9cdc-e6dea41b34e4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
자주 묻는 질문

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

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

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

고급 - 콘텐츠 제작, 멀티모달 AI

유료인가요?

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

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

고급 사용자를 위한 16+개 노드의 복잡한 워크플로우

저자
Sulieman Said

Sulieman Said

@sulieman-said

👋 Hi, I’m Sulieman – Founder of aufCopilot.de . I build custom n8n workflows, automations & AI integrations to help businesses save time and scale smarter. I share templates, answer questions and love exploring creative use cases – from lead generation to data workflows and AI-powered automations. 🚀 Always happy to connect, learn and contribute to the community. Although my profile is in English, I am a native German speaker and happy to work in both German and English projects.

외부 링크
n8n.io에서 보기

이 워크플로우 공유

카테고리

카테고리: 34