Skip to content
NEWError doctor and Watchtower: failed n8n runs explained in plain words, and emailed to you. See what is new

Library / Reports, Analytics & Dashboards

Reports, Analytics & Dashboards

Email Daily Restaurant Sales Insights with Gemini

Every day, it pulls sales, food waste and feedback data from Google Sheets, has Gemini write insights and emails the report through Gmail.

Import it free Sign in to open it

What it does

## Merge & Email Creation 📧 1. Combines the processed sales, food waste, and customer feedback data from the three AI analysis branches into a single data item. 2. A Code node structures the merged data for the final AI email summary generator. 3. An AI Agent compiles the combined data into a comprehensive, plain-text email body, including key metrics, detailed insights, and next-day suggestions.

The steps

  1. Google Gemini Chat Model for summary
  2. Think for summary
  3. Daily Report Scheduler
  4. Fetch Daily Sales Data
  5. Normalize Sales Records
  6. AI Sales Insights Generator
  7. Format Sales AI Output
  8. Google Chat Model
  9. Think Tool
  10. Fetch Daily Food Waste Records
  11. Normalize Waste Data
  12. AI Waste Reduction Insights Generator
  13. Format Waste AI Output
  14. Chat Model For Food Waste

27 steps in total.

Similar automations

Reports, Analytics & DashboardsForecast Restaurant Sales and Inventory with Gemini9 stepsReports, Analytics & DashboardsForecast Restaurant Food Waste Daily with Gemini12 stepsLead Generation & EnrichmentMarket and Book Restaurant Orders by VAPI Voice9 stepsForms & SurveysProcess Restaurant Orders and Suggestions with Gemini and Telegram11 steps