This is the core heart of generating the calendar format (.ics) from the email body.<\/p>\n
[For Standard Route] Managing Reservations, Modifications, Cancellations, and Returns<\/h3>\n\n\nconst items = $input.all();\n\nreturn items.map(item => {\n\/\/ Retrieve text or textPlain depending on Gmail output\nconst body = item.json.text || item.json.textPlain || "";\nconst subject = item.json.subject || "";\n\n\/\/ 1. Common: Extract reservation number\nconst resIdMatch = body.match(\/\u25a0\u4e88\u7d04\u756a\u53f7\n(\\d+)\/);\nconst resId = resIdMatch ? resIdMatch[1] : "000000";\n\n\/\/ 2. Determine action\nlet action = "PUT";\nif (subject.includes("\u4e88\u7d04\u53d6\u6d88\u5b8c\u4e86")) {\naction = "DELETE";\n}\n\n\/\/ 3. Extract data (only for PUT)\nlet startTime = "", endTime = "", stationName = "\u30bf\u30a4\u30e0\u30ba\u30ab\u30fc", stationUrl = "", carModel = "";\n\nif (action === "PUT") {\n\/\/ Extract vehicle\nconst carMatch = body.match(\/\u25a0\u8eca\u4e21\n([^\n]+)\/);\ncarModel = carMatch ? carMatch[1].trim() : "";\n\n\/\/ Separate station name and URL\nconst stationMatch = body.match(\/\u25a0\u30b9\u30c6\u30fc\u30b7\u30e7\u30f3\n([^\n]+)\n(https?:\\\/\\\/[^\n]+)\/);\nif (stationMatch) {\nstationName = stationMatch[1].trim();\nstationUrl = stationMatch[2].trim();\n}\n\n\/\/ [Fix Point 1] Date\/time parsing helper (modified to insert T)\nconst formatIcsDate = (str) => {\nif (!str) return "";\nconst clean = str.replace(\/[\\\/ :]\/g, ''); \/\/ 202603141000\nreturn clean.slice(0, 8) + 'T' + clean.slice(8, 12) + '00'; \/\/ 20260314T100000\n};\n\nif (subject.includes("\u8fd4\u5374\u8a3c")) {\nconst timeMatch = body.match(\/\u25a0\u5229\u7528\u6642\u9593\n(\\d{4}\\\/\\d{2}\\\/\\d{2} \\d{2}:\\d{2}) - (\\d{4}\\\/\\d{2}\\\/\\d{2} \\d{2}:\\d{2})\/);\nif (timeMatch) {\nstartTime = formatIcsDate(timeMatch[1]);\nendTime = formatIcsDate(timeMatch[2]);\n}\n} else {\nconst startMatch = body.match(\/\u25a0\u5229\u7528\u958b\u59cb\u65e5\u6642\n(\\d{4}\\\/\\d{2}\\\/\\d{2} \\d{2}:\\d{2})\/);\nconst endMatch = body.match(\/\u25a0\u8fd4\u5374\u4e88\u5b9a\u65e5\u6642\n(\\d{4}\\\/\\d{2}\\\/\\d{2} \\d{2}:\\d{2})\/);\nstartTime = startMatch ? formatIcsDate(startMatch[1]) : "";\nendTime = endMatch ? formatIcsDate(endMatch[1]) : "";\n}\n}\n\n\/\/ 4. Build iCalendar data\nconst summaryPrefix = subject.includes("\u8fd4\u5374\u8a3c") ? "\u3010\u8fd4\u5374\u6e08\u3011" : "\u3010\u4e88\u7d04\u3011";\nconst summary = `Times:${summaryPrefix}${stationName}`;\nconst icsDataRaw = `BEGIN:VCALENDAR\nVERSION:2.0\nPRODID:-\/\/Nando Kobo\/\/n8n\/\/EN\nBEGIN:VEVENT\nUID:times-${resId}\nSUMMARY:${summary}\nDTSTART:${startTime}\nDTEND:${endTime}\nLOCATION:${stationName}\nDESCRIPTION:\u8eca\u4e21: ${carModel}\\\n\u30b9\u30c6\u30fc\u30b7\u30e7\u30f3: ${stationName}\nURL:${stationUrl}\nEND:VEVENT\nEND:VCALENDAR`;\n\n\/\/ [Fix Point 2] Batch replace line break codes from \n to \\r\n (CRLF)\nconst icsData = icsDataRaw.replace(\/\n\/g, '\\r\n');\n\nreturn {\njson: {\naction,\nresId,\nfileName: `times-${resId}.ics`,\nicsData,\nisCancel: action === "DELETE"\n}\n};\n});<\/pre>\n[For Accident\/Trouble Route] Visualizing Emergencies<\/h3>\n\n\nconst items = $input.all();\n\nreturn items.map(item => {\nconst body = item.json.text || item.json.textPlain || "";\n\n\/\/ 1. Extract reservation number\nconst resIdMatch = body.match(\/\u3010\u4e88\u7d04\u756a\u53f7\u3011(\\d+)\/);\nconst resId = resIdMatch ? resIdMatch[1] : "000000";\n\n\/\/ 2. Station and vehicle\nconst stationMatch = body.match(\/\u3010\u30b9\u30c6\u30fc\u30b7\u30e7\u30f3\u3011([^\n]+)\/);\nconst stationName = stationMatch ? stationMatch[1].trim() : "\u30bf\u30a4\u30e0\u30ba\u30ab\u30fc";\n\nconst carMatch = body.match(\/\u3010\u8eca\u4e21\u3011([^\n]+)\/);\nconst carModel = carMatch ? carMatch[1].trim() : "\u4e0d\u660e";\n\n\/\/ 3. Special date\/time parsing (2026\/03\/20 08:00 \uff5e 2026\/03\/21 22:00)\nconst formatIcsDate = (str) => {\nconst clean = str.replace(\/[\\\/ :]\/g, '');\nreturn clean.slice(0, 8) + 'T' + clean.slice(8, 12) + '00';\n};\n\nconst timeMatch = body.match(\/\u3010\u4e88\u7d04\u65e5\u6642\u3011(\\d{4}\\\/\\d{2}\\\/\\d{2} \\d{2}:\\d{2}) \uff5e (\\d{4}\\\/\\d{2}\\\/\\d{2} \\d{2}:\\d{2})\/);\nconst startTime = timeMatch ? formatIcsDate(timeMatch[1]) : "";\nconst endTime = timeMatch ? formatIcsDate(timeMatch[2]) : "";\n\n\/\/ 4. Build iCalendar data\nconst summary = `\u3010\u4e8b\u6545!!\u3011${stationName}`;\nconst stationUrl = "https:\/\/share.timescar.jp\/view\/sp\/reserve\/list.jsp";\nconst description = `\u203b\u8eca\u4e21\u30c8\u30e9\u30d6\u30eb\u767a\u751f\u4e2d\uff01\u5225\u8eca\u4e21\u3078\u306e\u5909\u66f4\u304c\u5fc5\u8981\u3067\u3059\u3002\\\n\u8eca\u4e21: ${carModel}\\\n\u4e88\u7d04\u756a\u53f7: ${resId}`;\n\nconst icsData = `BEGIN:VCALENDAR\nVERSION:2.0\nPRODID:-\/\/Nando Kobo\/\/n8n\/\/EN\nBEGIN:VEVENT\nUID:times-${resId}\nSUMMARY:${summary}\nDTSTART:${startTime}\nDTEND:${endTime}\nLOCATION:${stationName}\nDESCRIPTION:${description}\nURL:${stationUrl}\nEND:VEVENT\nEND:VCALENDAR`.replace(\/\n\/g, '\\r\n');\n\nreturn {\njson: {\naction: "PUT",\nresId,\nfileName: `times-${resId}.ics`,\nicsData,\nisCancel: false\n}\n};\n});<\/pre>\nCountermeasures Against the “Fastidiousness” of the iCalendar Specification<\/h2>\n
Here is the prescription for two technical traps faced during writing to DAViCal:<\/p>\n
\n- The date\/time “T”: Strictly adhere to the 20260314T100000 format (requiring a T in the middle).<\/li>\n
- Line break codes: Convert all line breaks to CRLF using .replace(\/
\n\/g, ‘\\r
\n’). Missing this will result in an error (500) during DAViCal database registration.<\/li>\n<\/ul>\nConclusion: If There Is No API, Just Build One<\/h2>\n
Times Car does not have an official API, but by parsing incoming emails, they can be transformed into a proper API.<\/p>\n
Through this build, my calendar has become a living log where “reservations, accidents, and returns” are automatically synchronized. Building a system exclusively for yourself in your own workshop\u2014this is the true essence of self-hosting.<\/p>\n","protected":false},"excerpt":{"rendered":"
The other day, I had a bitter experience where I forgot to cancel a Times Car reservation and ended up being c […]<\/p>\n","protected":false},"author":4,"featured_media":2815,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"en_US","_original_post":"https:\/\/donguri3.net\/?p=2797","footnotes":""},"categories":[1167],"tags":[18,19,52,290,1107,10,1040],"class_list":["post-5376","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-n8n-automation","tag-docker","tag-docker-compose","tag-https","tag-json","tag-n8n","tag-server","tag-1040","en-US"],"_links":{"self":[{"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/posts\/5376","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/comments?post=5376"}],"version-history":[{"count":1,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/posts\/5376\/revisions"}],"predecessor-version":[{"id":5379,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/posts\/5376\/revisions\/5379"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/media\/2815"}],"wp:attachment":[{"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/media?parent=5376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/categories?post=5376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/tags?post=5376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"I'm](\"https:\/\/donguri3.net\/wp-content\/uploads\/2026\/03\/bcd5227d80d80f5e8703dfc7b9bc6229.png\")
<\/a><\/li>\n<\/ul>\n<\/li>\n