Connect Google Sheets to Your Business Dashboard in 15 Minutes

You do not have to throw your spreadsheet away

Many businesses already run on spreadsheets. That is okay. Spreadsheets are easy to edit. Your team already knows how to use them. They are often the fastest way to keep work moving.

The goal is not to rebuild your whole business on day one. The goal is smaller and more useful: turn one Google Sheet into a simple live dashboard.

The owner gets charts, KPIs, search, and filters. The team keeps using the sheet. That is the whole point.

Final Result

In this first version, you will connect one sheet called Customers. Staff can update rows in Google Sheets. The dashboard reads those rows and shows live numbers.

What you need

• A Google account
• One Google Sheet
• The Business Operations Starter dashboard
• A Google Service Account
• A deployed app on Render

Start by downloading or cloning the Business Operations Starter. This gives you the dashboard, table, chart, and deployment structure before you connect real data.

git clone https://github.com/mravert93/business-operations-starter.git

Create a Google Sheet named Customers. Add these columns in the first row.

This step gives your dashboard a safe way to read the sheet. Take it one click at a time.

1. Go to Google Cloud Console.
2. Create a project.
3. Enable Google Sheets API.
4. Create a Service Account.
5. Create a JSON key.
6. Save the file safely.

Open the JSON file and find client_email. It will look like an email address.

Open your Google Sheet. Click Share. Add that email address as Viewer.

This gives your dashboard permission to read the sheet, but not edit it.

Environment variables are private settings for your app. Your developer can add these locally and in Render.

GOOGLE_SERVICE_ACCOUNT_EMAIL=
GOOGLE_PRIVATE_KEY=
GOOGLE_SHEET_ID=

The first two values come from the JSON key file you downloaded in Step 3.

The sheet ID is in the Google Sheet URL.

https://docs.google.com/spreadsheets/d/SHEET_ID_IS_HERE/edit

This package lets the dashboard read rows from Google Sheets.

npm install googleapis

Ask your developer to create this file: src/utils/googleSheetsApi.ts

The helper connects with the service account, reads rows from the sheet, and turns those rows into objects the dashboard can use.

import { google } from "googleapis";

const auth = new google.auth.JWT({
  email: process.env.GOOGLE_SERVICE_ACCOUNT_EMAIL,
  key: process.env.GOOGLE_PRIVATE_KEY?.replace(/\\n/g, "\n"),
  scopes: ["https://www.googleapis.com/auth/spreadsheets.readonly"],
});

const sheets = google.sheets({ version: "v4", auth });

export async function getCustomersFromGoogleSheet() {
  const response = await sheets.spreadsheets.values.get({
    spreadsheetId: process.env.GOOGLE_SHEET_ID,
    range: "Customers!A1:F",
  });

  const [headers = [], ...rows] = response.data.values ?? [];

  return rows.map((row) =>
    Object.fromEntries(
      headers.map((header, index) => [header, row[index] ?? ""]),
    ),
  );
}

In the starter, the pretend data lives here: src/utils/mockApi.ts

Right now, this file gives the dashboard sample data. Change one function so it gets customers from Google Sheets instead.

getCustomers: () => wait(customers)

getCustomers: () => getCustomersFromGoogleSheet()

When it works locally, deploy it.

1. Push the code to GitHub.
2. Open Render.
3. Add the same environment variables.
4. Deploy the app.

1. Open the dashboard.
2. Change a row in Google Sheets.
3. Refresh the dashboard.
4. Look for the new data.

That is the moment most owners smile. The team keeps using the spreadsheet, and the dashboard updates from the same source.

What to connect next

Once Customers works, do not rush to rebuild the whole app. Pick the next sheet that saves the most time.

• Invoices
• Tasks
• Projects
• Registrations
• Documents

Troubleshooting

Continue Building

Once one sheet is connected, you can keep adding small, useful integrations one at a time.