Hi, can help.
Yes it's possible create orders tracking dashboard system base on google spreadsheets, integrate it into google sites and automated all with google scripts.
Project will consists from three main parts and can be extended:
I. Database development base on google spreadsheet
II. Spreadsheet company data management logic
III. Dashboard front-end/visualization of the google sites development and connection it with spreadsheet database layer.
Each part development will costs 250 CAD
Few questions:
1. how you plan input company data? Via form or directly into the google sheet?
2. do you plan to use/include time notificators for deadline of order status?
Regards, Viktor