Add data analysis to Notion Project to manage larger projects
At Morph, we love Notion and use it every day. Because Morph is built by Notionophiles, of course we designed Morph and Notion to work together.
Today I would like to share an example of importing data from Notion’s project management into Morph for data analysis. If you frequent tech twitter, you might have seen ChatGPT spitting out graphs — we’re going to do that, but with our own data.
Starting Point
In this example, I’ll use project management template from Notion: https://www.notion.so/templates/notion-projects-and-tasks
Import data from Notion
You can port data from Notion to Morph simply by filling in a form. Check the video below:
Filling in the form requires you to get Notion’s API key. Here’s how to do that: https://developers.notion.com/docs/create-a-notion-integration#getting-started
You also need the database’s id:
To find a database ID, navigate to the database URL in your Notion workspace. The ID is the string of characters in the URL that is between the slash following the workspace name (if applicable) and the question mark. The ID is a 32 characters alphanumeric string
Now you are ready to import the data to Morph! Go to Morph and click the ‘+’ button next to ‘Source’ in the sidebar. Then select “Notion” and fill out the form. Once complete, it will take about thirty seconds to import the data.
Once the data is imported, you will see Notion in the Source section. Go to the Source page and create a Notebook from the ‘+ Create’ button in the tool bar at the top.
Ask AI what you want on Notebook.
With Notebook on Morph, you can ask any type of task to your dataset with plain, non-technical language.
Making a pie chart by counting the number of tasks per status.
Put the prompt below:
Count the number of records grouped by status and make it into a pie chart.Then wait a second… and boom!
You can get any type of chart without writing code!
Next, let’s make the pie chart a little bit more fancy. Here are some ideas.
- Put the count next to the status label
- Change the colors used to cold colors
The prompt will be like this.
Count the number of records grouped by status and make it into a pie chart.
Put count next to the status label.
Use only cold colors.The result is:
See how easy it is to analyze data using Morph? AI, data, and data processing combined into one incredibly powerful tool. We hope you will give it a try!
Website: https://www.morphdb.io/
