🔄️ AI warehouse inventory cycle count bot using GPT, Telegram and Google Sheets — n8n 워크플로

높음 복잡도⚡ 트리거28개의 노드🏷️ Miscellaneous👁 199회 조회작성자: Samir Saci

개요

Tags: Logistics, Supply Chain, Warehouse Operations, Paperless Processes, Inventory Management

Context

Hi! I’m Samir, Supply Chain Engineer, Data Scientist based in Paris, and founder of LogiGreen.

> Let's use AI with n8n to help SMEs digitalise their logistics operations!

Traditional inventory cycle counts often require clipboards, scanners, and manual reconciliation.

With this workflow, the operator walks through the warehouse, sends voice messages, and the bot automatically updates

사용된 노드

Google SheetsTelegramAI AgentOpenAI Chat ModelStructured Output ParserOpenAI

워크플로 미리보기

AI Powered Inventory Cycle Count Telegram Bot
How it works
1. The workflow is triggered whenever an operator sends
2. It checks whether the message is a command or a voic
1. Telegram Trigger and message format check
2. Get all the locations not yet counted
3. Transcribe and parse the operator audio co
4. If the location or the quantity is missing
5. If the location is in the scope of the cyc
7. Get all the locations not yet counted
6. Generate help or error message based on th
8. Generate a customised instruction to go th
Tutorial
@youtube
parsermodel
⚡
T
Telegram Trigger
Transcribe Operator Comm…
Model: Information Extra…
Structured Output Parser
T
Transcription Error
Ask to repeat
Update Inventory Quantity
Error Message: Wrong Loc…
Get Location, Qty
C
Command
Collect Remaining Locati…
Collect Audio
C
Command Selection
Help Message
W
Wait
R
Remaining Locations
N
Number of Locations
L
Last Location ?
C
Combine with Location Re…
Wrong Command
I
Is Audio?
Get Locations to Check
E
Extract Location IDs
M
Merge Transcript With Lo…
I
Is Location in Scope?
Send Instruction: Next L…
Send Instruction: Last L…
F
First Location
28 nodes28 edges

작동 원리

  1. 1

    트리거

    워크플로는 트리거 트리거로 시작합니다.

  2. 2

    처리

    데이터가 28개의 노드를 통해 흐릅니다, connecting agent, aggregate, googlesheets.

  3. 3

    출력

    워크플로가 자동화를 완료하고 구성된 대상에 결과를 전달합니다.

노드 세부 정보 (28)

GO

Google Sheets

googleSheets

#1
TE

Telegram

telegram

#2
AI

AI Agent

n8n-nodes-langchain.agent

#3
OP

OpenAI Chat Model

n8n-nodes-langchain.lmChatOpenAi

#4
ST

Structured Output Parser

n8n-nodes-langchain.outputParserStructured

#5
OP

OpenAI

n8n-nodes-langchain.openAi

#6

이 워크플로 가져오는 방법

  1. 1오른쪽의 JSON 다운로드 버튼을 클릭하여 워크플로 파일을 저장합니다.
  2. 2n8n 인스턴스를 열고 워크플로 → 새로 만들기 → 파일에서 가져오기로 이동합니다.
  3. 3다운로드된 ai-warehouse-inventory-cycle-count-bot-using-gpt-telegram-and-google-sheets 파일을 선택하고 가져오기를 클릭합니다.
  4. 4각 서비스 노드에 대한 자격 증명（API 키, OAuth 등）을 설정합니다.
  5. 5워크플로 테스트를 클릭하여 모든 것이 작동하는지 확인한 후 활성화합니다.

또는 n8n → JSON에서 가져오기에 직접 붙여넣기:

{ "name": "🔄️ AI warehouse inventory cycle count bot using GPT, Telegram and Google Sheets", "nodes": [...], ...}

통합

agentaggregategooglesheetsiflimitlmchatopenaimergeopenaioutputparserstructuredsetswitchtelegramtelegramtriggerwait

이 워크플로 가져오기

한 번의 클릭으로 다운로드 및 가져오기

JSON 다운로드n8n.io에서 보기
노드28
복잡도high
트리거trigger
조회수199
카테고리Miscellaneous

제작자

Samir Saci

Samir Saci

@samirsaci

태그

agentaggregategooglesheetsiflimitlmchatopenaimergeopenaioutputparserstructuredset
⚡

n8n을 처음 사용하시나요?

n8n은 무료 오픈소스 워크플로 자동화 도구입니다. 자체 호스팅하거나 클라우드 버전을 사용하세요.

n8n 무료로 시작하기 →

Related Miscellaneous Workflows

COGMGOME+2
high

Automate Google Form Tracking & Gmail Alerts via n8n

Boost your administrative efficiency with this comprehensive n8n automation suite designed to bridge the gap between data collection and actionable insights. This workflow transforms standard Google Form submissions into a high-performance management ecosystem. Instead of manually checking spreadsheets, the system triggers instantly upon form submission, updating a centralized Google Sheets dashboard with real-time statistics while simultaneously executing conditional logic via the Code node. The automation intelligently distinguishes between new registrants and follow-ups, triggering personalized Gmail acknowledgments for immediate engagement. Furthermore, it incorporates a sophisticated reminder logic to ensure no student or lead falls through the cracks. By leveraging Webhook and Respond to Webhook nodes, the suite maintains a low-latency connection between your front-end forms and back-end database. This setup eliminates manual data entry errors, reduces response times by up to 90%, and provides stakeholders with a live visual overview of registration trends. It is an essential toolkit for any organization looking to scale their intake process without increasing headcount. **Common Use Cases:** - Educational Workshop & Course Enrollment Management - Automated Event Registration with Instant Attendee Confirmation - Customer Inquiry Routing and Lead Nurturing Pipeline

🔗 Webhook·20 nodes