Use Google Sheets AI to Analyze Your Food Cost

What This Does

Google Sheets now has a built-in AI assistant (Gemini) that can analyze your food cost data, identify which categories have the highest variance, and suggest likely causes — turning a spreadsheet into a conversation.

Before You Start

• A Google account (free)
• Your weekly sales data exported from your POS (Toast, Square, or similar)
• Basic food cost tracking data — even a simple table with item names, theoretical cost %, and actual cost %

Steps

1. Open your spreadsheet and find the AI sidebar

Go to sheets.google.com and open your food cost spreadsheet (or create a new one and paste in your data). Look for the Gemini icon (sparkle/star) in the upper right of the toolbar. Click it to open the Gemini sidebar on the right side of the screen.

2. Enter your data if you haven't already

Your spreadsheet should have columns like:

• Menu category (Protein / Produce / Dairy / Bar / etc.)
• Theoretical food cost % (from your recipe costing)
• Actual food cost % (from your physical inventory count vs. sales)
• Variance (actual minus theoretical)

If you have sales numbers and inventory usage numbers but haven't calculated percentages, paste those in — you can ask Gemini to calculate the percentages for you.

3. Ask Gemini to analyze the variance

In the Gemini sidebar, type a question like:

• "Which menu categories have the highest variance between theoretical and actual food cost this week?"
• "Based on this data, what are the most likely causes of the food cost variance in the protein category?"
• "Summarize where I'm losing the most money on food cost and give me 3 things to check first."

4. Review and act

Gemini responds in plain language directly in the sidebar. It will typically identify which categories are furthest off and suggest checking for waste, portioning, theft, spoilage, or recipe drift. Use its output to focus your next inventory walk.

Real Example

Scenario: Your food cost this week was 36% actual vs. 29% theoretical — a 7-point gap eating directly into your margin.

What you type: "My spreadsheet has actual vs theoretical food cost by category. My protein cost is showing 42% actual vs 30% theoretical. What are the most common causes of this variance in a full-service restaurant and what should I check first?"

What you get: Gemini identifies the top suspects: over-portioning (especially on hand-cut proteins), not recording waste and comps in the POS, receiving errors (charged for weight you didn't get), theft at receiving or prep, and menu mix shift (selling more high-cost items than the theoretical assumed). It gives you a checklist to work through.

Tips

• Even if your current spreadsheet is messy, paste it in anyway — ask Gemini to help you organize it first
• Save a version of your spreadsheet each week with the date; over 4-6 weeks you'll see trends that reveal systemic issues vs. one-time anomalies
• If you don't have theoretical food cost built out yet, ask Gemini: "Help me build a simple recipe cost calculator for a restaurant menu item" and it will walk you through it

Tool interfaces change — if the Gemini sidebar has moved, look for an AI or Gemini icon in the top toolbar, or check the Extensions menu.