I need a single web-based dashboard, linked to our Google Drive, that lets every employee open the right Google Sheets without ever seeing data they are not cleared for. Directors must keep full spreadsheet access, but managers and staff should only view or edit the fields I authorise. Core workflow • Each morning I will upload or update multiple Google Sheets. From the dashboard, tasks are automatically assigned to the relevant employee. • Staff mark items done directly in the interface; if a due date slips, the system pings both the assignee and their manager. • I can change columns, field names or validation rules at any time and have those changes cascade to every connected sheet without manual relinking. Security and compliance • Role-based access control decides who can read, write or approve each sheet or field. • Sensitive columns (salary, cost prices, etc.) remain encrypted when stored and decrypted only for directors. • Every view, edit or export action is logged so I can audit what happened, when and by whom. Management insight A built-in MIS view should roll up individual task statistics into team and company performance charts so I can spot delays or bottlenecks at a glance. Key deliverables – Responsive dashboard UI connected to Google Sheets & Drive API – Admin panel to create roles, map fields, and edit validation rules – Automated email / in-app notifications for task completion or delay – Encryption layer plus immutable audit trail – Deployment guide and brief hand-over session so my team can extend the tool later If you have solid experience with Apps Script, Google API, or a preferred web stack that plays well with G-Suite, let’s discuss the quickest path to a secure, flexible launch.