Investigate fuel tank variances with Google Sheets, Gemini, and Slack
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 20 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets, Google Gemini Chat Model and Slack.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Validate Webhook Data (Code): runs custom JavaScript code
- Read Tank Data from Sheets (Google Sheets): uses Google Sheets
- Fetch Tank Readings Sheets (Google Sheets): uses Google Sheets
- Retrieve Nozzle Sales Data (Google Sheets): uses Google Sheets
- Extract Delivery Records (Google Sheets): uses Google Sheets
- Load Audit History Sheets (Google Sheets): uses Google Sheets
- Compute Stock Variance (Code): runs custom JavaScript code
- Check for AI Analysis Need (If): checks a condition and branches into true / false
- AI Anomaly Detection (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini Model Analysis
- Apply Manual Defaults (Code): runs custom JavaScript code
…plus 8 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Merge
n8n-nodes-base.merge - Slack
n8n-nodes-base.slack - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
Quick overview Youtube Video: https://youtu.be/XHT46n4b1lg This workflow receives a shift-close webhook and reconciles fuel tank wet-stock in Google Sheets, optionally using Google Gemini to explain anomalies, then logs results back to Google Sheets and posts…