Tenant complaints: triage, technician dispatch, acknowledgement and SLA tracking

The scenario takes complaints from email and a web form, classifies them, finds the technician, opens a work order, acknowledges the tenant and escalates anything overdue.

  • Email and form complaints are handled the same way
  • The technician is matched by fault category, not from memory
  • The tenant gets an acknowledgement with a reference immediately
  • Overdue requests escalate to management on their own
Webhook

How it works

To pass leads from SeaTable to Gmail automatically, use a ready-made scenario — no manual copying, no lost leads.

  1. Starts when: Schedule Trigger
  2. Then: Search records
  3. Check: Loop over tickets
  4. Check: SLA breached?
  5. If yes: Escalate to FM Management
  6. Then: Normalise email inputs
  7. Check: Merge inputs
  8. Then: LLM extract & classify
  9. Then: Parse LLM output
  10. Then: Search technician
  11. Then: Create work order
  12. Then: Send ACK email
  13. Then: Update ACK status
  14. Then: Send a message
  15. Then: Normalise form inputs
  16. Starts when: Webhook
  17. Starts when: Gmail trigger

You can launch this SeaTable + Gmail integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.