I Built an AI WhatsApp Order Agent (Free Template), by Excel For Freelancers on YouTube. 15 min 54 s.
- Video length
- 15 min 54 s
- Time to do it
- 45 minutes
- Difficulty
- Medium
- Steps
- 8
What you need
Steps
Download the free Excel Order Manager workbook and the WhatsApp Order Agent skill file from the links in the video description.
Open the workbook and fill in your product list: item names, stock counts, prices and a payment QR code image.
In ChatGPT, create a new agent or chat and upload the Excel workbook as its data source.
Install the WhatsApp Order Agent skill so the agent knows how to read orders, check stock and reply with an invoice.
Test with a stock check first, for example ask for five smartwatches when only two are in stock, and confirm the agent flags the shortfall.
Send a real test order and check that the agent replies with a PDF invoice and the payment QR code.
Try a change request, such as swapping an out-of-stock item or adding a laptop stand after the invoice, and confirm a fresh invoice is sent.
Schedule the agent to check for new WhatsApp messages every five minutes so orders are handled without you typing.
Tips and common mistakes
Keep stock counts in the workbook accurate, because the agent trusts that sheet when it confirms an order.
Test with small orders before going live so you can catch wrong prices or missing products.
Save the skill so you can reuse it in any new chat instead of rebuilding the agent each time.
Double-check the payment QR code in a test invoice before customers scan it.
Questions
Do I need to know VBA or coding?
No. You upload the workbook and install the skill, then the agent handles the order logic. You only need to keep the product and stock data up to date.
What happens if an item is out of stock?
The agent checks the workbook and tells the customer the item is unavailable, then updates the order and sends a revised invoice for what is in stock.
Can it run without me watching WhatsApp?
Yes, once you set the scheduled task it checks for new messages every five minutes and replies on its own.
This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.
