Import lab results and flag the outliers
Every morning, WebRun opens your LIMS export in Google Sheets, matches each new lab result to its parameter and sample point in Operator10, verifies the values are logged, flags any result outside its expected range or missing a hold time, and posts a review note to Microsoft Teams so lab and operations stay aligned.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I import and flag lab results in Operator10 automatically?
Every morning, WebRun reads your LIMS export in Google Sheets and matches each result to its parameter and sample point in Operator10. It confirms the values are logged, flags any result outside its expected range or missing a hold time, and posts a review note to Microsoft Teams, so lab and operations catch outliers before they reach a report.
- New lab results are verified against Operator10 every morning
- Outliers and missing hold times surface before they reach a DMR
- Logged lab values are never overwritten, only checked and flagged
Built for lab technicians · wastewater operators · compliance staff · water quality analysts
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
allmaxsoftware.comin a real browser with your saved login - no setup, no API keys. -
1
Google Sheets - read the LIMS result export
google.com How to Automate Google Sheets
WebRun opens Google Sheets to read the LIMS result export. - Open the LIMS export workbook for the latest batch
- Read each result with its sample point, parameter, value, units, and collection time
- Skip any result already reconciled in a previous run
- List results missing a value or a hold time in a review column
Done when Every new lab result is read with its sample point, parameter, and value.
-
2
AllMax Operator10 - match and verify each result
allmaxsoftware.com How to Automate AllMax Operator10
WebRun opens Operator10 to match and verify each result. - Open Operator10 and load the DataView for each lab parameter
- Confirm each result is matched to the right sample point and date
- Compare each value against its expected range for that parameter
- Flag outliers and any result that failed to import cleanly
Done when Every result is matched in Operator10 and any outlier or import gap is flagged.
-
3
Microsoft Teams - post a review note
microsoft.com How to Automate Microsoft Teams
WebRun opens Microsoft Teams to post a review note. - Post a lab result review note to the operations Teams channel
- Lead with any outlier, missing value, or unimported result
- Summarize how many results were verified and how many need attention
Done when Lab and operations have a Teams note listing verified results and anything needing review.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it change lab values or overwrite Operator10 entries?
No. WebRun verifies that each LIMS result is matched correctly in Operator10 and flags anything off. It does not overwrite logged values or alter lab data, so your results stay as recorded and only the flags are new.
How does it decide a result is an outlier?
It compares each result against the expected range you set for that parameter in Operator10. Anything outside the range, missing a value, or missing a hold time is flagged for a person to review.
Is the review note shared outside the plant?
No. The review note is an internal digest to your own operations Teams channel, so WebRun posts it automatically. No lab result is sent to a regulator or external lab from this run.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.