It has other data that I need to store, bunch of relevant dates and locations of pickup/dropoffs. I have an script that updates our ERP from that spreadsheet.

It has other data that I need to store, bunch of relevant dates and locations of pickup/dropoffs. I have an script that updates our ERP from that spreadsheet. I also have a google apps script that sends out an email with all the relevant containers. e.g. container ABCD needs to be picked up by 5/12/2020 and container UVWX needs to be returned by 5/17/2020. This allows our logistics guy to allocate resources.