We have a google sheet that is used for sales and inventory for a business. We need a couple of things.
1. Fix an error in one of the current scripts.
2. Create a pick list. The google sheet has an inventory sheet that keeps track of number of inventory items and their locations in the warehouse. We need to be able to create a pick list that goes into the inventory sheet and compiles the items we need as well as their locations.