How to Use FDA substance records in Notion
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 Notion
Copy an example into Notion, 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.
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 Notion
Pick the way that suits you. Each takes about two minutes.
Use the Spiral skill
- Send Notion this message
Your agent reads Spiral's skill and sets itself up.
set up https://spiral.ai/SKILL.md
- 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
- Allow custom MCP servers
A workspace owner opens Settings › Connections, then the Manage tab, and turns on Enable custom MCP servers. Where members may install only approved connections, also add Spiral under Approved connections › Add approved connection › Custom MCP server with the URL below.
- Add Spiral to a custom agent
Open the custom agent (or create one), then Settings › Tools & Access › Add connection › Custom MCP server. Paste this URL, name it Spiral, keep OAuth and click Connect.
https://api.spiral.ai/mcp
- 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; Notion never sees it, and you can remove it under Settings › Connected apps in the console.
- 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
- 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
- Create an API key
In the console, under API keys.
- 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: Notion 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.
Settings you can ask for
Ask Notion for any of these in your prompt.
| Setting | Allowed values | Default | Description |
|---|---|---|---|
| Skip | 0 to 25000 | 0 | skip |
| Limit | 1 to 20 | 5 | 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 Notion?
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.
More on FDA substance records and Notion
Overview
FDA substance records in other agents
Questions about FDA substance records in Notion
Can Notion use FDA substance records?
Yes. Add Spiral to Notion as an MCP server, and Notion can find and run FDA substance records like any built-in tool.
How much does FDA substance records cost in Notion?
$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your Notion plan is separate.
Do I need an Alexandria account to use FDA substance records in Notion?
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 Notion?
About two minutes: allow custom MCP servers, then add Spiral to a custom agent, then sign in to Spiral and approve.
Does Notion wait while FDA substance records runs?
FDA substance records runs in the background. Notion 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.
Start using FDA substance records in Notion
One Spiral account for every tool your agent needs. No subscription; you pay per run.
Paste this into Notion:
set up https://spiral.ai/SKILL.md


