How 333ian/company-pawa-it-automation-bot works
Pawa IT Lunch Automation is a Google Apps Script bot for collecting employee lunch choices in a spreadsheet and reporting daily results. Employees respond through emailed links; HR/IT can manage reminders and triggers from a spreadsheet menu. The main stages are scheduling, reminder delivery, response handling, sheet updates, and supervisor reporting. All implementation nodes point to the single source file. The excerpts show selected calls; other capability links are included only where the README documents them.
Main entry points: companysignup.js Reminder Sender
Components 13
Menu and Scheduling
- Authorized Menu
companysignup.js - Daily Triggers
companysignup.js
Reminders and Responses
- Reminder Sender
companysignup.js - Reminder Emails
companysignup.js - Response Handler
companysignup.js
Spreadsheet Records
- Lunch Sheets
companysignup.js - Weekday Sheet Setup
companysignup.js
Reporting
- Pending Responses
companysignup.js - Daily Report
companysignup.js - Supervisor Email
companysignup.js
Other components
- HR / IT
- Employee
- Supervisor
Connections 17
- HR / IT → Authorized Menu: opens
README.md - Authorized Menu → Daily Triggers: manages
companysignup.js - Daily Triggers → Reminder Sender: schedules
companysignup.js - Daily Triggers → Daily Report: schedules
companysignup.js - HR / IT → Reminder Sender: requests manually
README.md - Reminder Sender → Lunch Sheets: reads employees
companysignup.js - Reminder Sender → Reminder Emails: sends
companysignup.js - Reminder Emails → Employee: delivers
README.md - Employee → Response Handler: submits choice
README.md - Response Handler → Lunch Sheets: updates choice
companysignup.js - Weekday Sheet Setup → Lunch Sheets: creates sheets
companysignup.js - Authorized Menu → Pending Responses: opens
companysignup.js - Pending Responses → Lunch Sheets: reads responses
companysignup.js - Pending Responses → Reminder Sender: can invoke
companysignup.js - Daily Report → Lunch Sheets: reads responses
companysignup.js - Daily Report → Supervisor Email: sends
companysignup.js - Supervisor Email → Supervisor: delivers
README.md