Preventive Maintenance Scheduler
Every Sunday, reads your asset list from Google Sheets, finds the maintenance jobs due within the coming week and creates a ClickUp task for each. It also emails the vendor to book the visit.
Steps in this flow
- Every Sunday 7:00
- Google Sheets: read the asset list
- Find jobs due this week
- For each job due
- ClickUp: create the maintenance task
- Vendor email known?
- Email the vendor to book a visit
- Google Sheets: log the job