Make a dashboard that updates itself from Google Sheets — no code
Published · Updated
You don’t need to write code to keep a dashboard current — point it at your Google Sheet once and it updates itself. Paste your dashboard into Larssoni, connect your Sheet, and every change you make to the spreadsheet flows through to the live link.
A living dashboard is just a normal dashboard pointed at your spreadsheet. You paste the one you already made, connect your Google Sheet once, and from then on it keeps itself up to date: change a number in the Sheet and the dashboard at your link changes too. No formulas to wire, no code to keep running — that’s the whole thing.
What “self-updating” actually means
A normal dashboard is a snapshot: true the moment you made it, wrong soon after. A self-updating dashboard stays pointed at the place your numbers actually live — your spreadsheet — and reads them again on a schedule. You don’t re-export anything and you don’t touch the code. You change the Sheet; the dashboard follows.
No formulas to wire up, nothing running on your laptop, no code to maintain. That’s the whole idea, and it takes about a minute to set up.
Build it in four steps
Paste your dashboard into the box at the bottom of this page. We keep it safe — it won’t vanish on you.
Connect your Google Sheet. We read the column names to set it up once; your real numbers stay yours.
Check it: your original on the left, today’s numbers flowing through it on the right. Looks right? Turn on auto-updates.
Keep it. From now on it updates itself — change the spreadsheet, and the dashboard changes too.
Setting it up reads your spreadsheet’s column names — the structure, not the values. Your real numbers only flow at update time, get checked, and go live only if they look right.
What happens when your numbers change
Once auto-updates are on, the dashboard checks your Sheet on a schedule. New numbers flow in, get checked against what the dashboard expects, and go live — you get a short note that it happened. If something looks wrong (a column emptied out, a number that can’t be right), it doesn’t publish the bad version: viewers keep seeing your last good one, clearly dated, while you fix the source.
That’s the difference between a snapshot and a living dashboard — the snapshot goes stale silently; this one keeps itself honest.
When a dashboard can’t update itself
About one dashboard in seven keeps its numbers locked inside a chart image, where no one — including us — can reach them to refresh. Yours still gets everything else: the always-on link, the sharing choices, every version kept. And there’s a one-line fix — ask the tool for “the same dashboard with a visible data table,” paste it again, and updates switch on. We show you exactly this tip if it happens.
Do the four steps above and you just built a living dashboard — keep it.