Build AI Business Solutions with Workflow Automation | NappAI

graph TD %%{init: {'theme': 'mc','layout': 'elk'}}%% ChatInput-idt53[<div><img src="/_astro/messages-square.BaSDmT6g.svg" style="height: 20px !important;width: 20px !important"/></div>Chat Input] style ChatInput-idt53 stroke:#a170ff AdvancedAgent-slwuk[Agent] style AdvancedAgent-slwuk stroke:#a170ff GoogleGenerativeAIModel-t5o3f[Gemini] style GoogleGenerativeAIModel-t5o3f stroke:#a170ff Airtable-f9c4x[read] style Airtable-f9c4x stroke:#a170ff Airtable-pfewz[update] style Airtable-pfewz stroke:#a170ff ChatOutput-rxxgc[<div><img src="/_astro/messages-square.BaSDmT6g.svg" style="height: 20px !important;width: 20px !important"/></div>Chat Output] style ChatOutput-rxxgc stroke:#a170ff Airtable-m6dwr[create] style Airtable-m6dwr stroke:#a170ff ChatInput-idt53 -.- AdvancedAgent-slwuk linkStyle 0 stroke:#a170ff GoogleGenerativeAIModel-t5o3f -.- AdvancedAgent-slwuk linkStyle 1 stroke:#a170ff Airtable-f9c4x -.- AdvancedAgent-slwuk linkStyle 2 stroke:#a170ff Airtable-pfewz -.- AdvancedAgent-slwuk linkStyle 3 stroke:#a170ff AdvancedAgent-slwuk -.- ChatOutput-rxxgc linkStyle 4 stroke:#a170ff Airtable-m6dwr -.- AdvancedAgent-slwuk linkStyle 5 stroke:#a170ff

Entrada Pedidos

🧩 Overview

This workflow defines an automated sales assistant that helps users select products and manage order registration. It receives user queries, consults real-time inventory data, and provides advice based on product availability and pricing. Before registering an order, it presents a summary for user confirmation and only proceeds to update stock and log the order in the database after receiving explicit approval. The final response is delivered to the user through a chat interface, maintaining a professional and helpful tone throughout the interaction.

⚙️ Main Features

Provides real-time product information by querying an inventory database.
Guides users through product selection and advises on quantities based on stock levels.
Presents a detailed order summary and requires explicit user confirmation before processing.
Automatically updates product stock levels and creates new order records in the database upon confirmation.
Ensures data integrity by validating all required order information is complete before saving.

🔄 Workflow Steps

Component Name	Role in the Workflow	Key Inputs	Key Outputs
Chat Input	Captures the initial user query or message.	User message text	User Message
Agent	The core conversational AI that orchestrates the sales process. It interprets the user's intent, uses tools to fetch data, provides advice, and manages the order confirmation and registration logic.	User Message, Language Model, Database Tools	Agent Response
Gemini Model	Provides the underlying language model powering the agent's reasoning and conversational abilities.	Model configuration	Language Model
Airtable (Read)	Serves as a tool for the agent to retrieve current product information from the inventory database.	Database query parameters	Product Data
Airtable (Update)	Serves as a tool for the agent to reduce product stock levels in the inventory after an order is confirmed.	Record ID, updated stock value	Update Result
Airtable (Create)	Serves as a tool for the agent to create a new order record in the orders database.	Order details (product, quantity, buyer info, etc.)	Create Result
Chat Output	Delivers the agent's final response back to the user interface.	Agent Response	Formatted Message

🧠 Notes

The workflow is designed for a conversational interface and maintains context across interactions.
The agent is instructed to always check real-time inventory before providing product advice and never to invent data.
A strict security rule prevents any database writes (stock updates or order creation) without an explicit "yes" from the user.
The agent validates that all necessary fields for an order record are complete before attempting to save it.
The workflow assumes a pre-configured connection to an Airtable base containing Productos and Pedidos tables.