Case study

Haus of Innovation

Formulation Generator

On-brand starting formulations, in one click.

Industry
Beauty and personal care ingredients
Company type
Start-up
Services
Custom AI tools

Google Sheet

Formula

Night Reset Hair Treatment
PhaseSupplierTrade nameINCI name%
AN/AD.I. WaterWater/Aqua85.07
ASino LionEvermild™ GLDA-30Tetrasodium Glutamate Diacetate0.05
BKatonah ChemicalGuar GumCyamopsis Tetragonoloba (Guar) Gum0.75
BKatonah ChemicalTara GumCaesalpinia Spinosa Gum0.30
BKatonah ChemicalGlycerinGlycerin3.00
CN/A10% C.AWater and Citric Acid0.30
DKatonah ChemicalStearic AcidStearic Acid1.00
DHaus of InnovationElenza™ HaloEthylhexyl Olivate, Butyrospermum Parkii (Shea) Butter, Squalane4.00

PDF generated by the tool

Formulation sheet for Night Reset Hair Treatment, made with the generator
Formulas entered in the team’s spreadsheet (recreated here) and the formulation sheets the generator makes from them.

Haus of Innovation’s chemists are great at creating concept formulations, but formatting each one took time away from the lab. We designed a simple, elegant template and built a document automation tool that turns the starting formulations they enter in a Google Sheet into on-brand formulation sheets, and a brochure of them all, with one click.

1

The chemists stay in their spreadsheet

Each formulation and its process go into a shared Google Sheet in the lab, one tab per formula. The generator reads it and lays every formula out on Haus of Innovation’s template.

The team’s Google Sheet, with a tab for each formula.
The Haus of Innovation formulation spreadsheet, one tab per formula

2

A brochure of every formulation

One more click gathers all the formulations into a single brochure, with a cover and a table of contents.

Cover of the Haus of Innovation Formulations brochure, October 2026
Table of contents listing the brochure’s 11 formulations
Velvet Leave-in Hair Conditioner Spray formulation
Lip Recovery Mask formulation
Mint Chocolate Chip PHA Scrub formulation
Pages from the Haus of Innovation Formulations brochure, October 2026.

Impact

Time back in the lab

Chemists enter a formula once; the formatting is done for them.

1

Click to a finished sheet

Every formulation becomes an on-brand sheet, ready to publish.

11

Formulations in one brochure

The October 2026 brochure, generated with a cover and contents.

100%

On brand

The template’s type, layout and logo are built in.

Contact

Want a tool like this for your team?

Ask about a custom tool
jackie@macallenmedia.com

Jackie Guscott MacAllenCommunications strategist