Turn Google Sheets into Live Dashboards

April 26, 2022

Turn Google Sheets into Live Dashboards

Did you know that you can turn your Google Sheet into a beautiful live dashboard? 🤩 

A dashboard you can share with your stakeholders in a few clicks.
A dashboard without the Google Sheets interface, but only with the core metrics that need to be monitored while keeping the source data intact.


Here is how you can set it up:

  1. Open your Google Sheet and head over to File → Share → Publish to web.
  2. Select the entire spreadsheet or a tab.
  3. Make sure you restrict access by checking the right box.
  4. Click Start publishing.
  5. Share the link with anyone you’d like to share your Google Sheet with.


Here is a 1-min video explainer showing you how to do it step-by-step.

With LiveFlow's templates you can create dozens of live dashboards that will update your data in real time. For example, you can use a free Google Sheets Budgets vs Actuals template, Consolidated Profit & Loss template, and a Marketing P&L template. You can use LiveFlow's Financial Dashboard template for Google Sheets too.

The best part? They come for free, check it out here.

Try out LiveFlow for QuickBooks Online and Google Sheets for free to automate your dashboards.

Continue reading

Bring financial data into Google Sheets. Fast.

Try out our Google Sheets Add-On and bring your P&L, Balance Sheet and Cash Flow into Google Sheets in no time.

Capterra & LiveFlow
G2 & LiveFlow Reviews
LiveFlow reviews on Product Hunt
Watch demo