How to Create a Restaurant Dashboard in Google Sheets

Nothing sinks the mood like staring at a dozen different reports trying to figure out if you had a great week or a terrible one. Between your point-of-sale (POS) system, your delivery apps, and your scheduling software, your restaurant’s data is scattered everywhere. This guide will walk you through, step-by-step, how to build a simple but powerful dashboard right in Google Sheets to see all your key numbers in one clean, clear place.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Your Restaurant Needs a Dashboard in Google Sheets

Before we jump into the "how," let's quickly cover the "why." While dedicated business intelligence software is powerful, a Google Sheets dashboard has some major advantages for a busy restaurant owner or manager:

• It’s free. You're likely already using Google Workspace. There are no extra software costs to get started.
• It puts you in control. You decide exactly what metrics matter to your restaurant, from sales per hour to your top-selling menu items.
• It centralizes your information. Instead of logging into Square, then Uber Eats, then your inventory app, you can create a single source of truth to see how everything connects.
• It visualizes your performance. Seeing a line chart of your daily sales is much more impactful than scanning a column of numbers. It helps you spot trends instantly.

Step 1: Planning Your Restaurant Dashboard

A good dashboard starts with a good plan. You wouldn't start a dinner service without doing your prep, and the same principle applies here. Taking a few minutes to plan will save you hours of frustration later.

Identify Your Key Metrics (KPIs)

What numbers do you need to see every day or week to know if your restaurant is on track? Don't try to track everything, focus on the metrics that drive key decisions. Here are some common examples for restaurants, grouped by category:

Sales & Revenue KPIs

• Total Daily/Weekly Revenue: The most basic performance indicator.
• Average Check Size: Total revenue divided by the number of orders. A great way to track upselling efforts.
• Sales by Category: How much revenue comes from food vs. beverages vs. merchandise?
• Busiest Hours/Days: Helps with staffing and marketing promotions.
• Top 5 Selling Items: Which dishes are your stars?
• Online vs. In-Person Orders: Shows where your customers are coming from.

Operational KPIs

• Cost of Goods Sold (COGS %): The cost of your ingredients divided by food revenue. Crucial for profitability.
• Labor Cost Percentage: Your total labor cost divided by total revenue. Helps you manage scheduling.
• Table Turnover Rate: How many times a table is used by different parties during a specific period.
• Number of Covers: The total number of guests you've served.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Gather Your Data Sources

Now, where will you get the data for these metrics? Most of it likely lives inside your existing tools. Your primary source will be your POS system (like Toast, Square, or Lightspeed), which tracks every transaction.

Other sources might include:

• Delivery Apps: DoorDash, Uber Eats, Grubhub.
• Reservation Software: OpenTable, Resy.
• Inventory Management Software: For food costs (COGS).
• Employee Scheduling Software: For labor costs.

For this guide, we'll assume you’re manually exporting reports from these systems as CSV files, which is the most common starting point.

Step 2: Structuring Your Google Sheet

Organization is everything. The best practice is to separate your data, calculations, and dashboard into different tabs within the same Google Sheet. This keeps things tidy and prevents you from accidentally breaking a formula in front of your whole team.

Here's the recommended three-tab structure:

1. ‘Raw Data’ Tab: This is where you will paste the raw data you export from your POS or other systems. Don't do any calculations or formatting here. Just paste and go.
2. ‘Calculations’ Tab: This is the engine room. It will pull from the ‘Raw Data’ tab and house all your pivot tables and formulas that summarize your KPIs.
3. ‘Dashboard’ Tab: This is the beautiful, clean final product. It will only feature your charts and key numbers, referencing the ‘Calculations’ tab.

Go ahead and create a new Google Sheet and create these three tabs along the bottom.

Step 3: Calculating Your Key Metrics

Now it’s time to turn that mountain of raw transaction data into a few clear, useful numbers. We'll do this in your 'Calculations' tab.

First, go to your 'Raw Data' tab and paste in a sample daily sales report from your POS. It will likely have columns like Date, Order ID, Item Name, Category (Food/Beverage), Quantity, and Price.

Next, switch over to your 'Calculations' tab. Here are two ways to summarize this data.

Using Pivot Tables for Quick Summaries

Pivot tables are your best friend in Google Sheets. They allow you to rapidly summarize large datasets without writing a single formula.

Let's create a pivot table to show your daily revenue.

1. Click on cell A1 in your 'Calculations' tab.
2. Go to the menu and select Insert > Pivot table.
3. For the 'Data range,' select all the data in your 'Raw Data' tab (e.g., 'Raw Data'!A:F).
4. Choose 'Existing sheet' for where to put it, making sure the location is your 'Calculations' tab.
5. The Pivot Table Editor will appear on the right. Now, let's configure it:

And just like that, you have a clean summary of your total sales for each day!

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Driving Deeper with Formulas

For more specific KPIs, you'll need some basic formulas. Let's calculate the revenue split between "Food" and "Beverage."

In your 'Calculations' tab, create two labels: 'Food Revenue' and 'Beverage Revenue'. In the cell next to 'Food Revenue,' enter this formula:

=SUMIF('Raw Data'!D:D, "Food", 'Raw Data'!F:F)

Let’s break that down:

• SUMIF adds up numbers in a range that meet a specific criterion.
• 'Raw Data'!D:D is the range where it will look for the criteria (assuming your 'Category' column is Column D).
• "Food" is the actual criteria it's looking for.
• 'Raw Data'!F:F is the range it will sum up if the criteria are met (assuming 'Price' is in Column F).

You can do the same for beverage revenue by simply changing "Food" to "Beverage" in the formula.

Step 4: Building the Dashboard View

This is the fun part: turning those calculations into a visual dashboard that you can understand at a glance. Click over to your 'Dashboard' tab.

Creating Your First Chart

Let's visualize the daily sales data from the pivot table we created.

1. Go back to your 'Calculations' tab and highlight the dates and corresponding sales totals from your pivot table.
2. Go to the menu and click Insert > Chart.
3. Google Sheets will probably suggest a nice Line Chart. If not, you can select it from the Chart Editor on the right.
4. Cut the chart (Ctrl+X or Cmd+X) from the 'Calculations' tab and paste it (Ctrl+V or Cmd+V) into your 'Dashboard' tab.
5. Resize and position it as you see fit. A good dashboard has a clean layout with some breathing room.

Using Different Chart Types for Different Data

The right chart can make all the difference. Here are some quick tips:

• Line Charts and Area Charts: Perfect for showing a trend over time, like your daily sales revenue or number of customers per week.
• Bar or Column Charts: Use these to compare different categories, such as Sales by Item or Revenue per Staff Member.
• Pie or Donut Charts: Best for showing a breakdown of a whole, like the percentage of sales from food vs. beverage, or online orders vs. in-person.
• Scorecard Charts: Found under 'Chart type', these are excellent for displaying single, important numbers, like 'Total Sales Today' or 'Average Check Size'.

Pro Tip: Design for Clarity

Don’t cram your dashboard with dozens of charts. Prioritize the KPIs you decided on in step one. Use clear titles for every chart (e.g., “Daily Sales - Last 30 Days”), use your brand's colors if you like, and align your charts to create a clean, professional grid.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 5: Keeping Your Dashboard Up-to-Date

Here’s the reality of a manual Google Sheets dashboard: it’s not truly “live.” To update it, you need to repeat the process of exporting a new report and pasting it into your 'Raw Data' tab.

To do this, simply scroll to the bottom of your existing data and paste the new rows. Your formulas and pivot tables that reference entire columns (like 'A:F') will update automatically. If your pivot table has a fixed range (like 'A1:F500'), you'll need to remember to update its data range to include the new rows.

This manual process is the biggest drawback. It takes discipline to do it every day or week, it’s easy to make a copy-paste error, and your dashboard is only ever as current as your last export.

Final Thoughts

Building a restaurant dashboard in Google Sheets is an excellent, no-cost way to get on top of your data. By structuring your sheet properly, using pivot tables and simple formulas to calculate your KPIs, and visualizing the results, you can turn raw sales data into real business insights that help you make smarter decisions about staffing, menus, and marketing.

Eventually, the manual routine of downloading CSVs and updating your dashboard every Monday morning can become a real drag. We built Graphed because we believe getting those insights shouldn't feel like a chore. We connect directly to your data sources - like your POS, Google Analytics, social media ads, and more - and keep everything updated in real-time. Instead of building pivot tables, you can just ask a question in plain English, like "Create a dashboard showing my top-selling items and average check size for the last month," and get a live, automated dashboard back in seconds.