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
Approach
- Implemented web-order-to-sheet automation with validation and normalization
- Added WhatsApp-to-sheet logging and tagging workflows
- Used n8n + Google Apps Script to balance speed and maintainability
- Defined fallback paths and operational checks for failed runs
Results
- Reduced daily manual copy-paste work
- Improved consistency of lead and order records
- Provided reusable automation patterns for future workflow extensions
Tech stack
- n8n
- Google Apps Script
- REST APIs
- Google Sheets