Automatisation du processus d'intégration en plusieurs étapes avec Google Sheets, Forms et notifications Gmail
Avancé
Ceci est unHR, Multimodal AIworkflow d'automatisation du domainecontenant 31 nœuds.Utilise principalement des nœuds comme If, Set, Code, Form, Gmail. Utiliser Google Sheets, Forms et les notifications Gmail pour automatiser un processus d'intégration multi-étapes
Prérequis
- •Compte Google et informations d'identification Gmail API
- •Informations d'identification Google Sheets API
Nœuds utilisés (31)
Catégorie
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"nodes": [
{
"id": "bdb2c014-ce81-4e05-bfd1-e6ca9a42fb0f",
"name": "Lors du clic sur 'Exécuter le workflow'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-2240,
2462
],
"parameters": {},
"typeVersion": 1
},
{
"id": "73376d8c-21d3-47b3-af14-3872147ce7af",
"name": "Générer le tableau de messages",
"type": "n8n-nodes-base.code",
"position": [
-1800,
2362
],
"parameters": {
"jsCode": "const steps = $input.all().map((item) => item.json);\n\nconst result = steps.reduce((acc, step) => {\n const { step: stepIndex, Type, ...rest } = step;\n if (!acc[stepIndex]) {\n acc[stepIndex] = {};\n }\n if (!acc[stepIndex][Type]) {\n acc[stepIndex][Type] = {};\n }\n acc[stepIndex][Type] = rest;\n return acc;\n}, {});\n\nreturn result;\n"
},
"typeVersion": 2
},
{
"id": "46747e54-1288-4887-aa08-d37cc835f57e",
"name": "Lire les lignes de statut MSG",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1580,
2362
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit?usp=drivesdk",
"cachedResultName": "Standardized messages status"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"executeOnce": true,
"typeVersion": 4.6
},
{
"id": "0d67cbd3-d0f5-45a7-9057-289a97be871a",
"name": "Planifier le déclencheur",
"type": "n8n-nodes-base.scheduleTrigger",
"disabled": true,
"position": [
-2240,
2262
],
"parameters": {
"rule": {
"interval": [
{
"field": "minutes"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "2526926e-8a12-4e5c-a588-03e9f03bb334",
"name": "Si completed4",
"type": "n8n-nodes-base.if",
"position": [
-260,
2562
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "02a63c32-dbed-48d6-a459-2d12969c6524",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.check }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "75188ae4-001c-4a84-89fd-b9d9f3d9f608",
"name": "Formulaire",
"type": "n8n-nodes-base.form",
"position": [
-1800,
1860
],
"webhookId": "77ad7d58-abf8-4133-96f7-0a117a157b59",
"parameters": {
"options": {},
"operation": "completion",
"completionTitle": "Thanks a lot for entering your information"
},
"typeVersion": 1
},
{
"id": "2db39637-6703-4691-ad62-1aabb8429357",
"name": "Enregistrer les données d'inscription",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2020,
1860
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "submittedAt",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "submittedAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "formMode",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "formMode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "step",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "step",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit?usp=drivesdk",
"cachedResultName": "Standardized messages status"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "824c1b36-bff3-4165-821a-9e2425c0a067",
"name": "Lire les messages",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2020,
2362
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/17_fUSV9zJo8Ya6ulvCOon2wjoeEmOwDFrpK1Xxa9gmw/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "17_fUSV9zJo8Ya6ulvCOon2wjoeEmOwDFrpK1Xxa9gmw",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/17_fUSV9zJo8Ya6ulvCOon2wjoeEmOwDFrpK1Xxa9gmw/edit?usp=drivesdk",
"cachedResultName": "Standardized Messages"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"executeOnce": true,
"typeVersion": 4.6
},
{
"id": "d3dcba73-305b-4faf-94ae-8f6d53a9f708",
"name": "Mettre à jour la ligne en 'completed'",
"type": "n8n-nodes-base.googleSheets",
"position": [
-260,
2120
],
"parameters": {
"columns": {
"value": {
"status": "completed",
"row_number": "={{ $('Read MSG status Rows').item.json.row_number }}"
},
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "submittedAt",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "submittedAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "formMode",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "formMode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "step",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "step",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit?usp=drivesdk",
"cachedResultName": "Standardized messages status"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "VVX0td9tCoaQ6bwK",
"name": "New credentials to new project"
}
},
"typeVersion": 4.6
},
{
"id": "8a89a0c4-0dae-4139-91c3-b05678722d10",
"name": "Effectuer une action",
"type": "n8n-nodes-base.noOp",
"position": [
-700,
2220
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e336dac1-00e4-4149-8e00-d3e207a99549",
"name": "Vérifier si l'action est terminée",
"type": "n8n-nodes-base.noOp",
"position": [
-700,
2562
],
"parameters": {},
"typeVersion": 1
},
{
"id": "159ebeb8-efc0-4489-be43-7fe7e05597ca",
"name": "Créer l'étape suivante",
"type": "n8n-nodes-base.googleSheets",
"position": [
400,
2462
],
"parameters": {
"columns": {
"value": {
"step": "={{ $('Read MSG status Rows').item.json.step + 1 }}",
"Email": "={{ $('Read MSG status Rows').item.json.Email }}",
"status": "=sent",
"Last Name": "={{ $('Read MSG status Rows').item.json['Last Name'] }}",
"First Name": "={{ $('Read MSG status Rows').item.json['First Name'] }}"
},
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "submittedAt",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "submittedAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "formMode",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "formMode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "step",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "step",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yJ1JaUq4BNMWpBKl9E6Z-lkwcnZA7xQxc-zy4-TDeM0/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit?usp=drivesdk",
"cachedResultName": "Standardized messages status"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "082323c8-a6ec-475d-ad37-74df2cad4757",
"name": "Envoyer le message",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
-2240,
2960
],
"parameters": {
"workflowInputs": {
"values": [
{
"name": "email"
},
{
"name": "subject"
},
{
"name": "content"
},
{
"name": "variables",
"type": "object"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "fccbeab1-3536-409a-b68a-4bcf63a14f05",
"name": "Gmail2",
"type": "n8n-nodes-base.gmail",
"position": [
-1800,
2960
],
"webhookId": "4deca0da-c9ea-4707-bd1e-7f334b86a4a4",
"parameters": {
"sendTo": "={{ $('Send message').item.json.email }}",
"message": "={{ $json.msg }}",
"options": {
"appendAttribution": false
},
"subject": "={{ $('Send message').item.json.subject }}"
},
"credentials": {
"gmailOAuth2": {
"id": "DLjspol9TLgpGaXa",
"name": "Gmail account 2"
}
},
"typeVersion": 2.1
},
{
"id": "15c53cfe-963c-4ff3-8126-204c9c01f00e",
"name": "Envoyer le message à l'utilisateur",
"type": "n8n-nodes-base.executeWorkflow",
"onError": "continueErrorOutput",
"position": [
-480,
2220
],
"parameters": {
"mode": "each",
"options": {},
"workflowId": {
"__rl": true,
"mode": "id",
"value": "EORpbQwSc80AYgSs"
},
"workflowInputs": {
"value": {
"email": "={{ $('Read MSG status Rows').item.json.Email }}",
"content": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].sent.Content }}",
"subject": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].sent['Email subject'] }}",
"variables": "={{ $('Set variables').item.json.variables }}"
},
"schema": [
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subject",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "content",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "variables",
"type": "object",
"display": true,
"removed": false,
"required": false,
"displayName": "variables",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": true,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "17b9e0b9-9be8-4086-86d2-6b5f3e43096e",
"name": "Envoyer le message à l'administrateur",
"type": "n8n-nodes-base.executeWorkflow",
"onError": "continueErrorOutput",
"position": [
-260,
2320
],
"parameters": {
"options": {},
"workflowId": {
"__rl": true,
"mode": "id",
"value": "EORpbQwSc80AYgSs"
},
"workflowInputs": {
"value": {
"email": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].error['Email Reponsible'] }}",
"content": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].error.Content }}",
"subject": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].error['Email subject'] }}",
"variables": "={{ $('Set variables').item.json.variables }}"
},
"schema": [
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subject",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "content",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "variables",
"type": "object",
"display": true,
"removed": false,
"required": false,
"displayName": "variables",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "a007cd85-93d8-48bb-8921-ffdb5b653491",
"name": "Envoyer le message à l'utilisateur1",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
-40,
2462
],
"parameters": {
"mode": "each",
"options": {},
"workflowId": {
"__rl": true,
"mode": "id",
"value": "EORpbQwSc80AYgSs"
},
"workflowInputs": {
"value": {
"email": "={{ $('Read MSG status Rows').item.json.Email }}",
"content": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].completed['Content'] }}",
"subject": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].completed['Email subject'] }}",
"variables": "={{ $('Set variables').item.json.variables }}"
},
"schema": [
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subject",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "content",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "variables",
"type": "object",
"display": true,
"removed": false,
"required": false,
"displayName": "variables",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "9fc1fc41-0776-4fc5-a4c1-efc5129e3b12",
"name": "Définir les variables",
"type": "n8n-nodes-base.set",
"position": [
-1360,
2362
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7bcd18e7-d1aa-4f9b-8bc6-3114cee5a2b2",
"name": "variables",
"type": "object",
"value": "={{ { email: $('Read MSG status Rows').item.json['First Name']+'.'+$('Read MSG status Rows').item.json['Last Name'] +'@yourcompany.com', error: \"This has been ean error\" } }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "72bd115d-d8ec-43d4-93d0-bbd3eedbbba1",
"name": "Code",
"type": "n8n-nodes-base.code",
"position": [
-2020,
2960
],
"parameters": {
"jsCode": "\nlet template = $input.first().json.content\nlet variables = $input.first().json.variables\nlet msg = template.replace(/\\{\\{\\s*(\\w+)\\s*\\}\\}/g, (match, variableName) => {\n return variables.hasOwnProperty(variableName) \n ? variables[variableName] \n : match; // if variable not found, leave as is\n});\n\nreturn {msg}"
},
"typeVersion": 2
},
{
"id": "99146b8e-8f06-4c1c-94ff-abf68cf2fa29",
"name": "Envoyer le message à l'administrateur1",
"type": "n8n-nodes-base.executeWorkflow",
"onError": "continueErrorOutput",
"position": [
-40,
2662
],
"parameters": {
"options": {},
"workflowId": {
"__rl": true,
"mode": "id",
"value": "EORpbQwSc80AYgSs"
},
"workflowInputs": {
"value": {
"email": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].error['Email Reponsible'] }}",
"content": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].error['Content'] }}",
"subject": "={{ $('Generate message table').item.json[$('Read MSG status Rows').item.json.step].error['Email subject'] }}",
"variables": "={{ $('Set variables').item.json.variables }}"
},
"schema": [
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subject",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "content",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "variables",
"type": "object",
"display": true,
"removed": false,
"required": false,
"displayName": "variables",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "691dc84a-67aa-4df2-9ccf-43b24ef21a4d",
"name": "Note autocollante",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2300,
1680
],
"parameters": {
"color": 4,
"width": 680,
"height": 340,
"content": "## This is the starting point\n- You can send the link by email to the person\n- On ce it will fill it it will create the Step 1"
},
"typeVersion": 1
},
{
"id": "fe9f14e5-6ddf-4354-9596-d4cb3f933664",
"name": "Commutateur",
"type": "n8n-nodes-base.switch",
"position": [
-920,
2178
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Step 1",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e27fcf86-b911-4fb8-b578-5e634dcaa652",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 1
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 2",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "1e77bdfb-5aad-45c5-a9ef-6882d0c448e9",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 2
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 3",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "6cb7728e-4ee2-446a-8822-12c1b98d5aca",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 3
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 4",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "193098e4-0fa4-4805-ac37-8512bd8ce33b",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 4
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 5",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "efe9e13c-4a52-456a-b927-29694fe9b0da",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 5
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "7fef0239-7179-4ac2-8b6b-df3e0ff68ba6",
"name": "Commutateur1",
"type": "n8n-nodes-base.switch",
"position": [
-920,
2520
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Step 1",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e27fcf86-b911-4fb8-b578-5e634dcaa652",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 1
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 2",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "1e77bdfb-5aad-45c5-a9ef-6882d0c448e9",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 2
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 3",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "6cb7728e-4ee2-446a-8822-12c1b98d5aca",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 3
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 4",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "193098e4-0fa4-4805-ac37-8512bd8ce33b",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 4
}
]
},
"renameOutput": true
},
{
"outputKey": "Step 5",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "efe9e13c-4a52-456a-b927-29694fe9b0da",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.step }}",
"rightValue": 5
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "add73124-2a49-4b9b-b732-ff51c519b631",
"name": "Note autocollante1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-980,
2060
],
"parameters": {
"height": 340,
"content": "## Case setting \nHere you can set the distinct action for each step"
},
"typeVersion": 1
},
{
"id": "6ad12fb7-9e21-443a-bc2a-1f3f582fbe95",
"name": "Note autocollante2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-980,
2420
],
"parameters": {
"height": 400,
"content": "## Case setting \nHere you can set the distinct verifications for each step"
},
"typeVersion": 1
},
{
"id": "e25b6577-80ef-4419-ba65-8d7baa5c7bb4",
"name": "Note autocollante9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2300,
2040
],
"parameters": {
"color": 4,
"width": 2940,
"height": 800,
"content": "## Main workflow\n"
},
"typeVersion": 1
},
{
"id": "61697f64-a7f5-44b3-97f2-aa99104d61e0",
"name": "Type d'étape du commutateur",
"type": "n8n-nodes-base.switch",
"position": [
-1140,
2362
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "sent",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d2891710-d6d4-47d9-aecd-8e3a9e1f8454",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.status }}",
"rightValue": "=sent"
}
]
},
"renameOutput": true
},
{
"outputKey": "completed",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "9713a3ff-b93b-4b18-9e12-666d398351b6",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Read MSG status Rows').item.json.status }}",
"rightValue": "completed"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "c35de795-5fc3-4e6d-a87b-a98d467e7f74",
"name": "Définir le résultat du mode débogage",
"type": "n8n-nodes-base.set",
"position": [
-480,
2562
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "c5376105-41c5-4cee-ac3f-665bda0a996d",
"name": "check",
"type": "boolean",
"value": true
}
]
}
},
"typeVersion": 3.4
},
{
"id": "3d3ce9ce-83d1-4e07-8f09-a4248e9e8759",
"name": "Note autocollante3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2300,
2860
],
"parameters": {
"color": 4,
"width": 680,
"height": 260,
"content": "## Sub Workflow \n- replace the variables enclosed in {{ }} by its corresponding value set in \"Set variables node\".\n- Send messages, here you can set a slack or telegram nessage"
},
"typeVersion": 1
},
{
"id": "e0a9ac24-c20a-4209-a896-55da6dd158e3",
"name": "Mettre à jour la ligne en 'passed'",
"type": "n8n-nodes-base.googleSheets",
"position": [
180,
2460
],
"parameters": {
"columns": {
"value": {
"status": "passed",
"row_number": "={{ $('Read MSG status Rows').item.json.row_number }}"
},
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "submittedAt",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "submittedAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "formMode",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "formMode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "step",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "step",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yJ1JaUq4BNMWpBKl9E6Z-lkwcnZA7xQxc-zy4-TDeM0/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HBLJNt8hAXNkqj6lfwQilBr9FCRxjT3j0r0Ni6cgoYA/edit?usp=drivesdk",
"cachedResultName": "Standardized messages status"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "9d5ca28d-01a3-405c-a3a9-f9de83ba174e",
"name": "Inscription",
"type": "n8n-nodes-base.formTrigger",
"position": [
-2240,
1860
],
"webhookId": "fc69bf4d-938e-48e4-a2e1-91f599c0d61a",
"parameters": {
"options": {
"path": "onboarding"
},
"formTitle": "Welcome to our company",
"formFields": {
"values": [
{
"fieldLabel": "First Name",
"requiredField": true
},
{
"fieldLabel": "Last Name",
"requiredField": true
},
{
"fieldLabel": "Email",
"requiredField": true
},
{
"fieldName": "step",
"fieldType": "hiddenField",
"fieldValue": "1"
},
{
"fieldName": "status",
"fieldType": "hiddenField",
"fieldValue": "sent"
}
]
},
"formDescription": "Please enter you data here"
},
"typeVersion": 2.2
}
],
"connections": {
"72bd115d-d8ec-43d4-93d0-bbd3eedbbba1": {
"main": [
[
{
"node": "fccbeab1-3536-409a-b68a-4bcf63a14f05",
"type": "main",
"index": 0
}
]
]
},
"fe9f14e5-6ddf-4354-9596-d4cb3f933664": {
"main": [
[
{
"node": "8a89a0c4-0dae-4139-91c3-b05678722d10",
"type": "main",
"index": 0
}
],
[
{
"node": "8a89a0c4-0dae-4139-91c3-b05678722d10",
"type": "main",
"index": 0
}
],
[
{
"node": "8a89a0c4-0dae-4139-91c3-b05678722d10",
"type": "main",
"index": 0
}
],
[
{
"node": "8a89a0c4-0dae-4139-91c3-b05678722d10",
"type": "main",
"index": 0
}
],
[
{
"node": "8a89a0c4-0dae-4139-91c3-b05678722d10",
"type": "main",
"index": 0
}
]
]
},
"7fef0239-7179-4ac2-8b6b-df3e0ff68ba6": {
"main": [
[
{
"node": "e336dac1-00e4-4149-8e00-d3e207a99549",
"type": "main",
"index": 0
}
],
[
{
"node": "e336dac1-00e4-4149-8e00-d3e207a99549",
"type": "main",
"index": 0
}
],
[
{
"node": "e336dac1-00e4-4149-8e00-d3e207a99549",
"type": "main",
"index": 0
}
],
[
{
"node": "e336dac1-00e4-4149-8e00-d3e207a99549",
"type": "main",
"index": 0
}
],
[
{
"node": "e336dac1-00e4-4149-8e00-d3e207a99549",
"type": "main",
"index": 0
}
]
]
},
"9d5ca28d-01a3-405c-a3a9-f9de83ba174e": {
"main": [
[
{
"node": "2db39637-6703-4691-ad62-1aabb8429357",
"type": "main",
"index": 0
}
]
]
},
"082323c8-a6ec-475d-ad37-74df2cad4757": {
"main": [
[
{
"node": "72bd115d-d8ec-43d4-93d0-bbd3eedbbba1",
"type": "main",
"index": 0
}
]
]
},
"2526926e-8a12-4e5c-a588-03e9f03bb334": {
"main": [
[
{
"node": "a007cd85-93d8-48bb-8921-ffdb5b653491",
"type": "main",
"index": 0
}
],
[
{
"node": "99146b8e-8f06-4c1c-94ff-abf68cf2fa29",
"type": "main",
"index": 0
}
]
]
},
"824c1b36-bff3-4165-821a-9e2425c0a067": {
"main": [
[
{
"node": "73376d8c-21d3-47b3-af14-3872147ce7af",
"type": "main",
"index": 0
}
]
]
},
"9fc1fc41-0776-4fc5-a4c1-efc5129e3b12": {
"main": [
[
{
"node": "61697f64-a7f5-44b3-97f2-aa99104d61e0",
"type": "main",
"index": 0
}
]
]
},
"8a89a0c4-0dae-4139-91c3-b05678722d10": {
"main": [
[
{
"node": "15c53cfe-963c-4ff3-8126-204c9c01f00e",
"type": "main",
"index": 0
}
]
]
},
"159ebeb8-efc0-4489-be43-7fe7e05597ca": {
"main": [
[]
]
},
"0d67cbd3-d0f5-45a7-9057-289a97be871a": {
"main": [
[
{
"node": "824c1b36-bff3-4165-821a-9e2425c0a067",
"type": "main",
"index": 0
}
]
]
},
"15c53cfe-963c-4ff3-8126-204c9c01f00e": {
"main": [
[
{
"node": "d3dcba73-305b-4faf-94ae-8f6d53a9f708",
"type": "main",
"index": 0
}
],
[
{
"node": "17b9e0b9-9be8-4086-86d2-6b5f3e43096e",
"type": "main",
"index": 0
}
]
]
},
"a007cd85-93d8-48bb-8921-ffdb5b653491": {
"main": [
[
{
"node": "e0a9ac24-c20a-4209-a896-55da6dd158e3",
"type": "main",
"index": 0
}
]
]
},
"61697f64-a7f5-44b3-97f2-aa99104d61e0": {
"main": [
[
{
"node": "fe9f14e5-6ddf-4354-9596-d4cb3f933664",
"type": "main",
"index": 0
}
],
[
{
"node": "7fef0239-7179-4ac2-8b6b-df3e0ff68ba6",
"type": "main",
"index": 0
}
]
]
},
"e336dac1-00e4-4149-8e00-d3e207a99549": {
"main": [
[
{
"node": "c35de795-5fc3-4e6d-a87b-a98d467e7f74",
"type": "main",
"index": 0
}
]
]
},
"46747e54-1288-4887-aa08-d37cc835f57e": {
"main": [
[
{
"node": "9fc1fc41-0776-4fc5-a4c1-efc5129e3b12",
"type": "main",
"index": 0
}
]
]
},
"e0a9ac24-c20a-4209-a896-55da6dd158e3": {
"main": [
[
{
"node": "159ebeb8-efc0-4489-be43-7fe7e05597ca",
"type": "main",
"index": 0
}
]
]
},
"c35de795-5fc3-4e6d-a87b-a98d467e7f74": {
"main": [
[
{
"node": "2526926e-8a12-4e5c-a588-03e9f03bb334",
"type": "main",
"index": 0
}
]
]
},
"73376d8c-21d3-47b3-af14-3872147ce7af": {
"main": [
[
{
"node": "46747e54-1288-4887-aa08-d37cc835f57e",
"type": "main",
"index": 0
}
]
]
},
"2db39637-6703-4691-ad62-1aabb8429357": {
"main": [
[
{
"node": "75188ae4-001c-4a84-89fd-b9d9f3d9f608",
"type": "main",
"index": 0
}
]
]
},
"d3dcba73-305b-4faf-94ae-8f6d53a9f708": {
"main": [
[]
]
},
"bdb2c014-ce81-4e05-bfd1-e6ca9a42fb0f": {
"main": [
[
{
"node": "824c1b36-bff3-4165-821a-9e2425c0a067",
"type": "main",
"index": 0
}
]
]
}
}
}Foire aux questions
Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Avancé - Ressources Humaines, IA Multimodale
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Automatisation de l'envoi de demandes de contact LinkedIn et de messages d'ouverture avec Unipile et Google Sheets
Utiliser Unipile et Google Sheets pour envoyer automatiquement des demandes de contact LinkedIn et des messages d'ouverture
If
Set
Code
+
If
Set
Code
44 NœudsPollupAI
Autres
Automatisation des demandes LinkedIn et des messages d'ouverture avec Browserflow et Google Sheets
Utiliser Browserflow et Google Sheets pour automatiser les demandes LinkedIn et les messages d'ouverture
If
Set
Sort
+
If
Set
Sort
44 NœudsPollupAI
Ventes
Explorer les nœuds n8n dans la bibliothèque de références visuelles
Explorer les nœuds n8n dans la base de références visuelles
If
Ftp
Set
+
If
Ftp
Set
113 NœudsI versus AI
Autres
Version professionnelle de l'automatisation de blog WordPress (recherche approfondie) v2.1 sur le marché
Automatisation de la création de blog optimisé pour le SEO avec GPT-4o, Perplexity AI et support multilingue
If
Set
Xml
+
If
Set
Xml
125 NœudsDaniel Ng
Création de contenu
Prospection et workflow d'e-mails
Utiliser Google Maps, SendGrid et l'IA pour automatiser le développement de prospects B2B et le marketing par e-mail
If
Set
Code
+
If
Set
Code
141 NœudsEzema Kingsley Chibuzo
Génération de leads
Moteur automatisé de contenu viral pour LinkedIn et X
Création et publication automatique de contenu viral pour LinkedIn et X avec l'IA
If
Set
Wait
+
If
Set
Wait
156 NœudsDiptamoy Barman
Création de contenu
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds31
Catégorie2
Types de nœuds14
Description de la difficulté
Auteur
PollupAI
@zeerobugWe create bespoke AI solutions, automations and agents that help your business as it scales.
Liens externes
Voir sur n8n.io →
Partager ce workflow