3446

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "c3a9ba81-3a7e-4afe-be8b-cf482cbb88c2",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1040,
        -540
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 6
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "f63d035c-5a7b-4cf4-8730-5fa7dff6f94b",
      "name": "Get Subscribers",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        -860,
        -540
      ],
      "parameters": {
        "options": {},
        "resource": "worksheet",
        "workbook": {
          "__rl": true,
          "mode": "id",
          "value": "="
        },
        "operation": "readRows",
        "worksheet": {
          "__rl": true,
          "mode": "id",
          "value": "="
        }
      },
      "credentials": {
        "microsoftExcelOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "e93aa8de-5c68-4a01-ae60-beb141e0a430",
      "name": "Get Unique Categories",
      "type": "n8n-nodes-base.set",
      "position": [
        -400,
        -160
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "fe138128-50d5-469f-8c0b-0af8c873f198",
              "name": "categories",
              "type": "array",
              "value": "={{ $input.all().flatMap(item => item.json.categories).unique() }}"
            }
          ]
        }
      },
      "executeOnce": true,
      "typeVersion": 3.4
    },
    {
      "id": "a874ae4e-d67e-4019-9e5c-03ea677468ae",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        760,
        80
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "bc9c7578-3b6f-45fb-9f93-94637774d125",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1180,
        40
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "ae83c9e2-a267-463c-a606-b4d101f93f92",
      "name": "Collect Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        980,
        -60
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "4a266505-4b88-41cf-bf22-f38c705c27e5",
              "name": "workflow_id",
              "type": "number",
              "value": "={{ $('Workflows to Items').item.json.workflow.id }}"
            },
            {
              "id": "df3348e2-b6ec-4c38-a146-c38be9b830bc",
              "name": "workflow_name",
              "type": "string",
              "value": "={{ $('Workflows to Items').item.json.workflow.name }}"
            },
            {
              "id": "b4646059-748f-407a-b829-d6605d5ab683",
              "name": "workflow_desc",
              "type": "string",
              "value": "={{ $json.response.text }}"
            },
            {
              "id": "eac0d9ab-9445-4bc2-9e64-160fe44b9ace",
              "name": "workflow_created_at",
              "type": "string",
              "value": "={{ $('Workflows to Items').item.json.workflow.createdAt }}"
            },
            {
              "id": "24a3c0cb-224c-4ce6-b59e-38b10ab2c02f",
              "name": "author_id",
              "type": "number",
              "value": "={{ $('Workflows to Items').item.json.workflow.user.id }}"
            },
            {
              "id": "a2b8a52f-be72-484c-aa86-582b73be1859",
              "name": "author_name",
              "type": "string",
              "value": "={{ $('Workflows to Items').item.json.workflow.user.name }}"
            },
            {
              "id": "ae735511-8c7c-4bef-b6ac-cfe3d4b87b4f",
              "name": "author_username",
              "type": "string",
              "value": "={{ $('Workflows to Items').item.json.workflow.user.username }}"
            },
            {
              "id": "2dc1f59f-a854-4322-85df-c5998f782dcd",
              "name": "category",
              "type": "string",
              "value": "={{ $('For Each Category').item.json.category }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "8ca1ea7e-9098-4e82-919b-ba98ae7d7574",
      "name": "Categories to Items",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -220,
        -160
      ],
      "parameters": {
        "options": {
          "destinationFieldName": "category"
        },
        "fieldToSplitOut": "categories"
      },
      "typeVersion": 1
    },
    {
      "id": "eb6d74b8-f1ed-4ab2-8c5f-7e6c6361b055",
      "name": "For Each Category",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        320,
        -160
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "8640ffac-9df6-4154-bcd5-dfa90c3843d4",
      "name": "Workflows to Items",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        500,
        -60
      ],
      "parameters": {
        "options": {
          "destinationFieldName": "workflow"
        },
        "fieldToSplitOut": "workflows"
      },
      "typeVersion": 1
    },
    {
      "id": "4456a43b-df26-4bb8-a62d-b9f05eff4479",
      "name": "Workflow Summarizer",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        660,
        -60
      ],
      "parameters": {
        "text": "=## Description\n```\n{{ $json.workflow.description.replaceAll('#', '') }}\n```",
        "messages": {
          "messageValues": [
            {
              "message": "=You have received a description of a n8n template from the official template gallery. Your task is to summarize the description into one or two sentences. The summary should loosely follow the structure of:\n* identify the goal of the template\n* describe the method or approached implemented\n* highlight which important n8n nodes were used\n\neg. \"Obtain real-time crypto market insights using an AI-powered workflow with CoinMarketCap APIs through Telegram\""
            }
          ]
        },
        "promptType": "define"
      },
      "typeVersion": 1.5
    },
    {
      "id": "5f4a5921-c954-4523-8925-90401d8dbf22",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        660,
        -460
      ],
      "parameters": {
        "mode": "chooseBranch"
      },
      "typeVersion": 3.1
    },
    {
      "id": "f95fb28c-875c-4105-aa83-9fea257ea440",
      "name": "Fetch Latest 10 per Category",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -40,
        -160
      ],
      "parameters": {
        "url": "=https://n8n.io/api/product-api/workflows/search",
        "options": {},
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "category",
              "value": "={{$json.category }}"
            },
            {
              "name": "rows",
              "value": "10"
            },
            {
              "name": "sort",
              "value": "createdAt:desc"
            },
            {
              "name": "page",
              "value": "1"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "4dda6cbc-e53f-452d-b257-df9ef18abd75",
      "name": "No Operation, do nothing",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1560,
        -460
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "881337d8-3ca8-43d2-931f-9cfec16cc367",
      "name": "Get Relevant Workflows",
      "type": "n8n-nodes-base.set",
      "position": [
        1380,
        -280
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "fbd0ad94-e5aa-4082-81f5-d7b2e08dfbcf",
              "name": "workflows",
              "type": "array",
              "value": "={{\n$json.categories\n  .flatMap(cat =>\n    $('Flatten Workflows').first().json.workflows.filter(item => item.category === cat)\n  )\n}}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "b3ad0e26-e495-4dae-bfdd-f65961178acc",
      "name": "Flatten Workflows",
      "type": "n8n-nodes-base.set",
      "position": [
        500,
        -280
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "17a82dd9-3fcf-44d9-b5da-bf89a1f53d59",
              "name": "workflows",
              "type": "array",
              "value": "={{\n$input.all().flatMap(item => item.json.data)\n}}"
            }
          ]
        }
      },
      "executeOnce": true,
      "typeVersion": 3.4
    },
    {
      "id": "05f72731-f8b0-4d8f-ba78-66ef8fbaf059",
      "name": "Remove Already Seen",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        1740,
        -280
      ],
      "parameters": {
        "options": {},
        "operation": "removeItemsSeenInPreviousExecutions",
        "dedupeValue": "={{ $('For Each Subscriber').item.json.name.toSnakeCase() }}_{{ $json.workflow_id }}"
      },
      "typeVersion": 2
    },
    {
      "id": "3904d2a2-9a95-4e11-883e-b2e88c6a884f",
      "name": "Workflow to Items",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1560,
        -280
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "workflows"
      },
      "typeVersion": 1
    },
    {
      "id": "d416dee7-df0f-4579-a25f-6baed16453e8",
      "name": "Combine Workflows",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1920,
        -280
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "3797dd21-3144-47e8-9359-841b97073001",
      "name": "Has New Workflows?",
      "type": "n8n-nodes-base.if",
      "position": [
        1380,
        -600
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "08403b2a-4ae6-4cf5-aa88-cc49441e3c56",
              "operator": {
                "type": "array",
                "operation": "lengthGt",
                "rightType": "number"
              },
              "leftValue": "={{ $json.data }}",
              "rightValue": 0
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "0cd6ce35-c083-4db6-bc87-9d21e70a3bab",
      "name": "With User Reference",
      "type": "n8n-nodes-base.set",
      "position": [
        2100,
        -280
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "d69921eb-b518-4614-af63-e67a521ee373",
              "name": "name",
              "type": "string",
              "value": "={{ $('For Each Subscriber').item.json.name }}"
            },
            {
              "id": "01ee6e0a-9d03-42f6-ad46-68b9df861679",
              "name": "email",
              "type": "string",
              "value": "={{ $('For Each Subscriber').item.json.email }}"
            },
            {
              "id": "5263e512-1b24-43c8-9033-6547dab2811b",
              "name": "categories",
              "type": "array",
              "value": "={{ $('For Each Subscriber').item.json.categories }}"
            }
          ]
        },
        "includeOtherFields": true
      },
      "typeVersion": 3.4
    },
    {
      "id": "b3a616c7-615f-49ff-8e6f-530324a98be4",
      "name": "Generate HTML Template",
      "type": "n8n-nodes-base.html",
      "position": [
        1740,
        -720
      ],
      "parameters": {
        "html": "<h1>New Workflows for {{ $now.format('DD') }}</h1>\n{{\n$json.categories\n  .filter(cat =>\n    $json.data.filter(item => item.category === cat).length > 0\n  )\n  .map(category => `\n    <h2>${category.toSentenceCase()}</h2>\n    <ul>\n    ${$json.data\n      .filter(workflow => workflow.category === category)\n      .map(workflow => `\n      <li>\n        <a href=\"https://n8n.io/workflows/${workflow.workflow_id}\">\n          <h3>${workflow.workflow_name}</h3>\n        </a>\n        <p>\n          by\n          <a href=\"https://n8n.io/creators/${workflow.author_username}\">\n            ${workflow.author_name}\n          </a>\n          &middot;\n          created on ${DateTime.fromISO(workflow.workflow_created_at).toFormat('DD')}\n        </p>\n        <p>${workflow.workflow_desc}</p>\n      </li>\n    `).join('\\n')}\n    </ul>\n  `)\n  .join('\\n')\n}}"
      },
      "typeVersion": 1.2
    },
    {
      "id": "0c9865c7-9352-4fda-a943-34c8f524de6c",
      "name": "Parse Rows",
      "type": "n8n-nodes-base.set",
      "position": [
        -660,
        -540
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "d89dfc07-3c1f-4fbc-9a52-3748797a4840",
              "name": "name",
              "type": "string",
              "value": "={{ $json.name }}"
            },
            {
              "id": "c622ceca-2e6d-4bab-bb08-235f704c7e2f",
              "name": "email",
              "type": "string",
              "value": "={{ $json.email }}"
            },
            {
              "id": "9fca8e33-330a-4e4d-b461-251cd7e5c620",
              "name": "categories",
              "type": "array",
              "value": "={{ $json.categories.split(',') }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "f5fbd7f2-65e5-4dd7-8e43-38a8a99e3321",
      "name": "Send Daily Digest",
      "type": "n8n-nodes-base.microsoftOutlook",
      "position": [
        1920,
        -720
      ],
      "parameters": {
        "subject": "=New Workflows for {{ $now.format('DD') }}",
        "bodyContent": "={{\n$json.html\n  .replaceAll('\\n', '')\n  .replaceAll('  ', '')\n  .trim()\n}}",
        "toRecipients": "={{ $('Has New Workflows?').item.json.email }}",
        "additionalFields": {
          "from": "=no-reply <no-reply@example.com>",
          "replyTo": "=no-reply <no-reply@example.com>",
          "bodyContentType": "html"
        }
      },
      "credentials": {
        "microsoftOutlookOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "e81ba3a0-e3f6-4231-8870-8ef03edf41e1",
      "name": "Append Category",
      "type": "n8n-nodes-base.set",
      "position": [
        140,
        -160
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "b965dee8-f3b5-419b-b39a-79bf2b7d04c1",
              "name": "category",
              "type": "string",
              "value": "={{ $('Categories to Items').item.json.category }}"
            }
          ]
        },
        "includeOtherFields": true
      },
      "typeVersion": 3.4
    },
    {
      "id": "e1c2c743-a560-47e8-b906-a2e8fd17622f",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1060,
        -740
      ],
      "parameters": {
        "color": 7,
        "width": 440,
        "content": "## 1. Excel\uc5d0\uc11c \uad6c\ub3c5\uc790 \uac00\uc838\uc624\uae30\n\n[Excel \ub178\ub4dc\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uae30](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.microsoftexcel)\n\nExcel\uc740 \uac04\ub2e8\ud55c \uad6c\ub3c5\uc790 \ubaa9\ub85d\uc744 \uc800\uc7a5\ud558\ub294 \uc26c\uc6b4 \ubc29\ubc95\uc774 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub4e4\uc740 \uc6b0\ub9ac\uc758 \uc77c\uc77c \uc694\uc57d\uc744 \ubc1b\uc744 \uac83\uc785\ub2c8\ub2e4. \ub610\ud55c \uadf8\ub4e4\uc774 \uad00\uc2ec \uc788\ub294 \uce74\ud14c\uace0\ub9ac\ub9cc \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4."
      },
      "typeVersion": 1
    },
    {
      "id": "e10a23be-2af7-4b92-9b5f-df855e6ee349",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        -420
      ],
      "parameters": {
        "color": 7,
        "width": 620,
        "height": 220,
        "content": "## 2. n8n\uc5d0\uc11c \ucd5c\uc2e0 \ud15c\ud50c\ub9bf \uac00\uc838\uc624\uae30  \n[HTTP Request \ub178\ub4dc\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uae30](https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.httprequest)  \n\nHTTP \uc694\uccad \ub178\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec n8n.io \ud15c\ud50c\ub9bf \uac80\uc0c9 API\ub97c \ud638\ucd9c\ud558\uc5ec \ucd5c\uc2e0 \uac8c\uc2dc\ub41c \ud15c\ud50c\ub9bf\uc744 \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ub9ac\uc18c\uc2a4\ub97c \uc808\uc57d\ud558\uae30 \uc704\ud574, \uad6c\ub3c5\uc790\uc5d0\uac8c \uad00\ub828\ub41c \uce74\ud14c\uace0\ub9ac\uc5d0\uc11c\ub9cc \uac00\uc838\uc624\uace0 \uc2f6\uc2b5\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574:  \n1) \ubaa8\ub4e0 \uad6c\ub3c5\uc790\ub4e4 \uc0ac\uc774\uc758 \uace0\uc720 \uce74\ud14c\uace0\ub9ac\uc5d0\uc11c\ub9cc \ucd5c\uc2e0 \ud15c\ud50c\ub9bf\uc744 \uac00\uc838\uc624\uace0 \uc2f6\uc2b5\ub2c8\ub2e4  \n2) \uc774 \uac00\uc838\uc624\uae30\ub97c \ud55c \ubc88\ub9cc \uc218\ud589\ud558\uc5ec \ubaa8\ub4e0 \uad6c\ub3c5\uc790\ub97c \uc704\ud574 \ub098\uc911\uc5d0 \ucc38\uc870\ud569\ub2c8\ub2e4"
      },
      "typeVersion": 1
    },
    {
      "id": "0ee0b2ca-0247-4471-a6f5-920fd8e67f96",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        500,
        260
      ],
      "parameters": {
        "color": 7,
        "width": 580,
        "height": 180,
        "content": "## 3. \uac01 \ud15c\ud50c\ub9bf\uc5d0 \ub300\ud55c AI \uc694\uc57d \uc0dd\uc131\n\n[\uae30\ubcf8 LLM \ub178\ub4dc\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc77d\uae30](https://docs.n8n.io/integrations/builtin/cluster-nodes/root-nodes/n8n-nodes-langchain.chainllm)\n\n\uc774\uba54\uc77c \ub2e4\uc774\uc81c\uc2a4\ud2b8\ub97c \uad6c\ucd95\ud560 \ub54c, \uac01 \ud15c\ud50c\ub9bf\uc758 \uc124\uba85\uc744 \ub354 \uc9e7\uace0 \uc694\uc57d\ub41c \ubc84\uc804\uc73c\ub85c \ud574\uc11c \uc2a4\uce94\uacfc \uc77d\uae30\ub97c \uc27d\uac8c \ud558\uace0 \uc2f6\uc2b5\ub2c8\ub2e4. \uc774\ub97c AI\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub2ec\uc131\ud560 \uc218 \uc788\uc73c\uba70, \ud15c\ud50c\ub9bf \uac1d\uccb4\uc640 \ubcd1\ud569\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4."
      },
      "typeVersion": 1
    },
    {
      "id": "ab234694-2878-440b-aeb5-37573ebe517e",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1680,
        -60
      ],
      "parameters": {
        "color": 7,
        "width": 580,
        "height": 200,
        "content": "## 4. \uad6c\ub3c5\uc790\uc5d0 \ub300\ud55c \uad00\ub828 \ud15c\ud50c\ub9bf \ud544\ud130\ub9c1\n\n[Split Out \ub178\ub4dc\uc5d0 \ub300\ud574 \ub354 \uc77d\uae30](https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.splitout)\n\n\uac01 \uad6c\ub3c5\uc790\uc5d0 \ub300\ud574, \uc6b0\ub9ac\ub294 Excel \uc2dc\ud2b8\uc5d0 \uc815\uc758\ub41c \uad6c\ub3c5\uc790\uc640 \uad00\ub828\ub41c \uce74\ud14c\uace0\ub9ac\uc5d0 \ub530\ub77c \uc0c8\ub85c \uc218\uc9d1\ub41c n8n.io \ud15c\ud50c\ub9bf\uc744 \ud544\ud130\ub9c1\ud558\uace0 \uc2f6\uc2b5\ub2c8\ub2e4. \uc911\ubcf5 \ud15c\ud50c\ub9bf\uc744 \ucd94\uc801\ud558\uae30 \uc704\ud574 \"Remove duplicates\" \ub178\ub4dc\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4 - \ud15c\ud50c\ub9bf\uc774 \ud558\ub098 \uc774\uc0c1\uc758 \uce74\ud14c\uace0\ub9ac\ub97c \uac00\uc9c8 \uc218 \uc788\uace0 \ub450 \ubc88 \ub098\ud0c0\ub0a0 \uc218 \uc788\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4!"
      },
      "typeVersion": 1
    },
    {
      "id": "460a8b3d-c125-41c3-95c5-afdfe63c7561",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1740,
        -960
      ],
      "parameters": {
        "color": 7,
        "width": 580,
        "height": 200,
        "content": "## 5. \uc77c\uc77c \uc694\uc57d \uc0dd\uc131 \ubc0f Outlook\uc744 \ud1b5\ud574 \uc804\uc1a1\n\n[Outlook \ub178\ub4dc\uc5d0 \ub300\ud574 \ub354 \uc54c\uc544\ubcf4\uae30](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.microsoftoutlook)\n\n\ub9c8\uc9c0\ub9c9\uc73c\ub85c, HTML \ub178\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc6b0\ub9ac\uc758 \uc694\uc57d \ub0b4\uc6a9\uc744 \uad6c\uc131\ud558\uace0 \ud544\uc694\uc5d0 \ub530\ub77c \uad6c\ub3c5\uc790\ubcc4\ub85c \ub9de\ucda4\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7f0 \ub2e4\uc74c Outlook \ub178\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc694\uc57d\uc744 \uad6c\ub3c5\uc790\uc5d0\uac8c \uc804\uc1a1\ud569\ub2c8\ub2e4."
      },
      "typeVersion": 1
    },
    {
      "id": "c79a2775-6276-41df-a9f0-64017e88a8c7",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -500,
        0
      ],
      "parameters": {
        "color": 5,
        "width": 200,
        "height": 120,
        "content": "### \ud55c \ubc88 \uc2e4\ud589  \n\uc774 \ub178\ub4dc\ub294 \uac01 \uad6c\ub3c5\uc790\ub9c8\ub2e4 \uc2e4\ud589\ub418\ub294 \uac83\uc774 \uc544\ub2c8\ub77c \ud55c \ubc88\ub9cc \uc2e4\ud589\ub418\ub3c4\ub85d \uc124\uc815\ub418\uc5c8\uc2b5\ub2c8\ub2e4."
      },
      "typeVersion": 1
    },
    {
      "id": "5290822e-b63b-4b73-8511-6a12e2387656",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -940,
        -360
      ],
      "parameters": {
        "color": 5,
        "width": 280,
        "height": 120,
        "content": "### \uc5f4\n- \uc774\ub984 *(\ud14d\uc2a4\ud2b8)*\n- \uc774\uba54\uc77c *(\ud14d\uc2a4\ud2b8)*\n- \uce74\ud14c\uace0\ub9ac *(\ud14d\uc2a4\ud2b8, \uc27c\ud45c\ub85c \uad6c\ubd84\ub41c)*"
      },
      "typeVersion": 1
    },
    {
      "id": "56acbd11-7fa5-44b8-b031-fcdeb6e44839",
      "name": "For Each Subscriber",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1180,
        -460
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "6aef7efc-1bc7-4a1d-b0cb-459484b3d179",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1600,
        -1400
      ],
      "parameters": {
        "width": 500,
        "height": 1000,
        "content": "## \uc9c1\uc811 \ud574\ubcf4\uc138\uc694!\n### \uc774 n8n \ud15c\ud50c\ub9bf\uc740 \ub274\uc2a4\ub808\ud130(\"\uc77c\uc77c \uc694\uc57d\") \ubc30\uc1a1 \uc11c\ube44\uc2a4\ub97c \uad6c\ucd95\ud558\uba70, \uad6c\ub3c5\uc790\uac00 \uc815\uc758\ud55c \uc120\ud0dd \uce74\ud14c\uace0\ub9ac\uc758 \ucd5c\uc2e0 n8n.io \ud15c\ud50c\ub9bf\uc744 \uac00\uc838\uc640 \uc694\uc57d\ud569\ub2c8\ub2e4.\n\n\ub9e4\uc77c \ud55c \ubc88 \uc2e4\ud589\ub418\ub3c4\ub85d \uc608\uc57d\ub418\uc5b4 \uc788\uc73c\uba70, \uad6c\ub3c5\uc790\uc5d0\uac8c \uae54\ub054\ud558\uac8c \ud615\uc2dd\ud654\ub41c \uc774\uba54\uc77c\ub85c \uc9c1\uc811 \ub274\uc2a4\ub808\ud130\ub97c \ubcf4\ub0c5\ub2c8\ub2e4. \ub9e4\uc77c \ubc1c\ud45c\ub418\ub294 \ucd5c\uc2e0 \ud15c\ud50c\ub9bf\uc744 \ub530\ub77c\uc7a1\ub294 \ub370 \uc5b4\ub824\uc6c0\uc744 \uacaa\uace0 \uc788\ub2e4\uba74, \uc774 \uc6cc\ud06c\ud50c\ub85c\uc6b0\uac00 \uc2dc\uac04\uc744 \uc808\uc57d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4!\n\n### \uc791\ub3d9 \uc6d0\ub9ac\n* \uc608\uc57d\ub41c \ud2b8\ub9ac\uac70\uac00 Excel \ud1b5\ud569 \ubb38\uc11c\uc5d0\uc11c \uad6c\ub3c5\uc790 \ubaa9\ub85d(\uc774\uba54\uc77c\uacfc \uce74\ud14c\uace0\ub9ac \uc120\ud638\ub3c4)\uc744 \uac00\uc838\uc635\ub2c8\ub2e4.\n* \ubaa8\ub4e0 \uad6c\ub3c5\uc790 \uac04\uc758 \uace0\uc720 \uce74\ud14c\uace0\ub9ac\ub97c \ud655\uc778\ud558\uace0, \ub9ac\uc18c\uc2a4\ub97c \uc808\uc57d\ud558\uace0 API \ud638\ucd9c \uc218\ub97c \ucd5c\uc801\ud654\ud558\uae30 \uc704\ud574 \uc774 \uce74\ud14c\uace0\ub9ac\uc5d0\uc11c\ub9cc \ucd5c\uc2e0 n8n \uc6f9\uc0ac\uc774\ud2b8 \ud15c\ud50c\ub9bf\uc744 \uac00\uc838\uc635\ub2c8\ub2e4.\n* \uac00\uc838\uc628 \ud15c\ud50c\ub9bf\uc744 AI\ub97c \ud1b5\ud574 \uc694\uc57d\ud558\uc5ec \uc774\uba54\uc77c \ud615\uc2dd\uc5d0 \ub354 \uc801\ud569\ud55c \uc9e7\uc740 \uc124\uba85\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.\n* \uac01 \uad6c\ub3c5\uc790\uc5d0 \ub300\ud574 Excel\uc5d0 \uc815\uc758\ub41c \uce74\ud14c\uace0\ub9ac \uc120\ud638\ub3c4\uc640 \uad00\ub828\ub41c \ud15c\ud50c\ub9bf\ub9cc \ud544\ud130\ub9c1\ud558\uace0 \uc218\uc9d1\ud558\uba70, \uc911\ubcf5 \ud15c\ud50c\ub9bf\uc774\ub098 \uc774\uc804\uc5d0 \"\ubcf8 \uc801 \uc788\ub294\" \ud15c\ud50c\ub9bf\uc740 \uc81c\uc678\ud569\ub2c8\ub2e4.\n* HTML \ub178\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc774\uba54\uc77c \ub274\uc2a4\ub808\ud130\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. HTML \uc774\uba54\uc77c\uc740 \ud15c\ud50c\ub9bf\uc73c\ub85c\uc758 \ub9c1\ud06c\ub97c \ucd94\uac00\ud560 \uc218 \uc788\uc5b4 \uc644\ubcbd\ud55c \ud615\uc2dd\uc785\ub2c8\ub2e4.\n* \ub9c8\uc9c0\ub9c9\uc73c\ub85c, Outlook \ub178\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uad6c\ub3c5\uc790\uc5d0\uac8c \uc774\uba54\uc77c \uc694\uc57d\uc744 \ubcf4\ub0c5\ub2c8\ub2e4.\n\n### \uc0ac\uc6a9 \ubc29\ubc95\n* Excel \uc2dc\ud2b8\uc5d0 3\uac1c\uc758 \uc5f4\uc744 \ucc44\uc6b0\uc138\uc694: \uc774\ub984, \uc774\uba54\uc77c \ubc0f \uce74\ud14c\uace0\ub9ac. \uce74\ud14c\uace0\ub9ac\ub294 n8n \ud15c\ud50c\ub9bf \uc6f9\uc0ac\uc774\ud2b8\uc640 \uc77c\uce58\ud558\ub294 \uc27c\ud45c\ub85c \uad6c\ubd84\ub41c \ubaa9\ub85d\uc785\ub2c8\ub2e4. \uc0ac\uc6a9 \uac00\ub2a5\ud55c \uce74\ud14c\uace0\ub9ac\ub294 AI, SecOps, Sales, IT Ops, Marketing, Engineering, DevOps, Building Blocks, Design, Finance, HR, Other, Product \ubc0f Support\uc785\ub2c8\ub2e4.\n* \uc0c8 \uc0ac\uc6a9\uc790\ub97c \uad6c\ub3c5\ud558\ub824\uba74, \uc801\uc5b4\ub3c4 \ud558\ub098\uc758 \uce74\ud14c\uace0\ub9ac\ub97c \ud3ec\ud568\ud558\uc5ec Excel \uc2dc\ud2b8\uc5d0 \uadf8\ub4e4\uc758 \uc774\uba54\uc77c\uc744 \ucd94\uac00\ud558\uc138\uc694.\n* \uc0ac\uc6a9\uc790\ub97c \uad6c\ub3c5 \ucde8\uc18c\ud558\ub824\uba74, \uc2dc\ud2b8\uc5d0\uc11c \uc81c\uac70\ud558\uc138\uc694.\n* \uc720\ub8cc \ud15c\ud50c\ub9bf\uc5d0 \uad00\uc2ec\uc774 \uc5c6\ub2e4\uba74, \uac00\uc838\uc628 \ud6c4 \ud544\ud130\ub9c1\ud558\uc138\uc694.\n\n### \ub3c4\uc6c0\uc774 \ud544\uc694\ud558\uc138\uc694?\n[Discord](https://discord.com/invite/XPKeKXeB7d) \ub610\ub294 [Forum](https://community.n8n.io/)\uc5d0 \ucc38\uc5ec\ud558\uc138\uc694!"
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "For Each Subscriber",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate": {
      "main": [
        [
          {
            "node": "For Each Category",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse Rows": {
      "main": [
        [
          {
            "node": "Get Unique Categories",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Collect Fields": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append Category": {
      "main": [
        [
          {
            "node": "For Each Category",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Subscribers": {
      "main": [
        [
          {
            "node": "Parse Rows",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get Subscribers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Combine Workflows": {
      "main": [
        [
          {
            "node": "With User Reference",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Flatten Workflows": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "For Each Category": {
      "main": [
        [
          {
            "node": "Flatten Workflows",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Workflows to Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Workflow Summarizer",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Workflow to Items": {
      "main": [
        [
          {
            "node": "Remove Already Seen",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Has New Workflows?": {
      "main": [
        [
          {
            "node": "Generate HTML Template",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Workflows to Items": {
      "main": [
        [
          {
            "node": "Workflow Summarizer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Categories to Items": {
      "main": [
        [
          {
            "node": "Fetch Latest 10 per Category",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "For Each Subscriber": {
      "main": [
        [
          {
            "node": "Has New Workflows?",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Get Relevant Workflows",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Remove Already Seen": {
      "main": [
        [
          {
            "node": "Combine Workflows",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "With User Reference": {
      "main": [
        [
          {
            "node": "For Each Subscriber",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Workflow Summarizer": {
      "main": [
        [
          {
            "node": "Collect Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Unique Categories": {
      "main": [
        [
          {
            "node": "Categories to Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate HTML Template": {
      "main": [
        [
          {
            "node": "Send Daily Digest",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Relevant Workflows": {
      "main": [
        [
          {
            "node": "Workflow to Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Latest 10 per Category": {
      "main": [
        [
          {
            "node": "Append Category",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• microsoftExcelOAuth2Api
• microsoftOutlookOAuth2Api
• openAiApi

About this workflow

3446. Uses microsoftExcel, lmChatOpenAi, chainLlm, httpRequest. Scheduled trigger; 33 nodes.

Source: https://github.com/n8nKOR/n8n-shared-workflow/blob/62a671327e906c22a40d290b339ff6d2373f8d75/workflows/n8nworkflows/ai/3446.json — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.