We have developed an AI-powered tool designed to analyze data exported from NetSuite to Google Sheets, enabling users to query inventory, sales, or finance information in natural language. Leveraging generative AI (Gemini), the bot efficiently provides actionable insights and communicates results directly to Slack.
Purpose of the Bot
The primary objective is to simplify ERP data interpretation, making complex information accessible and actionable for all stakeholders, regardless of technical background. Users can submit plain language queries such as: “List 5 items that need restocking, in order of urgency.” This functionality allows for immediate insight into operational status and supports informed decision-making.
Process Flow
The bot executes the following sequence:
- Initiates a saved search in NetSuite via RESTlet.
- Automatically imports resulting data into Google Sheets.
- Utilizes Gemini to analyze and generate summaries of the data.
- Delivers analytical output to Slack channels using a Webhook.
Technologies Utilized
- RESTlet
- Google Apps Script
- Google Sheets
- Gemini
- Slack Webhook
Demo Image
Key Benefits
- Enables natural language queries without IT expertise
- Provides real-time notifications through Webhook integrations
- Operates entirely within Google Workspace, ensuring security and minimizing infrastructure requirements
Use Case Examples
While this solution is currently applied to inventory management, it can be readily adapted for additional business needs, including:
- Sales performance analytics
- Accounts receivable monitoring
- Project profitability assessments
- Prospects and opportunities management