Automated multi-site inventory tracking system

This inventory tracking system for managing multiple warehouses combines Google Sheets, Google Forms, and Sheetgo. This is a flexible system so you can also include additional tools like a QR-code scanner to register items, create automated inventory dashboards and generate hourly updated lists of available items.

Key benefits

Track deliveries

Make sure that every item that enters or leaves your warehouses and depots is logged correctly.

User-friendly system

With Google Forms, your staff have a quick and simple way to record the movement of goods.

Accurate inventory data

Streamline data flows across all your storage sites and get up-to-date information at your fingertips.

How to build this multi-site inventory tracking system

Step 1

Create a Google Form and include the following:

  • Item name / product SKU
  • Quantity of items
  • Checking items in?
  • Checking items out?
  • Name of employee filling out form
  • Timestamp

Share this form with everyone responsible for checking items in or out of the warehouse.

Step 2

Duplicate the Google Form for each warehouse you want to manage. You may have to edit certain questions as some warehouses may stock different items and so on.

You should now have one Google Form per location/warehouse.

 

Step 3

Use Sheetgo to connect the output from the Google Forms to your warehouse inventory management spreadsheet.

💡Tip!
If you have a lot of warehouses, use Sheetgo’s distribute feature. It allows you to distribute data from one spreadsheet to multiple other Google Sheets.

Step 4

To create a master inventory tracking management spreadsheet, use Sheetgo’s consolidate feature to merge data from many individual sheets into one single spreadsheet.

💡Tip!
As a best practice, use the =ARRAY formula to organize your data.

Step 5

Turn on automatic updates and schedule them on an hourly frequency to assure your inventory spreadsheets contain the latest information.

Step 6

Inside your inventory master spreadsheet, use charts and graphs to create your own custom inventory tracking dashboard.

If you’re looking for a helping hand with this, check out our blog post on how to create a dashboard in Google Sheets.

Need help? Talk to our experts

Do you need assistance designing your workflow? Looking for a more complex inventory management system or don’t have the time and resources to build it yourself?

Speak to our business automation experts about custom workflow design and implementation.

Connect spreadsheets, automate your work.