Problem
Inbound orders and chat updates were copied manually into spreadsheets, producing inconsistent records and delayed follow-up.
Constraints
- Needed to remain usable for non-technical operations users
- Third-party payloads could change without notice
- Logging needed traceability for audits and handovers
Delivery
- Implemented web-order-to-sheet automation with validation and normalization.
- Added WhatsApp-to-sheet logging and tagging workflows for shared follow-up visibility.
- Used n8n + Google Apps Script to balance speed, maintainability, and practical ownership.
- Defined fallback paths and operating checks for failed runs.
Result
- Reduced manual logging work in inbound operations.
- Improved consistency of lead and order records across channels.
- Provided reusable workflow patterns for future automation extensions.
Tech stack
- n8n
- Google Apps Script
- REST APIs
- Google Sheets