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

๐Ÿค– Google Sheets์—์„œ WordPress๋กœ ์ž๋™ํ™”๋œ AI ๊ธฐ์‚ฌ ์ƒ์„ฑ

๊ณ ๊ธ‰

์ด๊ฒƒ์€Content Creation, Multimodal AI๋ถ„์•ผ์˜์ž๋™ํ™” ์›Œํฌํ”Œ๋กœ์šฐ๋กœ, 16๊ฐœ์˜ ๋…ธ๋“œ๋ฅผ ํฌํ•จํ•ฉ๋‹ˆ๋‹ค.์ฃผ๋กœ If, Code, Webhook, Wordpress, HttpRequest ๋“ฑ์˜ ๋…ธ๋“œ๋ฅผ ์‚ฌ์šฉํ•˜๋ฉฐ. ์›น ํฌ๋กค๋ง๊ณผ GPT-4 Mini๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ Google Sheets์—์„œ WordPress๋กœ ๊ธฐ์‚ฌ ์ƒ์„ฑ

์‚ฌ์ „ ์š”๊ตฌ์‚ฌํ•ญ
  • โ€ขHTTP Webhook ์—”๋“œํฌ์ธํŠธ(n8n์ด ์ž๋™์œผ๋กœ ์ƒ์„ฑ)
  • โ€ข๋Œ€์ƒ API์˜ ์ธ์ฆ ์ •๋ณด๊ฐ€ ํ•„์š”ํ•  ์ˆ˜ ์žˆ์Œ
  • โ€ขGoogle Sheets API ์ธ์ฆ ์ •๋ณด
  • โ€ขOpenAI API Key
์›Œํฌํ”Œ๋กœ์šฐ ๋ฏธ๋ฆฌ๋ณด๊ธฐ
๋…ธ๋“œ ์—ฐ๊ฒฐ ๊ด€๊ณ„๋ฅผ ์‹œ๊ฐ์ ์œผ๋กœ ํ‘œ์‹œํ•˜๋ฉฐ, ํ™•๋Œ€/์ถ•์†Œ ๋ฐ ์ด๋™์„ ์ง€์›ํ•ฉ๋‹ˆ๋‹ค
์›Œํฌํ”Œ๋กœ์šฐ ๋‚ด๋ณด๋‚ด๊ธฐ
๋‹ค์Œ JSON ๊ตฌ์„ฑ์„ ๋ณต์‚ฌํ•˜์—ฌ n8n์— ๊ฐ€์ ธ์˜ค๋ฉด ์ด ์›Œํฌํ”Œ๋กœ์šฐ๋ฅผ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค
{
  "id": "9LKLgEkXV10DszQ1",
  "meta": {
    "instanceId": "1f1785d995b3fa32ab6b8219168659331dbe1459fee9ca0c94987e0285ae2676",
    "templateCredsSetupCompleted": true
  },
  "name": "๐Ÿค– Automated AI Article Generation from Google Sheets to WordPressnail",
  "tags": [
    {
      "id": "0TIhg6ju9FxO2Lcp",
      "name": "Wordpress",
      "createdAt": "2025-07-23T09:03:28.998Z",
      "updatedAt": "2025-07-23T09:03:28.998Z"
    },
    {
      "id": "KNKC6Mt3juYzghT4",
      "name": "Newsbreak",
      "createdAt": "2025-09-01T09:43:28.145Z",
      "updatedAt": "2025-09-01T09:43:28.145Z"
    },
    {
      "id": "j70AoEIxmOT3oVGW",
      "name": "๐ŸŸข Active",
      "createdAt": "2025-09-03T07:38:33.128Z",
      "updatedAt": "2025-09-03T07:38:33.128Z"
    }
  ],
  "nodes": [
    {
      "id": "019cddd8-29dd-46d1-9269-696ec3cef37a",
      "name": "ํ•ญ๋ชฉ ๋ฐ˜๋ณต",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -736,
        384
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "8ba87150-8d5d-4684-b91d-161e7e7d730a",
      "name": "์กฐ๊ฑด๋ฌธ",
      "type": "n8n-nodes-base.if",
      "position": [
        -64,
        144
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "loose"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "3f3244e8-d845-48b1-8355-07295725cb85",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.data }}",
              "rightValue": ""
            }
          ]
        },
        "looseTypeValidation": true
      },
      "typeVersion": 2.2,
      "alwaysOutputData": false
    },
    {
      "id": "7650e708-bb75-4472-88b2-5bf6384f2369",
      "name": "์ƒˆ ์•„ํ‹ฐํด ๊ฐ€์ ธ์˜ค๊ธฐ",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -960,
        384
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "New",
              "lookupColumn": "Flow Status"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 2027275420,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1CnYbGz4Xq0D0eI6T4jelZkL1c3ZY5hKB2wjhWtmjAOw/edit#gid=2027275420",
          "cachedResultName": "Cheapnail"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1CnYbGz4Xq0D0eI6T4jelZkL1c3ZY5hKB2wjhWtmjAOw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1CnYbGz4Xq0D0eI6T4jelZkL1c3ZY5hKB2wjhWtmjAOw/edit?usp=drivesdk",
          "cachedResultName": "n8n Newspress Article Workflow"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Br9lRn5gAnnRLFmy",
          "name": "Google Sheets account 2"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "dfa0ca22-4b60-4215-9f82-5fc0bc0d125d",
      "name": "์ฒ˜๋ฆฌ ์ƒํƒœ ์—…๋ฐ์ดํŠธ",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -512,
        144
      ],
      "parameters": {
        "columns": {
          "value": {
            "Topic": "={{ $json.Topic }}",
            "Source": "={{ $json.Source }}",
            "row_number": "={{ $json.row_number }}",
            "Flow Timing": "={{ $now.setZone(\"Asia/Kolkata\").toFormat(\"dd-MMM-yyyy HH:mm:ss\") }}",
            "Publish Status": "Processing"
          },
          "schema": [
            {
              "id": "Topic",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Topic",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Source",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Source",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Publish Status",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Publish Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Publish Link",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Publish Link",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Flow Status",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Flow Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Flow Timing",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Flow Timing",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Run Flow",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Run Flow",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "row_number"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 2027275420,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1CnYbGz4Xq0D0eI6T4jelZkL1c3ZY5hKB2wjhWtmjAOw/edit#gid=2027275420",
          "cachedResultName": "Cheapnail"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1CnYbGz4Xq0D0eI6T4jelZkL1c3ZY5hKB2wjhWtmjAOw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1CnYbGz4Xq0D0eI6T4jelZkL1c3ZY5hKB2wjhWtmjAOw/edit?usp=drivesdk",
          "cachedResultName": "n8n Newspress Article Workflow"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Br9lRn5gAnnRLFmy",
          "name": "Google Sheets account 2"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "ba43343e-ac56-4cdb-9877-c3f23458df0f",
      "name": "HTML ๊ฐ€์ ธ์˜ค๊ธฐ",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueRegularOutput",
      "position": [
        -288,
        144
      ],
      "parameters": {
        "url": "={{ $json.Source }}",
        "options": {
          "timeout": 10000
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "d4d5aceb-8065-415a-8bfe-7a9cb5df8bcd",
      "name": "์˜ค๋ฅ˜ ์—…๋ฐ์ดํŠธ",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        224,
        240
      ],
      "parameters": {
        "columns": {
          "value": {
            "row_number": "={{ $('Update Processing').item.json.row_number }}",
            "Flow Status": "Error",
            "Publish Link": "={{ $('Fetch HTML').item.json.error.status }}",
            "Publish Status": "Not Processed Because of an Error"
          },
          "schema": [
            {
              "id": "Topic",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Topic",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Source",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Source",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Publish Status",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Publish Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Publish Link",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Publish Link",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Flow Status",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Flow Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Flow Timing",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Flow Timing",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Run Flow",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Run Flow",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "row_number"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 2027275420,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1CnYbGz4Xq0D0eI6T4jelZkL1c3ZY5hKB2wjhWtmjAOw/edit#gid=2027275420",
          "cachedResultName": "Cheapnail"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1CnYbGz4Xq0D0eI6T4jelZkL1c3ZY5hKB2wjhWtmjAOw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1CnYbGz4Xq0D0eI6T4jelZkL1c3ZY5hKB2wjhWtmjAOw/edit?usp=drivesdk",
          "cachedResultName": "n8n Newspress Article Workflow"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Br9lRn5gAnnRLFmy",
          "name": "Google Sheets account 2"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "69aff7d4-a5d8-4bc7-93a6-a66ca684528b",
      "name": "์Šคํ‹ฐ์ปค ๋…ธํŠธ",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        128,
        -64
      ],
      "parameters": {
        "color": 6,
        "width": 640,
        "height": 224,
        "content": "## ๐Ÿค– These Two AI Brother is creating the Article โœŒ\n- Article Summarizer\n- Article Creator"
      },
      "typeVersion": 1
    },
    {
      "id": "175955b0-d9ba-4c52-96ae-9c02763a6cd5",
      "name": "์•„ํ‹ฐํด ์ƒ์„ฑ๊ธฐ",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        512,
        48
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini",
          "cachedResultName": "GPT-4.1-MINI"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "role": "system",
              "content": "=Generate a news article about the given Source Data\nThe article should follow this format and structure:\n- **Headline:** Create an SEO-optimized headline that includes the keywords from the topic title.\n- **Location Line:** Immediately after the headline, include a **location line** (e.g., **\"San Francisco, CA โ€“\"**) and **bold the location**.\n- **Introduction:** Write a strong, engaging introduction summarizing the key point of the article in one to two paragraphs. Make sure it captures the reader's attention.\n- **Main Headings Based on Content:**\n  - Instead of predefined subheadings, **generate the main headings** based on the **content of the article**. For example:\n    1. If the article is about a **discovery**, the main heading might be something like: **\"The Unexpected Discovery\"** or **\"How the Discovery Was Made\"**.\n    2. If the article focuses on **reactions**, the main heading could be: **\"Community Reactions and Expert Opinions\"** or **\"Public and Expert Responses\"**.\n    3. For articles related to **future implications** or **next steps**, the heading could be: **\"What Happens Next?\"** or **\"Implications for the Future\"**.\n  - The key here is that the main headings should be **created based on the content** in the body, rather than following a rigid structure.\n- **Body Content:**\n  - The body of the article should flow logically, based on the content collected from the source. Each section should expand on the corresponding headings.\n  - Ensure each section is fact-based, concise, well-researched, and provides relevant information. Use the extracted expert quotes where appropriate.\n- **Bold Key Points:**  Make sure to bold any important names, figures, dates, or key terms that require emphasis. Additionally, bold around 15% of the most important words in the article to highlight the key information and ensure clarity.\n- **Bullet Points:** Use bullet points to highlight key facts, data, trends, or recommendations within the article. Bullet points should break down complex information into digestible chunks.\n- **Blockquotes:** Include blockquotes for any expert opinions, quotes, or statements that should be emphasized.\n- **Source Integration:** Integrate the provided **source link** **only once** within the article body. It should be referenced naturally, in a relevant section like background information, expert quotes, or statistics.\n- **Customized Call-to-Action (CTA):** At the end of the article, include a **customized CTA** based on the article's content. For example, if the article is about a discovery, the CTA could be:\n  - **\"What do you think about this discovery? Have you ever visited Crater of Diamonds State Park? Share your thoughts in the comments below!\"**\n- **SEO Optimization:** Ensure the article includes relevant keywords naturally throughout the text, in headings and body content, to avoid keyword stuffing while making sure the text flows naturally."
            },
            {
              "role": "system",
              "content": "**Output Format:**\n\n```json\n{\n  \"title\": \"the original title here\",\n  \"content\": \"the fully written HTML article here\"\n}\n```"
            },
            {
              "content": "=Source Data :{{ $json.message.content }}\nsource link: {{ $('Loop Over Items').item.json.Source }}"
            }
          ]
        },
        "jsonOutput": true
      },
      "credentials": {
        "openAiApi": {
          "id": "jNGTDQUn7rhCJPBy",
          "name": "OpenAi account 2"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "e7b6c39b-1b55-41c6-9626-6c18da2253fb",
      "name": "์•„ํ‹ฐํด ์š”์•ฝ๊ธฐ",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        160,
        48
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini",
          "cachedResultName": "GPT-4.1-MINI"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "role": "system",
              "content": "=You are a data extraction AI tasked with processing HTML content. Your goal is to identify and extract the title and the main text content from the provided HTML document. Follow these specific instructions:\n\n1. **Input Format:** You will receive a well-formed HTML document as input.\n2. **Output Format:** Your output should be in Markdown format.\n3. **Content Extraction:**\n   - Extract the title of the article from the `<title>` tag or the main heading tag (e.g., `<h1>`).\n   - Extract the main body of the article excluding any images, external links, or other media. Focus solely on the text content.\n4. **Markdown Guidelines:**\n   - The title should be formatted as a top-level heading (using `#`).\n   - The main body text should follow the title in plain Markdown format, preserving paragraphs, lists, and any other textual formatting present in the HTML.\n5. **Restrictions:**\n   - Do not include any images, external links, or HTML tags in your output.\n   - Ensure that the extracted text is coherent and maintains the context of the original content.\n\nExample Input:\n```html\n<html>\n<head>\n<title>Sample Article Title</title>\n</head>\n<body>\n<h1>Sample Article Title</h1>\n<p>This is the first paragraph of the article.</p>\n<p>This is the second paragraph with <a href=\"http://example.com\">an external link</a>.</p>\n<img src=\"image.jpg\" alt=\"Sample Image\">\n</body>\n</html>\n```\n\nExpected Output:\n```\n# Sample Article Title\n\nThis is the first paragraph of the article with information.\n\nThis is the second paragraph of the article with information.\n```\n\nProcess the provided HTML input according to these instructions and generate the desired Markdown output."
            },
            {
              "content": "=The HTML is provided as follows:\n{{ $('Fetch HTML').item.json.data }}\n\n\nPlease process the HTML and return the Markdown formatted output."
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "jNGTDQUn7rhCJPBy",
          "name": "OpenAi account 2"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "411f871c-ce66-4c8f-81eb-b81a816a7445",
      "name": "์Šคํ‹ฐ์ปค ๋…ธํŠธ1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -560,
        64
      ],
      "parameters": {
        "width": 640,
        "height": 240,
        "content": "## ๐Ÿ•ธ  Fetch the article information from web"
      },
      "typeVersion": 1
    },
    {
      "id": "e7a86256-c59c-4f71-9035-39e93192fc6e",
      "name": "์Šคํ‹ฐ์ปค ๋…ธํŠธ2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1184,
        304
      ],
      "parameters": {
        "color": 5,
        "width": 576,
        "height": 240,
        "content": "## ๐Ÿ“‘ Get 'New' Articles data from G Sheet\n"
      },
      "typeVersion": 1
    },
    {
      "id": "fb65aa96-048d-4145-a7e7-499ecb81715f",
      "name": "์ดˆ์•ˆ ์ƒ์„ฑ",
      "type": "n8n-nodes-base.wordpress",
      "position": [
        1088,
        48
      ],
      "parameters": {
        "title": "={{ $json.title }}",
        "additionalFields": {
          "status": "draft",
          "content": "={{ $json.content }}",
          "authorId": 12
        }
      },
      "credentials": {
        "wordpressApi": {
          "id": "a7Cx6j0h8rI7LX2v",
          "name": "WP Cheapnail"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "6d4b278b-39e4-431e-aeca-e9192b813faa",
      "name": "์•„ํ‹ฐํด ์„œ์‹ ์ง€์ •",
      "type": "n8n-nodes-base.code",
      "position": [
        864,
        48
      ],
      "parameters": {
        "jsCode": "// Pull the incoming payload\nconst msg = $input.first().json.message || {};\nconst rawContent = msg.content;\n\n// Normalise inputs: html body + a separately provided title (if any)\nlet html = \"\";\nlet providedTitle = \"\";\n\nif (typeof rawContent === \"string\") {\n  // Sometimes the HTML is directly in message.content\n  html = rawContent;\n} else if (rawContent && typeof rawContent === \"object\") {\n  // Common shape: message.content = { title, content }\n  html = (rawContent.content || \"\").toString();\n  providedTitle = (rawContent.title || \"\").toString().trim();\n}\n\n// Helper: strip tags for the final title value\nconst stripTags = (s) => s.replace(/<[^>]*>/g, \"\").trim();\n\n// Try to extract <h1> from the HTML body (allow attributes, any casing)\nconst h1Match = html.match(/<h1\\b[^>]*>([\\s\\S]*?)<\\/h1>/i);\n\n// Title preference: <h1> from content first, else fall back to provided title field\nlet title = h1Match ? stripTags(h1Match[1]) : providedTitle;\n\n// Build the content: remove the first <h1> if present; otherwise keep HTML as-is\nlet content = html;\nif (h1Match) {\n  content = html.replace(/<h1\\b[^>]*>[\\s\\S]*?<\\/h1>\\s*/i, \"\").trim();\n} else {\n  content = (html || \"\").trim();\n}\n\n// Output\nreturn [\n  {\n    json: {\n      title,\n      content\n    }\n  }\n];\n"
      },
      "typeVersion": 2
    },
    {
      "id": "18d6447a-cb7a-49c6-9baa-4339c5601f8a",
      "name": "์ดˆ์•ˆ ์„ธ๋ถ€์ •๋ณด ์—…๋ฐ์ดํŠธ",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1312,
        224
      ],
      "parameters": {
        "columns": {
          "value": {
            "row_number": "={{ $('Update Processing').item.json.row_number }}",
            "Flow Status": "Flow Complete",
            "Publish Link": "={{ $json.link }}",
            "Publish Status": "={{ $json.status }}"
          },
          "schema": [
            {
              "id": "Topic",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Topic",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Source",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Source",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Publish Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Publish Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Publish Link",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Publish Link",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Flow Status",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Flow Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Flow Timing",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Flow Timing",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Run Flow",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Run Flow",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "row_number"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 2027275420,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1CnYbGz4Xq0D0eI6T4jelZkL1c3ZY5hKB2wjhWtmjAOw/edit#gid=2027275420",
          "cachedResultName": "Cheapnail"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1CnYbGz4Xq0D0eI6T4jelZkL1c3ZY5hKB2wjhWtmjAOw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1CnYbGz4Xq0D0eI6T4jelZkL1c3ZY5hKB2wjhWtmjAOw/edit?usp=drivesdk",
          "cachedResultName": "n8n Newspress Article Workflow"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Br9lRn5gAnnRLFmy",
          "name": "Google Sheets account 2"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "021f2b33-1f7a-4cba-90de-e56e6acc105a",
      "name": "์Šคํ‹ฐ์ปค ๋…ธํŠธ3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        832,
        -32
      ],
      "parameters": {
        "color": 2,
        "width": 624,
        "height": 416,
        "content": "## ๐Ÿ“‚ Make Draft Article and Update the Google Sheet"
      },
      "typeVersion": 1
    },
    {
      "id": "2aaa0031-8189-47c1-8946-62068490e79e",
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -1168,
        384
      ],
      "webhookId": "a1889360-e1bf-4b53-a96b-5eafa4b165a1",
      "parameters": {
        "path": "a1889360-e1bf-4b53-a96b-5eafa4b165a1",
        "options": {}
      },
      "typeVersion": 2.1
    }
  ],
  "active": true,
  "pinData": {},
  "settings": {
    "timezone": "Asia/Kolkata",
    "callerPolicy": "workflowsFromSameOwner",
    "errorWorkflow": "ipTcrzGbKoHF6UKi",
    "executionOrder": "v1"
  },
  "versionId": "dcb3a423-5356-4732-855f-419db73e8c89",
  "connections": {
    "8ba87150-8d5d-4684-b91d-161e7e7d730a": {
      "main": [
        [
          {
            "node": "e7b6c39b-1b55-41c6-9626-6c18da2253fb",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "d4d5aceb-8065-415a-8bfe-7a9cb5df8bcd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2aaa0031-8189-47c1-8946-62068490e79e": {
      "main": [
        [
          {
            "node": "7650e708-bb75-4472-88b2-5bf6384f2369",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ba43343e-ac56-4cdb-9877-c3f23458df0f": {
      "main": [
        [
          {
            "node": "8ba87150-8d5d-4684-b91d-161e7e7d730a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d4d5aceb-8065-415a-8bfe-7a9cb5df8bcd": {
      "main": [
        [
          {
            "node": "019cddd8-29dd-46d1-9269-696ec3cef37a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fb65aa96-048d-4145-a7e7-499ecb81715f": {
      "main": [
        [
          {
            "node": "18d6447a-cb7a-49c6-9baa-4339c5601f8a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6d4b278b-39e4-431e-aeca-e9192b813faa": {
      "main": [
        [
          {
            "node": "fb65aa96-048d-4145-a7e7-499ecb81715f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "175955b0-d9ba-4c52-96ae-9c02763a6cd5": {
      "main": [
        [
          {
            "node": "6d4b278b-39e4-431e-aeca-e9192b813faa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "019cddd8-29dd-46d1-9269-696ec3cef37a": {
      "main": [
        [],
        [
          {
            "node": "dfa0ca22-4b60-4215-9f82-5fc0bc0d125d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7650e708-bb75-4472-88b2-5bf6384f2369": {
      "main": [
        [
          {
            "node": "019cddd8-29dd-46d1-9269-696ec3cef37a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "dfa0ca22-4b60-4215-9f82-5fc0bc0d125d": {
      "main": [
        [
          {
            "node": "ba43343e-ac56-4cdb-9877-c3f23458df0f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e7b6c39b-1b55-41c6-9626-6c18da2253fb": {
      "main": [
        [
          {
            "node": "175955b0-d9ba-4c52-96ae-9c02763a6cd5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "18d6447a-cb7a-49c6-9baa-4339c5601f8a": {
      "main": [
        [
          {
            "node": "019cddd8-29dd-46d1-9269-696ec3cef37a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
์ž์ฃผ ๋ฌป๋Š” ์งˆ๋ฌธ

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

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

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

๊ณ ๊ธ‰ - ์ฝ˜ํ…์ธ  ์ œ์ž‘, ๋ฉ€ํ‹ฐ๋ชจ๋‹ฌ AI

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

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

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

YouTube ๋น„๋””์˜ค ๊ธฐ๋ฐ˜ ์ž์œจ ๋ธ”๋กœ๊ทธ ๊ฒŒ์‹œ
ChatGPT, Sheets, Apify, Pexels, WordPress๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ YouTube ๋น„๋””์˜ค๋ฅผ ์ž๋™์œผ๋กœ ๋ธ”๋กœ๊ทธ์— ๊ฒŒ์‹œํ•ฉ๋‹ˆ๋‹ค.
If
Set
Code
+
If
Set
Code
80 ๋…ธ๋“œOriol Seguรญ
์ฝ˜ํ…์ธ  ์ œ์ž‘
Printify ์ž๋™ํ™” - ์ œ๋ชฉ ๋ฐ ์„ค๋ช… ์—…๋ฐ์ดํŠธ - AlexK1919
GPT-4o-mini๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ Printify์šฉ SEO ์ œํ’ˆ ์ œ๋ชฉ ๋ฐ ์„ค๋ช… ์ž๋™ ์ƒ์„ฑ
If
Set
Code
+
If
Set
Code
26 ๋…ธ๋“œAmit Mehta
์ฝ˜ํ…์ธ  ์ œ์ž‘
WordPress ๋ธ”๋กœ๊ทธ ์ž๋™ํ™” ํ”„๋กœํŽ˜์…”๋„ ์—๋””์…˜(์‹ฌ์ธต ์—ฐ๊ตฌ) v2.1 ๋งˆ์ผ“
GPT-4o, Perplexity AI ๋ฐ ๋‹ค๊ตญ์–ด ์ง€์›์„ ์‚ฌ์šฉํ•œ SEO ์ตœ์ ํ™” ๋ธ”๋กœ๊ทธ ์ƒ์„ฑ ์ž๋™ํ™”
If
Set
Xml
+
If
Set
Xml
125 ๋…ธ๋“œDaniel Ng
์ฝ˜ํ…์ธ  ์ œ์ž‘
ๆ‰น้‡ SEO ์ฝ˜ํ…์ธ  ์ƒ์„ฑ ๋ฐ AI ์ด๋ฏธ์ง€ ํฌํ•จ Webflow ๋“œ๋ž˜๊ทธ ์•ค ๋“œ๋กญ ์ƒ์„ฑ (ํ…œํ”Œ๋ฆฟ)
GPT, Gemini ์ด๋ฏธ์ง€, Webflow ๋“œ๋ผใƒ•ใƒˆ๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๋Œ€๋Ÿ‰ SEO ์ฝ˜ํ…์ธ  ์ƒ์„ฑ
If
Set
Code
+
If
Set
Code
54 ๋…ธ๋“œDahiana
์ฝ˜ํ…์ธ  ์ œ์ž‘
Replicate์™€ OpenAI๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์–ผ๊ตด ์—†๋Š” ๊ณตํฌ ๋‹จํŽธ ์ œ์ž‘
OpenAI TTS, Replicate ๋น„๋””์˜ค ์ƒ์„ฑ ๋ฐ YouTube ์—…๋กœ๋“œ๋กœ ์–ผ๊ตด ์—†๋Š” ๊ณตํฌ ๋‹จํŽธ ์ œ์ž‘
If
Code
Wait
+
If
Code
Wait
50 ๋…ธ๋“œDeb Mukherjee
์ฝ˜ํ…์ธ  ์ œ์ž‘
Gemini, Tavily ๋ฐ ์ธ๊ณตๅฎกๆ ธ์„ ์‚ฌ์šฉํ•˜์—ฌ SEO ์ตœ์ ํ™” WordPress ๋ธ”๋กœ๊ทธ ์ƒ์„ฑ
์‚ฌ์šฉGemini, Tavily, ์ธ๊ณตๅฎกๆ ธ์œผ๋กœ SEO ์ตœ์ ํ™”๋œ WordPress ๋ธ”๋กœ๊ทธ ์ƒ์„ฑ
If
Set
Code
+
If
Set
Code
38 ๋…ธ๋“œAryan Shinde
์ฝ˜ํ…์ธ  ์ œ์ž‘
์›Œํฌํ”Œ๋กœ์šฐ ์ •๋ณด
๋‚œ์ด๋„
๊ณ ๊ธ‰
๋…ธ๋“œ ์ˆ˜16
์นดํ…Œ๊ณ ๋ฆฌ2
๋…ธ๋“œ ์œ ํ˜•9
๋‚œ์ด๋„ ์„ค๋ช…

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

์ €์ž
Automation for you

Automation for you

@n8nforyou

Workflow Automation Expert specializing in n8n implementations that drive measurable efficiency gains. I design custom automations for marketing, sales, operations, and beyond - turning complex business processes into seamless, automated workflows. Let's connect to discuss your automation challenges and build solutions that scale.

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

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

์นดํ…Œ๊ณ ๋ฆฌ

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