How Nuthera Calculates the True Cost of Every Metrc Tag with the T3 API

The challenge

Manual reconciliation, and costs no one could see

Nuthera's manufacturing team keeps its in-house records in sync with Metrc to confirm that product is weighed and reported correctly. That reconciliation was manual data entry.

A bigger question was also going unanswered: what does each batch actually cost to make? Every finished product passes through several production stages, and no cannabis ERP Taylor had seen could trace that chain back to raw inputs and put a price on it.

The insight

The answer was already in Metrc

Instead of keying data into another system, Taylor based the entire process on Metrc data alone, pulled through the T3 API.

The solution

A live cost and compliance system built on Metrc data

Taylor built a system in Google Sheets that stays in sync with Metrc automatically. It reconciles in-house records against Metrc without manual entry, and it traces every package back through each production stage to its raw inputs, attributing cost along the way. For any lot, Nuthera can see what went in, what came out, and the true cost per gram.

The results reach well beyond compliance:

• No replacement hire. Automated reconciliation took over the data-entry workload, so Nuthera didn't need to hire for the role.
• Profitability by batch. Nuthera knows the true cost of every Metrc tag it has ever made. Batches that run over cost are flagged, and Sales uses each batch's true cost to set its lowest acceptable price.
• Thousands saved. Each automation has saved thousands of dollars in manual entry labor, and the compliance team, department leads, and managers are thrilled with every update.

Taylor started in the lab, since everything starts there, and got the distillate summary and all its stages working first. Final packaging tags for production items come next, along with labor, split by production stage, and the bill of materials that completes the entire loop.

What T3 brings

Complete Metrc data, in the shape Taylor needed

Every hour, Taylor's Google Apps Scripts request four T3 API reports: active packages, inactive packages, and inactive transfers in and out. Each one returns the complete dataset in a single request, ready to drop into a sheet.

A report pull like Taylor's takes a few lines of Apps Script. Every parameter is covered in the API documentation.

// Runs on an hourly time-driven trigger
function syncActivePackages() {
  const key = PropertiesService.getScriptProperties().getProperty("T3_API_KEY");
  const url = "https://api.trackandtrace.tools/v2/packages/active/report" +
    "?licenseNumber=LIC-000123&contentType=csv&prependCsvMetadata=false";
  const csv = UrlFetchApp.fetch(url, { headers: { "X-T3-API-Key": key } });
  const rows = Utilities.parseCsv(csv.getContentText());
  const sheet = SpreadsheetApp.getActive().getSheetByName("Active Packages");
  sheet.clearContents();
  sheet.getRange(1, 1, rows.length, rows[0].length).setValues(rows);
}

Each run rewrites the tab with the latest Metrc data: