mihozip/google-workspace-admin-project-workflow

This repository is a hybrid teaching kit and ready to deploy template for school administrators in Taiwan who want to run their paperwork through Google Workspace. The first half is a lesson plan: it walks a teacher through using NotebookLM and Gemini to organize course materials, draft official documents, and produce result reports. The second half turns the same flow into a half automated workflow built on Google Forms, Sheets, Drive, Docs, Calendar, Gmail, and Apps Script. The core idea is one project, one folder. When an administrator receives an official document and needs to track an event, a meeting, or a school activity, they fill in a starter form. An Apps Script trigger then creates a standard subfolder tree in Drive for that case, opens a Docs file as the project log, and adds rows to a master Sheet that lists the project number, owner, status, todos, and stage dates. A second form lets the owner add more milestones later, and each milestone becomes a Calendar reminder, a row in a stage date log, and an email notice to the responsible person. The README is honest about what the system does not do. It only files documents, tracks them, and sends reminders. It does not publish formal announcements, handle budget reconciliation, deliver final results, send external notices, or make legal or privacy judgments. A human still has to do all of that. Installation is described as a five minute job. You create one root folder in Drive, copy its folder ID, plug it plus a Calendar ID and an admin email into a PHP file called generate_apps_script_installer.php, paste the generated code into a new Apps Script project, then run setupAdminWorkflow(). The README warns clearly: do not commit real Drive folder IDs, Calendar IDs, school accounts, or student information to a public repository.