How to Use Sugargoo Spreadsheet

Getting Started with Your Sugargoo Spreadsheet

Learning how to use a sugargoo spreadsheet is the single best investment you can make as an agent shopper. It takes about twenty minutes to set up and saves you hours of confusion every week. This guide walks you through every click, every formula, and every habit you need to build a tracking system that just works.

What You Will Need

• A free Google account (for Google Sheets) or Microsoft account (for Excel Online).
• A list of product links you want to track.
• Ten minutes of uninterrupted focus time.

Step 1: Open a New Spreadsheet

Navigate to Google Sheets and create a blank spreadsheet. Name it something memorable like "My Sugargoo Orders 2026." This document will become your shopping command center, so treat it like an important file.

Step 2: Build the Header Row

In row one, type these exact headers across columns A to J: Order ID, Product Link, Item Name, Color / Size, Price (CNY), Domestic Shipping, International Shipping, Total Cost, Status, and Notes. Bold the entire row and freeze it so it stays visible as you scroll.

Step 3: Enter Your First Order

Paste your first product link into column B. Type the item name in column C. Add the color and size in column D. Enter the price in CNY in column E. Leave shipping columns empty for now. Set the status to "Pending." This is your baseline entry.

Step 4: Add the Total Cost Formula

In column H (Total Cost), enter a formula that sums columns E, F, and G. For row 2, the formula is =E2+F2+G2. Copy this formula down the entire column by dragging the fill handle. Now every row automatically calculates its total cost as you enter data.

Step 5: Apply Conditional Formatting

Select the Status column. Open Format > Conditional Formatting. Create three rules: text contains "Pending" turns yellow, text contains "Shipped" turns green, and text contains "Issue" turns red. These colors give you an instant visual summary of your entire order pipeline.

Step 6: Create a Summary Dashboard

In a new sheet named "Dashboard," use COUNTIF and SUMIF formulas to count total orders, total shipped, and total spending. This high-level view helps you spot trends without scrolling through every individual row.

Daily Workflow: Five Minutes to Stay Organized

• Morning: Open your sheet and update any status changes from overnight emails.
• Afternoon: Paste new product links as you browse and add estimated prices.
• Evening: Review tomorrow's warehouse deadlines and confirm any urgent payments.

Comparison: Spreadsheet Platforms

Related Guides

Start Tracking Today