assess.one – AI-powered business operations platform

Workflow Template

Drain defect / root intrusion assessment Workflow

Captures a CCTV drain inspection, routes the report through drainage manager review (with an inspector revision loop), emails the approved report to the customer, and triggers a repair/relining quote task when recommended.

This workflow is designed for drainage inspection businesses that carry out CCTV surveys and need a consistent way to review, approve and deliver assessment reports. It automates the path from inspector submission through drainage manager review, including a revision loop when changes are needed, and emails the approved report to the customer with findings on root intrusion, pipe damage and recommended work. When repair or relining work is recommended, it automatically creates a quote task for the estimator, keeping the record's status and timeline up to date at every stage.

Business Outcomes

  • Reduces manual chasing between inspectors and drainage managers during report review
  • Speeds up delivery of approved inspection reports to customers
  • Helps standardise how root intrusion, pipe damage and recommended work are captured and reported
  • Supports faster handoff to estimators when repair or relining work is identified
  • Improves visibility of report status across submitted, revising, sent and closed records

Workflow Steps

Steps

  1. 1
    Create Drain Assessment Recordcreate record

    Registers the submitted inspection as a drain assessment record.

  2. 2
    Set Status to Report Reviewupdate record

    Sets the report status to Report Review after the inspection is submitted.

  3. 3
    Drainage Manager: Review Reportcreate task

    Assigns the drainage manager a task to review the inspection report within 2 days.

  4. 4
    Save Review Decisionupdate record

    Persists the drainage manager's review decision and comments to the record.

  5. 5
    Route on Review Decision

    Routes the workflow based on whether the drainage manager approved the report or requested changes.

    review_decision: "Approved"→Set Status to Report Sent
    review_decision: "Changes needed"→Set Status to Revising
    Default→End
  6. 6
    Set Status to Revisingupdate record

    Sets the report status to Revising when changes are needed.

  7. 7
    Inspector: Update Reportcreate task

    Assigns the inspector a task to update defects found and recommended work based on the manager's comments, due in 1 day.

  8. 8
    Save Revised Report Detailsupdate record

    Persists the inspector's updated defects and recommended work to the record.

  9. 9
    Return to Drainage Manager Reviewrestart from step

    Restarts the workflow from the manager review task so the revised report can be re-reviewed.

  10. 10
    Set Status to Report Sentupdate record

    Sets the report status to Report Sent once the drainage manager approves the report.

  11. 11
    Email Customer the Reportsend email

    Sends the customer the overall condition, root intrusion and pipe damage findings, and the recommended remedial work.

  12. 12
    Route on Repair/Relining Recommendation

    Routes to a quote task if repair or relining work is recommended, otherwise closes the record.

    repair_relining_recommended: "Yes"→Set Status to Quote to Follow
    repair_relining_recommended: "No"→Set Status to Closed
    Default→Set Status to Closed
  13. 13
    Set Status to Quote to Followupdate record

    Sets the report status to Quote to Follow when repair or relining work is recommended.

  14. 14
    Estimator: Prepare Drain Repair Quotecreate task

    Assigns the estimator a task to prepare a drain repair quote within 3 days, without waiting for completion.

  15. 15
    Set Status to Closedupdate record

    Sets the report status to Closed when no repair or relining work is recommended.

Fields

  • Inspector Name*
  • Customer Name*
  • Customer Email*
  • Customer Mobile*
  • Site Address*
  • Inspection Date*
  • +16 more fields

Forms

Drain CCTV Inspection Report

19 fields

Data Views

Drain Assessments

customer_name, site_address, inspection_date, line_affected +2 more

Dashboard Widgets

Assessments by Report Status

Recommended integrations

Setup the following integrations to extend workflow capability.

  • Send email in the workflow

    AWS SES logoAWS SES
drain defect / root intrusion assessmentdrain cleaning and cctvtradetrades

Similar Workflows

Similar Categories

FAQs

Why should we automate our drain assessment reporting instead of managing it manually?

Manually tracking CCTV inspection reports through review, revision and customer delivery often means emails and spreadsheets that are easy to lose track of. This workflow keeps each inspection as a single record with a status and timeline, so anyone in the workspace can see where a report stands. It also removes the need to manually chase the drainage manager or inspector, since tasks are assigned automatically at each stage.

What happens if the drainage manager requests changes to the report?

If the Review Decision is set to Changes needed, the record status moves to Revising and the inspector is assigned a task to update the defects found and recommended work based on the manager's comments, due within 1 day. Once the inspector submits the update, the workflow automatically returns to the drainage manager review task so the revised report can be re-reviewed. This loop can repeat until the manager approves the report.

What does the customer receive once the report is approved?

Once the drainage manager approves the report, the status is set to Report Sent and the customer is emailed the overall condition, root intrusion and pipe damage findings, along with the recommended remedial work. Customers do not need an account to receive this — the report is sent directly to the email address captured on the request form.

How does the quote task get triggered, and who handles it?

After the report is emailed, the workflow checks whether repair or relining work was recommended. If it was, the status changes to Quote to Follow and an estimator is assigned a task to prepare a drain repair quote within 3 days. The workflow does not wait for this task to complete, so the quote preparation notes stay on the task itself rather than being saved to the record.

What happens if no repair or relining work is recommended?

When the Repair or Relining Work Recommended field is set to No, the workflow sets the status to Closed and no further tasks are created. This keeps records that need no follow-up work moving out of the active queue quickly, so team attention stays focused on jobs that need a quote.

Can we customise the fields captured on the inspection form or the review steps?

Yes. A workflow can be changed by describing the change in plain English or by editing its steps directly in the workflow editor, and earlier versions are kept if you need to revert. This makes it straightforward to adjust the request form fields, review timeframes, or task assignments as your inspection process evolves.

Who is involved in this workflow, and what are they responsible for?

The inspector submits the initial CCTV inspection details through the request form and updates the report if changes are requested. The drainage manager reviews the report and records a decision and comments, and the estimator picks up the quote preparation task when repair or relining work is recommended. Tasks and approvals are assigned to workspace members, with admins able to oversee the workspace as a whole.

How quickly can we get this workflow running for our drainage business?

This is a ready-to-use template, so a workspace can publish it and start running live inspections within minutes, with no installation or development project required. Once published, submissions through the request form immediately create drain assessment records and start moving through review.

What information is kept on record for each drain assessment?

Each request becomes a record with a reference number, a status such as Report Review, Revising, Report Sent, Quote to Follow or Closed, and a timeline showing what happened at each step. The drainage manager's review decision and comments, and the inspector's revised defects and recommended work, are saved directly to the record. Businesses should confirm this level of detail meets their own record-keeping obligations.

Ready to use this workflow?

Create a free account and customise this workflow for your business.

Drain defect / root intrusion assessment Workflow | assess.one