One of the things that make Google Sheets so powerful and versatile is the ability to extend it with Apps Script and to be able to install and use add-ons from the Google Workspace Marketplace. We believe that even if Notion adds support for them in the feature, it will be difficult to match the options and customization that Google Sheets offers. Notion doesn’t support charts natively but there are a number of integrations that bring charts to Notion connected to databases. You can also create pivot tables with different aggregation functions, such as sum, average, count, min, max, etc and the values are automatically calculated as the main table changes. You can also create pivot tables with different dimensions, such as rows, columns, and values. You can create pivot tables with different types of data, such as numbers, dates, text, and even custom formulas. Pivot tables are used to summarize data in a table. We enter in Google Sheets speciality here. Once we enable filters, we can then create different views that show different data based on the filters that we have selected. We can filter data by colors, values, conditions and even custom formulas. We can apply filters to a single column or a range of columns, and we can sort a single column or a range of columns. Something similar happens in Google Sheets, where we need to mix two concepts, views and filters as well. You can create complex filters and sort rules and then use linked databases to show the same data in different ways. Views are great because they allow you to filter and sort your data in a way that is easy to understand and easy to use. Notion has the concept of views, where a single database can have multiple views which allows you to present your data in different formats. I’d say both provide amazing options, Notion being easier to start with and use while Google Sheets is more complex but more powerful. ![]() What is important to note is that you can’t define your own functions or reference data from other pages, you can only reference data from the same page. In Notion you can create columns of type formula in databases which allows you to format data, reference other properties from the same page and make use of more than 60 of Notion defined functions to work with your data. It has multiple templates that you can choose from, and you can also customize the look and feel, create tables with filters and search, and much more. The main player in this category is Sheet2Site, which is an add-on for Google Sheets that allows you to publish your spreadsheets as a website. ![]() Now you are probably thinking that Google Sheets is gonna lose this round, but it’s not. It is up to you to decide which one you want to use. Both offer custom domains, styles, great SEO by default, pretty URLs, and a lot more, including password protected pages □. In Notion we can name two main players, Super and Potion. Create a websiteīoth Notion and Google Sheets have options to publish your pages or spreadsheets as a website so people can easily access them, but let’s explore a little bit more about what additional third party options we have for each product. We can say then that in both cases we have amazing options around templates with premade databases, dashboards and structures that we can reuse in our projects. ![]() Doing a quick search in Google about “Google Sheets templates” you will also find dozens of websites that offer templates, free or with changes depending on how complex the template is.
0 Comments
Leave a Reply. |