Humanform API

Integration

Use Humanform inside Google Sheets

Tolerance stacks, BOMs, spec sheets, and sizing tables already live in spreadsheets. The =HUMANFORM(...) custom function calls the same prediction API as the REST endpoints, with the same credits and measurement set. No separate tool to learn: paste the script once, set your API key, and write formulas like any other cell function.

Get an API keyREST alternativeCLIMCP serverExcel

Setup

  1. Open the Google Sheet where you want predictions.
  2. Go to Extensions → Apps Script.
  3. Delete any default Code.gs content, then paste the copied script.
  4. Click Save, then reload the spreadsheet.
  5. Authorize the script when prompted (needed for API requests and secure key storage).
  6. Open the Humanform menu → Set API key... and paste a key from the dashboard.

Your API key is stored per Google account in Apps Script properties. It is not written into sheet cells or hardcoded in the script.

Humanform.gs

Copy the script to your clipboard, or download Humanform.gs for local reference. Then paste into your Apps Script project.

Download

Formulas

The function takes six arguments: measurement, gender, age, percentile, country, and unit (mm, cm, or in). It returns the predicted numeric value. Browse supported names on the measurements page and country codes on the countries page.

Literal arguments
=HUMANFORM("Stature", "Female", 34, 50, "US", "cm")
Cell references
=HUMANFORM(A2, B2, C2, D2, E2, F2)

Under the hood, each call maps to POST /v1/predict with the same request body as the REST API:

Request body
{
  "measurement": "Stature",
  "gender": "Female",
  "age": 34,
  "percentile": 50,
  "country": "US",
  "unit": "cm"
}

Credits and recalculation

Billing is unchanged from the REST API: one successful prediction costs one credit, or uses one free-tier call when you have no paid credits. There is no separate spreadsheet billing model.

ScenarioCredit impact
First time a distinct input combination runs1 credit or 1 free-tier call
Same formula inputs, cache hit (within ~6 hours)No additional API call
Input cell changes to a new combination1 credit or 1 free-tier call
Hundreds of genuinely different rowsLegitimate usage: one call per distinct combination

Free tier: 10 successful predictions per rolling 24-hour window when you have zero paid credits. Purchase credits in the dashboard or wait for the window to reset.

Recalculation: HUMANFORM is not volatile. Google Sheets recalculates it when its arguments change, not on every unrelated edit. Reopening a spreadsheet can sometimes rerun custom functions; the built-in cache avoids duplicate API calls for identical inputs within its TTL (6 hours, Google's platform maximum).

Recommended workflow: build your table with formulas, then copy the result range and use Paste special → Values only when the table is finalized. This removes live formulas and prevents accidental extra calls later.

Use cases

  • Sizing tables: fill percentile columns for multiple measurements in one sheet.
  • Tolerance stacks: pull population dimensions alongside mechanical tolerances.
  • Spec sheets: keep anthropometric targets next to product requirements your team already maintains in Sheets.

Explore

Browse datasets: full measurement list, supported countries, design examples, plugins roadmap, REST API docs, or MCP server install, or CLI install, or Google Sheets install, or Excel install.

MeasurementsCountriesExamplesPluginsAPI docsMCP serverCLIExcel