Dashboard blog banner
17. May 2023

How to create a dashboard in Notion

With its customizable interface and flexible features, Notion is a go-to tool for many teams and individuals looking to stay organized and productive. However, until recently, Notion has lacked the ability to create visual representations of your data. That's where GRID comes in. GRID seamlessly integrates with Notion, so you can create charts and interactive dashboards that help you stay on top of your tasks and goals. 

In this blog post, we'll show you how to create a dashboard in Notion using GRID for a streamlined workflow and better productivity.

Connecting your Notion database

First, you’ll need to connect your Notion account to GRID. It’s a really simple 3 step process:

1. Go to Setting & members on the top left on your Notion page and click My connections. If you don't see GRID on the page, click Browse connections in Gellery and find GRID and click connect. If you don’t already have an account, you’ll need to create one.

Notion dicovery page

2. Next, go to GRID and create a new document. Click Add existing data and click the Notion logo. Select the pages you want, and then the database you want to sync with GRID.

Connect notion database - notion lp

3. Now your database should be visible in the data panel. Note that your database appears in alphabetical order in GRID except for the first column, so it might look a bit different than it does on your Notion page.

  • To quickly create & format a visualization directly from your Notion database, use Chart Builder. You’ll be offered the option to use the chart builder when you connect your Notion database. Once activated, the chart builder will be visible in the bottom right corner of the data panel.

  • Our AI Chart Assistant is another fantastic option for creating visualizations from your Notion databases. This feature can be found in the right corner of the spreadsheet panel once you connect your database.
    Simply describe your requirements for the chart, and the chart assistant will create it for you.

Creating a dynamic sales dashboard

Embedded sales dashboard

Now that we’ve connected a Notion database, we can create our sales dashboard. You can access the Notion database here and the GRID document here. The dashboard will include four charts displaying the following information:

  • Total sales this quarter shown by month

  • Total sales by each salesperson

  • The commission for each salesperson

  • The distribution between enterprise and residential sales

Our first chart is a column chart showing total sales per salesperson. In the chart builder, select ‘Salesperson’ on the X-axis, then ‘sum’ and ‘Price’ on the Y-axis. To customize the chart (add a title, change colors, or adjust sort order) click More options in the bottom right corner of the chart builder. You can also double click on the chart to open the editor panel.

For our second chart, we need to create a helper column in our Notion database to show the total sales for each month. To do this, we add a new formula column and insert the following formula:

formatDate(prop("Date of sale"), "MM")

This column will give us a number from the date column. For example, January 5, 2023 will become 1 in the helper column. Now we can create the chart for Total sales by month. Select ‘Month helper’ on the X-axis, then ‘sum’ and ‘Price’ on the Y-axis. To change the labels, click ‘More options’ and input the desired labels in the X-axis labels field in this format: ={"January";"February";"March"}

You can learn more about the Chart Builder and Chart Assistant in this short tutorial:

For our final two charts, repeat the process described above, and choose your X and Y-axis categories and the desired aggregation for the data. The chart on the bottom right includes interactivity with radio buttons, which can be added by following the instructions in this help guide.

There might be specific cases where more aggregation of your data is needed than the chart builder offers. In those cases you can use the Query function. Yep, we’ve got a quick tutorial video for that too:

Finalize layout & enable embedding

Once the charts are arranged, go ahead and add column elements from the insert menu. This’ll position multiple charts side by side. With your charts arranged, embed them back into Notion by pasting the link to your document onto your Notion page. Alternatively, use the /embed function in Notion by making your GRID doc embeddable. Just go to ‘Share’, ‘More options’ and toggle ‘Embed’.

Dynamic dashboards are a strategic way to track important data, keep your team aligned on important KPIs, and help clients more easily navigate their options.

Try GRID

More blog posts

15. February 2024

Build a website calculator for lead generation in 4 steps

Transform spreadsheets into interactive, lead-generating calculators with GRID, enhancing lead qualification and website conversion rates.

22. November 2023

Tool building in GRID by guest blogger Vincent Doedee

In this guest post by Vincent Doedee, he describes how he's been able to use GRID to leverage his spreadsheets...

27. September 2023

Monetizing expertise through spreadsheet models

The blog discusses monetizing expertise using spreadsheet models, highlighting how domain experts can benefit from GRID's features to enhance their...

22. August 2023

Create beautiful charts with your Airtable bases in 3 simple steps

Learn how to use GRID to make charts and reports from your Airtable bases.

17. August 2023

6 great ways AI can improve your data work

Improve the quality, accuracy, and accessibility of your datavis with GRID’s AI assistants.

08. August 2023

Emre Toker: Empowering entrepreneurs with GRID

How startup founders and investors use GRID to make the best possible decisions.

26. June 2023

How to create a dashboard from your Airtable base

Learn how to visualize your Airtable bases and create a dashboard.

19. May 2023

How to switch from notioncharts.io to GRID: a step-by-step guide

Learn how to easily transition from notioncharts.io to GRID and gain access to powerful features including an AI formula assistant...

17. March 2023

How to use AI with INDEX MATCH, VLOOKUP and IF functions

Find out how you can unlock the power of the VLOOKUP, INDEX & MATCH, and IF functions with GRID's AI...