TICKET MANAGEMENT

Turn maintenance request emails into triaged work orders

Reads inbound facilities request emails, uses AI to extract the asset, location, and severity, logs a structured work order in Airtable.

CategoryTicket Management
EngineSim + Paperclip
Difficultyadvanced
Triggerevent
Steps5
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNew request email receivedGmailGmail
  • ActionExtract asset, location, severity with AIOpenAI
  • LogicMatch location to building, crew, and SLA tier
  • ActionWrite structured work order to AirtableAirtableAirtable
  • OutputCreate Trello card on building boardTrelloTrello

What it does

Converts free-text maintenance emails into clean, structured work orders. An AI step parses the unstructured message into asset, building, fault, and severity fields, removing manual re-keying from the intake desk.

When to use it

Use it when tenants and staff still email repair requests in plain language and someone has to read each one and open a ticket. This automates that triage while preserving the original email for reference.

How it works

  1. 1A new email arriving in the facilities inbox triggers the flow.
  2. 2An AI step extracts asset name, location, fault description, and inferred severity from the email body.
  3. 3The extracted location is matched to a building and crew, and an SLA tier is assigned.
  4. 4A structured work-order row is written to Airtable with the parsed fields and source email.
  5. 5A Trello card is created on the building's board, tagged with severity and crew, ready to dispatch.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect GmailRead, draft, send, label.
  2. 2
    Connect OpenAIModels, embeddings, files.
  3. 3
    Connect AirtableBases, tables, views, automations.
  4. 4
    Connect TrelloKanban boards for everything.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.