Workflow: Reservation Medcin
Integrations: googleCalendarTool, googleSheetsTool, manualTrigger, noOp, stickyNote, stopAndError

{"id": "my335cY3wVwMqvqy", "meta": {"instanceId": "workflow-c828a542", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:45.330734", "updatedAt": "2025-09-29T07:07:45.330749", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "name": "Reservation Medcin", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "nodes": [{"id": "trigger-d7e25663", "name": "Manual Trigger", "type": "n8n-nodes-base.manualTrigger", "typeVersion": 1, "position": [100, 100], "parameters": {}}, {"id": "32fe7a8b-aa1a-4517-a167-41972f77d69b", "name": "When chat message received", "type": "n8n-nodes-base.noOp", "position": [-360, -40], "webhookId": "8f427031-1110-4ea3-aef7-5d06ba7d5bce", "parameters": {"options": {}}, "typeVersion": 1.1, "notes": "This chatTrigger node performs automated tasks as part of the workflow."}, {"id": "3510bb5a-3c8b-4978-a6c5-5c077be74f3f", "name": "AI Agent", "type": "n8n-nodes-base.noOp", "position": [-20, -60], "parameters": {"options": {"systemMessage": "=\ud83c\udfaf Role of the Assistant\nYou are a virtual assistant specializing in appointment management for Dr. Hakim. Your goal is to schedule consultations accurately, ensuring real availability while providing a smooth experience for patients.\n\n\ud83d\udd52 Office Hours\nMonday - Friday: 9:00 AM - 8:00 PM\nSaturday: 9:00 AM - 1:00 PM\nSunday: \u274c Closed\nConsultation Duration: 1 hour\nBreak Between Patients: 15 minutes\n\n\ud83d\udcc5 Booking Process\n\n1\ufe0f\u20e3 Request Patient Information (Mandatory):\nFull Name\nPhone Number\nDesired Date and Time\n2\ufe0f\u20e3 Availability Check:\nIf the requested time is outside office hours \u2192 offer only available slots.\nIf the requested time is available, ask for confirmation and book it.\nIf the requested time is unavailable, apologize and suggest the actual available slots on the requested day (between 9:00 AM and 8:00 PM, respecting breaks).\n\n##Example:\nIf a patient requests an appointment at 10:00 AM, check Google Calendar to confirm availability between 9:00 AM and 8:00 PM, considering the consultation duration (1 hour) and the 15-minute breaks.\n\n\ud83d\udea8 Do not confirm the appointment immediately\u2014you must receive the patient's confirmation first.\n\n3\ufe0f\u20e3 Confirmation & Updates:\nConfirm availability with the patient before finalizing.\nUpdate Google Calendar & Google Sheets after every booking.\nGoogle Calendar Event Title: \"Patient Name - Phone Number\".\nFor modifications or cancellations, free the slot and update the schedule.\n\n##Tools:\nUse \"Cheek Avilability\" to check available slots.\nUse \"Creat event\" to book the appointment.\nUse \"Add Data\" to record patient information.\n\n\ud83d\udcac Communication\n\u2705 Respond clearly, professionally, and in a friendly manner.\n\u2705 Always confirm the final date and time with the patient.\n\u2705 Ensure Google Calendar and Google Sheets are updated after every booking.\n\n\ud83d\udcc5 Today's date: {{ $now }}."}}, "typeVersion": 1.7, "notes": "This agent node performs automated tasks as part of the workflow."}, {"id": "fea932f2-c99e-4e1a-83bc-b06abf6cce41", "name": "OpenAI Chat Model", "type": "n8n-nodes-base.noOp", "position": [-80, 160], "parameters": {"model": {"__rl": true, "mode": "list", "value": "gpt-4o-mini"}, "options": {}}, "credentials": {"openAiApi": {"id": "x0tQpNXNP6v5Ovtd", "name": "OpenAi account 2"}}, "typeVersion": 1.2, "notes": "This lmChatOpenAi node performs automated tasks as part of the workflow."}, {"id": "05bfbeb4-d2a4-4372-b763-6da636ed4393", "name": "Window Buffer Memory", "type": "n8n-nodes-base.noOp", "position": [60, 160], "parameters": {"sessionKey": "YOUR_CREDENTIAL_HERE", "sessionIdType": "customKey"}, "typeVersion": 1.3, "notes": "This memoryBufferWindow node performs automated tasks as part of the workflow."}, {"id": "86899211-daf8-4fc6-a61a-98504b239d83", "name": "Sticky Note2", "type": "n8n-nodes-base.stickyNote", "position": [20, -220], "parameters": {"color": 7, "width": 194, "height": 141, "content": "**AI Agent \ud83d\udc47**\nThe Prompt is already there, You just need to setup the prompt user message with your text message."}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "947c5aa3-549e-49f1-b136-030cbd3ca6ff", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [-120, 300], "parameters": {"color": 7, "width": 150, "height": 80, "content": "**Chat Model \u261d\ufe0f**\nAdd your Open Ai API Key "}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "cac840df-644e-4092-b678-af2fdf3fc378", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [240, 300], "parameters": {"color": 7, "width": 190, "height": 80, "content": "**Gpoogle Calendar \u261d\ufe0f**\nConnect to Google Calendar"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "f474ee97-ba38-4100-bfc7-0d01d0a4c599", "name": "Sticky Note3", "type": "n8n-nodes-base.stickyNote", "position": [500, 300], "parameters": {"color": 7, "width": 190, "height": 80, "content": "**Google Sheets \u261d\ufe0f**\nConnect to Google Sheets"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "51fcd961-7b0b-4435-a315-17d4ddc1ed30", "name": "Sticky Note4", "type": "n8n-nodes-base.stickyNote", "position": [40, 300], "parameters": {"color": 7, "width": 150, "height": 80, "content": "**Memory \u261d\ufe0f**\nAdd the Session ID "}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "398fdf7a-508d-4a0a-8c2c-1f0075b6ad56", "name": "Check Availability", "type": "n8n-nodes-base.googleCalendarTool", "position": [200, 160], "parameters": {"options": {}, "timeMax": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('End_Time', ``, 'string') }}", "timeMin": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Start_Time', ``, 'string') }}", "calendar": {"__rl": true, "mode": "list", "value": "3009ae2f09f9ecab6eaa1d36f0b38c099f0e370759cad1c51691f9dc0fbd64fd@group.calendar.google.com", "cachedResultName": "Prise de rendez vous pour les Medcins "}, "resource": "calendar"}, "credentials": {"googleCalendarOAuth2Api": {"id": "NtT31ekfbGzWyc9k", "name": "Google Calendar account"}}, "typeVersion": 1.3, "notes": "This googleCalendarTool node performs automated tasks as part of the workflow."}, {"id": "43673597-ffb6-4d38-8fb0-975eb47976f6", "name": "Creat event", "type": "n8n-nodes-base.googleCalendarTool", "position": [360, 160], "parameters": {"end": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('End', ``, 'string') }}", "start": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Start', ``, 'string') }}", "calendar": {"__rl": true, "mode": "list", "value": "3009ae2f09f9ecab6eaa1d36f0b38c099f0e370759cad1c51691f9dc0fbd64fd@group.calendar.google.com", "cachedResultName": "Prise de rendez vous pour les Medcins "}, "additionalFields": {}}, "credentials": {"googleCalendarOAuth2Api": {"id": "NtT31ekfbGzWyc9k", "name": "Google Calendar account"}}, "typeVersion": 1.3, "notes": "This googleCalendarTool node performs automated tasks as part of the workflow."}, {"id": "650b5d36-7b52-4bb2-953a-d9ee278a35eb", "name": "Add data", "type": "n8n-nodes-base.googleSheetsTool", "position": [500, 160], "parameters": {"columns": {"value": {"Nom complet": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Nom_complet', ``, 'string') }}", "Date / heure ": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Date___heure_', ``, 'string') }}", "Num\u00e9ro de telephone": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Num_ro_de_telephone', ``, 'string') }}"}, "schema": [{"id": "Nom complet", "type": "string", "display": true, "required": false, "displayName": "Nom complet", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "Num\u00e9ro de telephone", "type": "string", "display": true, "required": false, "displayName": "Num\u00e9ro de telephone", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "Date / heure ", "type": "string", "display": true, "required": false, "displayName": "Date / heure ", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "Confirm\u00e9", "type": "string", "display": true, "removed": true, "required": false, "displayName": "Confirm\u00e9", "defaultMatch": false, "canBeUsedToMatch": true}], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false}, "options": {}, "operation": "append", "sheetName": {"__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Feuille 1"}, "documentId": {"__rl": true, "mode": "list", "value": "1JAbg-TJZr7fqiRMAjQY6baDAkQoigzUd4YqbTPoQqWE", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "RDV Medcin"}}, "credentials": {"googleSheetsOAuth2Api": {"id": "Q4J5dsFmt1OSnjNV", "name": "Google Sheets account"}}, "typeVersion": 4.5, "notes": "This googleSheetsTool node performs automated tasks as part of the workflow."}, {"id": "error-f3a06be4", "name": "Error Handler", "type": "n8n-nodes-base.stopAndError", "typeVersion": 1, "position": [1000, 400], "parameters": {"message": "Workflow execution error", "options": {}}}], "active": false, "pinData": {}, "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "versionId": "39048f71-6a4c-4181-947e-5e2545c4dc1e", "connections": {"fea932f2-c99e-4e1a-83bc-b06abf6cce41": {"main": [[{"node": "error-handler-fea932f2-c99e-4e1a-83bc-b06abf6cce41-d1b72bc0", "type": "main", "index": 0}]]}, "398fdf7a-508d-4a0a-8c2c-1f0075b6ad56": {"main": [[{"node": "error-handler-398fdf7a-508d-4a0a-8c2c-1f0075b6ad56-ad1a1a84", "type": "main", "index": 0}]]}, "43673597-ffb6-4d38-8fb0-975eb47976f6": {"main": [[{"node": "error-handler-43673597-ffb6-4d38-8fb0-975eb47976f6-f9687077", "type": "main", "index": 0}]]}, "650b5d36-7b52-4bb2-953a-d9ee278a35eb": {"main": [[{"node": "error-handler-650b5d36-7b52-4bb2-953a-d9ee278a35eb-3b22ab22", "type": "main", "index": 0}]]}}, "description": "Automated workflow: Reservation Medcin. This workflow integrates 8 different services: stickyNote, agent, stopAndError, googleSheetsTool, lmChatOpenAi. It contains 16 nodes and follows best practices for error handling and security.", "notes": "Excellent quality workflow: Reservation Medcin. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}