Automated Food Menu Update Notifications via WhatsApp, Email & SMS

This n8n workflow automates the process of detecting updates to the restaurant’s special menu stored in Google Sheets and sending timely notifications to customers through their preferred communication channels—WhatsApp, Email, or SMS. It begins with a scheduled trigger that fetches the latest menu data from Google Sheets, then compares it with previous data to identify new, updated, or removed items. Based on these changes, it generates a clear, formatted notification message. The workflow then reads customer contact details and their notification preferences, branching out to send personalized updates via WhatsApp using the WhatsApp API, email via SMTP, or SMS through Twilio. It also logs the status of each notification sent for auditing purposes. Practical use cases include daily or hourly updates about menu changes, ensuring customers are always informed about specials or new offerings in real time.