Most practitioners begin their aromatherapy “safety system” with a spreadsheet. The trouble is that a tidy table doesn’t automatically guide what happens in a real session. On a busy day, it’s easy to estimate by eye, skip a note, or realize too late that a bottle’s batch can’t be traced.
What actually helps is better design: a workflow where the safer choice is the easiest one. A simple SOP inside Google Sheets can hold your boundaries, support consistent blending, capture consent clearly, and give you a calm path to follow if something needs reviewing.
Key Takeaway: A strong aromatherapy SOP is not just a list of rules. It is a practical workflow that helps you document intake, screen for sensitivities, track oil provenance, calculate dilutions, record client choices, and learn from incidents. When these steps are built into one lean workbook, safety becomes part of the session rather than an afterthought.
Step 1: Map your aromatherapy SOP before you open Sheets
Before building tabs and formulas, decide what your practice stands for. Your SOP should reflect the kind of support you can offer clearly, consistently, and with integrity.
Think of it as a compact between you, the plants, and the people you support: clear scope, clear boundaries, and clear next steps when something needs extra care. As Robert Tisserand notes, zero risk doesn’t exist, so the aim is to reduce avoidable risk through good practice.
Define the safety promise you can actually keep
Write one sentence that captures your approach. For example: “I offer client-centered aromatherapy within safe topical and inhalation limits, with transparent education and meaningful choice.” Keep it visible and let it guide every tab you build.
Your SOP should make five questions effortless to answer in every session:
- Who is this client, and what matters to them?
- What exactly am I using?
- How will I prepare it?
- How will it be used?
- What do I do if something feels off?
For a foundational practice, your scope might include education, topical use, inhalation, diffusion, clear communication, documentation, and follow-up. Just as important is what sits outside your scope. That clarity protects both you and the people you serve.
Add a couple of scenario notes so your boundaries are usable under pressure. Example: “If a client is unsure how their skin reacts to citrus, pause topical use, offer inhalation instead, and revisit later.”
Step 2: Build a Google Sheets workbook that supports safer practice
Once your boundaries are clear, the workbook becomes much easier to design. The goal is a lean tool you can use in real time, even when you’re balancing conversation, preparation, and note-taking.
Start with a six-tab structure
A simple six-tab workbook is usually enough to begin:
- Client Intake: names, pronouns, contact details, goals, preferences
- Safety Screen: sensitivities, skin condition, life stage, pause flags
- Oil Inventory: botanical identity, origin, supplier, batch, storage, status
- Blend Calculator: volumes, target %, limits, auto-warnings
- Consent & Session Record: proposal, method, questions, decisions
- Incident Log: what happened, first response, follow-up, improvements
Build in friction-reducers: dropdown menus for methods, protected formula cells, required fields, consistent date formatting, and timestamps for sign-off fields.
Standardize naming early. If you log lavender as “Lavandula angustifolia,” use that form everywhere. If dates are YYYY-MM-DD in one tab, keep them that way across the workbook. Consistency is what makes a spreadsheet reliable over time.
A simple rule can tie the system together: a blend isn’t marked “Ready” until the calculator is within range and the session note includes consent.
Step 3: Turn intake and screening into a listening-centered process
Your sheets should support a warm conversation, not replace it. Done well, intake and screening help you gather what matters while keeping the client feeling respected and heard.
Use fields that invite clear, human answers
In your Intake tab, include essentials such as preferred name, contact details, session date, goals in the client’s own words, scent preferences, previous experiences with oils, and permission to record relevant notes.
In the Safety Screen, add structured prompts for:
- known allergies or sensitivities
- reactive or compromised skin
- pregnancy or possible pregnancy
- breastfeeding
- age group
- current wellness support context
- personal considerations or boundaries
- a yes/no “Pause and discuss outside advice” flag
Language matters here. Try prompts such as: “Are there any sensitivities, circumstances, or personal beliefs you would like me to consider before we discuss topical oils?”
Build in stop points. If a client reports uncertainty, strong scent sensitivity, damaged skin, or a context where extra care is needed, the workbook can prompt a pause and suggest an alternative method such as inhalation.
For dilution planning, some practitioners choose lower default strengths in more sensitive contexts. The Alliance of International Aromatherapists notes 1% dilution as a cautious reference point for children, pregnancy, older adults, and similar situations. Your calculator can apply that automatically when a sensitivity flag is selected.
Step 4: Create an oil inventory and provenance log you can rely on
Your inventory is more than stock control. It’s the record that connects each bottle to a source, a batch, and a clear decision about whether it belongs in session work.
Track identity, origin, storage, and status
For each aromatic material, record:
- common name
- Latin binomial
- plant family
- plant part
- extraction method
- country or region of origin
- supplier
- batch or lot number
- date received
- date opened
- storage notes
- practical safety notes
- status
Latin names help when common names overlap. Region matters too. In traditional practice, origin often shapes how an oil feels and performs, and research also suggests aromatic profile can shift with environmental growing conditions.
For storage, use clear fields such as “tightly closed,” “protected from light,” and “away from heat.” General storage guidance also supports keeping oils in appropriate, clean containers and away from degrading conditions.
Add status labels you can act on quickly: Available, Quarantined, Expired, Contaminated, Recalled, and Disposed. If a bottle smells off or looks cloudy, quarantine it and stop using it until you’ve reviewed it properly.
A practical entry might read: “Lavandula angustifolia, flowering tops, steam distilled, Haute-Provence, batch LAV-23-041, received 2025-03-15, opened 2025-04-02, stored cool and dark, status Available.” Brief, checkable, and session-friendly.
Step 5: Let your blend calculator handle the dilution math
Blending becomes steadier when the spreadsheet handles the numbers. That reduces guesswork and frees your attention for the client in front of you.
Measure by volume first, drops second
The core formula is simple: essential-oil volume = total blend volume × target dilution. A 30 mL blend at 2% calls for 0.6 mL of essential oils.
Your calculator tab can include:
- total volume
- target dilution %
- calculated essential-oil volume
- each oil’s share in mL and %
- approximate drop count
- preparer
- date
- verification field
- approval status
In everyday aromatherapy, many leave-on blends sit within a modest range, and 0.5–5% is often used as a general guide. For many adults, 2% works as a practical default, while lower strengths make sense when sensitivity flags appear. Choose the lowest dilution that still supports your intended outcome.
If you keep oil-specific limits in a reference table, your calculator can check them automatically. This is especially helpful for oils that require extra care in leave-on use and for skin irritation prevention.
Where possible, calculate by mL rather than drops. The literature notes drop-based dosing is imprecise because drop size changes with bottle fitment and viscosity. If you include drops for convenience, label them as approximate. A working estimate like 20–30 drops per mL is reasonable for planning, but measured volume is the standard when precision matters.
Example: a 60 mL body oil at 2% gives 1.2 mL total essential oil. Divide that amount intentionally across your chosen oils, verify the result, and only then mark the blend as ready.
Step 6: Record consent, method, and client choice as one clear story
Consent is strongest when it’s woven into the session record rather than reduced to a single signature. Your notes should show what was proposed, what alternatives were offered, what the client chose, and what guidance was shared.
Make session notes easy to understand later
Include fields for:
- proposed oils with botanical names
- carrier or base
- method of use
- dilution level
- application area
- precautions discussed
- alternatives offered
- client questions
- consent decision
- date and initials
Keep the wording client-friendly. For example: “We will use a 1% blend of lavender and frankincense in jojoba on the upper back and shoulders, avoiding the face. Alternative offered: personal inhaler only.” If the client chooses the alternative, record that choice clearly.
Professional standards also emphasize client education as part of responsible aromatherapy. In practice, that means explaining what you’re offering, why it fits the session goal, how it’s diluted, where it will be used, and what to do if the client wants to stop.
For method-specific notes, be concrete. NAHA advises keeping essential oils away from eyes and mucous membranes. If you’re using photosensitizing oils, state that clearly in aftercare. “Avoid strong sun exposure on the applied area for 24 hours” is more useful than a vague warning.
A short written summary can also help clients feel grounded after the session: blend name, ingredients, dilution, method, storage, and stop-use guidance.
Step 7: Plan incident logging and SOP updates before you need them
Even in a careful practice, unexpected reactions and quality concerns can arise. What matters is having a calm, consistent response built into your system ahead of time.
Create a log that supports action and learning
Your Incident Log can include:
- date
- client name or ID
- product used
- botanical identity
- batch number
- dilution
- route of use
- amount used
- body area
- onset
- what was observed
- first response
- follow-up
- corrective action
- link to session record
If the concern involved inhalation or diffusion, document the practical setup as well. Useful review points include diffuser type, drop count, duration, ventilation, and distance from the client, since these details can change exposure significantly.
Build first-response checklists directly into the sheet so they’re easy to follow under pressure. For example, if there is skin discomfort, your SOP can direct you to stop use immediately, remove any affected clothing, wash the area gently, and monitor what happens next. If there is eye exposure, the workflow should be just as clear and easy to find.
After any incident, leave space for learning. Add a field such as “What needs to change?” with options like:
- Add a limit
- Lower a default dilution
- Update intake wording
- Review supplier quality
- Strengthen client education
Finally, keep a Revision tab for version control: SOP title, owner, version number, effective date, review date, summary of changes, and where retired versions are stored. This turns your workbook into a living document rather than a static file.
Conclusion: Let your SOP become a quiet ally in practice
When your intake supports a genuine conversation, your inventory tells a traceable story, your calculator handles the numbers, your consent notes reflect real choice, and your incident log gives you a steady response, the whole practice feels more grounded. The spreadsheet becomes part of your craft, supporting the care you already bring.
Start small: build the six tabs, write your one-sentence safety promise, enter one oil properly, and record one session with more clarity than the last. Keep your workbook aligned with your values, and review it regularly as your skills and boundaries evolve through herbalism and plant medicine study, including structured aromatherapy certification training.
Explore Aromatherapy Certification
Build confident, client-safe workflows in the Aromatherapy Certification course, from intake to dilution, consent, and documentation.
Explore Aromatherapy Certification →