Preparing a results table with an AI assistant
Back to the documentation home.
Ex Herbario has no built-in AI: researchers use the assistant they already have (Claude, ChatGPT or another) to turn a published paper into an import table, and every value then goes through the normal import preview and compound review.
- On the study page, open Add data → Prepare the table from a paper with your AI assistant. Copy the prompt and download the import template (
GET /api/chemistry/import-template.xlsx). - Give the assistant the prompt together with the paper's PDF and supplementary files.
- Paste Table A (chromatographic profiles) into the template's GC-MS profile sheet, or Table B (isolated compounds) into Isolated compounds. Rename the sample columns to your sample codes. Section C is for you: use it when creating samples and preparations and in the run settings.
- Upload the file with Import a results table and check every value against the paper. The import recognises the template's headers, ignores the
Sourcecolumn, and flags percentages above 100%, RIs far from their reference, invalid SMILES and m/z values that do not match the formula.
The prompt is kept in app/chemistry/ai_extraction_prompt.md; the study page shows the same text. It asks the assistant to copy values exactly, to mark trace and not-detected values, to leave out summary rows, to give each row its source, and to give identifiers and SMILES only where the paper prints or draws them.
AI extraction is a data-entry aid. The author remains responsible for the values, and should treat SMILES written from drawings and any value the assistant marked as uncertain with particular care.