{"product_id":"n8n-overtime-limits-tracker-forms-to-google-sheets-slack","title":"n8n Overtime Limits Tracker: Forms to Google Sheets \u0026 Slack","description":"\u003ch3\u003eTrack monthly overtime, calculate limits, and get Slack warnings automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures employee overtime and holiday work via an \u003cstrong\u003en8n Form\u003c\/strong\u003e, stores it in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, then checks every Monday for anyone nearing monthly, rolling-average (2–6 months), or annual overtime limits—posting per-employee alerts (or an all-clear) to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects submissions\u003c\/strong\u003e: Receives monthly hours from an n8n Form, including employee details, the month, overtime hours, and holiday work hours.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and normalizes input\u003c\/strong\u003e: Normalizes the data, generates a per-employee-per-month key, verifies month format and hour ranges, and returns clear plain-language errors back to the form when invalid.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites to Google Sheets\u003c\/strong\u003e: Saves valid entries into the \u003cstrong\u003eMonthlyHours\u003c\/strong\u003e tab, appending or updating the same row so resubmissions for the same employee and month overwrite prior values.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly limit checks\u003c\/strong\u003e: Every Monday morning, reads all rows from MonthlyHours and calculates remaining capacity against:\n    \u003cul\u003e\n      \u003cli\u003ethe configured \u003cstrong\u003emonthly combined cap\u003c\/strong\u003e,\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003erolling-average caps\u003c\/strong\u003e across 2–6 months (skipping averages when months are missing), and\u003c\/li\u003e\n      \u003cli\u003ethe \u003cstrong\u003eannual overtime cap\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies Slack and logs results\u003c\/strong\u003e: If someone is below the configured threshold, posts a \u003cstrong\u003eper-employee warning\u003c\/strong\u003e to a Slack channel and appends the details to a \u003cstrong\u003eWarningLog\u003c\/strong\u003e tab in Google Sheets. If nobody is close, posts a one-line confirmation in Slack.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eHR\/ops teams monitoring overtime compliance without manual spreadsheet review.\u003c\/li\u003e\n  \u003cli\u003eTeams using n8n automation to centralize overtime reporting with Slack alerts.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who need scheduled limit monitoring and audit-friendly logging 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\u003cstrong\u003en8n Form\u003c\/strong\u003e for collecting monthly overtime and holiday work submissions\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e via OAuth2 (MonthlyHours + WarningLog tabs)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e via OAuth2 for warning messages and weekly all-clear\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic implemented with nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eform\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, and \u003cstrong\u003esplit out\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45994965794995,"sku":"N8N-19436","price":57.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Q2FADi71ub2IiJGTeW3D0_GdSZvM7Y.png?v=1789030990","url":"https:\/\/buyflowscripts.com\/products\/n8n-overtime-limits-tracker-forms-to-google-sheets-slack","provider":"N8N Commerce","version":"1.0","type":"link"}