{"product_id":"n8n-workflow-japan-business-day-contract-deadlines-sheets-claude-slack","title":"n8n Workflow: Japan Business-Day Contract Deadlines (Sheets, Claude, Slack)","description":"\u003ch3\u003eTurn contract deadline wording into Japan-aware deadlines—then notify your team in Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically reads contract-style deadline text from a Google Sheet, uses Anthropic Claude to convert new wording into a structured rule, calculates Japan business-day deadlines (respecting weekends and national holidays), writes the results back to Sheets, and sends due\/overdue reminders to Slack.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns daily at 8:00\u003c\/b\u003e (or can be triggered manually) to start the deadline check.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReads open items\u003c\/b\u003e from the Google Sheets \u003ci\u003e“Deadlines”\u003c\/i\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLoads Japan national holidays\u003c\/b\u003e from the \u003cb\u003eCabinet Office holiday CSV\u003c\/b\u003e to ensure business-day calculations are Japan-aware.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends only updated wording\u003c\/b\u003e (new or changed deadline phrasing) to \u003cb\u003eAnthropic Claude\u003c\/b\u003e to extract a JSON rule (e.g., type, number\/month, and holiday-adjustment direction) without calculating dates in Claude.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eValidates the extracted rule\u003c\/b\u003e against the original wording.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eComputes each deadline\u003c\/b\u003e and \u003cb\u003eremaining business days\u003c\/b\u003e by skipping weekends, national holidays, and any \u003cb\u003econfigured company holidays\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUpdates the sheet\u003c\/b\u003e with the stored rule, computed deadline, business-days-left, and any \u003cb\u003e“Needs review”\u003c\/b\u003e issues.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePosts a Slack summary\u003c\/b\u003e for overdue, due today, due soon (within the configured business-day window), and rows needing review—only when there’s something to report.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack “X business days after …” language in contracts and auto-calculate Japan-adjusted due dates.\u003c\/li\u003e\n  \u003cli\u003eOperationally monitor obligations (renewals, deliverables, notices) with automated Slack reminders.\u003c\/li\u003e\n  \u003cli\u003eReduce manual deadline interpretation by converting natural language into a consistent rule stored in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e (read\/write the \u003ci\u003eDeadlines\u003c\/i\u003e tab)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAnthropic Claude\u003c\/b\u003e (extract JSON deadline rules from changed wording)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCabinet Office holiday CSV\u003c\/b\u003e (Japan national holiday data)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSlack\u003c\/b\u003e (due\/overdue notifications)\u003c\/li\u003e\n  \u003cli\u003en8n nodes include: \u003cb\u003eif, set, code, merge, slack, sticky note\u003c\/b\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46244569120947,"sku":"N8N-21084","price":78.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ADzsZPrqsiM3w0SIxwqB-_7ZAGbQ2V.png?v=1792402265","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-japan-business-day-contract-deadlines-sheets-claude-slack","provider":"N8N Commerce","version":"1.0","type":"link"}