Google sheets has Apps Script which extends its functionalities — allowing the automation of tasks, creation of UIs, webapps, add-ons, etc. This makes it a very powerful tool to create customized solutions for your needs.

A simple approach on dealing with complexities of managing inventory for small businesses using Spreadsheets and Google Apps Script.

Source: Using Google sheets to build a very simplistic Inventory Management solution for your small…