how to build a simple business dashboard without code

a business dashboard answers your most important questions without you having to pull reports, export CSVs, or open five different tools every Monday morning.

this guide covers three approaches — Google Sheets, Looker Studio, and Rows.com — all of which require no coding and cost between $0 and $17/month.

what a business dashboard should actually tell you

a dashboard that shows every metric is a dashboard that shows nothing useful.

a solopreneur needs to answer five questions weekly:
1. how many visitors came to the site this week?
2. where did they come from (organic, social, direct, paid)?
3. which content or pages drove the most conversions?
4. what is the current revenue trend?
5. which marketing channel has the best ROI?

build your dashboard around those five questions. add more metrics only when you have made decisions based on the first five consistently.

option 1: Google Sheets dashboard (free, 30 minutes)

a Google Sheets dashboard is a sheet that pulls key metrics into one view and updates automatically via add-ons or IMPORTRANGE.

step 1: install the Google Analytics 4 add-on

in Google Sheets, go to Extensions → Add-ons → Get Add-ons → search “Google Analytics” → install the official Google Analytics spreadsheet add-on.

this add-on lets you pull GA4 metrics directly into a Sheet with a formula: sessions, pageviews, conversions, goal completions — whatever your GA4 reports contain.

step 2: set up a report

go to Extensions → Google Analytics → Create New Report. configure the report: choose your view, metrics (sessions, conversions, revenue), dimensions (date, source/medium, page), and date range (last 7 days).

click “Run Reports.” the data lands in a new sheet called “Report Configuration.”

step 3: build the summary tab

create a new sheet called “Dashboard.” use IMPORTRANGE or direct cell references to pull key numbers from the report output into a clean layout.

step 4: add a chart

select your weekly traffic data, go to Insert → Chart, choose Line chart, and set it to update automatically.

the Sheet updates every time you manually refresh the GA4 report. to automate the refresh: install a scheduling add-on like “Automate Sheets” or use a Google Apps Script trigger.

limitations: requires occasional manual refresh unless you set up automation. more setup than Looker Studio. better for analysts who want to customize formulas.

option 2: Looker Studio dashboard (free, 1 hour)

Looker Studio (free) is the fastest path to a live connected dashboard that updates automatically without any manual refresh.

step 1: create a new Looker Studio report

go to lookerstudio.google.com. click “Create” → “Report.”

step 2: connect your data sources

click “Add Data” in the setup screen. connect:
– Google Analytics 4 (select your property)
– Google Search Console (select your site)
– Google Sheets (any sheet with business data — revenue, ad spend, etc.)

each connection takes under 2 minutes.

step 3: add charts and scorecards

use the toolbar to add:
– Scorecard: a single big number (total sessions, total conversions, MRR)
– Time Series: sessions or revenue over the last 30 days as a line chart
– Bar Chart: traffic by source/medium
– Table: top 10 landing pages with sessions and conversion rate

drag and resize components to build the layout you want.

step 4: set the date range

add a “Date Range Control” component (from the toolbar). this gives every viewer a filter to change the time period. link it to all your charts.

step 5: share the dashboard

click Share in the top right. anyone with the link can view the live dashboard. you can also set up scheduled email delivery (Looker Studio sends a PDF snapshot of the dashboard to a list on a weekly schedule).

pre-built templates: instead of building from scratch, use an existing template — see best Looker Studio templates for small business 2026.

limitations: calculation capabilities are more limited than Google Sheets. complex metrics like customer lifetime value require preprocessing the data before it enters Looker Studio.

option 3: Rows.com dashboard (free-$17/month, automated data pull)

Rows.com connects directly to live data sources — Stripe, Google Analytics, HubSpot — without using add-ons or manual exports.

step 1: create a new Rows spreadsheet

go to rows.com. create a free account. create a new spreadsheet.

step 2: connect a data source

click the “Integrations” button in the toolbar. select your data source (e.g., Google Analytics 4). authenticate. Rows imports a sample query showing your traffic data.

step 3: configure the data pull

modify the query to pull the exact metrics you need. set the refresh schedule (daily, weekly, on open).

step 4: build the dashboard layout

use Rows’ table and chart components to build a clean view. the “AI Summarize” formula can add a text summary: =AI.SUMMARIZE(A1:A30) on a column of weekly session counts produces “sessions peaked in week 3 at 1,240 and declined 12% in week 4.”

limitations: free tier limited to 3 scheduled refreshes per month. paid Starter plan ($17/month) allows weekly or daily refreshes.

five metrics every solopreneur dashboard should track

1. organic sessions week-over-week: is SEO growing? week-over-week trend lines catch drops before they become Google Search Console alerts.

2. top 5 landing pages by sessions: which content is pulling traffic? this tells you where to invest next and which pages need refreshing.

3. conversion rate by traffic source: organic traffic converting at 3% and paid at 0.5%? that data changes your budget allocation decision.

4. revenue (or signups) trend: monthly or weekly revenue line. if you run Stripe, pull this directly via Rows or a Zapier → Sheets → Looker Studio pipeline.

5. content production velocity: if you are content marketing, how many articles went live this month vs target? a simple counter in a Sheet linked to the dashboard keeps you honest.

recommended path by starting point

starting from zero: build a Looker Studio dashboard using a free template. connect GA4 and Search Console. done in under an hour.

already in Google Sheets: extend your existing Sheets with the GA4 add-on. add a Dashboard tab that references key cells from your data sheets.

willing to pay $17/month: use Rows for auto-refreshing data from Stripe and GA4 side by side in one spreadsheet.

for the full data visualization tool comparison: best data visualization tools for solopreneurs 2026.

for pivot table skills that feed into your dashboard: Google Sheets pivot tables: complete beginner guide.