Google Sheets - OpenText Decision Service Integration and Automation

Common Integration Use Cases Between Google Sheets and OpenText Decision Service

• Business rule maintenance from Google Sheets to OpenText Decision Service
  Business teams maintain decision tables, thresholds, and eligibility criteria in Google Sheets, where subject matter experts can review and update values without technical support. The approved sheet data is then synchronized into OpenText Decision Service to publish updated rules for pricing, credit approval, fraud screening, or case prioritization. This reduces dependency on developers and shortens the time needed to change operational policies.
• Policy review and approval workflow for rule changes
  Google Sheets is used as a controlled workspace for drafting new rules, comparing versions, and capturing stakeholder comments before deployment. Once the business and compliance teams approve the content, the finalized rule set is pushed into OpenText Decision Service. This supports auditability, improves governance, and ensures that only validated rules are activated in production.
• Exception handling and manual decision support
  OpenText Decision Service evaluates transactions and flags exceptions that require human review, such as borderline loan applications or unusual claims. Exception records are written to Google Sheets for operations teams to triage, annotate, and assign follow up actions. After review, the updated disposition can be sent back to OpenText Decision Service or the downstream workflow system to continue processing.
• Decision outcome reporting and rule performance analysis
  OpenText Decision Service outputs decision results, rule hits, and exception statistics into Google Sheets for business analysis. Teams use the spreadsheet to monitor approval rates, rejection reasons, turnaround times, and policy impact across regions or product lines. This gives operations and compliance teams a simple reporting layer for identifying rule tuning opportunities.
• Customer or case prioritization using spreadsheet maintained scoring criteria
  Operations teams maintain prioritization factors in Google Sheets, such as service level targets, customer segment weights, or case severity thresholds. OpenText Decision Service consumes these values to automatically assign priority levels to service tickets, claims, or leads. This helps teams adapt prioritization logic quickly when business conditions change.
• Product, pricing, or eligibility rule distribution across teams
  Commercial teams manage product eligibility matrices, discount bands, or regional pricing rules in Google Sheets during planning cycles. OpenText Decision Service uses the approved spreadsheet data to enforce consistent decisions across sales portals, order management, or customer service applications. This ensures that all channels apply the same business logic without manual interpretation.
• Controlled testing of new decision logic before production release
  Analysts use Google Sheets to simulate proposed rule changes by testing sample cases, comparing expected outcomes, and documenting edge cases. The same data set is then used to validate the corresponding logic in OpenText Decision Service before deployment. This improves quality assurance and reduces the risk of incorrect rule activation.
• Cross functional governance for regulated decision processes
  Google Sheets serves as a shared governance register for rule owners, approvers, effective dates, and policy references. OpenText Decision Service executes the approved logic while the spreadsheet provides a business friendly control record for audits and periodic reviews. This is especially useful in regulated environments such as lending, insurance, healthcare, and public sector case management.