{"product_id":"safety-inspections-automation-with-n8n-deepseek-sheets-gmail-telegram","title":"Safety Inspections Automation with n8n + DeepSeek, Sheets, Gmail, Telegram","description":"\u003ch3\u003eAutomate Safety Inspections End-to-End with n8n + DeepSeek, Google Sheets, Gmail \u0026amp; Telegram\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically captures safety inspection submissions, uses DeepSeek (via the OpenAI API) to generate corrective actions for any “not Pass” items, logs everything in Google Sheets, and sends critical alerts, overdue reminders, and a weekly digest through Telegram and Gmail.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIngests inspection submissions\u003c\/strong\u003e from an \u003cstrong\u003en8n form\u003c\/strong\u003e, capturing statuses and notes for four safety areas.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates required fields\u003c\/strong\u003e and immediately notifies you via \u003cstrong\u003eTelegram\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e if anything is missing (invalid-submission alert).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates corrective actions with DeepSeek\u003c\/strong\u003e (OpenAI API): non-pass results are converted into \u003cem\u003estructured\u003c\/em\u003e corrective actions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses and validates AI output\u003c\/strong\u003e, calculates due dates and severity counts, and creates a \u003cstrong\u003ecritical-findings list\u003c\/strong\u003e when applicable.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs results to Google Sheets\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eAppends inspection summaries to the \u003cstrong\u003eInspections\u003c\/strong\u003e tab.\u003c\/li\u003e\n      \u003cli\u003eAppends each corrective action to the \u003cstrong\u003eCorrectiveActions\u003c\/strong\u003e tab.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends immediate critical alerts\u003c\/strong\u003e to Telegram and a detailed email report via Gmail when critical findings exist.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily overdue monitoring\u003c\/strong\u003e: checks Google Sheets for overdue open corrective actions and sends overdue reminders via Telegram and Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly reporting\u003c\/strong\u003e: computes inspection\/action stats from Google Sheets, uses DeepSeek to draft a short digest, and sends it to Telegram and Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack workplace or site safety checks across locations with consistent logging and follow-up.\u003c\/li\u003e\n  \u003cli\u003eConvert “Not Pass” inspection findings into actionable corrective plans automatically.\u003c\/li\u003e\n  \u003cli\u003eReduce missed follow-ups with daily overdue reminders and weekly performance digests.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeepSeek via OpenAI API\u003c\/strong\u003e to generate structured corrective actions and weekly digest.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e integration (Inspections + CorrectiveActions tabs).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail OAuth2\u003c\/strong\u003e for email alerts and reports.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram\u003c\/strong\u003e notifications for invalid submissions, critical alerts, overdue reminders, and weekly digests.\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic uses nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, \u003cstrong\u003esplit out\u003c\/strong\u003e, and related parsing\/validation steps.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup\u003c\/strong\u003e requires credentials for Google Sheets, OpenAI API (DeepSeek model), Gmail OAuth2, and Telegram.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45917697605811,"sku":"N8N-18761","price":12.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/JsOZncn5G3S-FQ1Fb2HRf_pw2Ae6r3.png?v=1788080825","url":"https:\/\/buyflowscripts.com\/products\/safety-inspections-automation-with-n8n-deepseek-sheets-gmail-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}