If you’re constantly moving data between Gmail, Google Drive, Docs, and Calendar, you’re likely wasting a significant amount of time.
The problem isn’t that you’re not working hard — it’s that you’re still relying on manual workflows.
This guide gives you a ready-to-use AI prompt resource pack to help you:
- Automatically organize supplier quotations
- Automatically write customer complaint replies
- Automatically schedule meetings
- Automatically analyze data (no formulas needed)
- Automatically turn data into marketing copy
- Build your own brand AI assistant
- Create a “no-hallucination” knowledge base
Everything below is designed to be copy-and-paste ready.
📦 1. Gmail: Automatically Organize Supplier Quotations
Use case: Procurement / price comparison / supply chain management
👉 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.
💡 What you get:
- Automatically structured comparison table
- Clear visibility of price changes
- Reduced risk of missing critical details
📧 2. Gmail: Customer Complaint Replies (Human + High Quality)
👉 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
💡 Key benefits:
- References actual customer details
- Avoids generic template responses
- Maintains trust and brand tone
📅 3. Gmail + Calendar: Auto-Schedule Meetings
👉 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
💡 Outcome:
- Automatically avoids scheduling conflicts
- Optimizes your calendar efficiently
- Eliminates manual email checking
📊 4. Drive: No-Formula Data Analysis
👉 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.
👉 Add reporting:
Create a structured report based on the analysis.
Title: Q1 Sales Summary
Include:
- Executive summary
- Key insights
- Recommendations
💡 Key benefits:
- No Excel formulas required
- No pivot tables needed
- Instant insights and recommendations
✍️ 5. Docs: Turn Data into Marketing Copy
👉 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 refinement:
Make the tone warmer and more emotional in Traditional Chinese.
Add one sentence highlighting natural ingredients.
💡 Outcome:
- Converts insights directly into sales copy
- Quickly adjusts tone and messaging
- Reduces editing back-and-forth
🤖 6. Gems: Build a Brand AI Assistant
👉 Example setup:
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
💡 Use cases:
- No need to repeat brand context every time
- Maintains consistent tone
- Improves conversion-focused content
📚 7. NotebookLM: Build a “No-Hallucination” Knowledge Base
👉 How to use:
Upload:
- Product information
- FAQs
- Brand story
- Policy documents
👉 Example questions:
Is lavender oil safe for cats?
Can a customer return the product after 14 days?
💡 Key features:
- Answers only based on your uploaded materials
- Provides source-backed responses
- Eliminates AI hallucination risks
🔗 8. NotebookLM × Gemini: Upgrade Content Generation
👉 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
💡 Result:
- All outputs are grounded in verified information
- Ready-to-use assets for marketing and support
- Bridges knowledge → execution
🧩 How to Apply This (Simple Workflow)
- Use Gmail / Drive to gather and structure data
- Use Gemini to analyze and generate outputs
- Use Gems to maintain brand consistency
- Use NotebookLM to verify accuracy
- Use Gemini again to produce final marketing or operational content
💡 This workflow helps you:
- Save up to 70% of repetitive work
- Reduce human errors
- Improve content quality and conversion outcomes
