.png){kind=logo}
An AI automation prompt resource that integrates Gmail, Drive, Docs, Calendar, and NotebookLM—helping you save time instantly while improving efficiency and accuracy.
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