<aside> 🌐

https://us2.make.com/public/shared-scenario/bwLUzVRLGIO/automated-order-tracking-and-team-notifi

</aside>

<aside> 💡

Overview

This automation handles new customer orders submitted through Jotform, extracts all product information, stores each item into a Google Sheet, and sends notifications to both the customer and the fulfillment team. It removes manual encoding, speeds up processing, and ensures everyone has complete visibility of the order.

</aside>

<aside> 🧰

Tools

<aside> 🚧

The Challenge

Manually checking Jotform submissions, copying product details, calculating totals, emailing the customer, and notifying the team was taking too much time and caused errors. The process needed to be fully automated to reduce delays and make fulfillment faster and more accurate.

</aside>

<aside> 🚀

The Outcome

✅ Orders are instantly logged into a structured Google Sheet

✅ Customers receive a personalized, complete order confirmation

✅ Fulfillment team is notified immediately via Slack

✅ Manual processing time is reduced significantly

</aside>

<aside> 📈

Project Impact

Impact Area Description
⏱️ Time Saved Eliminates manual encoding and emailing, saving 10–15 minutes per order.
📦 Order Accuracy Ensures all product details are captured and stored without errors.
⚡ Team Efficiency Slack alerts help fulfillment work faster and stay aligned.
😊 Customer Experience Sends a clear, complete order summary that gives customers full confidence.
</aside>

<aside> ⚙️

Workflow Summary

<aside> 🖼️

Screenshots / Gallery

Untitled

</aside>

<aside> 💭

Reflection / Key Learning

Automating each step—from data extraction to messaging—proved how much time and accuracy can be gained by removing manual work.

</aside>