n8n Verified Creators

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

Getting Started

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!

Value Proposition

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.

Implementation

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.