Overview
This workflow automates the process of notifying customers about daily food menu updates via WhatsApp. It leverages scheduled triggers, Google Sheets integration, and conditional logic to ensure timely and relevant communication.
Key Features
- Automated Scheduling: Uses a schedule trigger to initiate the workflow daily.
- Data Integration: Fetches the latest special menu data and customer contact lists from Google Sheets.
- Change Detection: Compares current and previous menu data to identify updates.
- Personalized Messaging: Generates tailored WhatsApp alert messages for customers based on their notification preferences.
- Batch Processing: Efficiently splits contacts into batches and filters for WhatsApp users.
- Status Logging: Tracks and logs the status of each WhatsApp notification sent.
Benefits
- Time Savings: Eliminates manual effort in updating and notifying customers about menu changes.
- Improved Engagement: Ensures customers receive timely and relevant menu updates, enhancing satisfaction.
- Accurate Targeting: Only notifies customers who have opted for WhatsApp alerts, reducing noise.
Use Cases
- Restaurants and food services wanting to keep customers informed about daily specials.
- Businesses seeking to automate customer communication based on dynamic data changes.
Integrations
- Google Sheets for data management
- WhatsApp for customer notifications
- HTTP requests for external communication