{"product_id":"n8n-sop-training-checklist-quiz-automation-drive-gemini-gmail","title":"n8n SOP Training Checklist \u0026 Quiz Automation: Drive, Gemini, Gmail","description":"\u003ch3\u003eTurn new SOPs into training checklists \u0026amp; quizzes automatically—then route them for approval\u003c\/h3\u003e\n\u003cp\u003eThis n8n SOP Training Checklist \u0026amp; Quiz Automation workflow watches your \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e folder for new Google Docs SOPs, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to draft a checklist and multiple-choice quiz, and sends the results to a reviewer via \u003cstrong\u003eGmail\u003c\/strong\u003e—while tracking every approval decision in \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\u003eMonitors Google Drive\u003c\/strong\u003e for newly created SOP Google Docs files in a specified folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts and validates SOP text\u003c\/strong\u003e from Google Docs, checking that content exists and meets a minimum length. If invalid, it emails the reviewer via Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a draft\u003c\/strong\u003e with \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, producing a training checklist and a multiple-choice quiz in the configured language.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates Gemini’s JSON output\u003c\/strong\u003e, including checklist length, question structure, and evidence quotes that must exist verbatim in the SOP. If validation fails, it emails the reviewer requesting corrections.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicate reviews\u003c\/strong\u003e by checking \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for an existing record for the same document ID (including prior decisions or pending review).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves valid drafts\u003c\/strong\u003e to a review tab (e.g., “Training Reviews”) and emails a formatted approval request with \u003cstrong\u003eApprove\/Reject\u003c\/strong\u003e actions via Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates review status\u003c\/strong\u003e in the same sheet row as \u003cstrong\u003eApproved\u003c\/strong\u003e, \u003cstrong\u003eRejected\u003c\/strong\u003e, or \u003cstrong\u003eTimed out after 7 days\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eConvert each new SOP Google Doc into a ready-to-review training checklist and quiz for onboarding.\u003c\/li\u003e\n  \u003cli\u003eStandardize quiz quality by enforcing Gemini JSON validation with SOP verbatim evidence quotes.\u003c\/li\u003e\n  \u003cli\u003eStreamline review workflows for SaaS operators and automation engineers with an auditable Google Sheets history.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers\/Logic:\u003c\/strong\u003e Google Drive file-created trigger, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Drive, Google Docs, Google Sheets, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow notes:\u003c\/strong\u003e uses a \u003cem\u003eSticky Note\u003c\/em\u003e for setup guidance\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore behavior:\u003c\/strong\u003e data validation, Gemini JSON parsing\/validation, deduplication by document ID, and 7-day timeout updates\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup tip:\u003c\/strong\u003e Connect Google Drive, Google Docs, Google Sheets, Gmail, and Google Gemini credentials, then set the Drive folder ID that contains SOP Google Docs and configure your review tab columns (e.g., “Training Reviews”).\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46289030119603,"sku":"N8N-21666","price":52.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/RUjImdoWC0_FYLxOwo5oU_cJbAJxho.png?v=1793005988","url":"https:\/\/buyflowscripts.com\/products\/n8n-sop-training-checklist-quiz-automation-drive-gemini-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}