Arrow left
Back to product 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.


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.

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

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at:
Check Icon
Call us at +1 (415) 650-1711