Automate restaurant sales & inventory forecasting with Gemini AI & Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 9 nodes and runs on a schedule (every week at 20:00). Along the way it connects Google Sheets, Google Gemini Chat Model and Gmail.
How it runs
Trigger: On a schedule (every week at 20:00).
- Load Historical Sales Data (Google Sheets): uses Google Sheets
- Format Input for AI Agent (Code): runs custom JavaScript code
- Generate Forecast with AI (AI Agent): runs an AI agent, with model: Chat Model; 1 tool (AI Think Tool)
- Interpret AI Forecast Output (Code): runs custom JavaScript code
- Log Forecast to Google Sheets (Google Sheets): append
- Email Forecast Summary (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Generate Forecast with AI (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Generate Forecast with AI (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Think Tool
@n8n/n8n-nodes-langchain.toolThink - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Gmail
n8n-nodes-base.gmail
From the author
This automated n8n workflow performs weekly forecasting of restaurant sales and raw material requirements using historical data from Google Sheets and AI predictions powered by Google Gemini. The forecast is then emailed to stakeholders for efficient planning…