Back to guides

How To Create Live Financial Dashboards with IMPORTRANGE

Here is a step-by-step guide on how to create live and dynamic financial dashboards with LiveFlow & Google Sheets.

We'll use the IMPORTRANGE formula to import a live P&L and Expenses by Supplier/Vendor report.

  1. Import your live financial reports with LiveFlow.
  2. Write the IMPORTRANGE function to pull in your data
  3. First, specify the Spreadsheet URL. This will be the URL of the sheet you're currently in, if you're storing your underlying reports/data in the same sheet.
  4. Second, specify the range of data that you want to import, i.e. Profit&Loss!A10:C32
  5. Bring that together in the IMPORTRANGE function
  6. Click enter and when you are asked "Click to connect these sheets" then click Connect


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

Automate financial reporting with LiveFlow

Cta Photo

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.