Flag expiring peptide vials automatically: 2026 sheet wins

Instead of checking freezer records by hand before every experiment, use a shared Google Sheets inventory to flag expiring peptide vials automatically. Record each vial’s approved use-by date, then use a date formula and a daily email alert to identify vials that need review.

Why this matters

An inventory alert is only as reliable as the date behind it. A receipt date does not tell you when a reconstituted vial should be discarded, and a purity result does not establish how long a vial remains suitable under your lab’s handling conditions.

Celonyx Labs research peptides are best for laboratory researchers seeking 99%-pure, third-party-tested materials; your lab must still set and verify each vial’s use-by date. Keep the supplier information, vial identity and lab handling record together as the vial moves through storage. The order-to-freezer inventory workflow covers that earlier handoff.

For a shared freezer in 2026, the practical goal is simple: identify a vial before someone selects it for an experiment, not after a result needs explaining. The workflow below flags dates for review. It does not certify that a vial is suitable for use.

Before you start

• Get access to a shared Google Sheet and Google Apps Script. The person creating the daily email trigger needs permission to edit the sheet and authorize the script. Decide who owns the sheet and who checks alerts when that person is away.
• Gather approved dates and identifiers. You need a unique vial ID, peptide name, lot identifier, storage location, current state and the use-by date established by your lab’s applicable instructions or procedure. If a date has not been established, mark the record for review; do not derive one from a generic peptide shelf-life claim.
• Resolve the state-change gotcha before entering data. A lyophilized vial and the same vial after reconstitution cannot safely share a single undifferentiated expiry field. Keep a separate approved use-by field for each state. When a vial is reconstituted, record that event and its newly approved use-by date before treating the inventory status as current.

A 2026 inventory sheet should also have a named owner for corrections. Researchers can enter handling events, but someone must resolve missing dates and remove disposed vials from active inventory.

Choose the alert you need

Both options below use the same sheet and the same approved dates. Start with the visible flag; add email when researchers do not reliably open the inventory before an experiment.

Neither option replaces your lab’s decision about whether a vial can be used. An alert means check the record, not proceed with the experiment.

Configure your vial inventory

1. Create a Google Sheet tab named Vials. Use these headers in columns A through L, in order: Vial ID, Peptide Name, Lot ID, State, Reconstitution Date, Lyophilized Use-By, Reconstituted Use-By, Active Use-By, Days Left, Status, Disposition and Storage Location. Keep one row per physical vial, even when several vials share a lot.
2. In State, enter either Lyophilized or Reconstituted. Use Data > Data validation to restrict entries to those exact values. The formulas below depend on matching text.
3. Enter the approved date in Lyophilized Use-By while the vial is lyophilized. After reconstitution, record Reconstitution Date, change State and enter the approved Reconstituted Use-By date. Do not copy the earlier use-by date into the new field without a documented basis.
4. Reserve Disposed as the value in Disposition when a vial leaves active inventory. Do not delete the row: the ID, date fields and final status remain available for a record review.

Expected result: each physical vial has one traceable row, and the sheet can distinguish a missing use-by date from an approved date that has passed. If you cannot identify the source of a date, leave the relevant use-by field empty and resolve it before use.

Calculate the active date and status

Put the following formula in H2, under Active Use-By. It reads the date for the state shown in column D; a reconstituted vial without both a reconstitution date and its own use-by date stays blank.

=IF(D2="Reconstituted",IF(OR(E2="",G2=""),"",G2),IF(D2="Lyophilized",IF(F2="","",F2),""))

Put this formula in I2, under Days Left, then format column H as dates and column I as numbers:

=IF(H2="","",INT(H2-TODAY()))

Put this formula in J2, under Status:

=IF(K2="Disposed","CLOSED",IF(H2="","REVIEW",IF(I2<0,"EXPIRED",IF(I2<=7,"FLAG","OK"))))

Copy all 3 formulas down the rows used for inventory. FLAG begins when the approved use-by date is 7 days away; EXPIRED begins after that date. The 7-day lead is an example for arranging a review, not a claim about peptide stability. Change the threshold in the formula if your lab requires a different review window. A vial with 0 days left remains flagged on its approved use-by date; your lab’s procedure determines what action follows.

Select the Status cells and open Format > Conditional formatting. Create separate Text is exactly rules for FLAG, EXPIRED and REVIEW, using distinct fills. In File > Settings > Calculation, select On change and every hour so the date-based sheet recalculates without relying solely on someone editing a row.

Expected result: a row with no applicable date shows REVIEW, a date within the configured window shows FLAG, a past date shows EXPIRED, and a disposed vial shows CLOSED. Check those four outcomes with test rows before entering live inventory.

The status is a sequence, not an independent field someone should type over. State selects Active Use-By; that date produces Days Left; the countdown produces Status.

Schedule the daily email

A colored cell helps only when someone opens the sheet. In a 2026 lab with a shared freezer, a scheduled message gives the inventory owner a separate prompt to review open flags.

1. In the spreadsheet, select Extensions > Apps Script. Add the function below to the script bound to this sheet, then save it. The function reads the Vials tab and emails vial IDs and statuses; it does not put peptide names or lot details in the message.
2. Select sendVialFlags in the function selector and click Run once. Complete the authorization prompts using the account responsible for the alert. Confirm that the message reaches that account when a test row has FLAG, EXPIRED or REVIEW status.
3. In Apps Script, open Triggers, select Add Trigger, choose sendVialFlags, set the event source to Time-driven and choose a daily schedule. Set the spreadsheet’s time zone in File > Settings so TODAY() follows the lab’s intended calendar date.

function sendVialFlags() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Vials');
  if (!sheet) throw new Error('Vials sheet not found');
  const rows = sheet.getDataRange().getDisplayValues().slice(1);
  const alerts = rows
    .filter(row => ['FLAG', 'EXPIRED', 'REVIEW'].includes(row[9]))
    .map(row => row[0] + ': ' + row[9]);
  if (alerts.length === 0) return;
  const recipient = Session.getEffectiveUser().getEmail();
  if (!recipient) throw new Error('Trigger owner email unavailable');
  MailApp.sendEmail(recipient, 'Peptide vial status review', alerts.join(String.fromCharCode(10)));
}

Expected result: the account that owns the trigger receives one message on a scheduled day when open flags exist. It receives no message when none exist. An unresolved vial appears again on subsequent daily messages; that repetition is intentional until someone corrects the record or records its disposition.

Do not forward the email as proof that a vial was checked. Assign a person to open the sheet, confirm the vial ID against the physical label, and document the resulting decision in the lab’s normal record system.

Recheck dates when a vial is reconstituted

The adjacent workflow begins when someone changes State from Lyophilized to Reconstituted. Enter the Reconstitution Date and the newly approved Reconstituted Use-By date as part of the same handling event. Until both are present, Active Use-By stays blank and Status becomes REVIEW.

That behavior is deliberate: the old lyophilized date must not silently remain the active date after reconstitution. Once both fields are entered, the sheet calculates days remaining from the reconstituted date and applies the same flagging rule. If your lab maintains reconstitution calculations elsewhere, keep that record connected to the vial ID rather than treating the inventory sheet as the calculation record.

Troubleshooting

• Every date shows as text or the countdown is wrong. Select the date columns and apply Format > Number > Date. Re-enter any values that remain text, then check the spreadsheet time zone under File > Settings.
• A reconstituted vial shows REVIEW despite having a use-by date. Check that State is exactly Reconstituted and that both Reconstitution Date and Reconstituted Use-By are populated. The formula intentionally refuses to activate an undated reconstitution event.
• The email lists the wrong records. Confirm that Status is column J and Vial ID is column A. Moving columns without updating the script changes what its row positions mean.
• A disposed vial keeps appearing in email. Enter Disposed in its Disposition cell and confirm Status changes to CLOSED. Correct the record rather than deleting its history.
• No email arrives after setup. Run sendVialFlags manually with a test FLAG row, check the authorized account’s inbox, then inspect Triggers for an execution error. No email is sent when the sheet has no open flags.

Test the process again after anyone changes column order, status wording or the lab’s review window. A script that still runs is not proof that it is reading the intended fields.

Customize your workflow

Use the vial ID to connect this tracker to the records your lab already keeps. The peptide purity data and electronic lab notebook guide covers a related documentation handoff; a purity record and an expiration flag answer different questions, so keep both identifiable.

For Celonyx Labs research peptides, record the available third-party testing information alongside the vial identity where your lab’s procedure calls for it. Do not use a 99% purity claim to populate Lyophilized Use-By or Reconstituted Use-By. In 2026, the next useful improvement is ownership: decide who resolves REVIEW records, who checks daily alerts and where each use-or-discard decision is documented.

FAQ

One last thing

Test a state change, not just an approaching date. A sheet that correctly flags a lyophilized vial can still give a misleading answer if its old use-by date remains active after reconstitution. In a 2026 inventory review, that transition is the test that proves the workflow follows the vial rather than merely counting calendar days.

Related guides

• Peptide storage solutions for academic core facilities
• Peptide reconstitution for biotech startup labs
• Automatically reorder research peptides before freezer stock runs low