Automate Subscription Info with Airtable & OpenAI

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 →

{
  "createdAt": "2024-11-17T13:21:28.565Z",
  "updatedAt": "2024-11-24T15:02:18.000Z",
  "id": "l2BVbME1lebOUA6x",
  "name": "\uccad\uc57d\uc815\ubcf4 \uc790\ub3d9\ud654",
  "active": false,
  "nodes": [
    {
      "parameters": {},
      "id": "e64bb1eb-dfe4-4563-897f-98dbaacf8832",
      "name": "When clicking \u2018Test workflow\u2019",
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [
        940,
        300
      ]
    },
    {
      "parameters": {
        "operation": "search",
        "base": {
          "__rl": true,
          "value": "appNmvI2WmKxPFhwx",
          "mode": "list",
          "cachedResultName": "\uccad\uc57d\uc815\ubcf4\uc870\ud68c",
          "cachedResultUrl": "https://airtable.com/appNmvI2WmKxPFhwx"
        },
        "table": {
          "__rl": true,
          "value": "tblJ5XJDuntv2830y",
          "mode": "list",
          "cachedResultName": "\uccad\uc57d\uc815\ubcf4_2024-11-10",
          "cachedResultUrl": "https://airtable.com/appNmvI2WmKxPFhwx/tblJ5XJDuntv2830y"
        },
        "filterByFormula": "=AND(\n    {\ud3ec\uc2a4\ud305\uc0c1\ud0dc} = '\ub300\uae30',\n    NOT({\uc8fc\ud0dd\uba85} = '')\n)",
        "options": {
          "fields": []
        }
      },
      "id": "3467ff2f-8524-49b8-a7aa-86fb4c5ce0ce",
      "name": "Airtable",
      "type": "n8n-nodes-base.airtable",
      "typeVersion": 2.1,
      "position": [
        1160,
        300
      ],
      "credentials": {
        "airtableTokenApi": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {},
      "id": "4e54fd0e-06c8-42eb-aba4-66292aa9e122",
      "name": "Limit",
      "type": "n8n-nodes-base.limit",
      "typeVersion": 1,
      "position": [
        1340,
        300
      ]
    },
    {
      "parameters": {
        "jsCode": "const item = items[0];\nconst caption = `\ud83c\udfe2 ${item.json.\uc8fc\ud0dd\uba85}\\n`+\n\n`\ud83d\udccd \uc704\uce58: ${item.json.\uacf5\uae09\uc704\uce58}\\n`+\n`\ud83c\udfd7\ufe0f \uc2dc\uacf5\uc0ac\uba85: \ub300\uc6b0\uac74\uc124\\n`+\n`\ud83d\udcb0 \uacf5\uae09\uaddc\ubaa8: ${item.json.\uacf5\uae09\uaddc\ubaa8}\uc138\ub300\\n`+\n\n`\ud83d\udcc5 \uccad\uc57d\uc77c\uc815\\n`+\n`\u25ab\ufe0f \ubaa8\uc9d1\uacf5\uace0\uc77c: ${item.json.\ubaa8\uc9d1\uacf5\uace0\uc77c}\\n`+\n`\u25ab\ufe0f \uccad\uc57d\uc811\uc218\uc2dc\uc791\uc77c: ${item.json.\uccad\uc57d\uc811\uc218\uc2dc\uc791\uc77c}\\n`+\n`\u25ab\ufe0f \uccad\uc57d\uc811\uc218\uc885\ub8cc\uc77c: ${item.json.\uccad\uc57d\uc811\uc218\uc885\ub8cc\uc77c}\\n`+\n\n`#\uccad\uc57d #\ubd80\ub3d9\uc0b0 #\uc2e0\ucd95\uc544\ud30c\ud2b8 #\ubd84\uc591\uc815\ubcf4`;\n\nitem.json.instagram_caption = caption;\nreturn [item];"
      },
      "id": "c6fa6f54-b57c-4aa6-96e8-022d3bd1c314",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        1940,
        300
      ]
    },
    {
      "parameters": {
        "url": "={{ $json.url }}",
        "options": {
          "response": {
            "response": {
              "responseFormat": "file"
            }
          }
        }
      },
      "id": "56691657-36cd-43d9-9cbd-58768e5a939e",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        1720,
        300
      ]
    },
    {
      "parameters": {
        "assignments": {
          "assignments": [
            {
              "id": "7fc18960-54f8-4ef1-aeb3-c438c5d93d61",
              "name": "",
              "value": "",
              "type": "string"
            }
          ]
        },
        "options": {}
      },
      "id": "678a828f-834e-4558-a961-aeb782cfdda1",
      "name": "Edit Fields",
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [
        2160,
        300
      ]
    },
    {
      "parameters": {
        "resource": "image",
        "prompt": "={{ $json['\uc8fc\ud0dd\uba85'] }} \uc5d0 \uc5b4\uc6b8\ub9ac\ub294 \ub300\ud55c\ubbfc\uad6d\uc758 \uac74\uc124\uc5c5\uccb4\uc758 \ube0c\ub79c\ub4dc\uc5d0 \uac78\ub9de\ub294 \uc544\ud30c\ud2b8 \uc678\uad00\uc744 \uadf8\ub9b0\ub2e4. ",
        "options": {
          "quality": "standard",
          "size": "1024x1024",
          "style": "vivid",
          "returnImageUrls": true
        }
      },
      "id": "235c468f-35c6-4ea3-8364-40f0ed4de14b",
      "name": "OpenAI",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "typeVersion": 1.6,
      "position": [
        1520,
        300
      ],
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      }
    }
  ],
  "connections": {
    "When clicking \u2018Test workflow\u2019": {
      "main": [
        [
          {
            "node": "Airtable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Airtable": {
      "main": [
        [
          {
            "node": "Limit",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Limit": {
      "main": [
        [
          {
            "node": "OpenAI",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  },
  "staticData": null,
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "versionId": "921a89a6-a862-401c-b1ee-a148789ce6e6",
  "triggerCount": 0,
  "tags": []
}

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.

• airtableTokenApi
• openAiApi

About this workflow

청약정보 자동화. Uses airtable, httpRequest, openAi. Event-driven trigger; 7 nodes.

Source: https://github.com/leoskyearth/repository_n8n/blob/146446f72d7dfd5b1fee14a51f6f5dd7dba533c3/workflows/l2BVbME1lebOUA6x.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.