All templates

CyFrame Automated Lot Certification Requests

Every morning, WebRun opens CyFrame, finds resin lots received in the last day without a certificate of analysis on file, logs each lot to a Google Sheet with the supplier and PO number, and drafts a request email to the supplier for the missing certificate, left unsent for you to review.

Runs on WebRun · Strict Lockdown policy
Every day at 8:00 AM WebRunorchestrates each step
1 CyFrame find lots missing a certificate
2 Google Sheets log the certification tracker
3 Gmail draft the supplier request
In short

How do I chase suppliers for missing material lot certifications?

WebRun makes sure no resin lot slips through without paperwork. Every morning it opens CyFrame, finds lots received without a certificate of analysis on file, logs each to a Google Sheet with its supplier and PO number, and drafts a request to the supplier for the missing certificate, left unsent for you to review and send.

  • No resin lot sits uncertified without anyone noticing
  • A supplier request is drafted the same day a gap is found
  • Certification status is tracked lot by lot, not chased from memory

Built for plastics profile extruders · quality assurance teams · materials managers · purchasing coordinators

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens cyframe.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    CyFrame - find lots missing a certificate
    cyframe.com
    WebRun in CyFrame: find lots missing a certificate
    WebRun opens CyFrame to find lots missing a certificate.
    • Open CyFrame and review resin lots received in the last day
    • Check each lot against finished-goods certification records for a certificate of analysis on file
    • Capture the lot number, supplier, PO number, and resin grade for any lot missing its certificate

    Done when Every lot received without a certificate of analysis is listed with its supplier and PO.

  3. 2
    Google Sheets - log the certification tracker
    google.com
    WebRun in Google Sheets: log the certification tracker
    WebRun opens Google Sheets to log the certification tracker.
    • Open the certification tracker and add a row per lot missing its certificate
    • Record the lot number, supplier, PO number, and date received
    • Mark the row resolved once a certificate is later matched to the lot in CyFrame

    Done when The tracker shows every lot still waiting on a certificate of analysis.

  4. 3
    Gmail - draft the supplier request
    gmail.com
    WebRun in Gmail: draft the supplier request
    WebRun opens Gmail to draft the supplier request.
    • Draft a request to each supplier listing the lot numbers and PO numbers missing a certificate of analysis
    • Ask for the certificate to be sent before the lot is released to production
    • Save it as a draft for you to review. Never send the request automatically

    Done when A draft certificate request is ready per supplier, unsent, covering every open lot.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
cyframe.com
ScheduleRuns automatically on this cadence
Every day at 8:00 AM
DeliveryHow each run's result reaches you
Certification tracker · Google Sheets
OutputWhat each run produces - A certification tracker in Google Sheets plus a drafted, unsent request email per supplier for missing certificates of analysis.
Text
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input GUARDRAIL
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it email suppliers without me seeing it first?

No. WebRun drafts the certificate request in Gmail and leaves it unsent. You review the lot list and send it yourself, so no request goes out without a person checking it.

Does it release a lot to production if the certificate is missing?

No. WebRun only reads and reports certification status. It never changes a lot's release status in CyFrame. That decision stays with your quality team.

How does it know a certificate is missing?

It checks each resin lot received against the certificate of analysis records in CyFrame. Any lot with no matching certificate on file is flagged and added to the tracker.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.