Bibliothek / Dokumente, PDF & OCR
Dokumente, PDF & OCR
Scope Creep in Gmail-Anfragen gegenüber SOWs mit OpenAI und Google Docs erkennen
Überwacht Gmail auf neue E-Mails von zugeordneten Kundendomains, liest das SOW jedes Kunden aus Google Docs und nutzt OpenAI, um Anfragen zu markieren, die außerhalb des vereinbarten Umfangs liegen.
Was sie bewirkt
## Detect scope creep in client emails against your SOW with Gmail, OpenAI and Google Sheets Who's it for Agencies, consultants and freelancers who lose margin to scope creep. "Can you just quickly add..." emails get done for free because nobody checks them against the contract. How it works 1. A Gmail trigger watches your inbox. Emails from client domains you've mapped to a statement of work (SOW) are picked up; everything else is ignored. 2. The client's SOW is read live from Google Docs, so contract edits apply instantly. 3. OpenAI compares the request with the SOW. It returns a verdict (in scope, out of scope or unclear), the clause it relied on, an effort estimate in hours and a polite change-order reply. Emails that aren't requests are dropped. 4. Every request is logged to a Scope Log sheet with its verdict, estimated hours and value at your rate. That gives you a running ledger of unbilled work per client for renewal and upsell conversations. 5. For out-of-scope or unclear requests, your team gets a Slack alert. The change-order reply is saved as a Gmail draft in the same thread. Nothing is sent without you. How to set up 1. Create a Google Sheet tab named Scope Log with these headers: checked_at, client_domain, from_email, subject, request_summary, verdict, matching_clause, estimated_hours, estimated_value, thread_link. 2. In Configure settings, map each client email domain to its SOW Google Doc URL in client_sow_map. Add the Sheet ID, hourly rate, currency, Slack channel and sign-off name. 3. Connect Gmail (trigger and draft node), Google Docs, Google Sheets, OpenAI and Slack credentials, then activate. Requirements Gmail, Google Docs (one doc per client SOW), Google Sheets, an OpenAI API key and Slack. How to customize - Tune the reply tone in the AI prompt. - Change the trigger's Gmail search to watch a shared client inbox. - Add a monthly summary that totals estimated_value per client from the Scope Log.
Die Schritte
- New client email
- Configure settings
- Match client SOW
- Get client SOW
- Check request against SOW
- OpenAI Chat Model
- Structured Output Parser
- Drop non-requests
- Prepare scope record
- Log to Scope Log
- Needs attention?
- Alert team in Slack
- Save change-order draft
- In scope: logged only
Ähnliche Automatisierungen
E-Mail-AutomatisierungChange-Order-Antworten auf Kundenmails außerhalb des Leistungsumfangs mit Gmail und OpenAI entwerfen11 SchritteTexterstellung & Content-GenerierungStartup-Ideen und Businesspläne mit Claude entwickeln6 SchritteBerichte, Analysen & DashboardsMarktforschungsberichte mit Claude und Perplexity erstellen6 SchritteDokumente, PDF & OCRRFP-Antworten mit OpenAI, Google Docs und Slack entwerfen13 Schritte