Automated Refrigerant Cylinder Tracking Log
Every night, WebRun opens Savance Enterprise (Klipboard), reads every refrigerant cylinder received and dispensed that day, logs the cylinder ID, type, and net weight to a Google Sheet, and sends your compliance channel a Telegram alert if a cylinder's running weight does not match its expected count.
How do I keep an audit ready log of refrigerant cylinder movements?
WebRun reads every refrigerant cylinder received and dispensed in Savance Enterprise (Klipboard) each night, logs the cylinder ID, type, and net weight to a Google Sheet, and carries forward a running balance by cylinder type and branch. If a balance does not reconcile with the expected count, it sends your compliance channel a Telegram alert with the details.
- Every cylinder movement is logged the same night it happens
- Count discrepancies surface within hours, not at the next audit
- Each branch keeps its own reconciled running balance by refrigerant type
Built for HVAC wholesale distributors · branch warehouse managers · compliance and EHS staff · refrigerant inventory coordinators
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
klipboard.com/loginin a real browser with your saved login - no setup, no API keys. -
1
Savance Enterprise (Klipboard) - read today's cylinder movements
klipboard.com
WebRun opens Savance Enterprise (Klipboard) to read today's cylinder movements. - Open Savance Enterprise (Klipboard) and pull today's refrigerant cylinder receipts and dispenses
- Capture the cylinder ID, refrigerant type, and net weight for each movement
- Note which branch and which technician or contractor the dispense was logged against
Done when Every cylinder movement logged today has its ID, type, and net weight captured.
-
2
Google Sheets - log net weight by cylinder and type
google.com
WebRun opens Google Sheets to log net weight by cylinder and type. - Open the refrigerant tracking sheet and add a row for each movement
- Update the running net weight total for each cylinder type and branch
- Carry forward the previous day's closing balance so the log stays continuous
Done when Every movement is logged and each cylinder type shows a current running balance.
-
3
Telegram - alert on a count mismatch
telegram.org
WebRun opens Telegram to alert on a count mismatch. - Compare today's closing balance against the expected count for each cylinder type
- Send a Telegram alert to the compliance channel if any balance is off by more than your set tolerance
- Include the cylinder ID, branch, and the size of the discrepancy in the alert
Done when Compliance has been alerted to any cylinder count that does not reconcile.
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 this replace our EPA recordkeeping?
No. It keeps a running, dated log of cylinder movements to support your existing recordkeeping. It does not file anything with a regulator or replace your compliance program.
How does it decide a count is off?
It compares each cylinder type's running balance against the expected count you set in the sheet, and only alerts when the gap is larger than the tolerance you choose.
What if two branches log the same cylinder?
It tracks each cylinder ID separately by branch, so a cylinder moved between branches shows up as a transfer, not a duplicate.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.