Optimize CEMEX Orders via Google Sheets & Twilio Automation

Streamline your CEMEX order management operations with this powerful n8n automation workflow that connects Google Sheets order tracking with intelligent phone agent assistance and multi-channel customer notifications through Twilio WhatsApp and Gmail integration.

What this workflow does

This comprehensive automation exposes two specialized webhook endpoints designed for phone-agent order assistance systems. The first webhook (/X-get-orders) instantly retrieves customer order history from Google Sheets using phone number lookup, returning a structured JSON summary of both active and recent inactive orders. When no phone number is provided, it intelligently falls back to loading all orders for comprehensive visibility.

The second webhook (/X-orders) handles complete order lifecycle management through four key actions: consultar (consult), modificar (modify), cancelar (cancel), and reprogramar (reschedule). For modifications, the workflow seamlessly merges partial changes into existing order rows. When processing cancellations, it automatically generates customer-facing confirmation messages and simultaneously sends notifications via both Twilio WhatsApp and Gmail, ensuring customers receive immediate confirmation across multiple channels.

Use cases

• CEMEX customer service representatives managing order inquiries and modifications in real-time
• Automated phone systems requiring instant access to customer order data stored in Google Sheets
• Multi-channel order cancellation workflows with automatic WhatsApp and email confirmations
• Order rescheduling operations with integrated customer communication
• Centralized order management systems connecting spreadsheet data with communication platforms

Technical details

Built using essential n8n nodes including webhook triggers, Google Sheets integration for order data management, Twilio for WhatsApp messaging, Gmail for email notifications, conditional logic with if/switch nodes, and custom code processing. The workflow requires Google Sheets OAuth2 credentials and proper configuration of spreadsheet columns including order_id, phone_number, status, delivery_date, and delivery_time.

Perfect for automation engineers and SaaS operators seeking to optimize order management workflows with reliable Google Sheets integration and comprehensive customer communication capabilities.