Skip to content

T3 Reports

T3 Reports is the report builder in the T3 Chrome Extension. It exports Metrc data as CSV, JSON, Excel, or Google Sheets, either as a one-time snapshot or as a live view that a spreadsheet re-fetches on its own.

The builder assembles a T3 API report URL, shows you a preview of the data it returns, and then hands you that URL. The URL is the product. You can open it, download it, email it, turn it into a Google Sheet, or paste it into a spreadsheet's =IMPORTDATA() formula so the sheet keeps itself up to date. See Spreadsheet Sync.

Every setting in the builder corresponds to one query parameter on that URL. Nothing the builder does is unavailable to a script, and nothing a script can do to a report URL will confuse the builder; you can paste a URL you wrote by hand straight back into it.

Opening T3 Reports

Open the T3 floating button menu in the bottom right of Metrc and choose T3 Reports.

The header links to a video walkthrough, to the T3 API Reports reference, and to Exports (Legacy), the older export tool documented under Exports (Legacy).

T3 Free and T3+

T3 Reports is a T3+ feature. T3 Free users can open the builder and see how it works, but access to the reports themselves is limited. Full access comes with a T3+ subscription.

Authentication

A report URL carries its own credential. This is not a shortcut, a browser following a link, and a spreadsheet calling IMPORTDATA, have no way to send an Authorization header, so the credential has to live in the URL.

Secret key or temporary key

The Authentication card offers two modes:

Mode What it is When to use it
Secret key A long-lived key generated once from your Metrc credentials and saved to your account Anything you intend to keep, a saved report, a spreadsheet formula, a scheduled pull
Temporary key The extension's current short-lived session token Trying something out. No setup, but the URL stops working when the token expires

The builder shows which key is active by its last four characters and validates it in the background, so you find out that a key is wrong while you are building rather than when the report fails.

Choosing the temporary key adds a standing warning under the generated URL. A temporary link is fine for a one-off download and useless in a spreadsheet.

A report URL contains your credential

Anyone holding the URL can read the Metrc data it returns. The builder masks the key in the URL breakdown by default and lets you reveal it deliberately. Do not paste a report URL into a shared document, a ticket, or a screenshot.

Generating a secret key

If you have no key yet, the builder offers to generate one. Your hostname and username are filled in from your current Metrc session and cannot be edited, a key belongs to the account you are signed in as.

Two states need one extra field:

State Extra field Notes
Colorado Metrc login email The email tied to your Metrc login
Michigan Multi-factor authentication key The key, not a 6-digit code

Michigan: the key is not the code

Metrc's MFA setup shows both a QR code and a manual-entry key. T3 needs the key (the long string you would type into an authenticator app) because it generates the 6-digit codes itself. If you paste something that starts with six digits, the form tells you so.

Getting the key means resetting MFA in Metrc, and a reset key has to be activated by logging into Metrc with it once before T3 can use it. The generate form walks through those steps.

Keys can also be generated and managed outside the builder. See Authentication and the secret key page.

Choosing What to Build

Report categories

Reports are grouped into four categories:

Category What it produces Trade-off
Manifest Reports Transfer manifests with their packages and transporters The widest rows. See transfer manifest reports
Collection Reports Plain lists of Metrc records, packages, items, plants, harvests The largest maximum size
Supercollection Reports Records with related data attached, packages with lab results, harvests with source plants, items with ingredients More detail, smaller maximum size. See Super Reports
Scan Sheets Manifest packages laid out for barcode scanning Google Sheets and Excel only. See Scan Sheets

A category with no endpoints available to you is shown as Coming soon rather than hidden, so the set of categories does not change shape between accounts.

The builder remembers the last category you used and the last report you chose within each category, so returning to a category puts you back where you left it.

Starting from an existing report URL

Paste a T3 report URL into the Edit an existing report URL box and the builder reopens with every setting filled in from it, report path, licenses, format, includes, row layout, columns, header overrides, filters, sort, row limit, delivery, and email.

An entire spreadsheet formula works too. This is valid input:

=IMPORTDATA("https://api.trackandtrace.tools/v2/packages/active/report?licenseNumber=LIC-00001&contentType=csv&prependCsvMetadata=false")

If anything in the URL could not be applied exactly (a column that no longer exists, a format that does not support an option you asked for) the builder loads what it can and tells you what it changed.

This is the fastest way to modify a report that is already running in a spreadsheet: paste the formula, change what you need, and copy the new formula back.

Starting from a saved report

Your saved reports are listed with their names and descriptions and can be searched. Clicking one loads it into the builder, exactly as if you had pasted its URL.

Rows can be renamed or deleted in place. See Saving a Report.

Next Steps