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

  1. Every Sunday 7:00
  2. Google Sheets: read the asset list
  3. Find jobs due this week
  4. For each job due
  5. ClickUp: create the maintenance task
  6. Vendor email known?
  7. Email the vendor to book a visit
  8. Google Sheets: log the job

All templates