{ "edges": [], "nodes": [ { "id": "22c8d63b-ce3c-4aab-b3f6-4bae8c1b9ec5", "name": "Window Buffer Memory", "type": "passthrough", "params": { "mode": "noOp", "sessionKey": "YOUR_CREDENTIAL_HERE", "sessionIdType": "customKey", "contextWindowLength": 20 }, "position": [ 1460, 880 ] }, { "id": "45403d5c-6e85-424f-b40b-c6214b57457b", "name": "Respond to Webhook", "type": "passthrough", "params": { "mode": "noOp", "options": {} }, "position": [ 1880, 580 ] }, { "id": "1111262a-1743-4bae-abf1-f69d2e1a580c", "name": "OpenAI Chat Model", "type": "passthrough", "params": { "mode": "noOp", "model": "gpt-4o-2024-08-06", "options": { "temperature": 0.4 } }, "position": [ 1360, 760 ] }, { "id": "df891547-c715-4dc6-bfcc-c0ac5cfcaf02", "name": "Make Appointment", "type": "passthrough", "params": { "url": "{{ $env.WEBHOOK_URL }}", "mode": "noOp", "method": "POST", "jsonBody": "{\n \"subject\": \"Meetings with at \",\n \"start\": {\n \"dateTime\": \"{dateStartTime}\",\n \"timeZone\": \"Europe/London\"\n },\n \"end\": {\n \"dateTime\": \"{dateEndTime}\",\n \"timeZone\": \"Europe/London\"\n },\n \"body\": {\n \"contentType\": \"HTML\",\n \"content\": \"{reason}\"\n },\n \"attendees\": [\n {\n \"emailAddress\": {\n \"address\": \"{email}\",\n \"name\": \"{name}\"\n },\n \"type\": \"required\"\n }\n ],\n \"location\": {\n \"displayName\": \"Online Meeting\"\n },\n \"isOnlineMeeting\": true,\n \"onlineMeetingProvider\": \"teamsForBusiness\",\n \"showAs\": \"busy\",\n \"categories\": [\n \"Meeting\"\n ]\n}", "sendBody": true, "sendQuery": true, "specifyBody": "json", "authentication": "{{ $credentials.predefinedCredentialType }}", "parametersQuery": { "values": [ { "name": "Content-Type", "value": "application/json", "valueProvider": "fieldValue" } ] }, "toolDescription": "Call this tool to make the appointment, ensure you send the user email, name, company, reason for the meeting and the appointment start time and the date in ISO String format with timezone for . When creating an appointment, always send JSON.", "nodeCredentialType": "YOUR_CREDENTIAL_HERE", "placeholderDefinitions": { "values": [ { "name": "dateStartTime", "type": "string", "description": "The date and start time of the appointment in toISOString format with timezone for Europe/London" }, { "name": "dateEndTime", "type": "string", "description": "The date and end time of the appointment in toISOString format, always 30 minutes after the dateStartTime, format with timezone for Europe/London" }, { "name": "reason", "type": "string", "description": "Detailed description of the meeting, will be sent to us and the customer" }, { "name": "email", "type": "string", "description": "The customers email address." }, { "name": "name", "type": "string", "description": "The customers full name, must be second and last name" } ] } }, "position": [ 1820, 840 ] }, { "id": "44141c44-de49-4707-b287-24007c84ca21", "name": "Execute Workflow Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.executeWorkflowTrigger" }, "position": [ 2160, 580 ] }, { "id": "795e1451-57d8-4563-8b86-5a75df2427b6", "name": "varResponse", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "c0b6e779-0f7b-41f0-81f8-457f2b31ccfe", "name": "response", "type": "array", "value": "={{ $json.freeTimeSlots.toJsonString() }}" } ] } }, "position": [ 3120, 460 ] }, { "id": "4283635f-649c-4cc7-84b9-37524ddb6ce0", "name": "freeTimeSlots", "type": "code", "params": { "jsCode": "// Input: An array with objects containing a 'value' array of events.\nconst businessHoursStart = \"08:00:00Z\"; // Business hours start time\nconst businessHoursEnd = \"17:30:00Z\"; // Business hours end time\n\nconst inputData = items[0].json.value; // Assuming the input data is in the 'value' array of the first item\n\n// Function to convert ISO datetime string to a Date object with specified time\nfunction getDateWithTime(dateString, time) {\n const datePart = new Date(dateString).toISOString().split(\"T\")[0]; // Extract the date part (YYYY-MM-DD)\n return new Date(`${datePart}T${time}`);\n}\n\n// Function to get day of the week from a date string\nfunction getDayOfWeek(dateString) {\n const daysOfWeek = [\"Sunday\", \"Monday\", \"Tuesday\", \"Wednesday\", \"Thursday\", \"Friday\", \"Saturday\"];\n return daysOfWeek[new Date(dateString).getUTCDay()];\n}\n\n// Function to add days to a date\nfunction addDays(date, days) {\n const result = new Date(date);\n result.setDate(result.getDate() + days);\n return result;\n}\n\n// Function to format date as YYYY-MM-DD\nfunction formatDate(date) {\n return date.toISOString().split('T')[0];\n}\n\n// Determine the default timezone from input data\nconst defaultTimeZone = inputData.length > 0 && inputData[0].start && inputData[0].start.timeZone \n ? inputData[0].start.timeZone \n : \"UTC\";\n\n// Find min and max dates in the input\nlet minDate = null;\nlet maxDate = null;\n\ninputData.forEach(event => {\n if (event.start && event.start.dateTime) {\n const eventDate = new Date(event.start.dateTime);\n if (!minDate || eventDate < minDate) {\n minDate = eventDate;\n }\n if (!maxDate || eventDate > maxDate) {\n maxDate = eventDate;\n }\n }\n});\n\n// If we have valid dates, ensure they're at the start of the day\nif (minDate && maxDate) {\n minDate = new Date(minDate.toISOString().split('T')[0]);\n maxDate = new Date(maxDate.toISOString().split('T')[0]);\n}\n\n// Organise events by date\nconst eventsByDate = {};\ninputData.forEach(event => {\n if (event.start && event.start.dateTime) {\n const eventDate = new Date(event.start.dateTime).toISOString().split(\"T\")[0]; // Extract the date\n if (!eventsByDate[eventDate]) {\n eventsByDate[eventDate] = [];\n }\n if (event.showAs === \"busy\") {\n eventsByDate[eventDate].push({\n start: new Date(event.start.dateTime),\n end: new Date(event.end.dateTime),\n timeZone: event.start.timeZone || defaultTimeZone\n });\n }\n }\n});\n\n// Find free slots within business hours for each date\nconst freeTimeSlots = [];\n\n// Process all dates in the range\nif (minDate && maxDate) {\n for (let currentDate = new Date(minDate); currentDate <= maxDate; currentDate = addDays(currentDate, 1)) {\n const dateStr = formatDate(currentDate);\n const busyEvents = eventsByDate[dateStr] || [];\n \n // Define business start and end times for the current date\n const businessStart = getDateWithTime(dateStr, businessHoursStart);\n const businessEnd = getDateWithTime(dateStr, businessHoursEnd);\n \n // If there are no busy events for this date, add the entire business day as free\n if (busyEvents.length === 0) {\n freeTimeSlots.push({\n date: dateStr,\n dayOfWeek: getDayOfWeek(dateStr),\n freeStart: businessStart.toISOString(),\n freeEnd: businessEnd.toISOString(),\n timeZone: defaultTimeZone\n });\n continue; // Skip to the next date\n }\n \n // Sort events by their start time\n busyEvents.sort((a, b) => a.start - b.start);\n \n // Check if there's free time before the first busy event\n if (busyEvents[0].start > businessStart) {\n freeTimeSlots.push({\n date: dateStr,\n dayOfWeek: getDayOfWeek(dateStr),\n freeStart: businessStart.toISOString(),\n freeEnd: busyEvents[0].start.toISOString(),\n timeZone: busyEvents[0].timeZone\n });\n }\n \n // Check for gaps between busy events\n for (let i = 0; i < busyEvents.length - 1; i++) {\n if (busyEvents[i].end < busyEvents[i+1].start) {\n freeTimeSlots.push({\n date: dateStr,\n dayOfWeek: getDayOfWeek(dateStr),\n freeStart: busyEvents[i].end.toISOString(),\n freeEnd: busyEvents[i+1].start.toISOString(),\n timeZone: busyEvents[i].timeZone\n });\n }\n }\n \n // Check if there's free time after the last busy event\n if (busyEvents[busyEvents.length - 1].end < businessEnd) {\n freeTimeSlots.push({\n date: dateStr,\n dayOfWeek: getDayOfWeek(dateStr),\n freeStart: busyEvents[busyEvents.length - 1].end.toISOString(),\n freeEnd: businessEnd.toISOString(),\n timeZone: busyEvents[busyEvents.length - 1].timeZone\n });\n }\n }\n}\n\n// Output the free time slots\nreturn [{ json: { freeTimeSlots } }];\n" }, "position": [ 2900, 460 ] }, { "id": "0786b561-449e-4c8f-bddb-c2bbd95dc197", "name": "Get Events", "type": "http", "params": { "url": "{{ $env.BASE_URL }}", "options": {}, "sendQuery": true, "sendHeaders": true, "authentication": "{{ $credentials.predefinedCredentialType }}", "queryParameters": { "parameters": [ { "name": "startDateTime", "value": "={{ new Date(new Date().setDate(new Date().getDate() + 2)).toISOString() }}" }, { "name": "endDateTime", "value": "={{ new Date(new Date().setDate(new Date().getDate() + 16)).toISOString() }}" }, { "name": "$top", "value": "50" }, { "name": "select", "value": "start,end,categories,importance,isAllDay,recurrence,showAs,subject,type" }, { "name": "orderby", "value": "start/dateTime asc" } ] }, "headerParameters": { "parameters": [ { "name": "Prefer", "value": "outlook.timezone=\"Europe/London\"" } ] }, "nodeCredentialType": "YOUR_CREDENTIAL_HERE" }, "position": [ 2680, 460 ] }, { "id": "55c4233e-d395-4193-9a1d-1884faed6f1e", "name": "Get Availability", "type": "passthrough", "params": { "mode": "noOp", "name": "Get_availability", "fields": { "values": [ { "name": "route", "stringValue": "availability" } ] }, "workflowId": { "__rl": true, "mode": "list", "value": "KD21RG8VeXYDS2Vf", "cachedResultName": "Website Chatbot" }, "description": "Call this tool to check my calendar for availability before booking an appointment. This will result in all events for the next 2 weeks. Review all events and do not double book." }, "position": [ 1760, 1080 ] }, { "id": "096d1962-31e6-4b3b-ba75-7956f70a6a32", "name": "Send Message", "type": "passthrough", "params": { "mode": "noOp", "name": "Send_email", "fields": { "values": [ { "name": "route", "stringValue": "message" } ] }, "workflowId": { "__rl": true, "mode": "list", "value": "KD21RG8VeXYDS2Vf", "cachedResultName": "Website Chatbot" }, "description": "Call this tool when the customer wants to speak to a human, or is not ready to make an appointment or if the customer has questions outside of your remit. The tool will send an email to our founder, . Always send the customer's full name, company and email address along with a detailed message about the enquiry. You must always gather project details.", "jsonSchemaExample": "{\n\t\"email\": \"the customer's email\",\n \"subject\": \"the subject of the email\",\n \"message\": \"The customer's enquiry, must be a detailed description of their enquiry\",\n \"name\": \"the customer's full name\",\n \"company\": \"the customer company name\"\n}", "specifyInputSchema": true }, "position": [ 1620, 1080 ] }, { "id": "285ddd31-5412-4d1c-ab80-d9960ec902bb", "name": "Chat Trigger", "type": "passthrough", "params": { "mode": "noOp", "public": true, "options": { "responseMode": "responseNode", "allowedOrigins": "*" } }, "position": [ 620, 600 ] }, { "id": "032a26e9-6853-490d-991b-b2af2d845f58", "name": "Switch", "type": "switch", "params": { "rules": { "values": [ { "outputKey": "YOUR_CREDENTIAL_HERE", "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "operator": { "type": "string", "operation": "equals" }, "leftValue": "={{ $json.route }}", "rightValue": "availability" } ] }, "renameOutput": true }, { "outputKey": "YOUR_CREDENTIAL_HERE", "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "52fd844b-cc8d-471f-a56a-40e119b66194", "operator": { "name": "filter.operator.equals", "type": "string", "operation": "equals" }, "leftValue": "={{ $json.route }}", "rightValue": "message" } ] }, "renameOutput": true } ] }, "options": {} }, "position": [ 2380, 580 ] }, { "id": "c74905ce-4fd9-486c-abc4-b0b1d57d71a8", "name": "varMessageResponse", "type": "set", "params": { "options": { "ignoreConversionErrors": false }, "assignments": { "assignments": [ { "id": "0d2ad084-9707-4979-84e4-297d1c21f725", "name": "response", "type": "string", "value": "={{ $json }}" } ] } }, "position": [ 2900, 700 ] }, { "id": "04c5d43c-1629-4e11-a6bb-ae73369d7002", "name": "Send Message1", "type": "integration", "params": { "service": "outlook", "subject": "={{ $('Execute Workflow Trigger').item.json.query.subject }}", "operation": "read", "bodyContent": "=\n\n\n \n \n New Webchat Customer Enquiry\n \n\n\n \n \n \n \n

\n \n \n \n \n \n \n \n \n \n \n

New Customer Enquiry

A potential client has reached out through our webchat

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

FROM

COMPANY

MESSAGE

This enquiry was automatically generated from our website's chat interface.

\n\n", "toRecipients": "you@yourdomain.com", "additionalFields": { "importance": "High", "bodyContentType": "html" } }, "position": [ 2680, 700 ] }, { "id": "5dfda5c9-eeeb-421a-a80d-f42c94602080", "name": "AI Agent", "type": "passthrough", "params": { "mode": "noOp", "text": "={{ $json.chatInput }}", "options": { "systemMessage": "=You are an intelligent personal assistant to Wayne, Founder at nocodecreative.io (ai consultancy and software development agency) responsible for coordinating appointments and gathering relevant information from customers. Your tasks are to:\n\n- Understand when the customer is available by asking for suitable days and times (ensuring they are aware we are in a UK timezone)\n- Check the calendar to identify available slots that match their preferences. Pay attention to each event's start and end time and do not double book, you will be given all events for the next 14 days\n- Ask the customer what they would like to discuss during the appointment to ensure proper preparation.\n- Get the customer's name, company name and email address to book the appointment\n- Make the conversation friendly and natural. Confirm the appointment details with the customer and let them know I’ll be ready to discuss what they’d like.\n- After you have checked the calendar, book the appointment accordingly, without double booking. Confirm the customer's timezone and adjust the appointment for EU/London.\n- If the customer isn't ready to book, you can send an email for a human to respond to, ensure you gather a detailed enquiry from the customer including contact details and project information.Ensure the message contains enough information for a human to respond, always include project details, if the customer hasn't provided project details, ask.\n- Alwways suggest an appointment before sending a message, appointment are you primary goal, message are a fall back\n\nExample questions:\n\n\"Hi there! we'd love to help arrange a time that works for us to meet. Could you let us know which days and times are best for you? We’ll check the calendar and book in a suitable slot.\"\n\n\"Could you please let us know what you’d like to discuss during the appointment? This helps us prepare in advance and make our time together as productive as possible.\"\n\n\"Before we put you in touch with a human, please can you provide more information about the project you have in mind?\" //You must gather project info at all times, even if the enquiry is about pricing/costs.\n\nIf the time the customer suggests is not available, suggest the nearest alternative appointment based on existing events, do not book an appointment outside of freeTimeSlots\n\nImportant information:\n- All appointments need 48 hours' notice from {{ \n new Date().toLocaleString(\"en-GB\", { timeZone: \"Europe/London\", hour12: false })\n .split(\", \")[0].split(\"/\").reverse().join(\"-\") \n + \"T\" + new Date().toLocaleTimeString(\"en-GB\", { timeZone: \"Europe/London\", hour12: false }) + \":00.000Z\" \n}} (current date and time in the UK) // this is non-negotiable, but discuss with care and be friendly, only let the customer know this if required\n- Business hours are 8am - 6pm Monday to Friday only Europe/London timezone, ensure the customer is aware of this and help them book during UK hours, you must confirm their timezone to do this!\n- Do not book appointments on a Saturday or sunday\n- Do not book appointments outside of freeTimeSlots\n- Always check the next 14 days, and review all events before providing availability \n- All appointments are for a max of 30 minutes\n- You must never offer an appointment without checking the calendar, if you cannot check the calendar, you cannot book and must let the customer know you can not book an appointment right now.\n- Always offer the soonest appointment available if the customer's preferred time is unavailable\n- When confirming an appointment, be thankful and excited!\n- Initial 30 minute consultation are free of charge\n\n\nMessages and description:\n- When creating descriptions or sending messages, always ensure enough detail is provided for preparation, meaning you can ask follow-up questions to extract further information as required. For example, if a customer asks about pricing, gather some information about the project so our team can provide accurate pricing, and apply this logic throughout\n\nComments:\n//!IMPORTANT! Do not offer any times without checking the calendar, do not make availability up\n//**Do not discuss anything other than appointment booking, if the query does not relate to an appointment, advise them you cannot help at this time.** be friendly and always offer to book an appointment to discuss their query\n//When the appointment is confirmed, let the customer know, by name, that they will be meeting our founder, Wayne for a 30 minute consultation, and that they will receive a calendar invite by email, ensure they accept the invite to confirm the appointment.\n//Always respond as a highly professional executive PA, remember this is the customer's first engagement, they do not know us or Wayne at this stage\n//Do not refer to yourself as me or I, instead communicate like an organisation, using terms like 'us'\n//Always gather project for descriptions and messages" }, "promptType": "define" }, "position": [ 1460, 580 ] }, { "id": "6156ab7e-d411-46b9-ac44-52ad56ee563d", "name": "If Node", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "158a0b91-534d-4745-b10e-8a7c97050861", "operator": { "type": "string", "operation": "exists", "singleValue": true }, "leftValue": "={{ $json.chatInput }}", "rightValue": "" } ] } }, "position": [ 840, 600 ] }, { "id": "c94171a9-a71d-4f63-bef6-e90361c57abd", "name": "Respond With Initial Message", "type": "passthrough", "params": { "mode": "noOp", "options": {}, "respondWith": "json", "responseBody": "{\n \"output\": \"Hi, how can I help you today?\"\n}" }, "position": [ 1140, 720 ] } ] }

AI Appointment Scheduler with Outlook Integration