Prompt Details
Model
Chat - (gpt-6-luna)
Token size
1,515
Example input
[Describe the business process, repetitive task, or activity you want to automate.]: Automate customer orders, order confirmations, inventory updates, and delivery notifications.
[Explain your business type, current workflow, challenges, and desired outcome.]: I run a small online store. Customers place orders through WhatsApp and Instagram. I currently record orders manually in Google Sheets.
[List your existing applications, preferred automation platforms, and available budget.]: WhatsApp Business, Google Sheets, Gmail. Budget: $30 per month.
[Beginner, Intermediate, or Advanced. Specify whether you prefer no-code, low-code, or custom-code solutions.]: Beginner. I prefer no-code automation.
Example output
# **Workflow Automation Blueprint: Small Online Store**
**Project:** Automating Customer Orders, Inventory Updates, Order Confirmations, and Delivery Notifications.
Beginner-friendly approach
No-code preferred
## **1. Project Overview**
Your goal is to build a simple automation system for your online store that reduces the time spent manually recording customer orders and managing order updates.
The proposed system will help you:
- Capture customer orders from WhatsApp and Instagram.
- Record orders automatically or through a simple order-entry process.
- Store customer and order information in Google Sheets.
- Update inventory when orders are confirmed.
- Send order confirmation messages.
- Track order processing and delivery status.
- Notify customers when their orders are dispatched or delivered.
**Important design decision:** Start with a semi-automated system. Automate the processes that are easy and reliable, while keeping human approval for order confirmation, stock changes, and delivery updates.
This avoids building an expensive or complicated system before your business needs it.
## **2. Current Workflow Analysis**
Your current process looks something like this:
**Customer places an order**
WhatsApp or Instagram
**You manually collect order details**
**You enter the order into Google Sheets**
**You check inventory and contact the customer**
**You arrange delivery and notify the customer**
### **Problems with the current process**
1. Repeatedly entering customer information wastes time.
2. Orders can be forgotten or recorded incorrectly.
3. Inventory may not reflect the actual available stock.
4. Customers may wait too long for order confirmations.
5. Tracking delivery progress requires manual communication.
## **3. Automation Opportunities**
I recommend starting with these five automation opportunities.
| Task | Recommended solution | Priority |
| ---------------------- | ----------------------------------------------------------- | -------- |
| Order collection | Google Forms + Sheets | High |
| Order recording | Make + Google Sheets | High |
| Inventory tracking | Google Sheets formulas | High |
| Order confirmation | Automated Gmail notification + manual WhatsApp confirmation | High |
| Delivery notifications | Status-based notification workflow | Medium |
### **What should be automated?**
**A. Order collection**
Instead of manually asking customers for the same information repeatedly, create a Google Form containing:
- Customer name
- Phone number
- Product name
- Quantity
- Delivery address
- Payment method
- Additional instructions
Share the form link with customers who contact you on WhatsApp or Instagram.
**B. Order recording**
Every submitted form automatically creates a new record in Google Sheets.
**C. Inventory tracking**
Google Sheets calculates the remaining stock based on confirmed orders.
**D. Order confirmation**
When you approve an order, the system can send an internal Gmail notification and prepare a customer confirmation message.
**E. Delivery tracking**
When you change an order's status to DISPATCHED or DELIVERED, the system prepares the appropriate notification.
## **4. Recommended Automation Tools**
I recommend using only three main tools initially.
[Google Sheets 2025 | Precios y opiniones del Software](https://images.openai.com/static-rsc-4/5zOM9c0tjzm6nUWWsSHDshvo0DqRh2BLYlNCRxP3rKxn-Bg29X6Di74lB0O-YsBb-Gd3BYHkIHC6mNyx2B_8kGLIlzM5rlrvMbWeOxiYa_Gt2cD_1x-xI3_plwx7E6wOB351HNCpHIL5UfNQ5XDzh_7Xx62gm9ffb1yK6r4jc18?purpose=inline)
**1. Google Sheets**
Essential
- Stores customer orders.
- Tracks inventory.
- Monitors delivery status.
- Provides a simple business dashboard.
Cost: Free for personal use within Google's available limits.
[Logo Make – Logos PNG](https://images.openai.com/static-rsc-4/YurEsOAhAKiAQHz2h-EFb8Q8ek9NaVqixKe-U_MwahhVKCqwZDcQZqt0MXtepV5RdSDBRmyOpdmCec4y54laZ4yC4JZ6mlnbJcRtYd-gZZvO9EtoFvnehXPLs3kvTkk5yZN-wQWr0GLN1_Dd8J6i-gS3Q6ys5QQ0BStjclJov84?purpose=inline)
**2. Make**
Recommended automation engine
- Connects Google Forms, Sheets and Gmail.
- Automatically transfers information.
- Applies conditions and decision rules.
- Sends notifications.
Free: 1,000 credits/month. Core: approximately $12/month for 10,000 credits, according to the listed pricing. 
[image](https://www.google.com/s2/favicons?domain=https://www.make.com\&sz=32)
Make+1
[Gmail New 2020 Logo PNG (Transparent) SVG AI – Free Download](https://images.openai.com/static-rsc-4/1Hbj2BNKA46lYOXKSmUqF1xcAyLiHwCPIajMCy5J3Z8gjE5CuHIs3VjLlHgUZC8EzpJtDlfgCOCGir3PmJZwexXhjrKdkjh30QvJwZcUM23A8p0lCjZGzvk-z8U3OYfHlowu03dmWIDEpJDcP0T8Yez7r7CutqXJWAT3Z0UTDEs?purpose=inline)
**3. Gmail**
Essential notification tool
- Receives new-order notifications.
- Sends internal alerts.
- Can send customer email confirmations.
Cost: Free for standard personal Gmail accounts within available limits.
**Additional tools**
- Google Forms: Customer order collection.
- WhatsApp Business: Customer conversations and manual confirmation.
- Instagram: Customer acquisition and order enquiries.
### **Budget recommendation**
Suggested monthly automation budget
# **$0–$12**
| Service | Estimated cost |
| -------------------- | -------------- |
| Google Forms | $0 |
| Google Sheets | $0 |
| Gmail | $0 |
| Make Free | $0 |
| Make Core (optional) | About $12 |
| **Total** | **$0–$12** |
USD estimates, excluding taxes, messaging charges and any additional paid services. Verify checkout pricing before subscribing.
You do not need to spend your entire $30 budget.
**Important WhatsApp limitation:** The ordinary WhatsApp Business app is not the same as the WhatsApp Business Platform API. Fully automated message sending requires an appropriate API integration, account setup and compliance with Meta's messaging rules. Outside the customer-service window, approved templates are generally required. 
[image](https://www.google.com/s2/favicons?domain=https://developers.facebook.com\&sz=32)
Meta for Developers+1
For your first version, I recommend keeping WhatsApp and Instagram customer conversations human-managed while automating order data and internal processes.
## **5. Proposed Workflow Architecture**
Here is the recommended system.
## **Workflow 1: Customer Order Management**
**TRIGGER**
Customer submits Google Order Form
**ACTION 1**
Make receives new order information
**ACTION 2**
Check product inventory in Google Sheets
**CONDITION**
Is sufficient stock available?
YES
**Order pending approval**
Notify store owner by Gmail.
NO
**Insufficient stock**
Flag order for manual attention.
**HUMAN APPROVAL**
Owner checks payment and confirms order.
**ACTION 3**
Update order status and inventory records.
**FINAL OUTPUT**
Order confirmed and customer notified.
### **Workflow 2: Delivery Notifications**
Owner changes delivery status in Google Sheets.
Make detects the status update.
**Check delivery status**
- DISPATCHED
- DELIVERED
**Prepare the correct notification**
Gmail delivery email or WhatsApp message for manual sending.
## **6. Step-by-Step Implementation Guide**
Let's build the system in six stages.
### **Stage 1: Create your Google Sheets database**
Open Google Sheets and create a spreadsheet named:
**ONLINE STORE ORDER MANAGEMENT SYSTEM**
Create three worksheets.
**Sheet 1: ORDERS**
| Column | Field name |
| ------ | ---------------- |
| A | Order ID |
| B | Order Date |
| C | Customer Name |
| D | Phone Number |
| E | Product |
| F | Quantity |
| G | Unit Price |
| H | Total Amount |
| I | Delivery Address |
| J | Payment Status |
| K | Order Status |
| L | Delivery Status |
Suggested order statuses:
- NEW
- PENDING APPROVAL
- CONFIRMED
- PROCESSING
- DISPATCHED
- DELIVERED
- CANCELLED
**Sheet 2: INVENTORY**
| Product | Opening Stock | Confirmed Quantity | Available Stock |
| --------- | ------------- | ------------------ | --------------- |
| Product A | 50 | 5 | 45 |
| Product B | 30 | 10 | 20 |
| Product C | 20 | 3 | 17 |
For Available Stock in D2, use:
```
=B2-C2
```
Copy the formula down the column.
**Sheet 3: DASHBOARD**
Create these business indicators:
- Total orders received.
- Total confirmed orders.
- Pending orders.
- Delivered orders.
- Cancelled orders.
- Total sales from confirmed orders.
- Products running low on stock.
For example, count confirmed orders with:
```
=COUNTIF(ORDERS!K2:K,"CONFIRMED")
```
Calculate confirmed sales with:
```
=SUMIF(ORDERS!K2:K,"CONFIRMED",ORDERS!H2:H)
```
These formulas provide a simple overview of business performance.
### **Stage 2: Create the customer order form**
1. Open Google Forms.
2. Select Blank Form.
3. Name it Online Store Order Form.
4. Add the customer information fields.
5. Add product selection and quantity.
6. Add delivery address and payment method.
7. Connect the form to your Google Sheets spreadsheet.
8. Copy the form link.
9. Put the link in your WhatsApp Business quick replies and Instagram profile.
[How to Create an Online Order Form - So Fontsy](https://images.openai.com/static-rsc-4/_vnqMDdhJfSuYj5jN8ZRldFnLpg3XUCQYlGn79vZK1jnktcPT4xOTurQ7ZynL0WUxqJI0zPHDYGwlrurkKM0XFTV2ern4Ld494Si1u73b6DYs6BTAbEPCARlscqzsuax1LGXIB61fo0DvY2g6BfmLV3b-RJ1b7zw-uCmFy8k270?purpose=inline)
[sofontsy.com](https://sofontsy.com/blogs/education-center-business-resources/how-to-create-an-online-order-form?srsltid=AfmBOoqfOJePQSZrunGn3ZQwIyObQQZLjBNJqkSRJRbkr_0ACyeLLhwQ\&utm_source=chatgpt.com)
Now customers can submit their orders without you manually typing every detail.
### **Stage 3: Connect Google Sheets to Make**
1. Visit [Make.com](https://www.make.com/?utm_source=chatgpt.com).
2. Create a free account.
3. Select Create a new scenario.
4. Search for Google Sheets.
5. Select the module that watches for new spreadsheet rows, where available.
6. Connect your Google account.
7. Select the spreadsheet and the order-response worksheet.
8. Configure the scenario to detect new submissions.
[Kevin Stratvert’s Guide to Automating Workflows with Make | Make](https://images.openai.com/static-rsc-4/bJq9GELtEk82rnrs6njv_cFt9K7hjCM11Zq58egq6e4bbv8TvnXtYL5VacZ6-g2Hc6_ISU1sKgVGucCOrU8iSBQs-yZmH7Zpntv3hZQoERTHdKZLEd8afh6jcUTgdQyIrZcCmuTvMeTTIDjXHHL_HOAS9HucPfOqrwRNvUQhaU4?purpose=inline)
[make.com](https://www.make.com/en/blog/kevin-stratverts-guide-to-improving-efficiency-with-make?utm_source=chatgpt.com)
Your first automation will look like this:
`New Google Sheets Row → Read Order Information → Continue Processing`
On the free plan, scheduled checks have a 15-minute minimum interval. 
[image](https://www.google.com/s2/favicons?domain=https://www.make.com\&sz=32)
Make+1
### **Stage 4: Add inventory checking**
In Make:
1. Add a Google Sheets Search Rows module.
2. Search the INVENTORY worksheet.
3. Match the customer's selected product against the Product column.
4. Retrieve its available stock.
5. Add a filter to check whether available stock is greater than or equal to the requested quantity.
6. Create two possible paths.
**Path A: Stock available**
- Mark the order PENDING APPROVAL.
- Send an email to the store owner.
- Include the customer name, product and quantity.
**Path B: Insufficient stock**
- Flag the order as INSUFFICIENT STOCK.
- Send an alert to the store owner.
- Do not deduct stock.
Do not deduct inventory merely because someone submits a form. Deduct or reserve stock only after you approve the order. This prevents unapproved orders from reducing your available inventory.
### **Stage 5: Automate order confirmations**
After you approve an order:
1. Change its status to CONFIRMED.
2. Update the confirmed quantity in the inventory worksheet.
3. Calculate the new available stock.
4. Send an internal Gmail notification.
5. Use WhatsApp Business to send the customer a confirmation message.
Example confirmation:
Hello [Customer Name],
Thank you for placing your order!
Your order has been confirmed.
Order ID: [Order ID]\
Product: [Product Name]\
Quantity: [Quantity]\
Total Amount: [Amount]
We will keep you updated as your order is being processed.
Thank you for shopping with us!
### **Stage 6: Automate delivery tracking**
Create another Make scenario.
Set it up as follows:
1. Watch for order status changes.
2. Check whether the delivery status is DISPATCHED.
3. Prepare a dispatch notification.
4. When the status becomes DELIVERED, prepare a delivery-completion notification.
5. Send the customer an email if an email address is available, or use a prepared WhatsApp message for manual sending.
Example:
Hello [Customer Name],
Good news! Your order [Order ID] has been dispatched.
Your order is on its way.
Thank you for choosing our store!
**Implementation note:** The Google Sheets status-change trigger and the order approval logic need careful configuration. Use a unique Order ID and a processed-status field to prevent duplicate notifications or repeated inventory deductions. For reliable operation, test these controls before using the system with real customers.
## **7. Expected Benefits**
Here are the improvements you can reasonably expect.
| Business area | Expected improvement |
| ---------------- | ------------------------------------ |
| Order recording | Less manual data entry |
| Inventory | Better stock visibility |
| Customer service | Faster order processing |
| Communication | More consistent updates |
| Reporting | Easier sales monitoring |
| Accuracy | Fewer copying and calculation errors |
### **Potential time savings**
Consider this illustrative example:
Assume your store receives 10 orders daily.
- Manual recording takes 3 minutes per order.
- Automated recording reduces your manual data-entry work to approximately 30 seconds per order for checking.
Calculation:
- Manual work: 30 minutes daily.
- New checking work: 5 minutes daily.
- Potential time saved: 25 minutes daily.
Over 26 working days:
\\[ 25 \times 26 = 650 \text{ minutes} \\]
Illustrative monthly time savings
# **10 hours 50 minutes**
Based on the assumptions above, not a guaranteed result.
## **8. Testing and Troubleshooting**
Before launching, test the system with sample orders.
| Test | Expected result |
| --------------------------- | -------------------------------- |
| Submit a new order | New row appears in ORDERS |
| Order available stock | Owner receives an alert |
| Order unavailable stock | Order is flagged |
| Approve an order | Inventory updates once |
| Change status to DISPATCHED | Correct notification is prepared |
| Change status to DELIVERED | Delivery completion is recorded |
| Submit duplicate order | Duplicate is detected or flagged |
### **Common problems and solutions**
**Problem 1: Orders are not appearing in Sheets.**
Solution: Check the Google Forms response destination and spreadsheet permissions.
**Problem 2: Inventory is incorrect.**
Solution: Check product names, quantities, formulas and duplicate processing.
**Problem 3: Make stops running.**
Solution: Check credit limits, connected accounts, execution history and scenario errors.
**Problem 4: Customers are not receiving notifications.**
Solution: Verify customer contact details, messaging permissions and delivery channel configuration.
**Problem 5: The same order is processed twice.**
Solution: Use unique Order IDs and a processing-status field.
### **Security recommendations**
- Never share your Google Sheets spreadsheet publicly.
- Give staff only the access they need.
- Enable two-factor authentication.
- Never place passwords or API keys inside spreadsheet cells.
- Keep a backup of your order records.
- Avoid collecting unnecessary customer information.
## **9. Future Improvements**
Once the first system is working properly, you can introduce more advanced features.
By purchasing this prompt, you agree to our terms of service
GPT-6-LUNA
Transform repetitive tasks into efficient automated workflows. Identify automation opportunities, design step-by-step systems, select suitable tools, integrate AI, reduce manual work, and improve productivity with practical solutions for businesses, entrepreneurs, freelancers, and teams.
...more
Added 27 minutes ago
