AI automation · Reporting · 2026
Test Job Reporting Agent
An n8n automation for a solar module testing lab. It logs each test job, grades the results, and sends the client report, the lab alerts and a weekly digest without anyone retyping a number.
IndustrySolar module testing
Project typeCustom build
My roleAI Automation Engineer
Year2026
The problem
A testing lab turns raw results into client reports by hand: copying numbers between spreadsheets, judging pass or fail, writing the summary email and then chasing the team about modules that need attention. It is slow, differs from engineer to engineer and is easy to get wrong.
What I built
An n8n workflow that starts when a lab engineer logs a new test job. It saves the job to a live tracker, grades the results against the lab’s tolerances, uses AI to write a plain-English summary, and sends the client report. Flagged modules alert the team, and a weekly digest covers every open job.
The workflow
How it works.
01
Test job form
A lab engineer logs a new job through a form: client, job number, module type and the results from the test run.
02
Live job tracker
Every job is saved to a Google Sheet that works as a live tracker, with its status, grade and flagged modules.
03
Results check
JavaScript logic compares measured power, insulation and electroluminescence findings with the tolerances and works out an overall grade.
04
AI summary
An AI agent writes a short plain-English summary of the results, in the same clear tone every time.
05
Client report and lab alert
The client receives a formatted report email. If modules fall outside tolerance, the lab team gets an alert listing exactly which ones.
06
Weekly digest
Every week the team receives a summary of all jobs: what is completed, what is flagged and what still needs attention.
Sample test job output
What the workflow produced automatically for a sample test job.
Grade C
Overall grade
99.7%
Average power
5
Modules flagged
0
Insulation fails
Tools & technologies
n8nAI agentsGoogle SheetsGmailJavaScriptWebhooksScheduled triggers
Inside the build
The complete n8n workflow, from the job form to the weekly digest.
Lab engineers log a new test job through a simple form.
Test results are graded automatically against the lab’s tolerances.
Every job is tracked in a live sheet with its grade and status.
The client receives a clear report email with the key results.
The lab team is alerted when modules are flagged.