assess.one – AI-powered business operations platform

Workflow Template

CCTV drain inspection report Workflow

Captures a CCTV drain inspection report, routes it through drainage manager review (with a bounded revision loop back to the inspector), emails the approved report to the customer, and triggers a repair quote task when repair work is recommended.

Built for drainage and pipeline inspection businesses that carry out CCTV surveys, this workflow takes a submitted inspection report through drainage manager review, a bounded revision loop with the inspector, and on to the customer once approved. It automatically emails the approved report to the customer with overall condition, defects and recommended work, and creates a repair quote task for the estimator when repair work is recommended, so every report moves from field capture to customer delivery with a clear status and timeline.

Business Outcomes

  • Reduces time between site inspection and customer report delivery
  • Helps standardise manager review before reports leave the business
  • Cuts back-and-forth on report corrections with a structured revision loop
  • Speeds up handoff to repair quoting when work is recommended
  • Improves visibility into report status across the inspection pipeline

Workflow Steps

Steps

  1. 1
    Create Inspection Report Recordcreate record

    Registers the submitted inspection as an inspection_report record.

  2. 2
    Set Status: Report Reviewupdate record

    Sets the report status to Report Review.

  3. 3
    Drainage Manager: Review Reportcreate task

    Assigns the drainage manager a task due in 2 days to review the report and record a decision.

  4. 4
    Save Review Decisionupdate record

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

  5. 5
    Route on Review Decision

    Routes based on whether the report is approved or needs changes.

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

    Sets the report status to Revising when changes are needed.

  7. 7
    Inspector: Update Defects and Recommended Workcreate task

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

  8. 8
    Save Revised Report Detailsupdate record

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

  9. 9
    Send Back for Reviewrestart from step

    Restarts the workflow from the manager review task with the revised report.

  10. 10
    Set Status: Report Sentupdate record

    Sets the report status to Report Sent once approved.

  11. 11
    Email Customer the Reportsend email

    Sends the customer the approved report including overall condition, defects with locations, and recommended work.

  12. 12
    Route on Repair Recommendation

    Routes based on whether repair work is recommended.

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

    Sets the report status to Quote to Follow since repair work is recommended.

  14. 14
    Estimator: Prepare Drain Repair Quotecreate task

    Assigns the estimator a task due in 3 days to prepare a drain repair quote; does not wait for completion.

  15. 15
    Set Status: Closedupdate record

    Sets the report status to Closed since no repair work is recommended.

Fields

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

Forms

CCTV Drain Inspection Report

15 fields

Data Views

Inspection Reports

customer_name, site_address, inspection_date, overall_condition +1 more

Dashboard Widgets

Reports by Report Status

Recommended integrations

Setup the following integrations to extend workflow capability.

  • Send email in the workflow

    AWS SES logoAWS SES
cctv drain inspection reportdrain cleaning and cctvinspectiontradetrades

Similar Workflows

Similar Categories

FAQs

Why should we automate CCTV drain inspection reporting instead of handling it manually?

Manually tracking inspection reports through review, revisions, and customer delivery relies on emails and spreadsheets that are easy to lose track of. This workflow captures each inspection as a record with a status and timeline, so the drainage manager's review, any revisions, and the final customer email all happen in a consistent sequence. It also automatically creates the repair quote task when needed, removing a manual handoff step.

What is the ROI of using this workflow over ad hoc email and paper-based processes?

The workflow reduces the administrative time spent chasing report approvals and re-sending corrected versions, since the revision loop and status updates happen automatically. Reports move to customers and estimators as soon as decisions are recorded, cutting delays that come from manual follow-up. Because the platform template is ready to use immediately, there's no development project needed to get these efficiencies.

How does the drainage manager review step work?

Once a report is submitted, its status is set to Report Review and the drainage manager is assigned a task, due in 2 days, to review the report and record a Review Decision along with Comments. The workflow waits for this task to complete before proceeding, and the decision and comments are saved to the record. Based on the decision, the report is either routed to the customer email step or back to the inspector for revisions.

What happens if the drainage manager requests changes?

If the Review Decision is 'Changes needed', the report status is set to Revising and the inspector is assigned a task, due in 1 day, showing the manager's comments so they can update the defects found and recommended work. Once the inspector submits the updated details, they are saved to the record and the workflow sends the report back for another round of manager review. This creates a bounded revision loop that continues until the manager approves the report.

What does the customer receive once a report is approved?

Once the drainage manager approves the report, its status is set to Report Sent and an email is sent to the customer containing the overall condition, defects with their locations, and the recommended work. The customer receives this by email without needing to log in or create an account. This gives customers a clear, documented outcome of the inspection directly from the business.

How does the workflow handle repair quotes?

After the customer report is sent, the workflow checks the 'Is repair work recommended?' field from the original submission. If repair work is recommended, the status is set to Quote to Follow and an estimator is assigned a task, due in 3 days, to prepare a drain repair quote; this task doesn't hold up the workflow, so the report can still show as sent while the quote is prepared. The Quote Reference entered on that task is kept with the task itself in the record's task list. If no repair work is recommended, the report status is simply set to Closed.

Can we customise the workflow to match our own inspection process?

Yes, the workflow can be adjusted by describing the change in plain English or by editing the steps directly in the workflow editor, and earlier versions are kept so changes can be reviewed. This means task deadlines, form fields, or routing conditions can be tailored to your business without a development project. Because the template is ready to use, a workspace can start running the live process while refining details over time.

Who is involved in running this workflow day to day?

The workflow involves the inspector who submits the initial report and updates it if changes are needed, the drainage manager who reviews and approves reports, and the estimator who prepares repair quotes when work is recommended. Customers take part only through the emailed report, without needing an account. Tasks and the review decision are assigned to specific team members within the workspace, who are set up as admins or members.

How can we track the status of inspection reports across our team?

Each submitted inspection becomes a record with a reference number, a status such as Report Review, Revising, Report Sent, Quote to Follow, or Closed, and a timeline of what happened. Table views and dashboards show records grouped by status, making it straightforward to see which reports are awaiting manager review, in revision, or closed out. Workspace activity is also logged, giving a record of actions taken throughout the process.

Ready to use this workflow?

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

CCTV drain inspection report Workflow | assess.one