How to Create a Skincare Tracker in Google Sheets

Building a personalized skincare tracker is one of the best ways to figure out which products actually work for your skin. Instead of relying on memory or guessing, a dedicated log helps you connect the dots between your daily routine and your skin's condition. This guide will walk you through creating a powerful, flexible, and completely free skincare tracker using Google Sheets.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Use Google Sheets for a Skincare Tracker?

While dedicated apps exist, Google Sheets offers unmatched flexibility. You aren’t locked into someone else's idea of what's important. You decide what to track, from product usage and ingredients to nuanced observations about irritation or hydration. It's completely customizable to your unique skin goals, whether that’s clearing acne, reducing redness, or just achieving a dewy glow.

Plus, it has some key advantages:

• It's free: You only need a Google account.
• Accessible anywhere: Update your log from your phone, tablet, or computer.
• Visually track progress: Use simple charts and color-coding to see patterns emerge over time.
• It grows with you: As you learn more about your skin, you can easily add new sections and data points to your tracker without starting over.

Setting Up Your Skincare Tracker: A Step-by-Step Guide

Ready to build it? Let's break it down into four simple steps. We'll start by organizing your products and then create a log to track your daily routine and skin condition.

Step 1: Create a New Sheet and Two Tabs

First, head to sheets.new to instantly create a new spreadsheet. At the bottom of the page, you'll see a tab named "Sheet1". Double-click it and rename it "Daily Log".

Next, click the "+" icon to add a second tab. Rename this one "Product Library". Keeping your product information separate from your daily entries keeps everything clean and organized. It will also help us do some cool automation later on.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 2: Build Your 'Product Library'

Click on the "Product Library" tab. This will be your master inventory of every skincare product you own, have tried, or want to buy. It helps you keep track of ingredients, purchase dates, and impressions all in one place.

Set up the following columns in the first row:

• Column A: Product Name
• Column B: Brand
• Column C: Product Type (e.g., Oil Cleanser, Serum, Moisturizer, SPF)
• Column D: Key Active Ingredients (e.g., Salicylic Acid, Vitamin C, Retinol)
• Column E: Purchase Date
• Column F: Open Date
• Column G: Expiration (e.g., using a PAO or "period after opening" symbol)
• Column H: Status (e.g., In Use, Finished, Decluttered, To-Buy)
• Column I: Notes/Impressions

Now, spend a few minutes populating this list with your current products. This seems simple, but having this database will make daily logging much faster.

Step 3: Structure Your 'Daily Log' Tab

Now, switch to your "Daily Log" tab. This is where you’ll record your routine and skin observations each day. Set up these columns in the first row. You can add or remove columns based on what's most important to you!

Core Information:

• Column A: Date
• Column B: Overall Skin Rating (1-5)

AM Routine:

• Column C: Cleanser (AM)
• Column D: Toner/Essence (AM)
• Column E: Serum 1 (AM)
• Column F: Serum 2 (AM)
• Column G: Moisturizer (AM)
• Column H: Sunscreen

Tip: Be specific! It's better to have more columns and leave some blank than to cram multiple products into one cell.

PM Routine:

• Column I: First Cleanse (PM)
• Column J: Second Cleanse (PM)
• Column K: Mask/Treatment (PM)
• Column L: Toner/Essence (PM)
• Column M: Serum/Retinoid (PM)
• Column N: Moisturizer (PM)

Skin Observations:

• Column O: Breakouts (Yes/No, or a number)
• Column P: Redness/Irritation (Low, Medium, High)
• Column Q: Hydration Level (Low, Medium, High)
• Column R: Daily Notes (Anything you noticed: diet changes, stress, etc.)

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 4: Add Features to Make Tracking Easier

This is where Google Sheets really shines. Let’s add some features that make logging faster and analyzing your data more intuitive.

Use Drop-Down Menus for Products

Instead of typing product names every day, you can create a drop-down list that pulls directly from your "Product Library."

1. In your "Daily Log" tab, select the cell right under your first product header (e.g., cell C2 under "Cleanser (AM)").
2. Go to the menu and select Data > Data validation.
3. In the "Criteria" dropdown, choose "Dropdown (from a range)".
4. Click the little grid icon next to the text box. A smaller window will pop up.
5. Click on your "Product Library" tab and select all the product names in Column A. It's good practice to select the entire column (by clicking the "A" at the very top) so new products you add are automatically included.
6. Click "OK" and then "Save". That cell now has a handy dropdown. You can drag the little blue square in the bottom-right corner of the cell down to apply it to the entire column. Repeat this for all your product columns!

Visualize Ratings with Stars

Who likes looking at numbers? Let’s turn your 1-5 skin rating into a visual ⭐ rating. In the cell next to your "Overall Skin Rating" (so, cell B2 if your rating is in A2), paste this formula:

=REPT("⭐", A2)

Press Enter, then drag the formula down the column. Now, when you enter a '4' in column A, four stars will automatically appear next to it.

Use Conditional Formatting to Spot Bad Skin Days

Conditional formatting changes a cell's color based on its value, making it easy to see patterns at a glance.

1. Select the entire "Overall Skin Rating" column by clicking its header letter (e.g., Column A).
2. Go to the menu: Format > Conditional formatting.
3. Under "Format rules," choose "is less than or equal to" from the dropdown.
4. Enter "2" in the value box.
5. Choose a light red color for the formatting style. Click "Done."

Now, any day you rate your skin a 1 or 2 will be highlighted in red, instantly showing you days to investigate further.

Advanced Tracking: Charting Your Progress

Once you’ve collected a few weeks of data, you can start creating visuals to understand your progress.

Create a Skin Progress Chart

A simple line chart can show you the ups and downs of your skin's condition over time.

1. In your "Daily Log" tab, click and drag to highlight the entire "Date" column and the "Overall Skin Rating" column. (Hold Ctrl or Command to select non-adjacent columns).
2. In the menu, go to Insert > Chart.
3. Google Sheets will usually default to a line chart, which is perfect for this. If not, select it from the Chart Editor.

You now have a running visual of your skin's journey! You can see how your skin score changed after introducing a new product or look for correlations with other factors like sleep or diet, which you might be tracking in your notes.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Track Product Usage Frequency

Ever wonder if you’re using that expensive retinol serum as often as you should? A simple COUNTIF formula can tell you.

Go to your "Product Library" tab and create a new column called "Usage Count." In the first cell under that header, use this formula, adjusting the cell references as needed:

=COUNTIF('Daily Log'!C:N, A2)

• 'Daily Log'!C:N is the range of all your product columns in the Daily Log.
• A2 is the cell containing the specific product name in your Product Library.

Drag this formula down for all your products, and you’ll have an up-to-date count of how many times you’ve used each one.

Final Thoughts

Building your own skincare tracker in Google Sheets is a practical and empowering way to take control of your skincare journey. It turns vague feelings about your skin into concrete data, helping you make smarter purchasing decisions and pinpoint exactly what's causing irritation or breakouts.

While manual tracking in spreadsheets is perfect for personal projects like this, it can become a time-sink for business-critical data like sales and marketing performance. That's why we built Graphed. We automate the drudgery of pulling data from platforms like Shopify, Google Analytics, and Facebook Ads. Instead of downloading CSVs and building charts by hand, you can just ask questions in plain English - like "Show me a dashboard of ad spend vs revenue by campaign" - and get a live, automated dashboard instantly.