This n8n workflow automates the process of generating and delivering a comprehensive daily report for restaurant management. It pulls data from Google Sheets on sales, food waste, and customer feedback, processes each dataset through AI agents to analyze and extract key insights, and then merges these insights into a structured email report. The workflow is scheduled to run daily, providing restaurant owners and staff with timely performance updates and actionable suggestions to optimize operations, reduce waste, and enhance customer satisfaction.

Step-by-step, the workflow begins with a scheduled trigger every evening. It fetches sales data, food waste records, and customer feedback from Google Sheets. Each dataset then undergoes normalization and analysis via AI agents—sales insights identify top-performing dishes and profitability, waste insights highlight waste costs and problem areas, and feedback analysis uncovers customer sentiment and recurring issues.

The insights from each analysis are merged, formatted into a clear and concise email body by an AI text generator, and then the email is automatically sent via Gmail to designated recipients. This automation ensures that restaurant management consistently receives up-to-date, data-driven reports without manual effort, aiding in strategic decision-making and continuous improvement.

Node Count	>20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmChatGoogleGemini, @n8n/n8n-nodes-langchain.toolThink, code, gmail, googleSheets, merge, scheduleTrigger, stickyNote, wait