AutomationFlowsData & Sheets › Workflow 05

Workflow 05

WorkFlow 05. Uses notion, httpRequest. Scheduled trigger; 44 nodes.

Cron / scheduled trigger★★★★★ complexity44 nodesNotionHTTP Request
Data & Sheets Trigger: Cron / scheduled Nodes: 44 Complexity: ★★★★★ Added:

This workflow follows the HTTP Request → Notion recipe pattern — see all workflows that pair these two integrations.

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 →

Download .json
{
  "name": "WorkFlow 05",
  "nodes": [
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "months",
              "triggerAtHour": 4
            }
          ]
        }
      },
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1.2,
      "position": [
        -1792,
        64
      ],
      "id": "6e430061-c26c-4c3b-9842-eabe29026276",
      "name": "Schedule Trigger"
    },
    {
      "parameters": {
        "values": {
          "string": [
            {
              "name": "_log.workflow",
              "value": "={{$workflow.name}}"
            },
            {
              "name": "_log.executionId",
              "value": "={{$execution.id}}"
            }
          ]
        },
        "options": {}
      },
      "id": "927634ca-82b4-4c5d-9e1f-2214e06f4835",
      "name": "Log Meta (expressions)",
      "type": "n8n-nodes-base.set",
      "typeVersion": 1,
      "position": [
        -1600,
        64
      ]
    },
    {
      "parameters": {
        "functionCode": "return items.map(i => {\n  const startedAt = new Date().toISOString();\n  i.json._log = {\n    runId: startedAt,\n    workflow: i.json._log?.workflow || null,\n    executionId: i.json._log?.executionId || null,\n    startedAt,\n    ok: 0,\n    ko: 0,\n    actions: [],\n    failedNodes: {}\n  };\n  return i;\n});"
      },
      "id": "33e5550a-c554-499f-a97d-a00196b8038d",
      "name": "Start Log",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        -1408,
        64
      ]
    },
    {
      "parameters": {
        "functionCode": "return items.map(i => {\n  const log = i.json._log || {};\n  \n  // LIGNE 5 CORRIG\u00c9E\n  const nodeName = i.json._lastNode || 'UnknownNode';\n  \n  const failed = !!i.json._hadError || !!i.json.error;\n  \n  // Message adaptatif\n  const msg = i.json.error?.message || \n              i.json._errMsg || \n              (failed ? 'Erreur d\u00e9tect\u00e9e' : 'Succ\u00e8s');\n  \n  (log.actions ||= []).push({ node: nodeName, ok: !failed, msg });\n  \n  if (failed) {\n    log.ko = (log.ko || 0) + 1;\n    log.failedNodes = log.failedNodes || {};\n    log.failedNodes[nodeName] = true;\n  } else {\n    log.ok = (log.ok || 0) + 1;\n  }\n  \n  i.json._log = log;\n  return i;\n});"
      },
      "id": "70162d56-91ce-41df-9f0f-3b4948eb443d",
      "name": "Update Log1",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        2320,
        576
      ]
    },
    {
      "parameters": {
        "values": {
          "string": [
            {
              "name": "_lastNode",
              "value": "={{ ($workflow.name || 'Unknown Workflow') + \" - \" + ($json._log?.actions?.find(action => !action.ok)?.node || Object.keys($json._log?.failedNodes || {})[0] || 'UnknownNode') }}"
            },
            {
              "name": "_hadError",
              "value": "={{ $json.error !== undefined }}"
            },
            {
              "name": "_errMsg",
              "value": "={{ $json.error?.message || ''}}"
            }
          ]
        },
        "options": {}
      },
      "id": "66eb22dd-9ab5-4f8d-93ce-5efd72d4db30",
      "name": "Log Snapshot",
      "type": "n8n-nodes-base.set",
      "typeVersion": 1,
      "position": [
        -1136,
        576
      ]
    },
    {
      "parameters": {
        "resource": "databasePage",
        "operation": "getAll",
        "databaseId": {
          "__rl": true,
          "value": "{{NOTION_DB_ID_MASTER_TACHES}}",
          "mode": "list",
          "cachedResultName": "Master T\u00e2ches",
          "cachedResultUrl": "https://www.notion.so/{{NOTION_DB_ID_MASTER_TACHES}}"
        },
        "returnAll": true,
        "simple": false,
        "filterType": "manual",
        "filters": {
          "conditions": [
            {
              "key": "\u00c9tat|status",
              "condition": "equals",
              "statusValue": "Termin\u00e9"
            },
            {
              "key": "\u00c9tat|status",
              "condition": "equals",
              "statusValue": "\u00c9chec"
            },
            {
              "key": "\u00c9tat|status",
              "condition": "equals",
              "statusValue": "Annul\u00e9"
            }
          ]
        },
        "options": {}
      },
      "type": "n8n-nodes-base.notion",
      "typeVersion": 2.2,
      "position": [
        -1136,
        64
      ],
      "id": "b432622e-9a0c-4e23-a24a-ed6b9d892561",
      "name": "Get Master T\u00e2che",
      "executeOnce": true,
      "credentials": {
        "notionApi": {
          "name": "<your credential>"
        }
      },
      "onError": "continueErrorOutput"
    },
    {
      "parameters": {
        "assignments": {
          "assignments": [
            {
              "id": "efae6215-ab89-425a-be05-e377416c3bb8",
              "name": "ResponsableID",
              "value": "={{ $json.properties.Responsable.relation[0].id }}",
              "type": "string"
            },
            {
              "id": "350d8ae7-7078-40fc-bf58-cf006e807378",
              "name": "D\u00e9partementID",
              "value": "={{ $json.properties[\"D\u00e9partements\"].relation[0].id }}",
              "type": "string"
            },
            {
              "id": "063beaa0-1f64-43f0-8676-1c14d881023c",
              "name": "\u00c9quipeID",
              "value": "={{(() => {\n  const rel = $json.properties[\"\u00c9quipe\"].relation;\n  if (Array.isArray(rel) && rel.length > 0) {\n    return rel.map(item => item.id).join(', '); // Tous les IDs s\u00e9par\u00e9s par virgule\n  }\n  return null;\n})()}}",
              "type": "string"
            },
            {
              "id": "3e435e3b-00f2-41b0-865a-e5535bc00dfe",
              "name": "\u00c9tat",
              "value": "={{ $json.properties[\"\u00c9tat\"].status.name }}",
              "type": "string"
            },
            {
              "id": "18caa5f9-35be-425c-ad60-050606ee3716",
              "name": "Date de planification",
              "value": "={{ $json.properties[\"Date de planification\"] }}",
              "type": "object"
            },
            {
              "id": "9140d778-4e06-4017-b845-a2fd25e2b4c2",
              "name": "Date compl\u00e9t\u00e9",
              "value": "={{ $json.properties[\"Date compl\u00e9t\u00e9\"] }}",
              "type": "object"
            },
            {
              "id": "ad7f458b-46b6-4cbc-940c-98a77fb0973d",
              "name": "Date de cr\u00e9eation",
              "value": "={{ $json.properties[\"Date de cr\u00e9eation\"] }}",
              "type": "object"
            },
            {
              "id": "9e9d0e1f-678d-45a6-a289-384870d62f0d",
              "name": "Dead line",
              "value": "={{ $json.properties['Dead line'] }}",
              "type": "object"
            },
            {
              "id": "77d7e6fa-0896-4571-81a3-6a4f46f2c5a5",
              "name": "Types de tache",
              "value": "={{ $json.properties[\"Types de tache\"].relation[0].id }}",
              "type": "string"
            },
            {
              "id": "389e5fa5-363b-43c0-8a20-b64ef1129e51",
              "name": "T\u00e2cheid",
              "value": "={{ $json.id }}",
              "type": "string"
            },
            {
              "id": "097f5cd9-6657-47df-bf12-4f678127b7b8",
              "name": "property_r_f_rence_n8n",
              "value": "={{ $json.properties[\"*R\u00e9f\u00e9rence n8n*\"].rich_text[0].text.content }}",
              "type": "string"
            },
            {
              "id": "401cdbfd-48ff-4302-a374-33251e4e4fcb",
              "name": "Verification",
              "value": "={{ $json.properties.Verification.verification.state }}",
              "type": "string"
            },
            {
              "id": "e9baf552-1d5b-4ec3-890d-abedb46b58f6",
              "name": "Approbateur",
              "value": "={{ $json.properties.Approbateur.people[0].name }}",
              "type": "string"
            }
          ]
        },
        "options": {}
      },
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [
        -912,
        64
      ],
      "id": "b8f1fac3-c6ee-4ff9-853d-2bd165e1946c",
      "name": "Edit Master T\u00e2che",
      "notesInFlow": false,
      "onError": "continueRegularOutput"
    },
    {
      "parameters": {
        "conditions": {
          "options": {
            "caseSensitive": true,
            "leftValue": "",
            "typeValidation": "strict",
            "version": 2
          },
          "conditions": [
            {
              "id": "e67ae3b0-afc9-4d0b-9947-7adde1350480",
              "leftValue": "={{ (() => {\n  const dateField = new Date($json[\"Date compl\u00e9t\u00e9\"].date.start); // ta propri\u00e9t\u00e9 de base\n  dateField.setDate(dateField.getDate() + 30);     // +30 jours\n  return new Date() > dateField;                   // true si now est apr\u00e8s\n})() }}",
              "rightValue": "=",
              "operator": {
                "type": "boolean",
                "operation": "true",
                "singleValue": true
              }
            }
          ],
          "combinator": "or"
        },
        "options": {}
      },
      "type": "n8n-nodes-base.if",
      "typeVersion": 2.2,
      "position": [
        -496,
        64
      ],
      "id": "e4febe6e-ef86-48ec-a758-80a0c5d0c2d2",
      "name": "If"
    },
    {
      "parameters": {
        "rules": {
          "values": [
            {
              "conditions": {
                "options": {
                  "caseSensitive": true,
                  "leftValue": "",
                  "typeValidation": "strict",
                  "version": 2
                },
                "conditions": [
                  {
                    "id": "0307d5cd-263c-453f-a879-5d5410e60ba8",
                    "leftValue": "={{ $json[\"Nom de t\u00e2che\"] }}",
                    "rightValue": "Qualit\u00e9",
                    "operator": {
                      "type": "string",
                      "operation": "equals",
                      "name": "filter.operator.equals"
                    }
                  }
                ],
                "combinator": "and"
              },
              "renameOutput": true,
              "outputKey": "Qualit\u00e9"
            },
            {
              "conditions": {
                "options": {
                  "caseSensitive": true,
                  "leftValue": "",
                  "typeValidation": "strict",
                  "version": 2
                },
                "conditions": [
                  {
                    "id": "a1ab2e96-53c4-41de-a086-e62725abd6a4",
                    "leftValue": "={{ $json[\"Type de t\u00e2che\"] }}",
                    "rightValue": "V\u00e9rification Certificat",
                    "operator": {
                      "type": "string",
                      "operation": "equals",
                      "name": "filter.operator.equals"
                    }
                  }
                ],
                "combinator": "and"
              },
              "renameOutput": true,
              "outputKey": "Certificat"
            },
            {
              "conditions": {
                "options": {
                  "caseSensitive": true,
                  "leftValue": "",
                  "typeValidation": "strict",
                  "version": 2
                },
                "conditions": [
                  {
                    "id": "1fb81719-bddc-4e51-b762-dc96e05bf310",
                    "leftValue": "={{ $json[\"Type de t\u00e2che\"] }}",
                    "rightValue": "Maintenance Pr\u00e9ventive",
                    "operator": {
                      "type": "string",
                      "operation": "equals",
                      "name": "filter.operator.equals"
                    }
                  }
                ],
                "combinator": "and"
              },
              "renameOutput": true,
              "outputKey": "Maintenance1"
            },
            {
              "conditions": {
                "options": {
                  "caseSensitive": true,
                  "leftValue": "",
                  "typeValidation": "strict",
                  "version": 2
                },
                "conditions": [
                  {
                    "id": "e3714a31-2328-413d-91ae-ec9ae629beb7",
                    "leftValue": "={{ $json[\"Type de t\u00e2che\"] }}",
                    "rightValue": "Maintenance Curative",
                    "operator": {
                      "type": "string",
                      "operation": "equals",
                      "name": "filter.operator.equals"
                    }
                  }
                ],
                "combinator": "and"
              },
              "renameOutput": true,
              "outputKey": "Maintenance2"
            },
            {
              "conditions": {
                "options": {
                  "caseSensitive": true,
                  "leftValue": "",
                  "typeValidation": "strict",
                  "version": 2
                },
                "conditions": [
                  {
                    "leftValue": "={{ $json[\"Nom de t\u00e2che\"] }}",
                    "rightValue": "Calibration",
                    "operator": {
                      "type": "string",
                      "operation": "equals"
                    },
                    "id": "687b7303-4005-4fd2-bf91-5810fc218085"
                  }
                ],
                "combinator": "and"
              },
              "renameOutput": true,
              "outputKey": "Calibration"
            },
            {
              "conditions": {
                "options": {
                  "caseSensitive": true,
                  "leftValue": "",
                  "typeValidation": "strict",
                  "version": 2
                },
                "conditions": [
                  {
                    "id": "9fad257b-139a-44be-9441-64f4876c8bb2",
                    "leftValue": "={{ $json[\"Type de t\u00e2che\"] }}",
                    "rightValue": "V\u00e9rification \u00c9tallonage",
                    "operator": {
                      "type": "string",
                      "operation": "equals",
                      "name": "filter.operator.equals"
                    }
                  }
                ],
                "combinator": "and"
              },
              "renameOutput": true,
              "outputKey": "V\u00e9rification"
            },
            {
              "conditions": {
                "options": {
                  "caseSensitive": true,
                  "leftValue": "",
                  "typeValidation": "strict",
                  "version": 2
                },
                "conditions": [
                  {
                    "id": "fd600414-3ea7-4d7d-9a37-51898333b3f1",
                    "leftValue": "={{ $json[\"Type de t\u00e2che\"] }}",
                    "rightValue": "Contr\u00f4le D\u00e9viation",
                    "operator": {
                      "type": "string",
                      "operation": "equals",
                      "name": "filter.operator.equals"
                    }
                  }
                ],
                "combinator": "and"
              },
              "renameOutput": true,
              "outputKey": "D\u00e9viation"
            },
            {
              "conditions": {
                "options": {
                  "caseSensitive": true,
                  "leftValue": "",
                  "typeValidation": "strict",
                  "version": 2
                },
                "conditions": [
                  {
                    "id": "e1781591-2fca-4124-bbe6-3948e757e2c2",
                    "leftValue": "={{ $json[\"Nom de t\u00e2che\"] }}",
                    "rightValue": "T\u00e2che",
                    "operator": {
                      "type": "string",
                      "operation": "equals",
                      "name": "filter.operator.equals"
                    }
                  }
                ],
                "combinator": "and"
              },
              "renameOutput": true,
              "outputKey": "T\u00e2che basique"
            }
          ]
        },
        "options": {
          "fallbackOutput": "extra",
          "allMatchingOutputs": false
        }
      },
      "type": "n8n-nodes-base.switch",
      "typeVersion": 3.2,
      "position": [
        800,
        -64
      ],
      "id": "b9f6ac81-8aad-48ca-8456-6468253afe87",
      "name": "Switch",
      "retryOnFail": true
    },
    {
      "parameters": {
        "assignments": {
          "assignments": [
            {
              "id": "350d8ae7-7078-40fc-bf58-cf006e807378",
              "name": "T\u00e2che",
              "value": "={{ $('Code').item.json.parsed_data.nom_tache }}",
              "type": "string"
            },
            {
              "id": "3e435e3b-00f2-41b0-865a-e5535bc00dfe",
              "name": "\u00c9tat",
              "value": "={{ $('Edit Master T\u00e2che').item.json[\"\u00c9tat\"] }}",
              "type": "string"
            },
            {
              "id": "18caa5f9-35be-425c-ad60-050606ee3716",
              "name": "Date de planification",
              "value": "={{ $('Code').item.json.property_date_de_planification }}",
              "type": "object"
            },
            {
              "id": "9140d778-4e06-4017-b845-a2fd25e2b4c2",
              "name": "Date compl\u00e9t\u00e9",
              "value": "={{ $('Code').item.json[\"Date compl\u00e9t\u00e9\"] }}",
              "type": "object"
            },
            {
              "id": "ad7f458b-46b6-4cbc-940c-98a77fb0973d",
              "name": "Date de cr\u00e9eation",
              "value": "={{ $('Code').item.json[\"Dead line\"] }}",
              "type": "object"
            },
            {
              "id": "9e9d0e1f-678d-45a6-a289-384870d62f0d",
              "name": "Dead line",
              "value": "={{ $('Edit Master T\u00e2che').item.json[\"Dead line\"] }}",
              "type": "object"
            },
            {
              "id": "bc8e9ac0-f529-4707-bdef-c490a9d701cc",
              "name": "Nom de t\u00e2che",
              "value": "={{ $('Code').item.json.parsed_data.nom_tache }}",
              "type": "string"
            },
            {
              "id": "ee1623dd-05f6-4625-92cd-d025affffed7",
              "name": "Base m\u00e8re",
              "value": "={{ $('Code').item.json.parsed_data.id_database }}",
              "type": "string"
            },
            {
              "id": "a3bc15e7-acaa-4889-9399-82b5431a4c76",
              "name": "Page m\u00e8re",
              "value": "={{ $('Code').item.json.parsed_data.id_page }}",
              "type": "string"
            },
            {
              "id": "4cef21a0-7fcd-44bf-b081-4d8aea601e57",
              "name": "Fournisseur",
              "value": "={{ $('Code').item.json.parsed_data.id_fournisseur }}",
              "type": "string"
            },
            {
              "id": "a1c0f16b-356f-48c8-a8c9-0b3d279f2b42",
              "name": "Type de t\u00e2che",
              "value": "={{ $('HTTP Type tache').item.json.properties.Nom.title[0].text.content }}",
              "type": "string"
            },
            {
              "id": "a31bc7ca-5390-47fb-84f9-4a8d8fbcb3e9",
              "name": "D\u00e9partement",
              "value": "={{ $('Edit Master T\u00e2che').item.json[\"D\u00e9partementID\"] }}",
              "type": "string"
            },
            {
              "id": "6f68fbdb-d779-4192-a68c-0f5367bbd5d9",
              "name": "Ticket",
              "value": "={{ $('Code').item.json.parsed_data.ticket }}",
              "type": "number"
            },
            {
              "id": "9dba622b-0307-47f0-9761-ac567436516f",
              "name": "Verification",
              "value": "={{ $('Edit Master T\u00e2che').item.json.Verification }}",
              "type": "string"
            },
            {
              "id": "d7e6a55c-b7bd-4581-b2cb-3b01a018cb59",
              "name": "Approbateur",
              "value": "={{ $('Edit Master T\u00e2che').item.json.Approbateur }}",
              "type": "string"
            }
          ]
        },
        "options": {}
      },
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [
        368,
        48
      ],
      "id": "aa01c621-8949-49c4-8b58-cc775c224ac1",
      "name": "Edit T\u00e2che",
      "notesInFlow": false,
      "onError": "continueRegularOutput"
    },
    {
      "parameters": {
        "functionCode": "return items.map(i => {\n  const log = i.json._log || {};\n  \n  // LIGNE 5 CORRIG\u00c9E\n  const nodeName = i.json._lastNode || 'UnknownNode';\n  \n  const failed = !!i.json._hadError || !!i.json.error;\n  \n  // Message adaptatif\n  const msg = i.json.error?.message || \n              i.json._errMsg || \n              (failed ? 'Erreur d\u00e9tect\u00e9e' : 'Succ\u00e8s');\n  \n  (log.actions ||= []).push({ node: nodeName, ok: !failed, msg });\n  \n  if (failed) {\n    log.ko = (log.ko || 0) + 1;\n    log.failedNodes = log.failedNodes || {};\n    log.failedNodes[nodeName] = true;\n  } else {\n    log.ok = (log.ok || 0) + 1;\n  }\n  \n  i.json._log = log;\n  return i;\n});"
      },
      "id": "32be5dac-6a96-430c-863f-e04a5ac0b469",
      "name": "Update Log",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        592,
        48
      ]
    },
    {
      "parameters": {
        "jsCode": "const items = $input.all();\nconst processedItems = [];\n\nfor (const item of items) {\n  // R\u00e9cup\u00e9ration de la propri\u00e9t\u00e9 \"property_r_f_rence_n8n\"\n  const textData = item.json.property_r_f_rence_n8n || '';\n  \n  // Initialisation des variables\n  let parsedData = {\n    nom_tache: '',\n    id_database: '',\n    id_page: '',\n    id_fournisseur: '', // Seulement pour les certificats\n    ticket: null        // NOUVEAU : num\u00e9ro de ticket\n  };\n  \n  if (textData) {\n    // DEBUG : V\u00e9rifier le format exact du texte\n    console.log(\"Texte brut:\", textData);\n    console.log(\"Contient \\\\n litt\u00e9ral:\", textData.includes('\\\\n'));\n    console.log(\"Contient saut de ligne:\", textData.includes('\\n'));\n    \n    // Normalisation : Remplacer les \\n litt\u00e9raux par de vrais sauts de ligne\n    const normalizedText = textData.replace(/\\\\n/g, '\\n');\n    console.log(\"Texte normalis\u00e9:\", normalizedText);\n    \n    // D\u00e9coupage du texte par lignes (apr\u00e8s normalisation)\n    const lignes = normalizedText.split('\\n');\n    \n    // [1] Nom de la t\u00e2che (premi\u00e8re ligne)\n    if (lignes[0]) {\n      parsedData.nom_tache = lignes[0].trim();\n    }\n    \n    // Parsing des lignes suivantes\n    for (let i = 1; i < lignes.length; i++) {\n      const ligne = lignes[i].trim();\n      \n      // [2] ID Database\n      if (ligne.startsWith('ID Database:')) {\n        parsedData.id_database = ligne.replace('ID Database:', '').trim();\n      }\n      \n      // [3] ID Page\n      if (ligne.startsWith('ID Page:')) {\n        parsedData.id_page = ligne.replace('ID Page:', '').trim();\n      }\n      \n      // [4] ID Fournisseur (uniquement pour les certificats)\n      if (ligne.startsWith('ID Fournisseur :')) {\n        parsedData.id_fournisseur = ligne.replace('ID Fournisseur :', '').trim();\n      }\n      \n      // [5] NOUVEAU : Ticket (extraction du num\u00e9ro)\n      if (ligne.startsWith('Ticket :') || ligne.startsWith('Ticket:')) {\n        const ticketText = ligne.replace(/Ticket\\s*:\\s*/i, '').trim();\n        const ticketNumber = parseInt(ticketText, 10);\n        \n        // V\u00e9rification que c'est bien un nombre valide\n        if (!isNaN(ticketNumber)) {\n          parsedData.ticket = ticketNumber;\n          console.log(`Ticket extrait: ${ticketNumber}`);\n        } else {\n          console.log(`Erreur parsing ticket: \"${ticketText}\" n'est pas un nombre valide`);\n        }\n      }\n    }\n  }\n  \n  // LOGIQUE CORRIG\u00c9E : Gestion de la date de planification  \n  let datePlanification = item.json[\"Date de planification\"];\n  \n  // V\u00e9rifier si la date de planification est null (dans l'objet .date)\n  if (!datePlanification || datePlanification.date === null || datePlanification.date === undefined) {\n    const dateCreation = item.json[\"Date de cr\u00e9eation\"];\n    \n    if (dateCreation && dateCreation.created_time) {\n      // Convertir created_time ISO vers format date objet Notion\n      const dateOnly = dateCreation.created_time.split('T')[0]; // \"2025-09-03T23:41:00.000Z\" \u2192 \"2025-09-03\"\n      \n      // Reconstruire l'objet complet avec la nouvelle date\n      datePlanification = {\n        ...datePlanification, // Garde id, type, etc.\n        \"date\": {\n          \"start\": dateOnly,\n          \"end\": null,\n          \"time_zone\": null\n        }\n      };\n      \n      console.log(`Date planification mise \u00e0 jour depuis created_time: ${dateOnly}`);\n    }\n  }\n  \n  // D\u00e9termination du type de base d'archive bas\u00e9 sur le nom de t\u00e2che\n  let type_archive = '';\n  switch(parsedData.nom_tache.toLowerCase()) {\n    case 'calibration':\n      type_archive = 'Archive_Calibration';\n      break;\n    case 'maintenance':\n      type_archive = 'Archive_Maintenance';\n      break;\n    case 'deviation':\n      type_archive = 'Archive_Deviation';\n      break;\n    case 'certificat':\n      type_archive = 'Archive_Certificat';\n      break;\n    case 'qualit\u00e9':\n    case 'qualite':\n      type_archive = 'Archive_Qualite';\n      break;\n    case 't\u00e2che':\n    case 'tache':\n      type_archive = 'Archive_Taches_Recurrentes';\n      break;\n    default:\n      type_archive = 'Archive_Autres';\n  }\n  \n  // Ajout des donn\u00e9es pars\u00e9es \u00e0 l'item\n  processedItems.push({\n    json: {\n      ...item.json,\n      // MISE \u00c0 JOUR de la date de planification\n      property_date_de_planification: datePlanification,\n      // Donn\u00e9es pars\u00e9es structur\u00e9es\n      parsed_data: parsedData,\n      // Variables directement exploitables pour la suite du workflow\n      nom_tache: parsedData.nom_tache,\n      id_database_origine: parsedData.id_database,\n      id_page_origine: parsedData.id_page,\n      id_fournisseur: parsedData.id_fournisseur,\n      ticket_number: parsedData.ticket,  // NOUVEAU : ticket comme number\n      type_archive: type_archive,\n      // Boolean pour identifier les certificats\n      is_certificat: parsedData.nom_tache.toLowerCase() === 'certificat'\n    }\n  });\n}\n\nreturn processedItems;"
      },
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        -320,
        0
      ],
      "id": "44bf41a2-9744-40b3-9e69-ecb9a71babb9",
      "name": "Code"
    },
    {
      "parameters": {},
      "type": "n8n-nodes-base.noOp",
      "typeVersion": 1,
      "position": [
        -320,
        128
      ],
      "id": "c80d8102-f65f-43c8-bf33-185b9b63ad71",
      "name": "No Operation, do nothing"
    },
    {
      "parameters": {
        "workflowId": {
          "__rl": true,
          "value": "aPTwM9HqpwCbuavW",
          "mode": "list",
          "cachedResultName": "WorkFlow 05.01"
        },
        "workflowInputs": {
          "mappingMode": "defineBelow",
          "value": {},
          "matchingColumns": [],
          "schema": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": true
        },
        "mode": "each",
        "options": {
          "waitForSubWorkflow": true
        }
      },
      "type": "n8n-nodes-base.executeWorkflow",
      "typeVersion": 1.2,
      "position": [
        2112,
        -512
      ],
      "id": "96b3849f-653b-4b8d-9953-bab304db0d47",
      "name": "WorkFlow 05.01",
      "alwaysOutputData": true,
      "onError": "continueRegularOutput"
    },
    {
      "parameters": {
        "workflowId": {
          "__rl": true,
          "value": "KOU18Gv3gwCTQRJT",
          "mode": "list",
          "cachedResultName": "WorkFlow 05.02"
        },
        "workflowInputs": {
          "mappingMode": "defineBelow",
          "value": {},
          "matchingColumns": [],
          "schema": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": true
        },
        "mode": "each",
        "options": {
          "waitForSubWorkflow": true
        }
      },
      "type": "n8n-nodes-base.executeWorkflow",
      "typeVersion": 1.2,
      "position": [
        2112,
        -144
      ],
      "id": "1b2adba3-34a6-4a4f-9cdb-624b0ba15556",
      "name": "WorkFlow 05.02",
      "alwaysOutputData": true,
      "onError": "continueRegularOutput"
    },
    {
      "parameters": {
        "workflowId": {
          "__rl": true,
          "value": "dBMan0heaFJKNe7B",
          "mode": "list",
          "cachedResultName": "WorkFlow 05.03"
        },
        "workflowInputs": {
          "mappingMode": "defineBelow",
          "value": {},
          "matchingColumns": [],
          "schema": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": true
        },
        "mode": "each",
        "options": {
          "waitForSubWorkflow": true
        }
      },
      "type": "n8n-nodes-base.executeWorkflow",
      "typeVersion": 1.2,
      "position": [
        2112,
        64
      ],
      "id": "f2835f61-32b7-4d4b-8595-b556d67bc247",
      "name": "WorkFlow 05.03",
      "alwaysOutputData": true,
      "onError": "continueRegularOutput"
    },
    {
      "parameters": {
        "workflowId": {
          "__rl": true,
          "value": "i6WlS43KV0MGrXpC",
          "mode": "list",
          "cachedResultName": "WorkFlow 05.04"
        },
        "workflowInputs": {
          "mappingMode": "defineBelow",
          "value": {},
          "matchingColumns": [],
          "schema": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": true
        },
        "mode": "each",
        "options": {
          "waitForSubWorkflow": true
        }
      },
      "type": "n8n-nodes-base.executeWorkflow",
      "typeVersion": 1.2,
      "position": [
        2112,
        400
      ],
      "id": "76c6cbef-0771-40f0-a11d-0a0896c0c6c9",
      "name": "WorkFlow 05.04",
      "alwaysOutputData": true,
      "onError": "continueRegularOutput"
    },
    {
      "parameters": {
        "functionCode": "return items.map(i => {\n  const log = i.json._log || {};\n  \n  // LIGNE 5 CORRIG\u00c9E\n  const nodeName = i.json._lastNode || 'UnknownNode';\n  \n  const failed = !!i.json._hadError || !!i.json.error;\n  \n  // Message adaptatif\n  const msg = i.json.error?.message || \n              i.json._errMsg || \n              (failed ? 'Erreur d\u00e9tect\u00e9e' : 'Succ\u00e8s');\n  \n  (log.actions ||= []).push({ node: nodeName, ok: !failed, msg });\n  \n  if (failed) {\n    log.ko = (log.ko || 0) + 1;\n    log.failedNodes = log.failedNodes || {};\n    log.failedNodes[nodeName] = true;\n  } else {\n    log.ok = (log.ok || 0) + 1;\n  }\n  \n  i.json._log = log;\n  return i;\n});"
      },
      "id": "7464a641-235b-43d6-8d2c-7d239c06c3a2",
      "name": "Update Log16",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        1504,
        400
      ]
    },
    {
      "parameters": {
        "functionCode": "return items.map(i => {\n  const log = i.json._log || {};\n  \n  // LIGNE 5 CORRIG\u00c9E\n  const nodeName = i.json._lastNode || 'UnknownNode';\n  \n  const failed = !!i.json._hadError || !!i.json.error;\n  \n  // Message adaptatif\n  const msg = i.json.error?.message || \n              i.json._errMsg || \n              (failed ? 'Erreur d\u00e9tect\u00e9e' : 'Succ\u00e8s');\n  \n  (log.actions ||= []).push({ node: nodeName, ok: !failed, msg });\n  \n  if (failed) {\n    log.ko = (log.ko || 0) + 1;\n    log.failedNodes = log.failedNodes || {};\n    log.failedNodes[nodeName] = true;\n  } else {\n    log.ok = (log.ok || 0) + 1;\n  }\n  \n  i.json._log = log;\n  return i;\n});"
      },
      "id": "4c506893-8b99-4fd0-84ad-943f08b3b390",
      "name": "Update Log18",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        1504,
        -144
      ]
    },
    {
      "parameters": {
        "functionCode": "return items.map(i => {\n  const log = i.json._log || {};\n  \n  // LIGNE 5 CORRIG\u00c9E\n  const nodeName = i.json._lastNode || 'UnknownNode';\n  \n  const failed = !!i.json._hadError || !!i.json.error;\n  \n  // Message adaptatif\n  const msg = i.json.error?.message || \n              i.json._errMsg || \n              (failed ? 'Erreur d\u00e9tect\u00e9e' : 'Succ\u00e8s');\n  \n  (log.actions ||= []).push({ node: nodeName, ok: !failed, msg });\n  \n  if (failed) {\n    log.ko = (log.ko || 0) + 1;\n    log.failedNodes = log.failedNodes || {};\n    log.failedNodes[nodeName] = true;\n  } else {\n    log.ok = (log.ok || 0) + 1;\n  }\n  \n  i.json._log = log;\n  return i;\n});"
      },
      "id": "34a9b4dd-3328-4ccb-ba10-752ad5467aad",
      "name": "Update Log19",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        1504,
        -512
      ]
    },
    {
      "parameters": {
        "url": "=https://api.notion.com/v1/pages/{{ $('Edit Master T\u00e2che').item.json[\"Types de tache\"] }}",
        "authentication": "predefinedCredentialType",
        "nodeCredentialType": "notionApi",
        "options": {
          "batching": {
            "batch": {
              "batchSize": 1
            }
          }
        }
      },
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        -112,
        64
      ],
      "id": "0057f9bf-0efa-407f-b6a7-98722436627e",
      "name": "HTTP Type tache",
      "alwaysOutputData": true,
      "notesInFlow": false,
      "retryOnFail": true,
      "credentials": {
        "notionApi": {
          "name": "<your credential>"
        }
      },
      "onError": "continueErrorOutput"
    },
    {
      "parameters": {
        "functionCode": "return items.map(i => {\n  const log = i.json._log || {};\n  \n  // LIGNE 5 CORRIG\u00c9E\n  const nodeName = i.json._lastNode || 'UnknownNode';\n  \n  const failed = !!i.json._hadError || !!i.json.error;\n  \n  // Message adaptatif\n  const msg = i.json.error?.message || \n              i.json._errMsg || \n              (failed ? 'Erreur d\u00e9tect\u00e9e' : 'Succ\u00e8s');\n  \n  (log.actions ||= []).push({ node: nodeName, ok: !failed, msg });\n  \n  if (failed) {\n    log.ko = (log.ko || 0) + 1;\n    log.failedNodes = log.failedNodes || {};\n    log.failedNodes[nodeName] = true;\n  } else {\n    log.ok = (log.ok || 0) + 1;\n  }\n  \n  i.json._log = log;\n  return i;\n});"
      },
      "id": "4897ca18-3bb7-407a-b2c8-c2cc1114cf5f",
      "name": "Update Log20",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        1504,
        64
      ]
    },
    {
      "parameters": {
        "functionCode": "return items.map(i => {\n  const log = i.json._log || {};\n  \n  // LIGNE 5 CORRIG\u00c9E\n  const nodeName = i.json._lastNode || 'UnknownNode';\n  \n  const failed = !!i.json._hadError || !!i.json.error;\n  \n  // Message adaptatif\n  const msg = i.json.error?.message || \n              i.json._errMsg || \n              (failed ? 'Erreur d\u00e9tect\u00e9e' : 'Succ\u00e8s');\n  \n  (log.actions ||= []).push({ node: nodeName, ok: !failed, msg });\n  \n  if (failed) {\n    log.ko = (log.ko || 0) + 1;\n    log.failedNodes = log.failedNodes || {};\n    log.failedNodes[nodeName] = true;\n  } else {\n    log.ok = (log.ok || 0) + 1;\n  }\n  \n  i.json._log = log;\n  return i;\n});"
      },
      "id": "f093ca88-a9e2-4f3c-a7a2-e2bf94f5637a",
      "name": "Update Log4",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        -704,
        64
      ]
    },
    {
      "parameters": {
        "assignments": {
          "assignments": [
            {
              "id": "efae6215-ab89-425a-be05-e377416c3bb8",
              "name": "ResponsableID",
              "value": "={{ $('Edit Master T\u00e2che').item.json.ResponsableID || \"\"}}",
              "type": "string"
            },
            {
              "id": "350d8ae7-7078-40fc-bf58-cf006e807378",
              "name": "T\u00e2che",
              "value": "={{ $json.name || \"\"}}",
              "type": "string"
            },
            {
              "id": "063beaa0-1f64-43f0-8676-1c14d881023c",
              "name": "\u00c9quipeID",
              "value": "={{ $('Edit Master T\u00e2che').item.json[\"\u00c9quipeID\"] || \"\"}}",
              "type": "string"
            },
            {
              "id": "3e435e3b-00f2-41b0-865a-e5535bc00dfe",
              "name": "\u00c9tat",
              "value": "={{ $('Edit Master T\u00e2che').item.json[\"\u00c9tat\"] || \"\"}}",
              "type": "string"
            },
            {
              "id": "18caa5f9-35be-425c-ad60-050606ee3716",
              "name": "Date de planification",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Date de planification\"] || \"\"}}",
              "type": "object"
            },
            {
              "id": "9140d778-4e06-4017-b845-a2fd25e2b4c2",
              "name": "Date compl\u00e9t\u00e9",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Date compl\u00e9t\u00e9\"] || \"\"}}",
              "type": "object"
            },
            {
              "id": "ad7f458b-46b6-4cbc-940c-98a77fb0973d",
              "name": "Date de cr\u00e9eation",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Date de cr\u00e9eation\"] || \"\"}}",
              "type": "object"
            },
            {
              "id": "7a36bcf2-73db-4182-b19a-210ead71d660",
              "name": "Ticket",
              "value": "={{ $('Edit T\u00e2che').item.json.Ticket || \"\"}}",
              "type": "number"
            },
            {
              "id": "9e9d0e1f-678d-45a6-a289-384870d62f0d",
              "name": "Dead line",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Dead line\"] || \"\"}}",
              "type": "object"
            },
            {
              "id": "ee1623dd-05f6-4625-92cd-d025affffed7",
              "name": "Base m\u00e8re",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Base m\u00e8re\"] || \"\"}}",
              "type": "string"
            },
            {
              "id": "a3bc15e7-acaa-4889-9399-82b5431a4c76",
              "name": "Page m\u00e8re",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Page m\u00e8re\"] || \"\"}}",
              "type": "string"
            },
            {
              "id": "4cef21a0-7fcd-44bf-b081-4d8aea601e57",
              "name": "Fournisseur",
              "value": "={{ $('Edit T\u00e2che').item.json.Fournisseur || \"\"}}",
              "type": "string"
            },
            {
              "id": "a1c0f16b-356f-48c8-a8c9-0b3d279f2b42",
              "name": "Type de t\u00e2che",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Type de t\u00e2che\"] || \"\"}}",
              "type": "string"
            },
            {
              "id": "2d8da833-6a28-455f-bd1d-b7d1b21d29af",
              "name": "Departement",
              "value": "={{ $('Edit T\u00e2che').item.json[\"D\u00e9partement\"] || \"\"}}",
              "type": "string"
            },
            {
              "id": "1702da5b-71ea-464a-9b60-7129c0e11925",
              "name": "Note",
              "value": "={{ $json.property_note || \"\"}}",
              "type": "string"
            },
            {
              "id": "74a32bd4-abdd-421d-9cdf-adedc69b526d",
              "name": "T\u00e2cheid",
              "value": "={{ $('Edit Master T\u00e2che').item.json[\"T\u00e2cheid\"] || \"\"}}",
              "type": "string"
            },
            {
              "id": "e1bf518d-7760-4037-889b-7389661014af",
              "name": "Cr\u00e9ateur",
              "value": "={{ $json.property_cr_ateur || \"\"}}",
              "type": "string"
            },
            {
              "id": "7db9b1ab-5b27-464a-b7e1-546a8ba551ca",
              "name": "Priorit\u00e9",
              "value": "={{ $json.property_priorit || \"\"}}",
              "type": "string"
            },
            {
              "id": "4991291b-6d97-45db-b745-852fe9e02bd4",
              "name": "Mention",
              "value": "={{ $json.property_mention  || \"\" }}",
              "type": "string"
            },
            {
              "id": "fec226af-af72-4164-a99d-e60995f4119c",
              "name": "Verification",
              "value": "={{ $('Edit T\u00e2che').item.json.Verification  || \"\" }}",
              "type": "string"
            },
            {
              "id": "527bc722-e7aa-4dfb-8d37-58138230c87b",
              "name": "Approbateur",
              "value": "={{ $('Edit T\u00e2che').item.json.Approbateur  || \"\" }}",
              "type": "string"
            }
          ]
        },
        "options": {}
      },
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [
        1888,
        -144
      ],
      "id": "7efa3179-1616-4174-8314-6a5fbf2d2a74",
      "name": "Edit Certificat",
      "notesInFlow": false,
      "retryOnFail": true,
      "onError": "continueRegularOutput"
    },
    {
      "parameters": {
        "values": {
          "string": [
            {
              "name": "_lastNode",
              "value": "={{ ($workflow.name || 'Unknown Workflow') + \" - \" + ($json._log?.actions?.find(action => !action.ok)?.node || Object.keys($json._log?.failedNodes || {})[0] || 'UnknownNode') }}"
            },
            {
              "name": "_hadError",
              "value": "={{ $json.error !== undefined }}"
            },
            {
              "name": "_errMsg",
              "value": "={{ $json.error?.message || ''}}"
            }
          ]
        },
        "options": {}
      },
      "id": "5d688604-bbbb-4197-9786-525a9cc07620",
      "name": "Log Snapshot11",
      "type": "n8n-nodes-base.set",
      "typeVersion": 1,
      "position": [
        128,
        48
      ]
    },
    {
      "parameters": {
        "resource": "databasePage",
        "operation": "get",
        "pageId": {
          "__rl": true,
          "value": "={{ $('Edit Master T\u00e2che').item.json[\"T\u00e2cheid\"] }}",
          "mode": "id"
        }
      },
      "type": "n8n-nodes-base.notion",
      "typeVersion": 2.2,
      "position": [
        1696,
        -144
      ],
      "id": "4aef4bb3-9d03-4da7-b522-c240a7f6db92",
      "name": "Get Createur Certificat",
      "retryOnFail": true,
      "credentials": {
        "notionApi": {
          "name": "<your credential>"
        }
      },
      "onError": "continueErrorOutput"
    },
    {
      "parameters": {
        "resource": "databasePage",
        "operation": "get",
        "pageId": {
          "__rl": true,
          "value": "={{ $('Edit Master T\u00e2che').item.json[\"T\u00e2cheid\"] }}",
          "mode": "id"
        }
      },
      "type": "n8n-nodes-base.notion",
      "typeVersion": 2.2,
      "position": [
        1696,
        -512
      ],
      "id": "358fb90a-f82a-4eae-87d3-3785141299d0",
      "name": "Get Createur Qualit\u00e9",
      "retryOnFail": true,
      "credentials": {
        "notionApi": {
          "name": "<your credential>"
        }
      },
      "onError": "continueErrorOutput"
    },
    {
      "parameters": {
        "assignments": {
          "assignments": [
            {
              "id": "efae6215-ab89-425a-be05-e377416c3bb8",
              "name": "ResponsableID",
              "value": "={{ $('Edit Master T\u00e2che').item.json.ResponsableID }}",
              "type": "string"
            },
            {
              "id": "350d8ae7-7078-40fc-bf58-cf006e807378",
              "name": "T\u00e2che",
              "value": "={{ $json.name }}",
              "type": "string"
            },
            {
              "id": "063beaa0-1f64-43f0-8676-1c14d881023c",
              "name": "\u00c9quipeID",
              "value": "={{ $('Edit Master T\u00e2che').item.json[\"\u00c9quipeID\"] }}",
              "type": "string"
            },
            {
              "id": "3e435e3b-00f2-41b0-865a-e5535bc00dfe",
              "name": "\u00c9tat",
              "value": "={{ $('Edit Master T\u00e2che').item.json[\"\u00c9tat\"] }}",
              "type": "string"
            },
            {
              "id": "18caa5f9-35be-425c-ad60-050606ee3716",
              "name": "Date de planification",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Date de planification\"] }}",
              "type": "object"
            },
            {
              "id": "9140d778-4e06-4017-b845-a2fd25e2b4c2",
              "name": "Date compl\u00e9t\u00e9",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Date compl\u00e9t\u00e9\"] }}",
              "type": "object"
            },
            {
              "id": "ad7f458b-46b6-4cbc-940c-98a77fb0973d",
              "name": "Date de cr\u00e9eation",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Date de cr\u00e9eation\"] }}",
              "type": "object"
            },
            {
              "id": "7a36bcf2-73db-4182-b19a-210ead71d660",
              "name": "Ticket",
              "value": "={{ $('Edit T\u00e2che').item.json.Ticket }}",
              "type": "number"
            },
            {
              "id": "9e9d0e1f-678d-45a6-a289-384870d62f0d",
              "name": "Dead line",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Dead line\"] }}",
              "type": "object"
            },
            {
              "id": "ee1623dd-05f6-4625-92cd-d025affffed7",
              "name": "Base m\u00e8re",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Base m\u00e8re\"] }}",
              "type": "string"
            },
            {
              "id": "a3bc15e7-acaa-4889-9399-82b5431a4c76",
              "name": "Page m\u00e8re",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Page m\u00e8re\"] }}",
              "type": "string"
            },
            {
              "id": "4cef21a0-7fcd-44bf-b081-4d8aea601e57",
              "name": "Fournisseur",
              "value": "={{ $('Edit T\u00e2che').item.json.Fournisseur }}",
              "type": "string"
            },
            {
              "id": "a1c0f16b-356f-48c8-a8c9-0b3d279f2b42",
              "name": "Type de t\u00e2che",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Type de t\u00e2che\"] }}",
              "type": "string"
            },
            {
              "id": "2d8da833-6a28-455f-bd1d-b7d1b21d29af",
              "name": "Departement",
              "value": "={{ $('Edit T\u00e2che').item.json[\"D\u00e9partement\"] }}",
              "type": "string"
            },
            {
              "id": "1702da5b-71ea-464a-9b60-7129c0e11925",
              "name": "Note",
              "value": "={{ $json.property_note }}",
              "type": "string"
            },
            {
              "id": "74a32bd4-abdd-421d-9cdf-adedc69b526d",
              "name": "T\u00e2cheid",
              "value": "={{ $('Edit Master T\u00e2che').item.json[\"T\u00e2cheid\"] || \"\" }}",
              "type": "string"
            },
            {
              "id": "e1bf518d-7760-4037-889b-7389661014af",
              "name": "Cr\u00e9ateur",
              "value": "={{ $json.property_cr_ateur || \"\" }}",
              "type": "string"
            },
            {
              "id": "7db9b1ab-5b27-464a-b7e1-546a8ba551ca",
              "name": "Priorit\u00e9",
              "value": "={{ $json.property_priorit || \"\" }}",
              "type": "string"
            },
            {
              "id": "09345ca1-7b34-4a95-b84d-80aeed8d8051",
              "name": "Approbateur",
              "value": "={{ $('Edit Master T\u00e2che').item.json.Approbateur || \"\" }}",
              "type": "string"
            },
            {
              "id": "a175226a-77ba-4ca8-85b6-a61899186910",
              "name": "Mention",
              "value": "={{ $json.property_mention || \"\" }}",
              "type": "string"
            },
            {
              "id": "bdccf1e9-d6f7-48d0-9fe3-f656b5fbbe31",
              "name": "Verification",
              "value": "={{ $('Edit T\u00e2che').item.json.Verification || \"\" }}",
              "type": "string"
            }
          ]
        },
        "options": {}
      },
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [
        1888,
        -512
      ],
      "id": "afd629b0-ebfe-4311-9cb3-7d1a79ce7456",
      "name": "Edit Qualit\u00e9",
      "notesInFlow": false,
      "retryOnFail": true,
      "onError": "continueRegularOutput"
    },
    {
      "parameters": {
        "assignments": {
          "assignments": [
            {
              "id": "efae6215-ab89-425a-be05-e377416c3bb8",
              "name": "ResponsableID",
              "value": "={{ $('Edit Master T\u00e2che').item.json.ResponsableID }}",
              "type": "string"
            },
            {
              "id": "350d8ae7-7078-40fc-bf58-cf006e807378",
              "name": "T\u00e2che",
              "value": "={{ $json.name }}",
              "type": "string"
            },
            {
              "id": "063beaa0-1f64-43f0-8676-1c14d881023c",
              "name": "\u00c9quipeID",
              "value": "={{ $('Edit Master T\u00e2che').item.json[\"\u00c9quipeID\"] }}",
              "type": "string"
            },
            {
              "id": "3e435e3b-00f2-41b0-865a-e5535bc00dfe",
              "name": "\u00c9tat",
              "value": "={{ $('Edit Master T\u00e2che').item.json[\"\u00c9tat\"] }}",
              "type": "string"
            },
            {
              "id": "18caa5f9-35be-425c-ad60-050606ee3716",
              "name": "Date de planification",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Date de planification\"] }}",
              "type": "object"
            },
            {
              "id": "9140d778-4e06-4017-b845-a2fd25e2b4c2",
              "name": "Date compl\u00e9t\u00e9",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Date compl\u00e9t\u00e9\"] }}",
              "type": "object"
            },
            {
              "id": "ad7f458b-46b6-4cbc-940c-98a77fb0973d",
              "name": "Date de cr\u00e9eation",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Date de cr\u00e9eation\"] }}",
              "type": "object"
            },
            {
              "id": "7a36bcf2-73db-4182-b19a-210ead71d660",
              "name": "Ticket",
              "value": "={{ $('Edit T\u00e2che').item.json.Ticket }}",
              "type": "number"
            },
            {
              "id": "9e9d0e1f-678d-45a6-a289-384870d62f0d",
              "name": "Dead line",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Dead line\"] }}",
              "type": "object"
            },
            {
              "id": "ee1623dd-05f6-4625-92cd-d025affffed7",
              "name": "Base m\u00e8re",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Base m\u00e8re\"] }}",
              "type": "string"
            },
            {
              "id": "a3bc15e7-acaa-4889-9399-82b5431a4c76",
              "name": "Page m\u00e8re",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Page m\u00e8re\"] }}",
              "type": "string"
            },
            {
              "id": "4cef21a0-7fcd-44bf-b081-4d8aea601e57",
              "name": "Fournisseur",
              "value": "={{ $('Edit T\u00e2che').item.json.Fournisseur }}",
              "type": "string"
            },
            {
              "id": "a1c0f16b-356f-48c8-a8c9-0b3d279f2b42",
              "name": "Type de t\u00e2che",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Type de t\u00e2che\"] }}",
              "type": "string"
            },
            {
              "id": "2d8da833-6a28-455f-bd1d-b7d1b21d29af",
              "name": "Departement",
              "value": "={{ $('Edit T\u00e2che').item.json[\"D\u00e9partement\"] }}",
              "type": "string"
            },
            {
              "id": "1702da5b-71ea-464a-9b60-7129c0e11925",
              "name": "Note",
              "value": "={{ $json.property_note }}",
              "type": "string"
            },
            {
              "id": "74a32bd4-abdd-421d-9cdf-adedc69b526d",
              "name": "T\u00e2cheid",
              "value": "={{ $('Edit Master T\u00e2che').item.json[\"T\u00e2cheid\"] }}",
              "type": "string"
            },
            {
              "id": "e1bf518d-7760-4037-889b-7389661014af",
              "name": "Cr\u00e9ateur",
              "value": "={{ $json.property_cr_ateur || \"\" }}",
              "type": "string"
            },
            {
              "id": "7db9b1ab-5b27-464a-b7e1-546a8ba551ca",
              "name": "Priorit\u00e9",
              "value": "={{ $json.property_priorit || \"\" }}",
              "type": "string"
            },
            {
              "id": "0e15cf72-1ee0-4b85-9988-27c0cb377545",
              "name": "property_mention",
              "value": "={{ $json.property_mention || \"\" }}",
              "type": "string"
            },
            {
              "id": "aa26592a-c4cb-4c5b-947b-663a7b924b17",
              "name": "Verification",
              "value": "={{ $('Edit Master T\u00e2che').item.json.Verification || \"\" }}",
              "type": "string"
            },
            {
              "id": "0fba6746-8d71-4cf2-b674-4af2395ba487",
              "name": "Approbateur",
              "value": "={{ $('Edit Master T\u00e2che').item.json.Approbateur || \"\" }}",
              "type": "string"
            }
          ]
        },
        "options": {}
      },
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [
        1888,
        400
      ],
      "id": "ee81a31f-afb2-47cb-8008-32e1a68e8e75",
      "name": "Edit T\u00e2che g\u00e9n\u00e9rique",
      "notesInFlow": false,
      "retryOnFail": true,
      "onError": "continueRegularOutput"
    },
    {
      "parameters": {
        "resource": "databasePage",
        "operation": "get",
        "pageId": {
          "__rl": true,
          "value": "={{ $('Edit Master T\u00e2che').item.json[\"T\u00e2cheid\"] }}",
          "mode": "id"
        }
      },
      "type": "n8n-nodes-base.notion",
      "typeVersion": 2.2,
      "position": [
        1696,
        400
      ],
      "id": "ac14d0b2-f045-4935-a281-3dcfbd60749a",
      "name": "Get Createur T\u00e2che Generique",
      "retryOnFail": true,
      "credentials": {
        "notionApi": {
          "name": "<your credential>"
        }
      },
      "onError": "continueErrorOutput"
    },
    {
      "parameters": {
        "assignments": {
          "assignments": [
            {
              "id": "efae6215-ab89-425a-be05-e377416c3bb8",
              "name": "ResponsableID",
              "value": "={{ $('Edit Master T\u00e2che').item.json.ResponsableID || \"\"}}",
              "type": "string"
            },
            {
              "id": "350d8ae7-7078-40fc-bf58-cf006e807378",
              "name": "T\u00e2che",
              "value": "={{ $json.name || \"\"}}",
              "type": "string"
            },
            {
              "id": "063beaa0-1f64-43f0-8676-1c14d881023c",
              "name": "\u00c9quipeID",
              "value": "={{ $('Edit Master T\u00e2che').item.json[\"\u00c9quipeID\"] || \"\"}}",
              "type": "string"
            },
            {
              "id": "3e435e3b-00f2-41b0-865a-e5535bc00dfe",
              "name": "\u00c9tat",
              "value": "={{ $('Edit Master T\u00e2che').item.json[\"\u00c9tat\"] || \"\"}}",
              "type": "string"
            },
            {
              "id": "18caa5f9-35be-425c-ad60-050606ee3716",
              "name": "Date de planification",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Date de planification\"] || \"\"}}",
              "type": "object"
            },
            {
              "id": "9140d778-4e06-4017-b845-a2fd25e2b4c2",
              "name": "Date compl\u00e9t\u00e9",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Date compl\u00e9t\u00e9\"] || \"\"}}",
              "type": "object"
            },
            {
              "id": "ad7f458b-46b6-4cbc-940c-98a77fb0973d",
              "name": "Date de cr\u00e9eation",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Date de cr\u00e9eation\"] || \"\"}}",
              "type": "object"
            },
            {
              "id": "7a36bcf2-73db-4182-b19a-210ead71d660",
              "name": "Ticket",
              "value": "={{ $('Edit T\u00e2che').item.json.Ticket || \"\"}}",
              "type": "number"
            },
            {
              "id": "9e9d0e1f-678d-45a6-a289-384870d62f0d",
              "name": "Dead line",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Dead line\"] || \"\"}}",
              "type": "object"
            },
            {
              "id": "ee1623dd-05f6-4625-92cd-d025affffed7",
              "name": "Base m\u00e8re",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Base m\u00e8re\"] }}",
              "type": "string"
            },
            {
              "id": "a3bc15e7-acaa-4889-9399-82b5431a4c76",
              "name": "Page m\u00e8re",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Page m\u00e8re\"] }}",
              "type": "string"
            },
            {
              "id": "4cef21a0-7fcd-44bf-b081-4d8aea601e57",
              "name": "Fournisseur",
              "value": "={{ $('Edit T\u00e2che').item.json.Fournisseur }}",
              "type": "string"
            },
            {
              "id": "a1c0f16b-356f-48c8-a8c9-0b3d279f2b42",
              "name": "Type de t\u00e2che",
              "value": "={{ $('Edit T\u00e2che').item.json[\"Type de t\u00e2che\"] }}",
              "type": "string"
            },
            {
              "id": "2d8da833-6a28-455f-bd1d-b7d1b21d29af",
              "name": "Departement",
              "value": "={{ $('Edit T\u00e2che').item.json[\"D\u00e9partement\"] }}",
              "type": "string"
            },
            {
              "id": "1702da5b-71ea-464a-9b60-7129c0e11925",
              "name": "Note",
              "value": "={{ $json.property_note || \"\"}}",
              "type": "string"
            },
            {
              "id": "74a32bd4-abdd-421d-9cdf-adedc69b526d",
              "name": "T\u00e2cheid",
              "value": "={{ $('Edit Master T\u00e2che').item.json[\"T\u00e2cheid\"] }}",
              "type": "string"
            },
            {
              "id": "e1bf518d-7760-4037-889b-7389661014af",
              "name": "Cr\u00e9ateur",
              "value": "={{ $json.property_cr_ateur || \"\"}}",
       

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.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

WorkFlow 05. Uses notion, httpRequest. Scheduled trigger; 44 nodes.

Source: https://github.com/WealthFinPilot/notion-qms-platform/blob/main/exports/workflows/wf-05-archive-taches.json — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

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

Data & Sheets

WorkFlow 08. Uses notion, httpRequest. Scheduled trigger; 37 nodes.

Notion, HTTP Request
Data & Sheets

This template is designed for social media managers, content creators, data analysts, and anyone who wants to automatically save and analyze their Meta Threads posts in Notion.

HTTP Request, Notion
Data & Sheets

&gt; Transform your content strategy with automated competitor intelligence

HTTP Request, Airtable, Notion +2
Data & Sheets

Automated Content Marketing Intelligence with OpenAI, Ahrefs & Multi-platform Integration. Uses httpRequest, airtable, notion, slack. Scheduled trigger; 21 nodes.

HTTP Request, Airtable, Notion +2
Data & Sheets

⚠️ COMMUNITY TEMPLATE DISCLAIMER: This is a community-contributed template that uses ScrapeGraphAI (a community node). Please ensure you have the ScrapeGraphAI community node installed in your n8n ins

N8N Nodes Scrapegraphai, HTTP Request, Notion +1