Automated E-Commerce Order & Tracking Workflow
Tools:
Zapier, WooCommerce, Google Sheets, Gmail, WhatsApp
Focus:
Order fulfillment, real-time updates, customer communication
Problem:
Order management is often slowed down by manual steps—sharing details with fulfillment teams, logging orders, tracking supplier updates, and emailing customers. This creates bottlenecks, inconsistent communication, and extra admin work.
Solution:
To demonstrate how automation can optimize this process, I built a workflow that simulates a WooCommerce store:
-Used Google Sheets to act as a substitute order form since I did not have access to a live WooCommerce account. This allowed me to replicate how incoming orders would trigger the workflow.
-Captures new order details (product, size, customer info, and image).
-Sends the order instantly to a WhatsApp group for fulfillment.
-Logs the order into a central Google Sheet for tracking.
-Updates records with supplier tracking details when available.
-Emails customers their tracking numbers automatically.
Outcome:
This project demonstrates how automation can streamline order fulfillment, improve customer communication, and eliminate repetitive data handling. By simulating WooCommerce with Google Sheets, I was able to showcase the full end-to-end logic of the process—highlighting my ability to connect sales, operations, and customer service workflows.
Project Gallery

Will activate the automation when a new order comes in

Order source as a substitute for the supposed "online store". (We don't a WooCommerce account in this case)

My Zapier folder for this simple yet very efficient automation

Will activate the automation when a new order comes in