Manage QA CAPA lifecycle with Google Sheets, Gmail, and Google Gemini

Quick overview This workflow collects QA/QC audit findings via an n8n form, uses Google Gemini to assess severity and CAPA need, and then tracks CAPAs in Google Sheets while sending assignment, verification, closure, and rework notifications through Gmail. How it works 1. Receives a new QA/QC finding submission through an n8n form trigger. 2. Generates a unique finding ID, normalizes the submitted fields, and sends the finding details to Google Gemini to determine category, risk level, severity score, CAPA requirement, and recommended actions. 3. If CAPA is not required, appends the decision and rationale to a Google Sheets “NoCAPALog” tab for audit trail purposes. 4. If CAPA is required, creates a CAPA entry in the Google Sheets “CAPALog”, assigns an owner based on the department, calculates a due date based on assessed risk, and updates the CAPA record to “Assigned.” 5. Looks up the assigned owner’s email address from a Google Sheets “OwnerDirectory” tab, sends a CAPA assignment email via Gmail, and logs the send status back to the CAPA log. 6. When the CAPA owner submits completion notes and evidence via a second n8n form, updates the CAPA record in Google Sheets to “Awaiting QA Verification” and emails the QA team to review the submission. 7. When QA submits a verification decision via a third n8n form, updates the CAPA record in Google Sheets to either “Closed” (and emails a closure notice) or “Rework Required” (and emails a rework request and logs the notification). Setup 1. Create and connect Google Sheets OAuth credentials, and ensure the spreadsheet contains the tabs and columns used by the workflow (CAPALog, OwnerDirectory, and NoCAPALog, including matching keys like CAPAID and Department). 2. Add Google Gemini (Google AI) credentials for the assessment step. 3. Add Gmail credentials and replace placeholder recipients (for example, [email protected] and [email protected]) with your real QA team and owner directory email addresses. 4. Populate the OwnerDirectory sheet with Department-to-email mappings (for example, a CAPAOwnerEmail column) so assignments and rework notifications can be addressed correctly. 5. Publish the three n8n forms and share their URLs with your reporters, CAPA owners, and QA verifiers so each stage (finding, evidence, verification) can be submitted.