Skip to main content

Documentation Index

Fetch the complete documentation index at: https://mintlify.com/arsinousltd-sudo/Arsinous-V8-Sales/llms.txt

Use this file to discover all available pages before exploring further.

Arsinous V8 Sales is a complete sales management platform built on Google Apps Script and Google Sheets. It connects your spreadsheet to a MySQL database, giving your team a familiar interface for managing customers, products, invoices, inventory, and financial reporting — without leaving Google Workspace.

Introduction

Learn what Arsinous V8 Sales is, how it works, and what problems it solves.

Setup

Deploy the script to your Google Spreadsheet and connect it to MySQL in minutes.

Configuration

Configure database credentials, Google Drive folders, and VAT codes.

Core Features

Explore customers, products, invoices, inventory, payments, and discounts.

What’s Inside

Arsinous V8 Sales provides a fully integrated sales workflow backed by a MySQL database, all operated from within Google Sheets.

Customers

Create and edit customers with linked Google Drive folders.

Products

Manage your product catalog with VAT codes and tiered pricing.

Invoices

Issue invoices and credit notes with automatic Google Sheets documents.

Inventory

Track lot-level stock with expiry dates and purchase order quantities.

Payments

Record customer payments and deposits, filter by date and type.

Discounts

Set percentage and fixed discounts per product per customer.

Financial Reporting

Balance

Statement of Account with a running balance for any customer.

Accounts Receivable

Aging report that buckets outstanding amounts by time period.

All Balances

Summary view of every customer’s outstanding balance.

Getting Started

1

Copy the script to your spreadsheet

Deploy the Apps Script project to a new Google Spreadsheet using the Google Apps Script editor or clasp CLI.
2

Configure your database connection

Set your MySQL host, database name, username, and password in Constants.gs, then configure Google Drive folder IDs.
3

Open the spreadsheet

On first open, the Arsinous sidebar appears automatically and the onOpen trigger creates the Arsinous menu.
4

Start managing sales

Use the sidebar to refresh tabs and control date filters. Create your first customer, add products, and issue your first invoice.
Arsinous V8 Sales requires a Google Workspace account with Apps Script access and a reachable MySQL database. The script runtime must have network access to your database host on port 3306.

Build docs developers (and LLMs) love