Smart Logistics and Inventory
Build intelligent logistics and inventory management workflows that analyze shipment data and stock levels, identify delays and bottlenecks, forecast future needs, and deliver comprehensive reports with AI-powered optimization recommendations.
Target Audiences
Prerequisites
Access to a Delaverse account
Customer data (e.g., name, phone number, email, purchase history) ready for upload
Google account access for Google Sheets and Google Docs Nodes
API access to CRM systems (if used) with authentication details
Step 1: Create a New Project
Log in to Delaverse: Visit playground.delaverse.ai and sign into your Delaverse account
Select New Project: On the projects dashboard, click the New Project box
Name the Project: Enter a title, e.g., Smart Logistics and Inventory Management, in the Project Name field and click Create Project
Enter the Playground: You'll be directed to the project's Playground, where you can add nodes
Step 2: Add Logistics and Inventory Data Input Nodes
To analyze logistics and inventory, data must be retrieved from one of two sources: Google Sheets or API. Users must choose one method.
2.1. Google Sheets Node
Uploads tabular logistics and inventory data
1
Add Node: From the right-hand menu, click Google Sheets Node2
Configure Node: Click the node and enter a title, e.g., دادههای لجستیک و موجودی (Logistics and Inventory Data)3
Sign in with your Google account and create a new sheet4
Enter data (e.g., shipment code, status, product inventory)5
Return to the Playground and click Update6
Save Changes: Click Save Changes and close the editor with the top-left X buttonSuggested Content:
Logistics Table: Columns for shipment code (e.g., SH123), dispatch date (e.g., 1404/03/01), destination (e.g., Tehran), status (e.g., in transit, delayed), estimated arrival time
Inventory Table: Columns for product code (e.g., PRD001), name (e.g., phone), current stock (e.g., 50), minimum stock (e.g., 10), monthly sales (e.g., 100 units)
2.2. API and Request API Nodes
Retrieve data from logistics/inventory systems (e.g., ERP)
Add API Node:
From the right-hand menu, click API Node
Click the node and enter a title, e.g., API لجستیک (Logistics API)
Enter the base URL (e.g., https://logistics.example.com/api)
Configure Authentication: No Authentication, Basic Auth, Bearer Token, or API Key
If headers or query parameters are needed, click Add Header, enter name and value
Click Save Changes and close the editor with the top-left X button
Add Request API Node:
From the right-hand menu, click Request API Node
Click the node and enter a title, e.g., دریافت دادههای لجستیک (Fetch Logistics Data)
In the Used API section, select the previous API Node
Choose the request type (e.g., GET) and enter the endpoint (e.g., /shipments or /inventory)
Configure tabs: Request, Headers, Parameters, Body, Response
Click Execute Request to view results
Connect the API Node's output to the Request API Node's input
Suggested Content:
Logistics Data: Shipment code, date, destination, status, estimated arrival
Inventory Data: Product code, stock level, sales rate, minimum stock
Note: Users must choose either Google Sheets or API. Combining both creates complexity not covered in this guide.
Important: Completing these steps is straightforward with the necessary access. However, if you need to connect an API through your system and lack the expertise, consult your company’s technical team. If you don’t have a technical team or they’re unavailable, submit a ticket to us. Request workflow creation by our team, and we’ll prepare a cost invoice based on your subscription level. After payment, we’ll work with you to build the workflow to meet your needs.
Step 3: Connect Data to Analysis Nodes
This step depends on whether you need real-time data updates. Choose one of the following approaches.
3.1. Connect Google Sheets to Vector Database Node (Static Data)
Add Node: From the right-hand menu, click Vector Database Node.
Configure Node: Click the node and enter a title, e.g., Inventory Database. Click Update.
Connect Node: Connect the Google Sheets Node’s output to the Vector Database Node’s input.
Verify Data: Click the Vector Database Node to ensure data is correctly aggregated.
Save Changes: Click Save Changes and close the editor with the top-left X button.
Important Note: When connecting Google Sheets to the Vector Database, updating the data in Google Sheets does not automatically update the Vector Database, as the data is stored statically. To update the data:
• Delete the file in the Vector Database associated with the Google Sheets.• Disconnect the Google Sheets and Vector Database nodes.
• Update the Google Sheets data.
• Reconnect the Google Sheets and Vector Database nodes to load the updated data.
3.2. Connect Google Sheets Directly to AI Assistant (Dynamic Data)
For real-time data updates without using the Vector Database:
Add Function Call Node:
• From the right-hand menu, click Function Call Node.
• Click the node, enter a title, and press the Parameters button.
• For non-technical users: Select the “Read from Sheets” template to auto-configure parameters.
• In the generated JSON schema, ensure the “name” parameter matches your preferred function name.
• Copy your Google Sheet’s ID from the Google Sheets Node and paste it into the section marked your_sheet_id in the JSON schema.
• For technical users: Click Build with AI, write your custom instructions in Persian, and click Build Smart Parameters.
Connect Nodes:• From the right-hand menu, click Function Call Node.
• Click the node, enter a title, and press the Parameters button.
• For non-technical users: Select the “Read from Sheets” template to auto-configure parameters.
• In the generated JSON schema, ensure the “name” parameter matches your preferred function name.
• Copy your Google Sheet’s ID from the Google Sheets Node and paste it into the section marked your_sheet_id in the JSON schema.
• For technical users: Click Build with AI, write your custom instructions in Persian, and click Build Smart Parameters.
Connect the Google Sheets Node’s output directly to the AI Assistant Node’s input, and connect the AI Assistant Node’s output to the Function Call Node’s input.
Note: The Request API Node does not connect to the Vector Database Node; connect it directly to the AI Assistant Node.
Step 4: Add the AI Assistant Node
This node analyzes logistics and inventory data and generates analytical reports:
Add Node: From the right-hand menu, click Analyzer Node
Configure Node: Click the node and enter a title, e.g., تحلیلگر لجستیک و موجودی (Logistics and Inventory Analyzer)
Select AI Model: Select an AI model (e.g., Open AI)
Instructions: Choose the Logistics and Inventory Management template or edit the instruction (see below)
Connect Nodes: If using Google Sheets with static data, connect Vector Database to AI Assistant. If using Google Sheets with dynamic data, connect Google Sheets directly to AI Assistant via the Function Call Node. If using API, connect Request API directly to AI Assistant
Save Changes: Click Save Changes and close the editor with the top-left X button
Logistics and Inventory Management Instruction Template
You are an AI assistant for warehouse inventory management. Your goal is to analyze inventory data to identify delays, bottlenecks, low-stock or overstocked products, and forecast future needs.
- Retrieve data from the Google Sheet with the following ID: {your sheet ID} in a vector database.
- Perform the following analyses:
- Inventory: Identify low-stock products (below minimum inventory), overstocked products (excessive inventory), and forecast needs based on sales rates and seasonal trends.
- Suggestions: Provide recommendations for optimization (e.g., increasing stock for product X).
- Write responses in Persian with a professional and friendly tone.
Critical Function Call Requirements: After providing your analysis, you must immediately call the function {your function name} with the full analysis text as the content parameter. Do not call the function with empty parameters like {}.
Mandatory Steps:
1. First: Provide your complete analysis response in Persian.
2. Then: Immediately call the function {your function name} with the same full analysis text as the content parameter. Call the function with the following values:
json
{
"doc_id": "your doc ID",
"content": content
}
The content parameter must be the complete analysis in Markdown format, not empty or summarized, but the full text.
Reminder: The function call is mandatory and must include your complete analysis as the content.
Important: Ensure the analysis result is sent to Telegram in its entirety.
Step 5: Deliver Reports
Users can receive reports via Telegram, Google Sheets, or Google Docs.
5.1. Telegram Node (Optional)
To deliver reports via Telegram:
Create a Telegram Bot:
• In Telegram, go to @BotFather, send /start, then /newbot• Choose a name, e.g., @LogisticsBot, and copy the bot token
Configure Telegram Node:
• Add Node: From the right-hand menu, click Telegram Node• Enter the bot token and click Test Connection• Configure Advanced Settings (Welcome Message, Group Access, etc.)
• Add Node: From the right-hand menu, click Telegram Node
• Enter the bot token and click Test Connection
• Configure Advanced Settings (Welcome Message, Group Access, etc.) Welcome Message: سلام! آماده گزارش وضعیت لجستیک و موجودی هستید؟ 😊 (Hello! Ready for logistics and inventory updates? 😊). Set Group Access, Access Restriction to All, Message Limit to 10 messages per minute.
5.2. Google Sheets Node (Optional)
To store reports in a table:
Add Google Sheets Node:
• From the right-hand menu, click Google Sheets Node• Enter title, e.g., گزارش لجستیک (Logistics Report)• Sign in and create new sheet with columns: shipment/product code, status, delay, stock, forecast
Add Function Call Node:
• Click Function Call Node from right-hand menu.• Select node, add title, click Parameters.• Non-technical: Use "Write to Google Sheets" template for auto-config.• Ensure JSON "name" matches function name.• Copy Google Sheet ID from Google Sheets Node, paste into "your_sheet_id" in JSON.• Technical: Use "Build with AI," write Persian instructions, click "Build Smart Parameters."
5.3. Google Docs Node (Optional)
To store reports as text:
Add Google Docs Node:
• From the right-hand menu, click Google Docs Node• Enter title, e.g., گزارش متنی لجستیک (Logistics Text Report)• Sign in and create new document for report content
Add Function Call Node:
• Click Function Call Node from right-hand menu.• Select node, add title, click Parameters.• Non-technical: Use "Write to Google Docs" template for auto-config. Set JSON "name" to match function name. • Copy Google Doc ID from Google Docs Node, paste into "google_doc_id" in JSON. • Technical: Use "Build with AI," write Persian instructions, click "Build Smart Parameters."
Step 6: Connect to the Frame Chat Node
This step enables delivering AI Assistant responses via an interactive chat frame on your website or app, with testing capabilities:
Basic Configuration
• Add Frame Chat Node from right-hand menuEnter title, e.g., Feedback FrameSet company name (e.g., Delaverse)
Domain & Style Configuration
• Domain & Style Configuration
Implementation & Testing
• Connect AI Assistant to Frame Chat• Go to Code tab and copy HTML code• Use Test Frame to preview responses
Testing and Verification
• After connecting to the AI Assistant, a Test Frame option appears• Enter sample queries to review responses• Ensure responses are accurate, professional, and aligned with input data• Click Save Changes to persist all settings
Step 7: Add Container and Analyzer Nodes (If Using Telegram)
For comprehensive data and conversation analysis:
Add Container Node
• From the right-hand menu, click Container Node• Click the node and enter a title, e.g., کانتینر لجستیک (Logistics Container)• Place all previous nodes (API, Request API, Google Sheets, Vector Database, AI Assistant, Telegram) inside the Container
Add Analyzer Node
• From the right-hand menu, click Analyzer Node• Click the node and enter a title, e.g., تحلیلگر جامع (Comprehensive Analyzer)• Choose the Logistics and Inventory Management template or edit the instruction (see below)• Connect the Container Node's output to the Analyzer AI Assistant Node's input
Comprehensive Analyzer Instruction Template
For Assistant Messages:
You are an AI assistant tasked with comprehensive inventory analysis based on assistant messages.
Your goal is to analyze inventory data to generate key metrics and periodic reports.
Required Actions and Analyses:
• Key Metrics: Percentage of delays, inventory consumption rate, high-risk products (low or overstocked).
• Periodic Trends: Changes in delays or inventory over past weeks/months.
• Advanced Forecasting: Predict delays or inventory needs based on trends.
• Recommendations: Solutions for improvement (e.g., rerouting shipments or ordering products).
Step 8: Add the Trigger Node
To automate the initiation of your workflow with precise timing:
Add Node:
• From the right-hand menu, click Trigger Node and drag it onto the canvas in the Delaverse Playground.
Configure Node:
Click the node and enter a title.Timing Settings: In the “Timing Settings” section, choose the scheduling type from the dropdown: • Interval: Select a value and unit (e.g., 1 day) for regular execution, and set the timezone (e.g., Asia/Tehran).• Cron Expression: Enter a Cron pattern, e.g., “0 8 * * *” for daily at 8 AM, following the provided example.Message Text: Enter “مطابق دستورالعمل، عمل کن” (Act per instructions) to guide the AI Assistant Node in executing the workflow’s analysis and reporting tasks.Maximum Executions: Leave blank for unlimited runs or enter a number (e.g., 10) to cap executions.Trigger Status: Toggle the status button to “On” to activate the trigger.Status Info: After setup, review execution history (e.g., runs completed) and click “Update Schedule” if timing changes are needed.
Connect Nodes:
• Connect the Trigger Node’s output to the AI Assistant Node’s input to initiate the workflow.
Test the Trigger
• Configure timing and message text, then click “Test Trigger” to simulate a workflow run. Verify outputs appear in Telegram, Google Sheets, or Google Docs, depending on your setup.
Save Changes:
• Click “Save Changes” to apply all configurations, then close the editor with the top-left “X” button to return to the Playground.
Why It’s Needed
• The Trigger Node automates the start of non-API workflows, working with the AI Assistant Node to initiate the workflow.
Key Tips for Success
Data Source Selection: Choose either Google Sheets or API to reduce complexity
Training Content: Use real data like shipment codes, stock levels, or sales rates
Persian Language: Keep all settings and outputs in Persian
Testing: Verify reports in Telegram, Google Sheets, or Google Docs
Continuous Saving: Click Save Changes after every modification
Final Output
Logistics and inventory data is collected from Google Sheets or API
Analyses of delays, bottlenecks, low/excess stock, and forecasted needs are generated
Reports are delivered via Telegram (text responses), Google Sheets (tables), or Google Docs (text reports)
Periodic trends and key metrics are provided through the Comprehensive Insights Node
General Note on Workflow Customization
This workflow, like all workflows in Delaverse’s knowledge base, is designed as a sample for educational purposes. Users can extensively customize nodes, settings, and input files to meet personal or organizational needs. For assistance, consult our 24/7 support chatbot or submit a ticket for guidance. If you’re unable to build or modify the workflow yourself, request professional workflow creation via a ticket; we’ll provide a cost invoice based on your subscription level, and after payment, we’ll collaborate to build it. For new node development (e.g., a custom node not yet available), submit a ticket with your requirements, noting that such requests may incur higher costs due to development efforts. Our team is here to ensure your automation success! 😊
This workflow, like all workflows in Delaverse’s knowledge base, is designed as a sample for educational purposes. Users can extensively customize nodes, settings, and input files to meet personal or organizational needs. For assistance, consult our 24/7 support chatbot or submit a ticket for guidance. If you’re unable to build or modify the workflow yourself, request professional workflow creation via a ticket; we’ll provide a cost invoice based on your subscription level, and after payment, we’ll collaborate to build it. For new node development (e.g., a custom node not yet available), submit a ticket with your requirements, noting that such requests may incur higher costs due to development efforts. Our team is here to ensure your automation success! 😊
Ready to Transform Your Logistics and Inventory Management?
Start building your intelligent logistics and inventory workflow today. Analyze shipment data, identify bottlenecks, forecast inventory needs, and optimize operations with AI-powered insights that drive efficiency and cost savings.