{"product_id":"gmail-openai-scope-creep-detection-to-google-sheets-n8n","title":"Gmail + OpenAI Scope Creep Detection to Google Sheets (n8n)","description":"\u003ch3\u003eDetect scope creep in Gmail—automatically compare requests to your SOW with OpenAI, log to Google Sheets, and alert via Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your Gmail inbox for client emails, pulls the correct Statement of Work (SOW) from Google Docs, and uses OpenAI to classify each request as in-scope or potential scope creep. Every result is logged in Google Sheets, with Slack alerts and a ready-to-send Gmail draft when clarification or change-order language is needed.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers every minute\u003c\/strong\u003e on new Gmail messages that match your configured search query.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches the sender domain\u003c\/strong\u003e to your \u003cem\u003eclient_sow_map\u003c\/em\u003e (JSON). Emails from unmapped domains are ignored.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches SOW content from Google Docs\u003c\/strong\u003e using the mapped SOW URL and sends it—along with the email content—to \u003cstrong\u003eOpenAI\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns a structured verdict\u003c\/strong\u003e (in-scope vs out-of-scope\/unclear), including \u003cem\u003eclause citation\u003c\/em\u003e, an \u003cem\u003eeffort estimate\u003c\/em\u003e, and a \u003cem\u003edraft reply\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters non-requests\u003c\/strong\u003e: messages classified as \u003ccode\u003enot_a_request\u003c\/code\u003e are skipped from logging details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs to Google Sheets\u003c\/strong\u003e by appending a record to a tab named \u003cstrong\u003e“Scope Log”\u003c\/strong\u003e, including an estimated hours\/value based on your hourly rate and a direct \u003cstrong\u003eGmail thread link\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack + Gmail draft for unclear\/out-of-scope\u003c\/strong\u003e: if the verdict is \u003cem\u003eout_of_scope\u003c\/em\u003e or unclear, the workflow posts an alert to Slack and creates a Gmail draft reply in the same thread; otherwise it only logs the in-scope request.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eStop late-stage budget surprises by flagging potential scope creep as soon as a client asks.\u003c\/li\u003e\n  \u003cli\u003eStandardize change-order replies with AI-generated draft language backed by SOW clauses.\u003c\/li\u003e\n  \u003cli\u003eMaintain an auditable history of requests, verdicts, estimated effort, and thread links in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n integrations\u003c\/strong\u003e: Gmail, Google Docs, Google Sheets, Slack, OpenAI.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic nodes\u003c\/strong\u003e mentioned: if, set, code, no op (plus the Gmail\/Slack\/Docs\/Sheets nodes).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfiguration required\u003c\/strong\u003e: connect credentials, set \u003cem\u003esheet_id\u003c\/em\u003e, ensure the \u003cstrong\u003e“Scope Log”\u003c\/strong\u003e tab exists, and update \u003cstrong\u003eclient_sow_map\u003c\/strong\u003e to map client email domains to SOW Google Docs URLs.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46217913041075,"sku":"N8N-20840","price":61.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/4iENRcl4d1-rObbqsH3SK_0V6OB4Mq.png?v=1791882767","url":"https:\/\/buyflowscripts.com\/products\/gmail-openai-scope-creep-detection-to-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}