Notion Charts: The Easiest Way To Get Charts in Notion (For Free)
Vložit
- čas přidán 25. 07. 2024
- Get super simple charts in Notion that update automatically in less than 5 minutes.
GET STARTED WITH ROWS (FOR FREE): rows.com/integrations/notion
Notion is an amazing tool, but it lacks a crucial features: data visualisation. But thanks to Rows new Notion integration, it's now possible to create charts in Notion for free in less than five minutes.
Simply connect your Notion account to Rows, import your Notion data to a Rows spreadsheet, create a chart and embed it back into Notion.
These new Notion charts are fully customisable and can automatically update whenever you change something in Notion.
So thank you Rows for sponsoring this video and for making Charts in Notion super simple and accessible.
GET 21+ FREE NOTION TEMPLATES: matthiasfrank.de/special
MY FREE NOTION TUTORIAL 👇🏼
• Notion Tutorial: From ...
BECOME A NOTION PRO & AUTOMATION AVENGER:
📩 Join 11,000+ tech-loving productivity fans who are levelling up their Notion & Automation skills:
matthiasfrank.de/special/
🐦 Twitter
/ mfreihaendig
🎥 TikTok
/ mfreihaendig
📸 Instagram
/ mfreihaendig
💼 LinkedIn
/ matthiasfrankprofile
🌍 The Blog
matthiasfrank.de
💪🏻 WORK WITH ME
Interested in tailor-made solutions to help your business waste less time and get more done? Send me a message on any channel and let’s have a chat
📣 SPONSOR MY WORK
Interested in getting your product or brand in front an audience of 11,000+ tech-loving productivity fans who who are interested in tools and products that help them lead better lives?
matthiasfrank.de/sponsor/
------------------------
Chapters:
00:00 Intro
00:38 Notion Charts Preview
01:38 Connect Notion to Rows
03:30 How to find your Notion Database ID
04:05 How to sync Notion Database to Rows Spreadsheet
05:01 Automatically Refresh Notion Data in Rows
05:30 How to create chart with Notion data in Rows
06:40 How to embed Rows Chart in Notion
08:15 How to create a Pivot Table in Notion
09:45 How to create a Pie Chart in Notion
10:04 How to use Rows AI to analyse your Notion Data
12:18 Outro
---
Notion and the Notion logo are trademarks of Notion Labs, Inc., and are used here with permission.
Some of the links in this description are affiliate links that help support this channel 😇
Want a FREE Notion Avatar? Rows is giving away free avatars to celebrate the launch! Grab yours on linkedin (www.linkedin.com/feed/update/urn:li:activity:7119964835471106049/) or Twitter (twitter.com/RowsHQ/status/1714198461397016859) 🎉
Broooooo!!! Lovin all these videos!! You figured out what I’ve been trying to figure out. Keep the brain dumps going! Brilliant work
Ah so happy to hear that! ☺️ anything in particular you’d love to see next?
Brilliant! I've been wanting to do something like this out for a while!
Glad to hear that! ☺️
I just saw something about ROWS and ignored it until your video opened up a world of possibility. Nicely done!
Right? So many cool options! 😍 glad to hear you like it!
Thank you! Thank you! thank you! I cannot say enough. I am building a Notion DB for my info product, you have no idea how much this video helps me !!!
Ah amazing! So glad to hear that 😇
Thanks for the video.
I am planning to create research reports. This will help me a lot.
Amazing, best of luck!
❤ thanks Mathias you made my day with this!!!!!
Amazing! 😍 are you also gonna get a Notion avatar made? 😎
Thanks for the video! It's soo easy to do
So glad you liked it! 😍
Very good, very helpful, very thanks 🤓
Glad you liked it! 😇
Hello Matthias, loved this
Yes definitely! You can schedule a refresh in rows when you click on the settings for the imported data ☺️ that way, you can set a time to update the data based on any recent changes 💪🏻
And yey to keeping your job ☺️🔥
Thank you so much!
Your welcome 😇
Hello Matthias, thanks for this great video again ! You are the best when it comes to Notion. I have a small issue because in my notion data base, I have a column with a relation and I want to be able to pull the value from the database. Currently rows pull the ID and not the value which is an issue. Do you have any ideas ? Thanks. I also have the same issue with formulas (it is empty in rows)
Ah yeah, that’s because on the Notion backend, it’s actually stored as the ID! Try using a rollup instead that shows the value you want - that might do the trick.
Formula bug is already reported and should be resolved soon ☺️ once that’s the case, you can then also definitely show relation values by using a helper formula!
@@mfreihaendig hello, thanks for your quick answer ! Rows is down today for me, I can not use it. Are you sure they can pull value from roll up ? Another question : on Rows, is it possible to have a dynamic chart ? For instance we want to get the amount of sales for the last 6 months ? And we want the period of the last 6 months to increment of 1 day everyday so that the data in the chart keeps on displaying the amount of sales for the last 6 months. Thanks !
When I add Rollups, I get an error simply saying "JsonObject". Going to try making an API call approach now.
Unfortunately, this didn't work either. There are roll up objects in the JsonResponse, however, while trying to access them with a Data Table, the cell value becomes blank. It seems it is currently not possible :/
Nice work, as always
Can I apply a filter to a database through this app?
I dont think that’s currently possible - you’d need to do some work on the side of rows to achieve that. Great point though, I‘ll pass that on! ☺️
@@mfreihaendig I'm stuck with the same problem. Rows ignores filters made on its own side too when making charts . I hope they will do something about that. Or is there a workaround?
hello matt thank your for your great videos. rows gave great thing for notion user. is rows have automatically sort from data inserted in notion?
Yes you can sort the data in rows based on your needs 💪🏻
@@mfreihaendig but when i insert new data on notion and update in rows the my default sort is change and it always sort manually
@@mfreihaendig when i insert new data on notion and update in rows table the new data always in the row 1 of the table not comfortable with this instead if the new data is added to bottom of the rows of table
thank you SO MUCH :)
Your welcome! 😍 glad you like it!
thank you so much. Do we need to update the data from Rows for the chart to be updated? I tried updating data from Notion database but it doesn't automatically update in Rows unless you click the "Refresh Data Table" manually?
Yes you need to refresh the rows data, but you can do that automatically by scheduling a refresh 💪🏻
I show it in the video tutorial during the setup how to do that
Hi Mathias, thank you so much for this! I was wondering if you know why I might be getting the error: "Failed to save your configuration. Please try again in later" every time I try to import the database? I don't think the problem is my database ID for its the right number of characters (32)
Make sure to open your database as a full page! Oftentimes, it’s actually an in-line database embedded in a page - so you copy the link to the page, not the actual database ☺️
Still not working unfortunately, tried this with all my databases, I don't think its a problem with the integration either@@mfreihaendig
Amazing video! I have one problem, in Rows I'm doing a sort filter to sort my database rows but every day that the data retrieved from Notion is updated, the sort filter sets to default and it's not what I want. I would like to save the sort filter for the table during all time. Do you know any solution to it? Thanks!!
Hmm I‘ll look into this! 😇
Thanks for your video but I'd like to check whether I understood it well or not. how I understood from your video is
,If I change something in the table on Rows, I need to fix the number on notion which is not automatic. is that correct? [7:35] you showed changing numbers on Rows and the graph embedded on notion is updated automatically but didn't show whether the number in the table on notion has changed or not
Yes exactly - it’s a one way sync from Notion to Rows, so you need to update and modify the data in Notion
What I showed on screen was just to demonstrate that any changes to the (existing) data immediately translates into a changed chart ☺️
So the order would be
a) data updates in Notion
b) refresh pulls new data into rows
c) chart reflects new data
If I need to easily switch the date selection for a category bar chart how would I go about doing this?
Could you expand a bit on this? You can set up the chart in the sidebar and select there the values you need to display on each axis ☺️
H how can I create a chart, using my data from calendar? For example I would like to track on chart the amount of money spent during the days. Monday -> -$50, Tuesday -> -$20, etc. etc. Would like to write on calendar and below see the chart
A calendar is just a normal database shown visually, so you would follow the same process to pull the information into Rows, then create a pivot table for days of the week and then build a chart for it 😇
One of my propertiy in notion database is a relation type, so when i integrate it in rows, it appears as an ID (random word like b1eaa57b...). Is there any way to make that "relation value" appear in rows?
Not yet unfortunately - you can use a separate formula property though that shows just the name of the related property and that should do the trick 💪🏻
Notion actually only stores the id in a relation and only renders it as a name, so this is a common issue with pretty much all integrations :-/
Could you explain us which formula could work to fix this problem?@@mfreihaendig
Any idea how can one retrieve more rows from the notion API?
The notion API limits to 100 per request, with the next 100 are on the next API page that can be reached via cursor property
but how can I for example get 200 rows instead of 100 and merge both results into the same rows table?
Edit: Never mind, I was following your blogpost which seems to be outdated approach, the official integration via rows gives all data, thanks for the guides.
Yeah I still need to update the blog post - thanks for the reminder!
Did everything work properly now? 😇
Hi Matthias great job! One question:Afters inserting data from Notion, I put a formula in the last row in Rows for transforming True, False into percentage but when I refresh the data this formula and row data disappears. Is there a way to lock it? I tried with "freeze one row" but it didn't work.
Do you add it as a row or as a column? Columns should stay - rows will disappear after reloading data but you could simply use a separate table and reference the Notion one to keep the calculations after a refresh 💪🏻
@@mfreihaendig thanks a lot! It worked !!
Does anyone know if there is any way to activate the dark mode in the embeds?
Not yet unfortunately, but I already asked the team to please add that in the future 😅
How to make a black mode?
Not yet supported 🥲 raised it with the team though, they are working on it!
If I add a new row of information to my table (in Notion), this new information does not appear in the chart, even when I update the data in Rows
Do I have to add new information direct to Rows?
Thanks for the awesome video
No it should sync over. What kind of new information are we talking about? New properties or new entries?
@mfreihaendig I don't know if this has a specific name.
I have a table view with some properties and the information I'm talking about is when I click "new" and a new row is added to my list and I can complete the property spaces. When I do this, the charts don't process this new information and I have to add new information every day.
The solution I found is to always make a bunch of new lines without filling in the properties, make a graph of them, and fill them in as the days go by, this way, the graph processes the new information (in this case, the new information is just the entries I make in the properties of the lines already created)
Thank you for your attention
This is great, but the problem I see is that filters you apply to a table or chart don't apply to the live view or embeds. This limitation means you can't share a chart based on a subset of your data (relevant if you had a large database where certain parts are private or sensitive).
That’s a general limitation in Notion. Applying filters also won’t allow you to securely share a subset of data.
Without using third party tools (or one of the workarounds for niche situations), it’s impossible to do that in Notion atm
Hi, I think this is amaazinggggggg, thank you for your work I love all this new tools!!!! I have one question, How do I make it work if I have formulas and not numbers in the boxes?
They’re still working on formula properties, so that should hopefully work soon! 😇
@@mfreihaendig thanks for the answer, and thanks for the templates I really learn a lot!
@@johanaduenas9582 awesome I’m really glad to hear that! Anything in particular you’d love to see next? ☺️
Cool tool, very sad that it doesn't support dark mode which makes it completely useless for my usecase :( Gonna keep track of it, hope it will be implemented at some point.
Notion also just announced that native charts are coming soon! So your dark mode problem shouldn’t exist for too long 😇
Hi Mathias, is Rows incapable of reading Notion formulas? All my data with formulas return blank in Rows.
That’s a bug that a few integrations have - I‘ve already raised it with the team, should hopefully be resolved soon!
I had the error with the functions and the Problem, that one collum with the select field is just a random looking ID. Right now it is not useful for me 😢
@@mediacenter2010 where does it show you a weird ID? For me, select and multi-select properties show correctly
@@mfreihaendig one entry is like „fe3305e3-bdc9-4532-b6a6-42b1fa7a7bd0“ it looks like an id. It is always the same id for one kind of the select value
@@mfreihaendig it is a entry from a difference database
tyvm
Your welcome 😇
i ll be here a lot, from now on.
@@paulopenido9268 well, I can't wait to hang out with you here 😇
Still no dark mode?
Nope - but Notion has announced native charts by now, should release soon!
Great video, so thanks for that.
However, does anyone know how to solve for the following disadvantages?:
- Height is not responsive
- Background is white only (so not looking good if your Notion is dark themed)
- Lacking of charts (it only has basic charts but no cooler charts like spider chart etc)
Yeah those are unfortunate drawbacks at the moment - but it should soon be much better because Notion has announced native charts! They should hopefully drop in Q3 😇
Bro, please try slowing down and speaking clearar. It's challenging enough that you have an accent
Sorry I’m too excited and impatient 😅😎