Créer des projets de tableau de bord Monday.com à partir des soumissions Jotform (avec mappage de champs)

• •Aucun prérequis spécial, prêt à l'emploi après importation

{
  "meta": {
    "instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "99d58716-909f-4bdd-87e2-7480df396fdf",
      "name": "Note adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1136,
        3120
      ],
      "parameters": {
        "color": 7,
        "width": 1248,
        "height": 1056,
        "content": "### Add Jotform submissions to a Monday.com board (Jotform Trigger → Monday.com Create Item)\n\nCapture new Jotform submissions and instantly create items on a Monday.com board with mapped columns (email, dates, dropdowns, instructions, etc.). Great for routing **leads**, **requests**, or **intake forms** straight into your team’s Monday pipeline.\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "01bb1db3-bb09-4216-8675-f78cef29c008",
      "name": "Note adhésive11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1568,
        3120
      ],
      "parameters": {
        "width": 400,
        "height": 1056,
        "content": "## 🛠️ Setup — Monday.com\n1. In Monday.com, **generate an API token** (Admin/Developers → API).  \n2. In **n8n → Credentials → New → Monday.com**, paste your **API token**.  \n3. Identify and set:\n   - **Board ID** (from your board URL or via node “List” operations)  \n   - **Group ID** (e.g., `topics`)  \n   - **Column IDs** that match your board (examples used by this workflow):  \n     - `text_mkvdj8v3` → Email (Text)  \n     - `date_mkvdg4aa` → Start Date (Date)  \n     - `dropdown_mkvdjwra` → Engagement Type (Dropdown)  \n     - `dropdown_mkvdd9v3` → Campaign Type (Dropdown)  \n     - `text_mkvd2md9` → Campaign Type (as Text label)  \n     - `text_mkvd1bj2` → Instructions (Text)  \n     - `text_mkvd5w3y` → Domain (Text)  \n4. Update the **label → ID mappings** inside the Monday.com node if your dropdown IDs differ (e.g., `Engagement A` → `1`, `Engagement B` → `2`).\n\n---\n## 📬 Contact  \nNeed help customizing this (e.g., more fields, file uploads, or multi-board routing)?  \n\n- 📧 **rbreen@ynteractive.com**  \n- 🔗 **Robert Breen** — https://www.linkedin.com/in/robert-breen-29429625/  \n- 🌐 **ynteractive.com** — https://ynteractive.com\n"
      },
      "typeVersion": 1
    },
    {
      "id": "2f3b5571-3cc8-4149-8e5a-bdb7129a9d14",
      "name": "Formulaire Jotform",
      "type": "n8n-nodes-base.jotFormTrigger",
      "position": [
        -848,
        3712
      ],
      "webhookId": "f4f6a2ed-a098-43e1-aa9e-eb6a44b34028",
      "parameters": {
        "form": "252445218058053"
      },
      "typeVersion": 1
    },
    {
      "id": "2e25b2de-0fe1-414a-baec-c62c1d760f5a",
      "name": "Publication Monday.com",
      "type": "n8n-nodes-base.mondayCom",
      "position": [
        -432,
        3872
      ],
      "parameters": {
        "name": "={{ $json.Name.first }} {{ $json.Name.last }}",
        "boardId": "9954397625",
        "groupId": "topics",
        "resource": "boardItem",
        "additionalFields": {
          "columnValues": "={{ (()=>{\n  const out = {};\n\n  // Email (Text)\n  out.text_mkvdj8v3 = $json.Email || \"\";\n\n  // Start Date (Date -> YYYY-MM-DD)\n  if ($json['Start Date']) {\n    const y = String($json['Start Date'].year || '');\n    const m = String($json['Start Date'].month || '').padStart(2,'0');\n    const d = String($json['Start Date'].day || '').padStart(2,'0');\n    out.date_mkvdg4aa = { date: (y && m && d) ? `${y}-${m}-${d}` : '' };\n  }\n\n  // Engagement Type (Dropdown) – map label -> ID\n  const engMap = { \"Engagement A\": 1, \"Engagement B\": 2 };\n  const eng = $json['Engagement Type'];\n  if (eng && engMap[eng]) {\n    out.dropdown_mkvdjwra = { ids: [ engMap[eng] ] };\n  }\n\n  // Campaign Type (Dropdown) – map label -> ID\n  const campMap = { \"Campaign A\": 1, \"Campaign B\": 2 };\n  const camp = $json['Campaign Type'];\n  if (camp && campMap[camp]) {\n    out.dropdown_mkvdd9v3 = { ids: [ campMap[camp] ] };\n  }\n\n  // Campaign Type (Text) – store label too\n  out.text_mkvd2md9 = $json['Campaign Type'] || \"\";\n\n  // Instructions on posting (Text)\n  out.text_mkvd1bj2 = $json.Instructions || \"\";\n\n  // Domain (Text) – derived from Email\n  out.text_mkvd5w3y = ($json.Email && $json.Email.includes(\"@\"))\n    ? $json.Email.split(\"@\")[1]\n    : \"\";\n\n  return JSON.stringify(out);\n})() }}\n"
        }
      },
      "credentials": {
        "mondayComApi": {
          "id": "swmFzbI2ZRBZwzn5",
          "name": "Monday.com account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "0fb77582-44ea-47c4-b653-32d4baaa5289",
      "name": "Note adhésive64",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -912,
        3312
      ],
      "parameters": {
        "color": 3,
        "width": 224,
        "height": 544,
        "content": "## 🛠️ Setup — Jotform (simple)\n1. **Add your Jotform API key** (Jotform Account → Settings → API → Create Key).  \n2. **Create your form template** in Jotform (use fields like Name, Email, Start Date, Engagement Type, Campaign Type, Instructions).  \n3. In **n8n**, open the **Jotform Trigger** node and **choose your Jotform template/form** from the dropdown. That’s it.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "19d12eff-5762-4b2a-ac2f-62c3dfeb6c11",
      "name": "Note adhésive65",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -576,
        3232
      ],
      "parameters": {
        "color": 3,
        "width": 432,
        "height": 848,
        "content": "## 🛠️ Setup — Monday.com\n1. Go to **https://monday.com** → profile menu → **Admin / Developers** → **API** and **generate a personal API token** (or use an existing token with the correct permissions).  \n2. In n8n, create a new **Monday.com** credential and paste your **API token**.  \n3. Identify your **Board ID** and **Group ID**:\n   - Open your board in a browser; the URL often contains the board ID.  \n   - Group IDs can be read via the Monday.com node (e.g., “List” operations) or from the UI if available.  \n4. Confirm column IDs on your board. Common examples used by this template (you can map to your own):  \n   - `text_mkvdj8v3` → Email (Text)  \n   - `date_mkvdg4aa` → Start Date (Date)  \n   - `dropdown_mkvdjwra` → Engagement Type (Dropdown)  \n   - `dropdown_mkvdd9v3` → Campaign Type (Dropdown)  \n   - `text_mkvd2md9` → Campaign Type (Label as Text)  \n   - `text_mkvd1bj2` → Instructions (Text)  \n   - `text_mkvd5w3y` → Domain (Text)  \n5. Update the **label→ID mappings** in the Monday.com node if your dropdown IDs differ:  \n   - Example mapping in the JSON:  \n     - `Engagement A` → `1`, `Engagement B` → `2`  \n     - `Campaign A` → `1`, `Campaign B` → `2`  \n   Replace these with the actual IDs from your board’s dropdown columns.\n"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {
    "Jotform Form": [
      {
        "Name": {
          "last": "Breen",
          "first": "Robert"
        },
        "Email": "Robert.j.breen@gmail.com2",
        "Start Date": {
          "day": "03",
          "year": "2025",
          "month": "09"
        },
        "Instructions": "testing this",
        "Campaign Type": "Campaign B",
        "Engagement Type": "Engagement A"
      }
    ]
  },
  "connections": {
    "2f3b5571-3cc8-4149-8e5a-bdb7129a9d14": {
      "main": [
        [
          {
            "node": "2e25b2de-0fe1-414a-baec-c62c1d760f5a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}