TP-20Daypack
TrailPack 20L
A compact 20-litre daypack for commuting and short hikes.
Sandbox: In stock
Sandbox: fictional products, real email enquiries. Nothing is for sale.
AI Product Enquiry Assistant
Explore an email assistant I built to answer product questions, track enquiries and send restock notifications automatically.
Manual workflow tested
Hourly monitoring configured, scheduled execution awaiting verification
Replies sent automatically
Catalogue
Fictional product range
Browse the six sandbox products. Click Enquire about this product to get a ready-to-send email template.
TL-01Desk lighting
GlowDesk LED Lamp
An adjustable LED desk lamp with four brightness levels and USB-C power.
Sandbox: In stock
WB-75Drinkware
FlowBottle 750 ml
A double-wall stainless-steel bottle intended for hot or cold drinks.
Sandbox: Low stock
CM-01Drinkware
CampMug Enamel 350 ml
An enamel-coated steel mug for home or campsite use.
Sandbox: Out of stock
RC-10Pack accessory
RainCover 10–25L
A rain cover for small and medium daypacks.
Sandbox: In stock
HC-35Headwear
HikeCap Soft Brim
A lightweight, adjustable cap for everyday outdoor use.
Sandbox: In stock
Workflow
How it works
The assistant runs entirely outside this website. Steps below are explanatory, not live status indicators.
01
Enquiry received
Participant sends from their email app using the sandbox template.
02
Inventory lookup
The assistant reads the connected product sheet and matches the SKU.
03
Classification
Question type is classified and response boundaries are applied.
04
Reply drafted
A reply is prepared using approved catalogue information only.
05
Reply sent
The reply is sent automatically to the participant's address.
06
Enquiry recorded
The submission is logged in the private tracker spreadsheet.
07
Restock request saved
If the participant requested a restock alert, consent and status are saved as Waiting.
08
Hourly check runs
A recurring task checks Waiting requests against live inventory.
09
Stock matched
When inventory matches a Waiting request, the restock path is triggered.
10
Notification sent
A notification email is sent automatically to the participant.
11
Request marked Sent
The restock request status is updated to Sent to prevent repeat alerts.
The hourly check drafts notifications only. It does not send emails or update records itself. Sending and recording completion happen through the separately approved workflow.
Case study
Building the assistant
Problem
Product enquiries require consistent answers, accurate stock information and follow-through when an item becomes available. Manual handling is error-prone and hard to scale.
My contribution
I designed and configured the workflow, structured the product knowledge base, defined response boundaries, set up enquiry and consent tracking, and tested the automated email and restock paths end to end.
Technology
ChatGPT WorkConnected emailGoogle SheetsNext.js 16Vercel
Design decisions
- 1Approved product information grounds every answer. The assistant does not speculate.
- 2Missing specifications lead to a clarification request or flagged review, not an invented answer.
- 3Conflicting stock information is flagged rather than silently resolved.
- 4Replies are sent automatically once a response is drafted from approved catalogue information.
- 5Restock follow-ups require the participant's explicit consent, not assumed from the enquiry.
- 6Message IDs and request status fields help prevent duplicate processing.
Validation
The following were tested manually and observed to behave as expected:
- Product lookup and enquiry classification
- Drafting and sending replies from approved catalogue information
- Saving a restock request without creating a duplicate
- Detecting a simulated restock
- Sending a restock notification automatically
- Marking the request Sent
- Running another check and correctly skipping the completed request
Limitations
- ·The catalogue and inventory are entirely fictional. Nothing is for sale.
- ·Hourly monitoring is configured; scheduled execution is enabled but has not been independently verified.
- ·The website catalogue is a static snapshot. The assistant reads live inventory when processing a real enquiry.
- ·The website submits enquiries but does not run, observe or control the assistant.
Participation
How your information is used
Your email address and enquiry will be processed using connected email, ChatGPT Work and a private Google Sheets tracker for this exercise. Replies are sent automatically. Restock follow-ups are optional and require your explicit request. Please do not send sensitive personal information.
This is a publicly disclosed learning exercise. All products and inventory are fictional. Participation is voluntary.