This book practically brings you the easy-to-follow solutions wherein you can connect AI-driven automation to everyday business tools using Model Context Protocol (MCP), with Microsoft Excel and Word as the primary execution and delivery surfaces. This book focuses on practical integration patterns that developers and technical teams can apply directly in real business environments. You won't find any discussions of model internals or theoretical AI concepts here.
The book presents a structured approach to building governed, auditable workflows. It shows how Excel rows act as requests, YAML playbooks define execution logic, and tools such as Jira, databases, document repositories, and reporting systems are integrated through well-defined contracts. We use Microsoft Word as a controlled output surface for reports and deliverables. There are audit logs and approval mechanisms in place to ensure transparency and traceability throughout the workflow lifecycle. I will guide you through designing MCP tool contracts, mapping Excel columns to tool arguments, normalizing results for analytics, and shaping outputs for Excel and Power BI. In this book, you will learn to implement safety patterns such as idempotency, retries, policy allowlists, tenant isolation, and least-privilege access. It includes practical chapters on connector development, authentication and secrets handling, governance controls, diagnostics, testing strategies, and deployment patterns for both scheduled and on-demand execution.
I strongly recommend this book to developers, platform engineers, and technical architects who work with Microsoft 365. These professionals will learn to integrate AI-assisted workflows into existing business processes without unnecessary complexity.
Key LearningsTurn Excel and Word into powerful AI-driven control and delivery hubs for business automation.
Automate business workflows with AI Agents without exposing users, model internals and LLMs.
Build predictable, auditable, and reusable automation using tool contracts and playbooks.
Trigger real business actions across Jira, databases, and documents using Excel and Word.
Make use of YAML playbooks to transform multi-step business processes into workflows.
Make use of audit logs, approvals, and correlation IDs to execute transparent and compliant AI actions.
Prevent duplicate actions using idempotency and request tracking.
Practice versioning, policies, and strict access controls for scaling MCP connectors.
Table of ContentMCP and Agent Primer
Microsoft 365 Project Blueprint
Tool Contracts for Excel and Word Automation
Building MCP Connectors as Business Actions
Authentication and Secrets for Microsoft 365 and SaaS
Governance, Approvals, and Audit Trails
Workflow Runner with YAML Playbooks
Jira Connector with Excel Requests
Data and Knowledge Connectors
Shipping MCP Integrations across Microsoft 365 Teams
外文書商品之書封，為出版社提供之樣本。實際出貨商品，以出版社所提供之現有版本為主。部份書籍，因出版社供應狀況特殊，匯率將依實際狀況做調整。
無庫存之商品，在您完成訂單程序之後，將以空運的方式為你下單調貨。為了縮短等待的時間，建議您將外文書與其他商品分開下單，以獲得最快的取貨速度，平均調貨時間為1~2個月。
為了保護您的權益，「三民網路書店」提供會員七日商品鑑賞期(收到商品為起始日)。
若要辦理退貨，請在商品鑑賞期內寄回，且商品必須是全新狀態與完整包裝(商品、附件、發票、隨貨贈品等)否則恕不接受退貨。
