Automate Restaurant Sales & Inventory Forecasting with Gemini AI & Google Sheets

This n8n workflow automates the process of generating sales and inventory forecasts for a restaurant using Google Gemini AI and Google Sheets. It periodically reads sales data, processes it with an AI agent to produce predictions, and can potentially integrate with other systems for further actions (though the current JSON focuses on the core forecasting logic).

What it does

This workflow performs the following key steps:

1. Triggers on a Schedule: The workflow is designed to run periodically, likely to generate forecasts at regular intervals (e.g., daily, weekly).
2. Reads Sales Data from Google Sheets: It connects to a Google Sheet to retrieve existing sales and inventory data. This data serves as the input for the AI forecasting.
3. Processes Data with an AI Agent (Google Gemini):
   • It utilizes an AI Agent (powered by LangChain) to orchestrate the forecasting process.
   • The agent leverages a Google Gemini Chat Model as its underlying language model to analyze the sales data and generate predictions.
   • A Think Tool is integrated, suggesting the AI agent has capabilities to reason and plan its steps during the forecasting task.
4. Generates Forecasts: Based on the input data and the AI model's capabilities, the agent will produce sales and inventory forecasts.
5. Potential for Further Actions: While not explicitly defined in the current JSON, the output of the AI agent can be used to update other Google Sheets, send notifications via Gmail, or integrate with other restaurant management systems.
6. Code Node for Custom Logic: A Code node is included, allowing for custom JavaScript logic to be executed. This could be used for data cleaning, formatting, or more complex post-processing of the AI-generated forecasts before they are used elsewhere.
7. Sticky Note for Documentation: A Sticky Note is present, likely for internal documentation or instructions within the workflow itself.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Account: A Google account with access to Google Sheets and Google Gemini API.
• Google Sheets: A Google Sheet containing your restaurant's historical sales and inventory data, structured in a way that the workflow can read.
• Google Sheets Credential: An n8n credential configured for Google Sheets (OAuth 2.0 or Service Account).
• Google Gemini Chat Model Credential: An n8n credential configured for the Google Gemini Chat Model.
• Gmail Credential (Optional): If you intend to use the Gmail node for notifications, a Gmail credential will be required.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Set up your Google Sheets credential. Ensure it has read/write access to the relevant spreadsheet.
   • Set up your Google Gemini Chat Model credential.
   • (Optional) Set up your Gmail credential if you plan to use it.
3. Configure Nodes:
   • Schedule Trigger: Adjust the schedule to your desired frequency for generating forecasts.
   • Google Sheets: Configure this node to point to your specific sales and inventory Google Sheet, specifying the spreadsheet ID and range.
   • AI Agent / Google Gemini Chat Model: Ensure these nodes are correctly configured with your Gemini API key and any specific model parameters if necessary.
   • Code: Review and modify the Code node if you have specific data manipulation or formatting requirements.
4. Activate the Workflow: Once configured, activate the workflow to start automated forecasting.