📱 Food menu update notifier

⚡ 1,050 views · 📱 Social Media & Email Marketing

Description

An intelligent food menu update notification system that automatically detects changes in your restaurant’s special menu and sends personalized notifications to customers via multiple channels - WhatsApp, Email, and SMS. This workflow ensures your customers are always informed about new dishes, price changes, and menu availability in real-time.

What’s the Goal?

By the end, you’ll have a fully automated menu notification system that keeps your customers informed and engaged with your latest culinary offerings.

Why Does It Matter?

Manual menu update communication is time-consuming and often missed by customers. Here’s why this workflow is essential for restaurants:

Think of it as your restaurant’s digital menu announcer that never misses an update.

How It Works

Here’s the complete workflow process:

Step 1: Menu Monitoring

Step 2: Data Retrieval

Step 3: Change Detection

Step 4: AI Content Generation

Step 5: Customer Data Processing

Step 6: Multi-Channel Delivery

The workflow splits into three parallel notification channels:

WhatsApp Branch

Email Branch

SMS Branch

Step 7: Comprehensive Logging

All notification activities are logged in Sheet 3 for tracking and analytics.

Google Sheets Structure

Sheet 1: Special Menu

ColumnDescriptionExample
Item IDUnique identifier for menu item”ITEM001”
Item NameName of the dish”Truffle Risotto”
PriceItem price”$28.99”
DescriptionDetailed item description”Creamy arborio rice with black truffle, parmesan, and wild mushrooms”
NutritionsNutritional information”Calories: 450, Protein: 15g”
CategoryMenu category”Main Course”
AvailableAvailability status”Yes” / “No”

Sheet 2: Customer Database

ColumnDescriptionExample
Customer NameCustomer’s full name”ABC”
EmailCustomer’s email address”abc@gmail.com”
Phone NumberCustomer’s phone number”91999999999”
WhatsApp NumberCustomer’s WhatsApp number”91999999999”
Email NotificationsEmail preference”Yes” / “No”
SMS NotificationsSMS preference”Yes” / “No”
WhatsApp NotificationsWhatsApp preference”Yes” / “No”

Sheet 3: Notification Logs

ColumnDescriptionExample
TimestampNotification send time”2025-07-09T12:51:09.587Z”
Customer NameRecipient name”ABC”
Notification TypeChannel used”Email” / “SMS” / “WhatsApp”
StatusDelivery status”Sent” / “Failed” / “Pending”
MessageContent sent”SPECIAL MENU UPDATE…”

How to Use the Workflow

Prerequisites

  1. Google Sheets Setup: Create three sheets with the required structure
  2. n8n Account: Access to n8n workflow platform
  3. WhatsApp Business API: WhatsApp Business account with API access
  4. Email Service: Gmail or SMTP service for email notifications
  5. Twilio Account: Twilio account for SMS functionality
  6. AI Model Access: OpenAI or similar AI service for content generation

Importing the Workflow in n8n

Step 1: Obtain the Workflow JSON

Step 2: Access n8n Workflow Editor

Step 3: Import the Workflow

Option A: Import from Clipboard

  1. Click the three dots (â‹Ż) in the top-right corner
  2. Select “Import from Clipboard”
  3. Paste the JSON code into the text box
  4. Click “Import” to load the workflow

Option B: Import from File

  1. Click the three dots (â‹Ż) in the top-right corner
  2. Select “Import from File”
  3. Choose the .json file from your computer
  4. Click “Open” to import the workflow

Configuration Setup

Google Sheets Integration

  1. Authentication: Connect your Google account in n8n
  2. Sheet 1 Configuration: Set spreadsheet ID and range for menu data
  3. Sheet 2 Configuration: Set spreadsheet ID and range for customer data
  4. Sheet 3 Configuration: Set spreadsheet ID and range for notification logs

WhatsApp Integration

  1. WhatsApp Business API: Set up WhatsApp Business API credentials
  2. Webhook Configuration: Configure webhook URLs for message delivery
  3. Message Templates: Create approved message templates for menu updates

Email Integration

  1. Gmail/SMTP Setup: Configure email service credentials
  2. Email Templates: Design HTML email templates for menu notifications
  3. Sender Configuration: Set sender name and email address

Twilio SMS Integration

  1. Twilio Account: Set up Twilio Account SID and Auth Token
  2. Phone Number: Configure Twilio phone number for SMS sending
  3. Message Templates: Create SMS message templates

AI Content Generation

  1. API Configuration: Set up OpenAI or preferred AI service credentials
  2. Prompt Customization: Configure prompts for menu update content
  3. Content Parameters: Set message tone, length, and style

Workflow Execution

Automatic Execution

  1. Scheduled Triggers: Set up cron expressions for regular checks
  2. Webhook Triggers: Configure real-time triggers for immediate updates
  3. Manual Triggers: Enable manual execution for testing

Monitoring and Maintenance

  1. Execution Logs: Monitor workflow execution through n8n interface
  2. Error Handling: Set up error notifications and retry mechanisms
  3. Performance Monitoring: Track execution times and success rates

Sample Notification Message

SPECIAL MENU UPDATE 🍽️

NEW ITEMS:
• Truffle Risotto - $28.99
  Creamy arborio rice with black truffle, parmesan, and wild mushrooms

• Chocolate Lava Cake - $18.99
  Warm chocolate cake with molten center, vanilla ice cream

Total Menu Items: 2
Updated: 7/9/2025, 12:10:50 PM

Visit our restaurant or call to place your order! đź“ž

Best Practices

Data Management

Notification Strategy

Content Quality

Performance Optimization

Troubleshooting

Common Issues

Error Handling

Analytics and Reporting

Key Metrics

Reporting Features

Security and Compliance

Data Protection

Rate Limiting

Conclusion

The Food Menu Update Notifier transforms restaurant communication from reactive to proactive, ensuring customers are always informed about your latest offerings. By leveraging multiple communication channels and AI-generated content, this workflow creates a seamless bridge between your kitchen innovations and customer awareness.

This system not only improves customer engagement but also drives immediate sales through timely notifications about new menu items, special offers, and seasonal dishes. The comprehensive logging and analytics capabilities provide valuable insights for menu optimization and marketing strategy refinement.

đź”— Nodes Used

Send Email, Google Sheets, HTTP Request, Schedule Trigger

đź“Ą Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup