{"product_id":"n8n-workflow-track-mandatory-paid-leave-with-gemini-gmail-slack","title":"n8n Workflow: Track Mandatory Paid Leave with Gemini, Gmail \u0026 Slack","description":"\u003ch3\u003eTrack Mandatory Paid Leave Risk and Notify Employees Automatically (Gemini + Gmail + Slack)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks Japan’s mandatory paid-leave minimum each month, identifies employees at risk of falling short, generates Japanese reminders with \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, sends them via \u003cstrong\u003eGmail\u003c\/strong\u003e, and posts an HR summary to \u003cstrong\u003eSlack\u003c\/strong\u003e—while logging every notification back to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns monthly:\u003c\/strong\u003e scheduled for the \u003cstrong\u003efirst day of each month\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads employee and leave data:\u003c\/strong\u003e loads the employee roster and paid-leave records from two tabs in your Google Sheets workbook (expected tabs: \u003cem\u003eEmployees\u003c\/em\u003e and \u003cem\u003eLeaveLog\u003c\/em\u003e), then combines the data by \u003cstrong\u003eemployeeId\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates leave shortfall:\u003c\/strong\u003e for each \u003cstrong\u003eactive\u003c\/strong\u003e employee, it calculates the current leave-year grant date, deadline, days taken, and remaining shortfall against the required minimum.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters who needs action:\u003c\/strong\u003e keeps only employees who still have a shortfall and whose deadline is within the configured \u003cstrong\u003ealert window\u003c\/strong\u003e (via \u003cstrong\u003ealertBeforeDays\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates Japanese messages:\u003c\/strong\u003e uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to produce:\n    \u003cul\u003e\n      \u003cli\u003ea short employee-friendly Japanese reminder\u003c\/li\u003e\n      \u003cli\u003ea one-line Japanese HR summary\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies and logs:\u003c\/strong\u003e sends the employee reminder through \u003cstrong\u003eGmail\u003c\/strong\u003e, posts the HR summary to \u003cstrong\u003eSlack\u003c\/strong\u003e, and appends a notification record to the \u003cem\u003eNotificationLog\u003c\/em\u003e tab in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eHR teams using n8n want automated, monthly reminders for employees approaching Japan mandatory paid-leave deadlines.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators and automation engineers need a reliable workflow with Gemini-generated Japanese copy, plus audit logging in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eCompanies centralizing leave tracking in Google Sheets and routing employee + HR updates via Gmail and Slack.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ tools:\u003c\/strong\u003e \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003emerge\u003c\/em\u003e, \u003cem\u003efilter\u003c\/em\u003e, \u003cem\u003egmail\u003c\/em\u003e, \u003cem\u003eslack\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, \u003cstrong\u003eGoogle Gemini (PaLM) API\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, and \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired setup:\u003c\/strong\u003e credentials for Sheets, Gemini (PaLM) API, Gmail, and Slack; spreadsheet ID; expected tabs (\u003cem\u003eEmployees\u003c\/em\u003e, \u003cem\u003eLeaveLog\u003c\/em\u003e, \u003cem\u003eNotificationLog\u003c\/em\u003e); configuration for \u003cstrong\u003egrantMethod\u003c\/strong\u003e, \u003cstrong\u003efixedGrantMonthDay\u003c\/strong\u003e (if used), \u003cstrong\u003erequiredDays\u003c\/strong\u003e, \u003cstrong\u003ealertBeforeDays\u003c\/strong\u003e, and the target Slack channel name.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45931125440691,"sku":"N8N-18953","price":20.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ylFatx31qTI2vO6Y3uHIH_rvDXFyym.png?v=1788254302","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-track-mandatory-paid-leave-with-gemini-gmail-slack","provider":"N8N Commerce","version":"1.0","type":"link"}