Restaurant Daily Insights with Gemini AI - Sales, Waste & Feedback Email Summary

In this guide, we’ll walk you through setting up an AI-driven n8n workflow that automatically retrieves daily sales, food waste, and customer feedback data from Google Sheets, generates actionable insights with Gemini AI, combines them into a comprehensive report, and creates it as an email draft. Ready to automate your restaurant’s daily insights? Let’s get started!

• Automates daily data collection for quick insights.
• Provides actionable reports using Gemini AI analysis.
• Tracks sales, waste, and feedback in one summary.
• Saves time with automated email draft creation.

• Daily Trigger (2:10 PM IST): Starts the workflow daily at 2:10 PM IST to gather data.
• Fetch Sales Data: Pulls daily sales figures from Google Sheets.
• Fetch Waste Data: Retrieves food waste data from Google Sheets.
• Fetch Feedback Data: Gathers customer feedback from Google Sheets.
• Merge Data: Combines all data into a single dataset.
• Generate Insights with Gemini AI: Uses Gemini AI to analyze and create insights.
• Format Report: Structures the insights into a readable report.
• Create Email Draft: Generates an email draft with the report.
• Send Email Draft: Delivers the draft to the designated email.

Want to dive deeper? Check it out here: Official Workflow Page.

Ready to transform your business with our Workflow Automation Solutions with n8n? Contact Us  today to Leverage Our AI/ML Expertise.