| # | Project | Core Value & Use Cases | Domain Knowledge & Tech Stack |
|---|---|---|---|
| 01 | Sentiment Analysis | 自動化情緒監測 • 電商評論監控 (Reviews) • 員工滿意度調查 (HR) • 社群品牌聲量分析 |
NLP & API Integration • OpenAI (Prompt Engineering) • Google Sheets API • Webhook Handling |
| 02 | Slack AI Chatbot | 企業內部全能助手 • IT Helpdesk 第一線支援 • 新員工 Onboarding 助手 • 業務知識庫查詢 |
Conversational AI & Bot Frameworks • LangChain Agents (Memory/Tools) • Slack App Configuration (Events/Scopes) • RAG Concepts |
| 03 | WordPress AI Chatbot | 網站內容活化 (RAG) • SaaS 產品文件助手 • 部落格/新聞站智慧導讀 • 電商選購顧問 |
RAG & Vector Databases • Vector Embeddings (Supabase pgvector) • Web Scraping / Content Ingestion • WordPress REST API |
| 04 | Telegram AI Assistant | 行動優先生產力工具 • 語音筆記轉行動清單 • 語言學習陪練 (Voice Interaction) • 現場工程查驗語音報告 |
Audio Processing & Messaging APIs • OpenAI Whisper (Speech-to-Text) • Telegram Bot API (Webhooks) • Multi-modal Interaction (Voice/Text) |
| 05 | PostgreSQL AI Agent | 數據秘書 (Text-to-SQL) • 主管營收即時查詢 • 庫存即時查詢系統 • 客服訂單狀態快查 |
Database & SQL • Relational Database Schemas (SQL) • LLM Function Calling • Prompt Engineering for SQL Generation |
| 06 | Database AI Chat | 對話式資料庫介面 • 複雜關聯查詢簡化 • 資料庫結構探索 • 非技術人員數據獲取 |
Advanced SQL & Schema Awareness • Database Metadata Management • Context Awareness (Schema Context) • Natural Language Understanding |
| 07 | SQL Agent Visualization | 自動化數據視覺化 • 自動化週報圖表生成 • 銷售業績圓餅圖/折線圖 • 異常數據視覺化警示 |
Data Visualization & Structured Output • JSON Structured Outputs • Charting Libraries/APIs (QuickChart.io) • Data Aggregation & Formatting |
| 08 | GitLab Code Review | 代碼品質守門員 • 初級代碼審查與風格建議 • 資安漏洞預警 (Hard-coded secrets) • Documentation 強制執行 |
DevOps & CI/CD • Git Version Control Flows (MR/PR) • Static Code Analysis Concepts • Webhook Security & Payload Parsing |
| 09 | Notion Vector RAG | 企業第二大腦搜尋 • 公司 SOP 智能問答 • 專案歷史決策回溯 • 個人知識庫靈感助手 |
Knowledge Management & RAG • Notion API (Block/Page Structure) • Recursive Text Splitting • Vector Similarity Search |
| 10 | NocoDB Data Analyst | 輕量級資料庫分析師 • 活動報名名單客群分析 • CRM 客戶分群與再行銷 • 產品庫存智慧盤點建議 |
Low-Code Databases & Data Analysis • NocoDB/Airtable API Interactions • Data Cleaning & Analysis Patterns • Schema Discovery |
- Deploy n8n to Zeabur or run locally
- Set up environment variables (see credentials-guide.md)
- Import any
workflow.jsoninto your n8n instance - Configure the required credentials using standardized names
| Credential Name | Type | Used By |
|---|---|---|
OpenAI Account |
OpenAI API | All projects |
Supabase Account |
Supabase | 01, 03, 05, 09 |
Slack Account |
Slack API | 02 |
Telegram Account |
Telegram | 04 |
Google Sheets Account |
Google API | 01 |
GitLab Account |
GitLab API | 08 |
Postgres Account |
PostgreSQL | 05, 06, 07 |
NocoDB Account |
NocoDB API | 10 |
n8n-portfolio/
├── README.md
├── .env.example
├── credentials-guide.md
└── [01-10]-*/
├── workflow.json
├── README.md
└── demo.gif
This portfolio is designed for Zeabur deployment. See zeabur-deployment-guide.md for details.
MIT License