Using a Google spreadsheet for inventory is the best way to keep track of your merchandise as you grow your business. It's possible to use this software to automate a lot of the processes of running your business and improve the profitability of your operation. A Google spreadsheet for inventory is especially helpful for entrepreneurs who need to manage their inventory from multiple locations.