Global FMCG Researcher Uses AI for Ingredient Analysis
カートのアイテムが多すぎます
カートに追加できませんでした。
ウィッシュリストに追加できませんでした。
ほしい物リストの削除に失敗しました。
ポッドキャストのフォローに失敗しました
ポッドキャストのフォロー解除に失敗しました
-
ナレーター:
-
著者:
Cosmetic scientists from FMCG companies spend days clicking between PubChem, INCI Decoder, and supplier sites just to figure out what's in one competitor product. Aidil is a cosmetic chemist. He does this manually in Excel and through hundreds of searches in a textbox.
We tried to solve that task with Claude Code - live, in 90 minutes. 10 products decoded, and a similarity matrix.
What you'll hear:
- Why a trained scientist still loses a day per product to manual ingredient lookups
- Aidil dictating what the tool should do - in plain English, no code
- Building a Python script live that pulls CAS numbers, molecular formulas, and chemistry from PubChem
- Tagging each ingredient's cosmetic function with INCI Decoder (surfactant, emulsifier, thickener)
- The messy bits: synonyms, rate limits, caching, and a PubChem API that doesn't have pKa
- A similarity matrix that clusters Pantene with Olaplex, and Head & Shoulders on its own
- Aidil's payoff: "it has the potential to just take a few seconds"
Hosts: Eric Tan (non-technical builder) & Yaohong Ch'ng (Founder, Superuser HQ, ex-Stashaway head of Data)
Guest: Aidil Juhari - ex-FMCG R&D scientist, cosmetic chemist
Got a problem you want us to solve live? Fill out the form:
https://forms.gle/DSyLzPAoR6x2M4Np9
We write here: https://substack.com/@coderiff
Join our community: https://chat.whatsapp.com/Dmp5eEEsAZhJTB6LjcIG3c?mode=gi_t
LEARN ALONG:
- FMCG: Fast-Moving Consumer Goods - shampoo, toothpaste, detergent. Aidil's world.
- INCI: The official scientific name for every cosmetic ingredient.
- CAS number: A passport number for molecules - unique ID for every chemical.
- PubChem: Free public chemistry database run by the US government.
- API: How one program asks another for data, instead of copying from a webpage.
- pKa: A chemistry number for how acidic or basic a molecule is. PubChem doesn't have it, which bit us.
Connect with us:
- Eric on LinkedIn: https://www.linkedin.com/in/erictisme/
- Yaohong on LinkedIn: https://www.linkedin.com/in/yaohongchng/
- Superuser HQ: https://superuserhq.com/
- Email: code.riffs.ai@gmail.com
Code Riff - messy real-world problems, solved with AI, so you can too.