leanzubrezki

3 年前議論

Thanks! I think it was the missing piece to make it really useful for business use cases and both features differentiate the product from the competition.

leanzubrezki

4 年前議論

Thanks! The most common use cases are data analysis, backups, charts, sharing data with users outside your Notion workspace and using Google Sheets formulas to then update values in Notion

leanzubrezki

4 年前議論

I do, not so much about Google but more about Notion, the product changes fast and I fear about changes in the API that would make Notion2Sheets not viable, it almost happen actually , but they rollbacked the changes.

I would think a little bit more about monetization from the beginning, at first there was just the free plan with artificial limits but nothing to test if users were willing to pay.

leanzubrezki

4 年前議論

Thanks!

I am building Packs for Coda, which is the name for integrations. Packs can bring data from third party services and define new formulas and actions, at this time I have built 23 of them connecting with services like Notion, Airtable, Bubble, Webflow and more

There is demand but the scale is not the one of Notion, the best Packs have around 1k workspace installs and then it depends on the number of users on each workspace but I don't have those numbers.

leanzubrezki

4 年前議論

I am Leandro the creator of Notion2Sheets, happy to answer any questions!

Notion2Sheets is a Google Workspace Add-On that runs on the sidebar in Google Sheets and allows users to sync Notion databases with Google Sheets among other things.

It has been around since May 31, 2021 and has almost 15k users.

Super niche tool but pays the bills

leanzubrezki

5 年前議論

Notion is the starting point, having your data in Sheets opens possibilities of integrations that you cannot do with just Notion, so to answer the question, people that want more power from Google Sheets.

The most common user story is:

1) User uses Notion for personal use or is part of a business or organization workspace.

2) Already has databases in the workspace for different purposes, projects, tasks, leads, expenses, backlog, sprints, HR candidates, employees, etc. Notion has a list of customers and use cases that it is quite insightful here -> https://www.notion.so/customers

3) Now the journey separates in different stories:

  - Have a copy of Notion databases as backup.

  - Use Notion databases data as input to other services, and uses Sheets as the middle men.

  - Do business intelligence from Notion databases, you can use Google Data Studio for example.

  - Have charts from their Notion databases and embed them back in Notion.

  - Show summarized information and statistics from Notion databases in a page.

  - Share data from a database without giving access or sharing the entire database or page.

  - Get third party data into Sheets and then from there to Notion.

  - Use Sheets formulas that are not available in Notion, like GOOGLEFINANCE, IMPORTXML to scrape data, etc and have that data available in Notion.

So most of the time if not all, is having Google Sheets as a middle point to then enable the usage of not only Sheets features, but also all the integrations that are built around it. The value of Notion2Sheets is unlocking that.

Something to keep in mind, there are 2 hard limits:

  Sheets -> 100 request in 100 seconds per user.

  Notion -> 3 request in 1 second per workspace.

leanzubrezki

5 年前議論

It is a mix between Sheets and Notion.

From Notion side webhooks could help, getting notified when a page in a database changed so we can update Sheets right on time. If that notification tells which properties changed even better. Moreover that will let us offer real time updates.

From Sheets side, I have tried with the different triggers that Apps Script provides and they are not 100% reliable in how they get executed and the parameters you get. There are some bugs opened in Google issue tracker waiting to be fixed that should address some of the problems, but I don't have a lot of hope as they have been opened for years.

leanzubrezki

5 年前議論

Thanks for the feedback, I really appreciate you taking the time to write.

I totally understand your comments around pricing, the product first started just being your databases in sync, then I added the chance of having Sheets to Notion connections with synced columns, later on recurring tasks to schedule page creations and just a couple of weeks ago synced cells and the ability to connect a cell value with a block in Notion.

Pricing is HARD and it definitely requires some iterations, it is something I struggled with. I started with the limit based approach, 3 databases for free with every one hour updates and then upgrade for more databases and 15 minutes updates. I continued with that line of pricing for the rest of the features but it is probably not the best, number of databases is straightforward but the same is probably not true for the rest of the features, will give that some thoughts.

How would you price those features? I have been thinking about just having the limits over the number of databases and making the rest unlimited for the paid plans.

Regarding content: YES, 100%, I am a software developer and I enjoy writing code and solving problems, the same is not true for content creation unfortunately. I think that in terms of features there isn't a lot more to do for now, so it is time to move into marketing mode and record some good Youtube videos using the different features and giving it a better explanation, I promise!

leanzubrezki

5 年前議論

Thanks for the question!

When you sync a database, by default the connection will be Notion -> Sheets. Then you can make specific columns Sheets -> Notion, but not both ways the same column.

The idea is to enable a much bigger set of formulas and calculations that are not possible or really complicated in Notion so you can make them in Google Sheets and those values will be then sent to Notion, for example you can use GOOGLEFINANCE, IMPORTXML formulas or even mix and match different databases without the need of relations and roll ups.

Similar to how you define a formula property in Notion now but done in Sheets.

If you have a formula in a column in Sheets, you don't want it to get overwritten by a manual change in Notion . I am doing some testing with 2 way sync but with the current Notion API and change mechanisms in Sheets it is not straightforward to have something that just works for all the cases

leanzubrezki

投稿

Show HN: Using sound symbolism and multi-agent AI to generate brand names

Show HN: Save your emails to Notion with one click

[untitled]

$2500 MRR on Notion and Google Sheets Add-On

Notion stock portfolio template synced with Google Sheets

Notion vs. Google Sheets, should you pick one or the other?

How to scrape and import live web data to Notion using Google Sheets

Give Notion the Superpowers of Google Sheets

コメント