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