The team needed an automated system that would allow them to sort PPE demand data from multiple sources by product and team, control who could access sensitive information (such as delivery address and contact details), and provide multiple data views for the different groups of makers. Make Me PPE turned to Sheetgo for this solution, thanks to the great control over private data, as well as the ability to track and record historical data for forecasting.
Automated management for optimized insights and analysis
Sheetgo built Make Me PPE a unique automated workflow that carries out two main objectives; receive demand updates from various sources so that they can prepare for PPE manufacturing, and analyze and forecast demand by keeping track of previous demand. Firstly, all PPE requests by sources such as the CDC, FDA and the government were delivered using Google Forms. Sheetgo then used the Merge feature to consolidate these requests into a single sheet that the entire team could access. Using Sheetgo filters, the demands were divided for each group, as well as status updates on the progress of each request.
Meanwhile, in the same system, Sheetgo’s append setting is used to record and track the historical data of previous PPE demand requests. Make Me PPE could then use this data to analyze and forecast trends for future demands. Finally, the team set up a custom automated schedule that would allow them to receive updates on a very frequent basis, to respond to PPE requests as close to real-time as possible.