Arrow left
Back to guides
Google Sheets Tips

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.


Save hours formatting your next financial spreadsheet!
100+ templates, all free to use.
Free Spreadsheet Templates

Here is how you can set it up:

  • Open your Google Sheet and head over to File → Share → Publish to web.

  • Select the entire spreadsheet or a tab.

  • Make sure you restrict access by checking the right box.

  • Click Start publishing.

  • 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.

Turn Quickbooks Online data into a Google Sheets dashboard
100+ templates, update automatically, totally secure!
Book a Demo

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below

No items found.