{"product_id":"n8n-qsr-health-inspection-automation-openai-gmail-digests","title":"n8n QSR Health Inspection Automation: OpenAI + Gmail Digests","description":"\u003ch3\u003eAutomate QSR Health Inspection Follow-Ups—Daily with OpenAI + Gmail Digests\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow ingests multi-location QSR health inspection notes every day, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to extract violation severity and corrective actions, logs everything to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends \u003cstrong\u003eGmail\u003c\/strong\u003e digests—with conditional escalation alerts based on a computed regional risk score.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 07:00\u003c\/strong\u003e via a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses multi-location notes\u003c\/strong\u003e: loads a batch of raw inspection notes, then splits them into \u003cem\u003eone record per location\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies OpenAI extraction\u003c\/strong\u003e: the Information Extractor classifies each location’s note into a \u003cstrong\u003eviolation category, severity, code section,\u003c\/strong\u003e and a \u003cstrong\u003erecommended corrective action\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes corrective deadlines\u003c\/strong\u003e by severity:\n    \u003cul\u003e\n      \u003cli\u003eCritical → \u003cstrong\u003e10 days\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eMajor → \u003cstrong\u003e30 days\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eMinor → \u003cstrong\u003e90 days\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs compliance data\u003c\/strong\u003e by appending each location’s detailed result to the Google Sheets \u003cstrong\u003e“Compliance Log”\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a regional rollup\u003c\/strong\u003e: aggregates processed locations into a \u003cstrong\u003eregional risk score\u003c\/strong\u003e and an \u003cstrong\u003eescalation flag\u003c\/strong\u003e, then appends a daily summary row to \u003cstrong\u003e“Compliance Summary”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends Gmail notifications\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eAn \u003cstrong\u003eescalation alert email\u003c\/strong\u003e if thresholds are exceeded\u003c\/li\u003e\n      \u003cli\u003eA \u003cstrong\u003econsolidated daily digest\u003c\/strong\u003e with per-location deadlines (regardless of escalation)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCentralized tracking of \u003cstrong\u003eQSR health inspections\u003c\/strong\u003e across many locations with standardized severity and corrective action reporting.\u003c\/li\u003e\n  \u003cli\u003eAutomatic daily compliance reporting to operations teams, including deadline visibility for every site.\u003c\/li\u003e\n  \u003cli\u003eEscalation when regional risk is high—so urgent corrective work gets attention faster.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e (via the Information Extractor) for violation severity, category, code section, and corrective action extraction.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e OAuth2 for appending to \u003cstrong\u003eCompliance Log\u003c\/strong\u003e and \u003cstrong\u003eCompliance Summary\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e OAuth2 for escalation emails and the consolidated daily digest.\u003c\/li\u003e\n  \u003cli\u003eWorkflow nodes include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, and \u003cstrong\u003esplit out\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003ePerfect for n8n automation engineers and SaaS operators who want a reliable, daily \u003cstrong\u003eQSR compliance\u003c\/strong\u003e workflow with OpenAI-powered extraction and Gmail-based communication.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938194776243,"sku":"N8N-19037","price":77.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/5H0BDRwebxq44G7h26jjx_abPdcLiM.png?v=1788340136","url":"https:\/\/buyflowscripts.com\/products\/n8n-qsr-health-inspection-automation-openai-gmail-digests","provider":"N8N Commerce","version":"1.0","type":"link"}