撠?: n8n + AI ?芸???擃葫閰阡勗 - Luke????/title> <meta name="description" content="撅內憒??? n8n ??AI ?銵??芸??游?憭?皞????蝎曄???擃?鞈芷勗嚗?蝜??ˊ雿?蝔器摨????> <link rel="canonical" href="https://lukehou.com/projects/qa-report-automation.html"> <meta property="og:type" content="website"> <meta property="og:url" content="https://lukehou.com/projects/qa-report-automation.html"> <meta property="og:title" content="撠?: n8n + AI ?芸???擃葫閰阡勗 - Luke????> <meta property="og:description" content="撅內憒??? n8n ??AI ?銵??芸??游?憭?皞????蝎曄???擃?鞈芷勗嚗?蝜??ˊ雿?蝔器摨????> <meta property="og:image" content="https://lukehou.com/images/qa-report-automation-main.png"> <meta property="og:site_name" content="Luke Hou"> <meta name="twitter:card" content="summary_large_image"> <meta name="twitter:title" content="撠?: n8n + AI ?芸???擃葫閰阡勗 - Luke????> <meta name="twitter:description" content="撅內憒??? n8n ??AI ?銵??芸??游?憭?皞????蝎曄???擃?鞈芷勗嚗?蝜??ˊ雿?蝔器摨????> <meta name="twitter:image" content="https://lukehou.com/images/qa-report-automation-main.png"> <meta name="keywords" content="n8n, AI, ?芸???? 頠?皜祈岫, QA, Jira, ?豢??游?, Luke Hou, 靘臭???> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet"> <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.5/font/bootstrap-icons.css"> <link rel="stylesheet" href="../css/style.css">  <script async src="https://www.googletagmanager.com/gtag/js?id=G-0V2L1DQVPY"></script> <script> window.dataLayer = window.dataLayer || []; function gtag() { dataLayer.push(arguments); } gtag('js', new Date()); gtag('config', 'G-0V2L1DQVPY'); </script> <style> .project-hero { background: linear-gradient(rgba(0, 0, 0, 0.5), rgba(0, 0, 0, 0.5)), url('../images/qa-report-automation-main.png') no-repeat center center; background-size: cover; padding: 4rem 0; color: white; } .project-hero h1 { font-weight: 700; } .summary-card { position: sticky; top: 20px; } .tech-badge { font-size: 0.9rem; margin-right: 0.5rem; margin-bottom: 0.5rem; } .gallery-img { cursor: pointer; transition: transform 0.2s; } .gallery-img:hover { transform: scale(1.05); } .floating-toggle-btn { position: fixed; top: 50%; right: 0; transform: translateY(-50%); z-index: 1050; writing-mode: vertical-rl; text-orientation: mixed; padding: 1rem 0.5rem; border-top-right-radius: 0; border-bottom-right-radius: 0; box-shadow: -2px 2px 5px rgba(0, 0, 0, 0.2); } </style> </head> <body> <a href="qa-report-automation-business.html" class="btn btn-primary floating-toggle-btn" title="???喳?璆剛?閫牧??> <i class="bi bi-briefcase-fill"></i> ?平閬?隤芣? </a> <header> <nav class="navbar navbar-expand-lg navbar-dark bg-dark"> <div class="container"> <a class="navbar-brand" href="../index.html">Luke Hou</a> <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation"> <span class="navbar-toggler-icon"></span> </button> <div class="collapse navbar-collapse" id="navbarNav"> <ul class="navbar-nav ms-auto"> <li class="nav-item"><a class="nav-link" href="../index.html">擐?</a></li> <li class="nav-item"><a class="nav-link" href="../tutorials.html">?飛</a></li> <li class="nav-item"><a class="nav-link" href="../portfolio.html">雿?</a></li> <li class="nav-item"><a class="nav-link" href="../blog.html">?澈</a></li> </ul> </div> </div> </nav> </header> <main> <section class="project-hero text-center"> <div class="container"> <h1 class="display-4">n8n + AI嚗?擃葫閰阡勗?刻????/h1> <p class="lead">銝???蝟餌絞?豢??誑 AI 撽???n8n ?芸????獢????銴ˊ鞎潔??丐擳?/p> </div> </section> <section class="container mt-5"> <div class="row">  <div class="col-lg-8"> <div class="card border-0 bg-transparent"> <div class="card-body">  <div class="row g-4 mb-5"> <div class="col-md-6"> <div class="glass-card h-100 p-4" style="border-left: 4px solid #ef4444;"> <h3 class="h4 text-danger mb-3"><i class="bi bi-fire me-2"></i>The Challenge </h3> <p class="text-gray"> ?葫閰行??賢 Jira?xcel 蝑??像?堆?瘥梢?鈭箏極???舐蜇?ˊ????蝜銝??粹嚗PI ?游?銴?摨阡??? </p> </div> </div> <div class="col-md-6"> <div class="glass-card h-100 p-4" style="border-left: 4px solid #22c55e;"> <h3 class="h4 text-success mb-3"><i class="bi bi-check-circle-fill me-2"></i>The Solution</h3> <p class="text-gray"> ?身閮?n8n ?芸??極雿?嚗葡??Jira API ??Google Sheets???LLM ?脰??豢????◢?芸霈嚗????HTML ?澆??移蝢勗?? </p> </div> </div> </div> <h2 class="card-title h3 mb-3"><i class="bi bi-card-text me-2"></i>?璁膩</h2> <p>撠頠?皜祈岫????嚗ˊ雿勗?臭???閬?璆萄蝜?遙???賢 Jira?葫閰行?靘恣?頂蝯晞xcel 銵冽蝑??像?堆?瘥活?賡?閬鞎餃之???脰??舐蜇?絞閮?鋆賢???/p> <p>?箔?閫?捱????函???嚗?閮剛?銝血祕雿?銝憟?n8n ?芸??極雿????賭葡?交???閬??豢?皞??拍 AI ?脰??箸????閬??蝯??萇????蒂?撘移蝢??釭?勗嚗???敺?銴抒??撌乩?銝剛圾?曉靘?/p> <hr class="my-4"> <h2 class="h3 mb-3"><i class="bi bi-lightbulb-fill me-2"></i>?詨????漁暺?/h2> <ol class="list-group list-group-numbered"> <li class="list-group-item d-flex justify-content-between align-items-start"> <div class="ms-2 me-auto"> <div class="fw-bold">憭??豢??芸??游?</div> 撌乩?瘚??芸???憭?Google Sheets ?葫閰行?”嚗蒂?? API ?? Jira嚗???啁? Defect ??Task ????⊿???撠?? </div> </li> <li class="list-group-item d-flex justify-content-between align-items-start"> <div class="ms-2 me-auto"> <div class="fw-bold">AI ?箸????撖?/div> 撠蝮賜??豢?鈭斤策 AI ?脰???嚗?????釭?瘜?閫撖?閬?瞏憸券?內嚗??勗?銝?????湔?瘣??? </div> </li> <li class="list-group-item d-flex justify-content-between align-items-start"> <div class="ms-2 me-auto"> <div class="fw-bold">蝎曄??勗?銝?萇???/div> ?????”?蝯?鋡急葡?銝??閮剔? HTML 璅⊥銝哨??Ｗ??撠平???潮霈?勗嚗??單???鋆賭??蝢??? </div> </li> <li class="list-group-item d-flex justify-content-between align-items-start"> <div class="ms-2 me-auto"> <div class="fw-bold">Webhook ?冽?閫貊</div> 敹???? Webhook ?嚗?????蜓蝞∪隞颱??閬????芷?暺?銝???嚗?舐??喟???啁??勗?嚗祕?曄?甇???n-Demand Reporting?? </div> </li> </ol> <hr class="my-4"> <h2 class="h3 mb-3"><i class="bi bi-kanban me-2"></i>??撅內</h2> <div class="alert alert-primary text-center" role="alert"> <a href="../demo_files/quality-assurance-weekly-report-demo.html" class="alert-link fw-bold" target="_blank"> <i class="bi bi-file-earmark-text-fill me-2"></i>暺迨?亦?摰鈭?撘?Demo ?勗 </a> <p class="mb-0 mt-1 small">(撌脖蝙??Mock Data ?踵?嚗??砍?祕鞈???</p> </div> <div class="row g-4"> <div class="col-12"> <h5>?蝯??? Mock Data ?勗蝭?<br>(?典??”?⊥??芸??嚗?暺??寥??閫?emo蝬脤?)</h5> <img src="../images/qa-report-automation-main.png" alt="?蝯勗?Ｗ蝭?" class="img-fluid rounded gallery-img"> </div> <div class="col-md-4"> <h6>銝餃極雿? (Master Workflow)</h6> <img src="../images/qa-report-automation-flow-1.png" alt="銝餃極雿?" class="img-fluid rounded gallery-img"> </div> <div class="col-md-4"> <h6>?豢???摮? (Data Fetching)</h6> <img src="../images/qa-report-automation-flow-2.png" alt="?豢???摮?" class="img-fluid rounded gallery-img"> </div> <div class="col-md-4"> <h6>Jira ?游?摮? (Jira Integration)</h6> <img src="../images/qa-report-automation-flow-3.png" alt="Jira ?游?摮?" class="img-fluid rounded gallery-img"> </div> </div> </div> </div> </div>  <div class="col-lg-4"> <div class="card shadow-sm summary-card"> <div class="card-body"> <h3 class="card-title h5 border-bottom pb-2 mb-3"><i class="bi bi-bar-chart-line-fill me-2"></i>????</h3> <ul class="list-unstyled"> <li class="mb-3 d-flex"> <i class="bi bi-clock-fill h4 text-primary me-3"></i> <div> <strong class="d-block">蝭??90% ?勗???</strong> <small class="text-muted">撠?靘?閬?1.5-2 撠???ˊ雿???蝮桃?啣嗾???批???/small> </div> </li> <li class="mb-3 d-flex"> <i class="bi bi-arrow-repeat h4 text-primary me-3"></i> <div> <strong class="d-block">?冽???嚗??榆</strong> <small class="text-muted">?⊿??券望???剖????渡?嚗??賜??喟銝???唳??/small> </div> </li> <li class="mb-3 d-flex"> <i class="bi bi-graph-up-arrow h4 text-primary me-3"></i> <div> <strong class="d-block">???豢?皞Ⅱ??/strong> <small class="text-muted">?芸???蝔??支?鈭箏極銴ˊ鞎潔??航撠?隤歹?蝣箔??勗??豢???蝣箏??/small> </div> </li> </ul> </div> <div class="card-footer"> <h3 class="h5 mt-2"><i class="bi bi-gear-fill me-2"></i>雿輻??銵?/h3> <div> <span class="badge bg-primary text-white tech-badge">n8n</span> <span class="badge bg-secondary tech-badge">AI (LLM)</span> <span class="badge bg-warning text-dark tech-badge">Jira API</span> <span class="badge bg-success text-white tech-badge">Google Sheets</span> <span class="badge bg-info text-dark tech-badge">HTML/CSS/JavaScript</span> </div> </div> </div> <div class="d-grid mt-3"> <a href="../portfolio.html" class="btn btn-outline-primary"><i class="bi bi-arrow-left-circle me-2"></i>餈?雿?</a> </div> </div> </div> </section> </main>  <section class="bg-body-tertiary py-5 border-top border-secondary-subtle"> <div class="container"> <div class="row justify-content-center"> <div class="col-lg-8 text-center"> <i class="bi bi-linkedin" style="font-size: 3rem; color: #0077b5;"></i> <h2 class="h3 mt-3 mb-3">? ?唾?閮???鈭思??瘜?</h2> <p class="text-muted mb-4"> 甇∟??唳???LinkedIn ????嚗????嗡?霈??韏瑚漱瘚?隢? ?∟??臬???靘??????祕雿?撽??隞颱???嚗甇∟??澈?? </p> <a href="https://www.linkedin.com/posts/junjia-hou_sqa-n8n-testautomation-activity-7360311570393944065-p6yS?utm_source=share&utm_medium=member_desktop&rcm=ACoAABIG390B3PtuoWttOVVAfWMw9172dduGwSA" class="btn btn-primary btn-lg" target="_blank" rel="noopener noreferrer"> <i class="bi bi-linkedin me-2"></i>?? LinkedIn 閮? </a> </div> </div> </div> </section> <footer class="bg-dark mt-5 py-4 border-top border-secondary-subtle"> <div class="container text-center"> <p class="text-muted mb-0">© 2025 Luke Hou. All rights reserved.</p> </div> </footer>  <div class="modal fade" id="imageModal" tabindex="-1" aria-labelledby="imageModalLabel" aria-hidden="true"> <div class="modal-dialog modal-lg modal-dialog-centered"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button> </div> <div class="modal-body text-center"> <img src="" class="img-fluid" id="modalImage" alt="Project Image"> </div> </div> </div> </div> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script> <script> document.addEventListener('DOMContentLoaded', function () { const imageModal = new bootstrap.Modal(document.getElementById('imageModal')); const modalImage = document.getElementById('modalImage'); document.querySelectorAll('.gallery-img').forEach(img => { img.addEventListener('click', function () { modalImage.src = this.src; imageModal.show(); }); }); }); </script> </body> </html>