[HN Gopher] Give Notion the Superpowers of Google Sheets
       ___________________________________________________________________
        
       Give Notion the Superpowers of Google Sheets
        
       Author : leanzubrezki
       Score  : 24 points
       Date   : 2021-09-23 18:27 UTC (4 hours ago)
        
 (HTM) web link (notion2sheets.com)
 (TXT) w3m dump (notion2sheets.com)
        
       | jitl wrote:
       | This is so cool! I wonder how their service resolve conflicts to
       | sync changes back into Notion.
        
         | leanzubrezki wrote:
         | 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
        
       ___________________________________________________________________
       (page generated 2021-09-23 23:01 UTC)