Calculate stock replenishment from Excel reports with Google Drive and GPT-4.1 mini
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 12 nodes and runs on Google Drive events (file created). Along the way it connects Google Drive and OpenAI.
How it runs
Trigger: On Google Drive events (file created).
- Download XLSX (Google Drive): download
- Extract from XLSX (Extract from File): extracts data from a file (xlsx)
- Code: runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
- Convert to XLSX (Convert to File): converts data to a file (xlsx)
- Message a model (OpenAI): uses OpenAI
- Update Sheet (Google Drive): update
- Code: runs custom JavaScript code
…plus 1 more step. 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 (7)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - Extract from File
n8n-nodes-base.extractFromFile - Convert to File
n8n-nodes-base.convertToFile - Google Drive
n8n-nodes-base.googleDrive - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
Quick overview This workflow watches a Google Drive folder for newly uploaded XLSX inventory reports, uses OpenAI (GPT-4.1 mini) to calculate per-product replenishment needs, writes the results back into the spreadsheet as new columns, and then updates and…