Spiral gives your agent every tool with one account. Browse the tools →

Zapier · Health

How to Use FDA substance records in Zapier

Find a substance’s UNII, recorded names, external codes, and relationships in FDA’s substance registry. Use it to reconcile ingredient names across datasets or inspect recorded links between a salt and its active moiety.

Prompts to try with FDA substance records in Zapier

Copy an example into Zapier, or ask in your own words.

Each month, use FDA substance records to check acetaminophen and report changes in its returned names or external codes since the previous check.

FDA substance recordsZapier
Try asking
  • Every quarter, use FDA substance records to refresh the UNIIs and recorded names for caffeine, aspirin, and citric acid and summarize any differences.

  • Each month, use FDA substance records to inspect ibuprofen sodium and report any changes to its recorded active moiety or parent relationships.

  • Every quarter, use FDA substance records to compare acetaminophen and paracetamol and report whether their returned UNIIs still agree.

  • Each month, use FDA substance records to check sodium chloride and potassium chloride and report changes to their returned external identifiers.

How to set up FDA substance records in Zapier

Pick the way that suits you. Each takes about two minutes.

Use the Spiral skill

  1. Send Zapier this message

    Your agent reads Spiral's skill and sets itself up.

    set up https://spiral.ai/SKILL.md
  2. Sign in or paste a key

    Approve Spiral in the browser, or give the agent a key from the console.

Use Spiral's MCP server

  1. Add an MCP Client connection

    In Zapier open Apps, click Add connection and search for MCP Client. Fill in the form:

    https://api.spiral.ai/mcp
  2. Sign in to Spiral and approve

    Spiral opens: sign in, pick the organization and click Authorize. No API key. Spiral gives the connection its own key; Zapier never sees it, and you can remove it under Settings › Connected apps in the console.

  3. Run a Spiral tool in a Zap

    Add an MCP Client step to a Zap and choose the Run Tool action with your Spiral connection. Pick a tool: discover finds the right model for a task, estimate_cost prices it and run runs it. For example, run with:

    {
      "provider": "fal",
      "model": "fal-ai/flux/schnell",
      "input": { "prompt": "a lighthouse at dawn" },
      "wait": true
    }
  4. Run FDA substance records in a workflow step

    Give the step an instruction like the ones below and run it on your trigger or schedule. Spiral finds FDA substance records, prices it and runs it each time the step fires.

Use the Spiral CLI

  1. Install and sign in

    Installs the Spiral CLI, signs you in and adds its skill to your coding agents.

    npx -y spiral-cli@latest init

Call the Spiral API

  1. Create an API key

    In the console, under API keys.

  2. Run FDA substance records

    One request; the result comes back by polling or a webhook.

    curl https://api.spiral.ai/v1/runs \
      -H "Authorization: Bearer $SPIRAL_API_KEY" \
      -H "Content-Type: application/json" \
      -H "Idempotency-Key: $(uuidgen)" \
      -d '{
        "provider": "alexandria",
        "model": "fda-gov/substances/substances",
        "input": {
          "unii": "<unii>"
        }
      }'

Then paste one of the prompts above: Zapier finds FDA substance records on Spiral, shows the price and runs it.

FDA substance records providers and prices

Spiral runs FDA substance records through Alexandria. Open a card for today's price, with every fee included.

AlexandriaHealth
FDA · Substances
fda-gov/substances/substances

Settings you can ask for

Ask Zapier for any of these in your prompt.

SettingAllowed valuesDefaultDescription
Skip0 to 250000

skip

Limit1 to 205

limit

Every API field of FDA · Substances is on its tool page: open its card above.

What can you do with FDA substance records in Zapier?

Keep a defined ingredient reference list aligned with published FDA substance records. An agent running on a schedule can compare returned names, codes, and relationships across checks, with openFDA’s updates occurring every few months.

Reconcile ingredient names

Look up ingredient names from two catalogs and compare their returned UNIIs before proposing duplicate records for review.

Build an ingredient synonym index

Collect recorded scientific, common, generic, and brand names for a defined ingredient list to support catalog search.

Cross-reference external identifiers

Attach the external codes recorded by FDA to an ingredient reference table, keeping each code beside its originating system.

Review salt relationships

Inspect recorded salt, solvate, and active moiety links before combining ingredient records in a research dataset.

Prepare a terminology review

Give a reviewer the substance’s UNII, recorded names, and external identifiers alongside the ingredient terminology used in a draft document.

Check published reference changes

Compare periodic lookups for a fixed ingredient list and report changes in returned names, codes, or relationships.

Create ingredient reference cards

Populate internal reference cards with FDA substance identifiers, names, and recorded relationships for researchers reviewing a compound list.

Questions about FDA substance records in Zapier

Can Zapier use FDA substance records?

Yes. Add Spiral to Zapier as an MCP server, and Zapier can find and run FDA substance records like any built-in tool.

How much does FDA substance records cost in Zapier?

$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your Zapier plan is separate.

Do I need an Alexandria account to use FDA substance records in Zapier?

No. Spiral runs FDA substance records on its own Alexandria account. You sign in to Spiral once and never paste a key.

How long does it take to set up FDA substance records in Zapier?

About two minutes: add an MCP Client connection, then sign in to Spiral and approve, then run a Spiral tool in a Zap.

Does Zapier wait while FDA substance records runs?

FDA substance records runs in the background. Zapier starts the run, checks on it and gives you the json when it's ready.

What kinds of substances does FDA cover?

GSRS defines six substance classes: chemicals, proteins, nucleic acids, polymers, mixtures, and structurally diverse substances. Its coverage includes substances used in drugs, biologics, foods, and devices.

How fresh are the substance records?

openFDA lists the substance dataset’s update frequency as every few months. A scheduled check can detect a published change, but that schedule does not make the underlying data update daily.

Does a UNII mean FDA approved the substance?

No. FDA explicitly states that UNII availability does not imply regulatory review or approval.

Are the synonyms and code mappings definitive?

FDA describes them as based on the best public information available at publication. That is a publication-time mapping, not a promise that every name or external identifier is included.

Which kinds of names can a record include?

Records can include scientific, common, generic, and brand names. This makes the data useful for comparing ingredient terminology across catalogs without assuming that each spelling represents a different substance.

Get started

Start using FDA substance records in Zapier

One Spiral account for every tool your agent needs. No subscription; you pay per run.

Paste this into Zapier:

Set up Zapier

set up https://spiral.ai/SKILL.md
Are you an AI agent? See setup options