![\"Mercari](\"https:\/\/donguri3.net\/wp-content\/uploads\/2026\/07\/ebd5e45a2a3560dd5261d01c201f0fca.png\")
<\/a><\/p>\nStep 1: Detect Specific Emails with Gmail Trigger and IF Node<\/h3>\n
First, configure the “Gmail Trigger” node in n8n. Set the Trigger event to “Message Received” and configure it to poll every minute (Every Minute) to retrieve new emails. At this time, make sure to turn off (disable) the “Simplify” option in the node settings so that the entire body of the email can be analyzed in subsequent processing.<\/p>\n
Next, place an “IF” node (or Filter node) to branch out “only the target emails” from all retrieved emails. In the condition settings, route emails where the sender (from) is no-reply@mercari.jp and the subject includes \u306e\u767a\u9001\u3092\u304a\u9858\u3044\u3057\u307e\u3059 (Please ship…) as True to the subsequent process. This design makes the processing paths for “Mercari emails” and “other emails” visually clear on the workflow and facilitates future expansions.<\/p>\n
Step 2: Extract Data and Create VTODO (Task) Data with Code Node<\/h3>\n
Place a “Code” node on the True route of the branch and use JavaScript regular expressions to extract product IDs, product names, etc., from the email body. Furthermore, retrieve the email reception date and time (internalDate) and convert it into the YYYYMMDDThhmmssZ format stipulated by the calendar data standard (RFC 5545).<\/p>\n
const items = $input.all();\nconst results = [];\n\nfor (const item of items) {\n \/\/ Get plain text body (including fallback if field name doesn't exist)\n const emailBody = item.json.text || item.json.snippet || item.json.html || "";\n \n \/\/ Group extraction using regular expressions\n const idMatch = emailBody.match(\/\u5546\u54c1ID\\s*:\\s*([a-zA-Z0-9]+)\/);\n const nameMatch = emailBody.match(\/\u5546\u54c1\u540d\\s*:\\s*(.+)\/);\n const priceMatch = emailBody.match(\/\u5546\u54c1\u4fa1\u683c\\s*:\\s*(.+)\/);\n \n const productId = idMatch ? idMatch[1].trim() : `unknown-${Date.now()}`;\n const productName = nameMatch ? nameMatch[1].trim() : "Unknown Product Name";\n const productPrice = priceMatch ? priceMatch[1].trim() : "Unknown Price";\n\n \/\/ Get email receipt date\/time (internalDate) and convert to Date object\n \/\/ Use current time as fail-safe if unavailable\n const internalDateMs = item.json.internalDate ? parseInt(item.json.internalDate, 10) : Date.now();\n const receiveDate = new Date(internalDateMs);\n\n \/\/ Function to convert to iCalendar standard UTC format (YYYYMMDDThhmmssZ)\n const formatIcalDate = (dateObj) => {\n return dateObj.toISOString().replace(\/[-:]\/g, '').split('.')[0] + 'Z';\n };\n\n const icalDateStr = formatIcalDate(receiveDate);\n \n \/\/ Construct VTODO data\n \/\/ Set receipt date\/time to DUE property to recognize it as a deadline\n const vtodoStr = \n`BEGIN:VCALENDAR\\\\r\nVERSION:2.0\\\\r\nPRODID:-\/\/n8n Workflow\/\/Mercari Dispatch\/\/JA\\\\r\nBEGIN:VTODO\\\\r\nUID:mercari-${productId}\\\\r\nDTSTAMP:${icalDateStr}\\\\r\nDUE:${icalDateStr}\\\\r\nSUMMARY:\u3010Shipping\u3011${productName}\\\\r\nDESCRIPTION:Please complete the shipping procedure for the Mercari item.\\\n\\\nProduct ID: ${productId}\\\nPrice: ${productPrice}\\\n\\\nLaunch App: https:\/\/mercari.com\/jp\/launch\/\\\\r\nSTATUS:NEEDS-ACTION\\\\r\nPRIORITY:1\\\\r\nEND:VTODO\\\\r\nEND:VCALENDAR`;\n\n \/\/ Pass extracted variables and generated payload to the next node\n results.push({\n json: {\n productId: productId,\n productName: productName,\n productPrice: productPrice,\n icalData: vtodoStr\n }\n });\n}\n\nreturn results;<\/pre>\n[Important Point for Badge Display]<\/h4>\n
When turning on the setting “Include items due today” in the iPhone Reminders app, the task must have a “Due” date set in order for the uncompleted badge to display on the icon. Therefore, write code that sets the previously converted email receipt date and time to the DUE property of the generated task (VTODO) data.<\/p>\n
Step 3: PUT Tasks to DAViCal via HTTP Request Node<\/h3>\n
Finally, register the created VTODO data to the DAViCal server.
\nUse n8n’s standard “HTTP Request” node and specify PUT as the HTTP method.<\/p>\n
The destination URL is a common stumbling block. Sending a PUT request to the parent folder (collection) will result in a 405 Method Not Allowed error. Be sure to send the request by specifying a unique file name (resource URI) at the end, like https:\/\/[host]\/caldav.php\/[user]\/tasks\/mercari-[productID].ics.
\nAdditionally, because data is sent as plain text rather than JSON, set the Body Content Type to Raw and specify text\/calendar; charset=utf-8 in the header.<\/p>\n
Conclusion<\/h2>\n
Since introducing this automation workflow, notifications and badges automatically appear on my iPhone whenever an item sells on Mercari, making shipping task management dramatically easier.
\nFor those who have a DAViCal server environment, this is a powerful mechanism that can be applied to various use cases, such as e-commerce site notifications or work assignment emails, so please give it a try!<\/p>\n","protected":false},"excerpt":{"rendered":"
Have you ever received the notification email “Please ship your item” when a product sells on Merc […]<\/p>\n","protected":false},"author":4,"featured_media":3860,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"en_US","_original_post":"https:\/\/donguri3.net\/?p=3857","footnotes":""},"categories":[1167],"tags":[52,387,290,10,397],"class_list":["post-5494","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-n8n-automation","tag-https","tag-java","tag-json","tag-server","tag-397","en-US"],"_links":{"self":[{"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/posts\/5494","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=5494"}],"version-history":[{"count":1,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/posts\/5494\/revisions"}],"predecessor-version":[{"id":5497,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/posts\/5494\/revisions\/5497"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/media\/3860"}],"wp:attachment":[{"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/media?parent=5494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/categories?post=5494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/tags?post=5494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}