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
- 1Create Drain Assessment Recordcreate record
Registers the submitted inspection as a drain assessment record.
- 2Set Status to Report Reviewupdate record
Sets the report status to Report Review after the inspection is submitted.
- 3Drainage Manager: Review Reportcreate task
Assigns the drainage manager a task to review the inspection report within 2 days.
- 4Save Review Decisionupdate record
Persists the drainage manager's review decision and comments to the record.
- 5Route 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 Sentreview_decision: "Changes needed"→Set Status to RevisingDefault→End - 6Set Status to Revisingupdate record
Sets the report status to Revising when changes are needed.
- 7Inspector: 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.
- 8Save Revised Report Detailsupdate record
Persists the inspector's updated defects and recommended work to the record.
- 9Return to Drainage Manager Reviewrestart from step
Restarts the workflow from the manager review task so the revised report can be re-reviewed.
- 10Set Status to Report Sentupdate record
Sets the report status to Report Sent once the drainage manager approves the report.
- 11Email Customer the Reportsend email
Sends the customer the overall condition, root intrusion and pipe damage findings, and the recommended remedial work.
- 12Route 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 Followrepair_relining_recommended: "No"→Set Status to ClosedDefault→Set Status to Closed - 13Set Status to Quote to Followupdate record
Sets the report status to Quote to Follow when repair or relining work is recommended.
- 14Estimator: Prepare Drain Repair Quotecreate task
Assigns the estimator a task to prepare a drain repair quote within 3 days, without waiting for completion.
- 15Set 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
Recommended integrations
Setup the following integrations to extend workflow capability.
Send email in the workflow
AWS SES
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.
