如果你每日都喺 Gmail、Google Drive、Docs、Calendar 之間搬資料，你其實已經浪費緊大量時間。
問題唔係你唔夠努力，而係你仲用緊「手動 workflow」。
呢篇文章會直接俾你一套可即用嘅 AI Prompt 資源包，幫你做到：
- 自動整理供應商報價
- 自動寫客訴回覆
- 自動排會議
- 自動分析數據（無需公式）
- 自動由數據生成文案
- 建立品牌AI助手
- 建立「唔會亂答」嘅知識庫
全部都可以直接 Copy & Paste 用。
📦 1. Gmail：自動整理供應商報價
適用場景：採購 / 比價 / 供應鏈管理
👉 Prompt：
@Find all supplier quotation emails from the past 3 months.
From these emails, extract and organize the following information:
- Supplier name
- Product name
- Unit price
- Minimum order quantity (MOQ)
- Lead time / delivery time
Then generate a comparison table.
Important:
- Identify quotation emails automatically (do not rely only on keywords)
- If information is missing, leave it blank instead of guessing
- Standardize formats (e.g., currency, time units)
Output as a clean table.
💡 你會得到：
- 自動整理表格
- 價格變動一目了然
- 減少漏資料風險
📧 2. Gmail：客訴回覆（高質 + 有人味）
👉 Prompt：
@Find the most recent email that contains a customer complaint or negative feedback about a product.
Then read it and draft a reply that:
- acknowledges the issue
- references specific details
- provides a helpful explanation
- offers support or compensation
Do not make up information.
Tone:
- empathetic, calm, and human
- not overly formal
- not generic
💡 重點：
- 會引用客戶內容
- 唔會寫模板垃圾文
- 保持品牌信任感
📅 3. Gmail + Calendar：自動排會議
👉 Prompt：
@Gmail @Google Calendar
Analyze my emails related to [project name] to identify all meeting requests.
Then plan and schedule them into my calendar.
Optimize for:
- minimal conflicts
- efficient time grouping
- realistic working hours
If conflicts occur:
- automatically adjust and explain the change
Show:
- original requested timing
- final scheduled timing
- reasoning behind adjustments
💡 成果：
- 自動避開撞時間
- 幫你重新排優化 schedule
- 唔洗再逐封 email check
📊 4. Drive：零公式數據分析
👉 Prompt：
@Find the file "Q1_Sales_Data".
Analyze the data and provide:
- Top 5 best-selling products
- Monthly sales trend
- Channel performance breakdown
- Average order value (if possible)
Highlight any interesting patterns or anomalies.
👉 再加報告：
Create a structured report based on the analysis.
Title: Q1 Sales Summary
Include:
- Executive summary
- Key insights
- Recommendations
💡 重點：
- 無需 Excel formula
- 無需 Pivot Table
- 直接出分析 + 建議
✍️ 5. Docs：由數據 → 文案
👉 Prompt：
Read my Q1 Sales Summary document.
Based on the insights, write a 300-word product introduction for retail buyers.
Include:
- brand story
- key selling points
- target audience
- differentiation from competitors
Tone: professional but warm.
👉 改 Tone：
Make the tone warmer and more emotional in Traditional Chinese.
Add one sentence highlighting natural ingredients.
💡 成果：
- 數據直接變 sales copy
- 快速調整 tone
- 減少來回修改
🤖 6. Gems：建立品牌 AI 助手
👉 設定範例：
Gems Name: PawCalm Marketing Assistant
You are a marketing assistant for a pet wellness brand.
Target Audience:
Caring pet owners aged 25–50
Brand Tone:
Warm, empathetic, reassuring
Core Message:
Help pets move from anxiety to calm using natural solutions
Key Points:
- 100% natural ingredients
- safe for dogs and cats
- vet-reviewed
Output Language: Traditional Chinese
💡 用途：
- 每次唔洗重新解釋品牌
- 保持內容一致性
- 提升轉換率
📚 7. NotebookLM：建立「唔亂答」AI 知識庫
👉 用法：
上傳：
- 產品資料
- FAQ
- 品牌故事
- 政策文件
👉 問題例子：
Is lavender oil safe for cats?
Can a customer return the product after 14 days?
💡 特點：
- 只用你提供資料回答
- 每個答案都有來源
- 避免 AI 幻覺
🔗 8. NotebookLM × Gemini：內容生成升級
👉 Step 1（NotebookLM）：
List the top 10 most common customer questions and answers.
👉 Step 2（Gemini）：
Based on the FAQ, generate:
1. Staff training checklist
2. WhatsApp quick reply templates
3. 7-day Instagram Story Q&A plan
Tone: warm and helpful
💡 結果：
- 所有內容都「有根據」
- 可直接用於營銷 & 客服
🧩 點樣實際用（快速上手流程）
1️⃣ 先用 Gmail / Drive 做資料整理
2️⃣ 用 Gemini 做分析 + 產出
3️⃣ 用 Gems 保持品牌一致
4️⃣ 用 NotebookLM 確保資料正確
5️⃣ 最後再生成內容（Marketing / Sales）
👉 呢個流程可以幫你：
- 慳 70% 重複工作
- 減少人為錯誤
- 提高內容轉換率
.jpg)
