{"product_id":"detect-scope-creep-with-gmail-gemini-in-n8n-docs-sheets","title":"Detect Scope Creep with Gmail \u0026 Gemini in n8n (Docs\/Sheets)","description":"\u003ch3\u003eSpot scope creep in client email—automatically (Gmail + Gemini in n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors labeled client emails in \u003cstrong\u003eGmail\u003c\/strong\u003e, compares requests to each active project’s approved \u003cstrong\u003escope of work\u003c\/strong\u003e stored in \u003cstrong\u003eGoogle Docs\u003c\/strong\u003e, and uses \u003cstrong\u003eGemini\u003c\/strong\u003e to recommend whether every request is \u003cem\u003ein scope\u003c\/em\u003e, a \u003cem\u003echange request\u003c\/em\u003e, or needs \u003cem\u003ehuman review\u003c\/em\u003e. When ambiguity or unsupported items appear, it logs the result in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and creates \u003cstrong\u003eunsent Gmail drafts\u003c\/strong\u003e for manual follow-up.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEvery five minutes\u003c\/strong\u003e, checks Gmail for incoming messages with the configured \u003cem\u003escope-review label\u003c\/em\u003e, excluding already processed, sent mail, and drafts.\u003c\/li\u003e\n  \u003cli\u003eUses Gmail message ID to search \u003cstrong\u003eScope_Requests\u003c\/strong\u003e in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e to prevent duplicate routine processing.\u003c\/li\u003e\n  \u003cli\u003eLoads the full email, removes quoted replies where possible, and validates the sender and new message content.\u003c\/li\u003e\n  \u003cli\u003eMatches the sender to \u003cstrong\u003eexactly one active project\u003c\/strong\u003e in the \u003cstrong\u003eProjects\u003c\/strong\u003e sheet, then retrieves that project’s approved statement of work from \u003cstrong\u003eGoogle Docs\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCalls \u003cstrong\u003eGemini\u003c\/strong\u003e to extract individual requests and suggest one of: \u003cstrong\u003eIN_SCOPE\u003c\/strong\u003e, \u003cstrong\u003eCHANGE_REQUEST_REQUIRED\u003c\/strong\u003e, or \u003cstrong\u003eNEEDS_HUMAN_REVIEW\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCode verifies cited text exists in the approved scope; unsupported classifications are escalated for \u003cstrong\u003ehuman review\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eWrites the overall decision, request details, supporting quotes, and processing status to Google Sheets; if drafts are enabled, creates an \u003cstrong\u003eunsent Gmail draft\u003c\/strong\u003e when review is needed.\u003c\/li\u003e\n  \u003cli\u003eSupports audit-style behavior when inputs are missing or provider handling errors occur (including attempts to record a \u003cstrong\u003eNOT_ASSESSED\u003c\/strong\u003e status).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAgencies\/Freelancers quickly triaging “can you also…” emails against the approved SOW.\u003c\/li\u003e\n  \u003cli\u003eReducing manual effort by routing only ambiguous or non-matching requests to human reviewers.\u003c\/li\u003e\n  \u003cli\u003eMaintaining an auditable trail in Google Sheets for scope decisions and supporting quotes.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/integrations:\u003c\/strong\u003e \u003ccode\u003egmail\u003c\/code\u003e, \u003ccode\u003egoogle docs\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eswitch\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, and logic to work with \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore behavior:\u003c\/strong\u003e label-driven Gmail polling, message-ID deduplication, Gemini-assisted scope classification, scope-text verification, and unsent Gmail drafts when \u003cstrong\u003ehuman review\u003c\/strong\u003e is required.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46206052335795,"sku":"N8N-20781","price":37.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/vHtxEgltECFqVp3wT-Yem_rBef7rnj.png?v=1791796129","url":"https:\/\/buyflowscripts.com\/products\/detect-scope-creep-with-gmail-gemini-in-n8n-docs-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}