8
n8n ํ•œ๊ตญ์–ดamn8n.com

๐Ÿ” ์–‘์ค‘ ํ™•์ธ ์ด๋ฉ”์ผ๏ฟฝ๏ฟฝ ์ธ์ฆ ์‹œ์Šคํ…œ(Google ์Šคํ”„๋ ˆ๋“œ์‹œํŠธ ์‚ฌ์šฉ)

๊ณ ๊ธ‰

์ด๊ฒƒ์€Marketing, IT Ops๋ถ„์•ผ์˜์ž๋™ํ™” ์›Œํฌํ”Œ๋กœ์šฐ๋กœ, 24๊ฐœ์˜ ๋…ธ๋“œ๋ฅผ ํฌํ•จํ•ฉ๋‹ˆ๋‹ค.์ฃผ๋กœ If, Code, Form, EmailSend, FormTrigger ๋“ฑ์˜ ๋…ธ๋“œ๋ฅผ ์‚ฌ์šฉํ•˜๋ฉฐ. ๐Ÿ” Google Sheets์˜ ๋”๋ธ” ํ™•์ธ ์ด๋ฉ”์ผ๏ฟฝ๏ฟฝ ์ธ์ฆ ์‹œ์Šคํ…œ

์‚ฌ์ „ ์š”๊ตฌ์‚ฌํ•ญ
  • โ€ขGoogle Sheets API ์ธ์ฆ ์ •๋ณด

์‚ฌ์šฉ๋œ ๋…ธ๋“œ (24)

์นดํ…Œ๊ณ ๋ฆฌ

์›Œํฌํ”Œ๋กœ์šฐ ๋ฏธ๋ฆฌ๋ณด๊ธฐ
๋…ธ๋“œ ์—ฐ๊ฒฐ ๊ด€๊ณ„๋ฅผ ์‹œ๊ฐ์ ์œผ๋กœ ํ‘œ์‹œํ•˜๋ฉฐ, ํ™•๋Œ€/์ถ•์†Œ ๋ฐ ์ด๋™์„ ์ง€์›ํ•ฉ๋‹ˆ๋‹ค
์›Œํฌํ”Œ๋กœ์šฐ ๋‚ด๋ณด๋‚ด๊ธฐ
๋‹ค์Œ JSON ๊ตฌ์„ฑ์„ ๋ณต์‚ฌํ•˜์—ฌ n8n์— ๊ฐ€์ ธ์˜ค๋ฉด ์ด ์›Œํฌํ”Œ๋กœ์šฐ๋ฅผ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค
{
  "id": "bWbwE1qVduRTdWmc",
  "meta": {
    "instanceId": "a98b2884375a41e5c54ee9fdf1ece06db7f5771d5abd20450875f3922d7c41f8"
  },
  "name": "๐Ÿ” Double Opt-In Email Verification System with Google Sheets",
  "tags": [
    {
      "id": "2E1hRaAa0axOUCXV",
      "name": "UTCM",
      "createdAt": "2025-05-08T22:11:01.814Z",
      "updatedAt": "2025-05-08T22:11:01.814Z"
    },
    {
      "id": "GZT3Cgu3i4As1Giz",
      "name": "Doble-OptIn",
      "createdAt": "2025-05-08T22:10:58.928Z",
      "updatedAt": "2025-05-08T22:10:58.928Z"
    },
    {
      "id": "UZnyfKrtC83mHOyK",
      "name": "Forms",
      "createdAt": "2025-05-08T22:10:50.602Z",
      "updatedAt": "2025-05-08T22:10:50.602Z"
    }
  ],
  "nodes": [
    {
      "id": "93c4049b-138e-4cb1-906a-8aada9485ffd",
      "name": "ํผ ์ œ์ถœ ์‹œ",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -4460,
        -160
      ],
      "webhookId": "13e025ae-a071-4659-ad64-6aab4fdf26c8",
      "parameters": {},
      "notesInFlow": false,
      "typeVersion": 2.2
    },
    {
      "id": "358d84d7-381b-4de9-8c5e-d1d988c0b4a7",
      "name": "์ด๋ฉ”์ผ ํผ",
      "type": "n8n-nodes-base.form",
      "position": [
        -4140,
        -160
      ],
      "webhookId": "65c69d26-adef-48d9-8bff-2f152fc5ce94",
      "parameters": {},
      "notesInFlow": false,
      "typeVersion": 1
    },
    {
      "id": "d0106dca-e3d1-45bc-b0e4-a0ac7a82a903",
      "name": "์ฝ”๋“œ ์ƒ์„ฑ",
      "type": "n8n-nodes-base.code",
      "position": [
        -3800,
        -160
      ],
      "parameters": {},
      "notesInFlow": false,
      "typeVersion": 2,
      "alwaysOutputData": true
    },
    {
      "id": "659f0327-c4ee-45f8-a38d-80e9aada20db",
      "name": "์ด๋ฉ”์ผ ์ „์†ก",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -3020,
        -160
      ],
      "webhookId": "7a787e42-b725-454a-99e6-71f95863d37f",
      "parameters": {},
      "notesInFlow": false,
      "typeVersion": 2.1
    },
    {
      "id": "ac5dfb19-9254-45fd-92bb-2d78a3062f51",
      "name": "๋ฐ์ดํ„ฐ ์ €์žฅ",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -3440,
        -120
      ],
      "parameters": {},
      "notesInFlow": false,
      "typeVersion": 4.5
    },
    {
      "id": "f9586647-ea00-4b21-bd54-76f4314f926d",
      "name": "์ธ์ฆ ํผ",
      "type": "n8n-nodes-base.form",
      "position": [
        -2700,
        -160
      ],
      "webhookId": "d21ac010-2872-4320-af3b-6f5e398dc8e5",
      "parameters": {},
      "notesInFlow": false,
      "typeVersion": 1
    },
    {
      "id": "e33fb6cd-59c2-4c84-9d51-5c8f7af1e2a1",
      "name": "์ฝ”๋“œ ํ™•์ธ",
      "type": "n8n-nodes-base.if",
      "position": [
        -2380,
        -160
      ],
      "parameters": {},
      "notesInFlow": false,
      "typeVersion": 2.2
    },
    {
      "id": "47dd37e4-409c-42dd-9554-b14c18b65cb0",
      "name": "๋ฉ”์ธ ํผ",
      "type": "n8n-nodes-base.form",
      "position": [
        -1840,
        -440
      ],
      "webhookId": "5c229f26-1625-4367-a3f9-ebd2cc3e8241",
      "parameters": {},
      "notesInFlow": false,
      "typeVersion": 1
    },
    {
      "id": "016ff76e-12f6-42ed-ad3c-234c585d6126",
      "name": "์ž˜๋ชป๋œ ์ฝ”๋“œ ํผ",
      "type": "n8n-nodes-base.form",
      "position": [
        -1920,
        600
      ],
      "webhookId": "c69a7027-4453-43ba-a5ae-5601d912978e",
      "parameters": {},
      "notesInFlow": false,
      "typeVersion": 1
    },
    {
      "id": "b1692894-3759-4f56-bd98-1c57a91dbb3c",
      "name": "๋‘ ๋ฒˆ์งธ ํ™•์ธ",
      "type": "n8n-nodes-base.if",
      "position": [
        -1200,
        60
      ],
      "parameters": {},
      "notesInFlow": false,
      "typeVersion": 2.2
    },
    {
      "id": "f883c1c1-4529-41a8-9ec4-4f2396fcc972",
      "name": "ํผ ์ดˆ๊ธฐํ™”",
      "type": "n8n-nodes-base.form",
      "position": [
        -640,
        760
      ],
      "webhookId": "16d0402a-20a1-4a6c-9ab8-13c353a1efe7",
      "parameters": {},
      "notesInFlow": false,
      "typeVersion": 1
    },
    {
      "id": "dc335784-6532-4e63-b4a1-5b9cf77b5de6",
      "name": "์ฐธ๊ณ  ์‚ฌํ•ญ 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4540,
        -600
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2160baa2-a011-4bd8-b4bb-a11845e0323c",
      "name": "์ฐธ๊ณ  ์‚ฌํ•ญ 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4240,
        -600
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6fed7946-cac4-48c0-836d-863f87ac1da0",
      "name": "์ฐธ๊ณ  ์‚ฌํ•ญ 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3920,
        -600
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "4d8dbcce-1dc3-48fa-a2f9-1561e6399462",
      "name": "์ฐธ๊ณ  ์‚ฌํ•ญ 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3600,
        -600
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3b1cdbbd-28f3-420a-b507-0a707e857845",
      "name": "์ฐธ๊ณ  ์‚ฌํ•ญ 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3120,
        -600
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "59276d85-d217-4883-86ac-427eb70083df",
      "name": "์ฐธ๊ณ  ์‚ฌํ•ญ 6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2800,
        -600
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6c0df430-39c0-4dc9-b0a4-6b9a2aeabc12",
      "name": "์ฐธ๊ณ  ์‚ฌํ•ญ 7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2480,
        -600
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "05973b8b-b873-44c6-8274-1bae17118cb8",
      "name": "์ฐธ๊ณ  ์‚ฌํ•ญ 8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2120,
        300
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1479b495-1d18-4a03-8fdb-d276b33e70ac",
      "name": "์ฐธ๊ณ  ์‚ฌํ•ญ 9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1480,
        -220
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "9936331c-2fb5-4d4f-ab8d-b586310a75ca",
      "name": "์ฐธ๊ณ  ์‚ฌํ•ญ 10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -780,
        400
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2ae131e8-69a1-4212-81d6-95aabaf5cd3e",
      "name": "์ฐธ๊ณ  ์‚ฌํ•ญ 11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2120,
        -740
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2a429ebd-460c-4a33-bc57-7576e31e1fea",
      "name": "์›Œํฌํ”Œ๋กœ์šฐ ๊ณ„์† ์ง„ํ–‰",
      "type": "n8n-nodes-base.noOp",
      "position": [
        -1200,
        -440
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0935942e-3a27-4f5c-ac0f-9a0ddc68ac8a",
      "name": "์ฐธ๊ณ  ์‚ฌํ•ญ",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1420,
        -1000
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "5ace2a5e-1f6c-4c13-a069-d71dcb22ee1d",
  "connections": {
    "47dd37e4-409c-42dd-9554-b14c18b65cb0": {
      "main": [
        [
          {
            "node": "2a429ebd-460c-4a33-bc57-7576e31e1fea",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e33fb6cd-59c2-4c84-9d51-5c8f7af1e2a1": {
      "main": [
        [
          {
            "node": "47dd37e4-409c-42dd-9554-b14c18b65cb0",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "016ff76e-12f6-42ed-ad3c-234c585d6126",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "358d84d7-381b-4de9-8c5e-d1d988c0b4a7": {
      "main": [
        [
          {
            "node": "d0106dca-e3d1-45bc-b0e4-a0ac7a82a903",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f883c1c1-4529-41a8-9ec4-4f2396fcc972": {
      "main": [
        [
          {
            "node": "358d84d7-381b-4de9-8c5e-d1d988c0b4a7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "659f0327-c4ee-45f8-a38d-80e9aada20db": {
      "main": [
        [
          {
            "node": "f9586647-ea00-4b21-bd54-76f4314f926d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ac5dfb19-9254-45fd-92bb-2d78a3062f51": {
      "main": [
        [
          {
            "node": "659f0327-c4ee-45f8-a38d-80e9aada20db",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b1692894-3759-4f56-bd98-1c57a91dbb3c": {
      "main": [
        [
          {
            "node": "47dd37e4-409c-42dd-9554-b14c18b65cb0",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "f883c1c1-4529-41a8-9ec4-4f2396fcc972",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d0106dca-e3d1-45bc-b0e4-a0ac7a82a903": {
      "main": [
        [
          {
            "node": "ac5dfb19-9254-45fd-92bb-2d78a3062f51",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f9586647-ea00-4b21-bd54-76f4314f926d": {
      "main": [
        [
          {
            "node": "e33fb6cd-59c2-4c84-9d51-5c8f7af1e2a1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "93c4049b-138e-4cb1-906a-8aada9485ffd": {
      "main": [
        [
          {
            "node": "358d84d7-381b-4de9-8c5e-d1d988c0b4a7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "016ff76e-12f6-42ed-ad3c-234c585d6126": {
      "main": [
        [
          {
            "node": "b1692894-3759-4f56-bd98-1c57a91dbb3c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
์ž์ฃผ ๋ฌป๋Š” ์งˆ๋ฌธ

์ด ์›Œํฌํ”Œ๋กœ์šฐ๋ฅผ ์–ด๋–ป๊ฒŒ ์‚ฌ์šฉํ•˜๋‚˜์š”?

์œ„์˜ JSON ๊ตฌ์„ฑ ์ฝ”๋“œ๋ฅผ ๋ณต์‚ฌํ•˜์—ฌ n8n ์ธ์Šคํ„ด์Šค์—์„œ ์ƒˆ ์›Œํฌํ”Œ๋กœ์šฐ๋ฅผ ์ƒ์„ฑํ•˜๊ณ  "JSON์—์„œ ๊ฐ€์ ธ์˜ค๊ธฐ"๋ฅผ ์„ ํƒํ•œ ํ›„, ๊ตฌ์„ฑ์„ ๋ถ™์—ฌ๋„ฃ๊ณ  ํ•„์š”์— ๋”ฐ๋ผ ์ธ์ฆ ์„ค์ •์„ ์ˆ˜์ •ํ•˜์„ธ์š”.

์ด ์›Œํฌํ”Œ๋กœ์šฐ๋Š” ์–ด๋–ค ์‹œ๋‚˜๋ฆฌ์˜ค์— ์ ํ•ฉํ•œ๊ฐ€์š”?

๊ณ ๊ธ‰ - ๋งˆ์ผ€ํŒ…, IT ์šด์˜

์œ ๋ฃŒ์ธ๊ฐ€์š”?

์ด ์›Œํฌํ”Œ๋กœ์šฐ๋Š” ์™„์ „ํžˆ ๋ฌด๋ฃŒ์ด๋ฉฐ ์ง์ ‘ ๊ฐ€์ ธ์™€ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๋‹ค๋งŒ, ์›Œํฌํ”Œ๋กœ์šฐ์—์„œ ์‚ฌ์šฉํ•˜๋Š” ํƒ€์‚ฌ ์„œ๋น„์Šค(์˜ˆ: OpenAI API)๋Š” ์‚ฌ์šฉ์ž ์ง์ ‘ ๋น„์šฉ์„ ์ง€๋ถˆํ•ด์•ผ ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

๊ด€๋ จ ์›Œํฌํ”Œ๋กœ์šฐ ์ถ”์ฒœ

CSV๋ฅผ HubSpot์— ์—…๋กœ๋“œ๊ธฐ (๋™์  ํ•„๋“œ ๋งตํ•‘ ๋ฐ Google ์Šคํ”„๋ ˆ๋“œ์‹œํŠธ ํ†ตํ•ฉ)
๋™์  ํ•„๋“œ ๋งตํ•‘๊ณผ Google Sheets ํ†ตํ•ฉ์„ ํฌํ•จํ•œ CSV์—์„œ HubSpot ์—…๋กœ๋“œ
If
Set
Code
+
If
Set
Code
36 ๋…ธ๋“œPollupAI
์ธ๊ณต์ง€๋Šฅ
Google Sheets, Forms ๋ฐ Gmail ์•Œ๋ฆผ์„ ์‚ฌ์šฉํ•œ ๋‹ค๋‹จ๊ณ„ ์˜จ๋ณด๋”ฉ ํ”„๋กœ์„ธ์Šค ์ž๋™ํ™”
Google Sheets, Forms ๋ฐ Gmail ์•Œ๋ฆผ์„ ์‚ฌ์šฉํ•œ ์ž๋™ํ™”๋œ ๋‹ค๋‹จ๊ณ„ ์˜จ๋ณด๋”ฉ ํ”„๋กœ์„ธ์Šค
If
Set
Code
+
If
Set
Code
31 ๋…ธ๋“œPollupAI
์ธ์‚ฌ
3D ์ œํ’ˆ ๋น„๋””์˜ค
ไธบ็”ตๅ•†ๅบ—้“บ์—์„œ2Dๅ›พๅƒ์ƒ์„ฑ3D์ œํ’ˆ่ง†้ข‘
If
Code
Wait
+
If
Code
Wait
21 ๋…ธ๋“œInfyOm Technologies
๋””์ž์ธ
AI ๋งˆ์ผ€ํŒ… ์—์ด์ „ํŠธ: Reddit + OpenRouter + Gmail ์ž ์žฌ๊ณ ๊ฐ ์ƒ์„ฑ
AI ๋งˆ์ผ€ํŒ… ์—์ด์ „ํŠธ: Reddit, OpenRouter ๋ฐ Gmail์„ ํ†ตํ•œ ์ž ์žฌ๊ณ ๊ฐ ์ƒ์„ฑ
If
Set
Code
+
If
Set
Code
23 ๋…ธ๋“œAri Nakos
์˜์—…
OpenAI, Google Sheets, Jina AI ๋ฐ Slack์„ ํ™œ์šฉํ•œ AI ๊ธฐ๋ฐ˜ ์ •๋ณด ๋ชจ๋‹ˆํ„ฐ๋ง
AI ๊ธฐ๋ฐ˜ ์ •๋ณด ๋ชจ๋‹ˆํ„ฐ๋ง ์›Œํฌํ”Œ๋กœ์šฐ๋กœ OpenAI, Google Sheets, Jina AI ๋ฐ Slack์„ ํ†ตํ•ฉํ•ฉ๋‹ˆ๋‹ค
If
Set
Code
+
If
Set
Code
31 ๋…ธ๋“œDataki
์˜์—…
๊ณ ๊ธ‰ AI ๊ธฐ๋ฐ˜ YouTube SEO ์ตœ์ ํ™” ๋ฐ ์ž๋™ ์—…๋ฐ์ดํŠธ
้ซ˜็บงAI้ฉฑๅŠจ์˜YouTube SEOไผ˜ๅŒ–ไธŽ์ž๋™์—…๋ฐ์ดํŠธ
If
Code
Form
+
If
Code
Form
12 ๋…ธ๋“œLucas Correia
์ธ๊ณต์ง€๋Šฅ
์›Œํฌํ”Œ๋กœ์šฐ ์ •๋ณด
๋‚œ์ด๋„
๊ณ ๊ธ‰
๋…ธ๋“œ ์ˆ˜24
์นดํ…Œ๊ณ ๋ฆฌ2
๋…ธ๋“œ ์œ ํ˜•8
๋‚œ์ด๋„ ์„ค๋ช…

๊ณ ๊ธ‰ ์‚ฌ์šฉ์ž๋ฅผ ์œ„ํ•œ 16+๊ฐœ ๋…ธ๋“œ์˜ ๋ณต์žกํ•œ ์›Œํฌํ”Œ๋กœ์šฐ

์™ธ๋ถ€ ๋งํฌ
n8n.io์—์„œ ๋ณด๊ธฐ โ†’

์ด ์›Œํฌํ”Œ๋กœ์šฐ ๊ณต์œ 

์นดํ…Œ๊ณ ๋ฆฌ

์นดํ…Œ๊ณ ๋ฆฌ: 34