Use Google Sheets AI to Build Sales Tracking Formulas

What This Does

Google Sheets' AI assistant lets you describe a formula in plain English and get the working formula back — no syntax memorization required. For e-commerce coordinators tracking margins, inventory levels, and sales velocity, this unlocks reporting that used to require a data analyst.

Before You Start

• You have a Google account (free)
• You have a Google Sheet with your sales or inventory data
• You know what you want to calculate (even roughly)

Steps

1. Open Your Sheet and Place Your Cursor

1. Open your sales tracking spreadsheet in Google Sheets
2. Click the cell where you want the formula result to appear (e.g., cell D2 for a profit margin calculation)

What you should see: The selected cell highlighted, ready for input

2. Access the AI Formula Assistant

1. Click Explore in the bottom-right corner of your sheet (a small icon that looks like a star/compass)
2. The Explore panel opens on the right
3. In the search box at the bottom of the Explore panel, type your question in plain English

What you should see: A natural language search box in the Explore panel Alternative: If you don't see Explore, go to Tools → Explore in the top menu

3. Describe Your Formula

Type your request in plain English. Examples:

• "Calculate profit margin as (selling price minus COGS minus FBA fees) divided by selling price as a percentage"
• "Sum column C only where column A equals 'water bottle'"
• "Find the average sales per day if I know total sales in column B and number of days in column C"
• "Flag any row in column D where inventory is below 50 units"

Click the suggested formula in the results, or press Enter.

What you should see: Google suggests a formula you can click to insert directly into your selected cell

4. Apply and Verify

1. Click the suggested formula — it inserts into your cell
2. Check that the cell references match your data (adjust column letters if needed)
3. Drag the formula down to apply it to all rows

Real Example

Scenario: You want to track the profit margin for every SKU in your catalog, factoring in COGS (column C), Amazon FBA fees (column D), and selling price (column B).

What you type in Explore: "Calculate profit margin where selling price is B, COGS is C, and FBA fees are D"

What you get: =(B2-C2-D2)/B2 formatted as a percentage — insert it in column E and drag down through all SKU rows.

What you see: An instant margin column showing which products are profitable and which are losing money.

Tips

• Describe the columns you're working with by letter ("column B") or by the header name ("the 'selling price' column") — both work
• Ask follow-up questions in plain English: "Now color it red if below 15% and green if above 30%" — Sheets AI can add conditional formatting too
• Save your most useful formulas in a "Formula Library" tab at the bottom of your workbook — you'll reuse them across different tracking sheets

Tool interfaces change — if a button has moved, look for similar AI/magic/smart options in the same menu area.