Google Sheets to/from Roam! We are calling it S2R!

GitMurf commented 3 years ago

✂️ Copy of your #42SmartBlock from Roam

Download the JSON .zip Roam page. Import it into your Graph. And follow the instructions!

S2R SmartBlock v0.4.zip

📋 Describe the SmartBlock

You can both "Push" and "Pull" data to/from Google Sheets from within Roam.

✅ Describe any prerequisites or dependencies that are required for this SmartBlock

Roam42
Following the instructions to setup your own personal Google API. The instructions look daunting but once you get it setup it is easy and no further ongoing work. 99% of the battle is getting the API setup but I have very detailed instructions in the Roam page provided.

📷 Screenshot of your #42SmartBlock workflow/template from Roam

Here is an intro video. More videos/demos will be posted in the Comments section below.

https://user-images.githubusercontent.com/64155612/103434808-3da31e80-4bbb-11eb-9782-36592fc8a883.mp4

💡 Additional Info

GitMurf commented 3 years ago

Fun / Simple Vlookup example Demo:

https://user-images.githubusercontent.com/64155612/103434861-05501000-4bbc-11eb-8781-4093bba9343e.mp4

GitMurf commented 3 years ago

Reference and Push / Pull blocks in other sheets; not just the one named in the S2R Sheet GID: attribute block. Also can hide cell reference blocks in Roam from being Pushed or Pulled by collapsing parent blocks.

https://user-images.githubusercontent.com/64155612/103434871-257fcf00-4bbc-11eb-9c46-3164481b86ba.mp4

GitMurf commented 3 years ago

When using the Push SmartBlock, if a cell is a formula in Sheets, it will also Pull it back.

https://user-images.githubusercontent.com/64155612/103434878-3597ae80-4bbc-11eb-8dc4-e7f9cc1de546.mp4

GitMurf commented 3 years ago

Use Block References in Roam to populate values to Push to Sheets:

https://user-images.githubusercontent.com/64155612/103434882-43e5ca80-4bbc-11eb-89ff-91aba6a253ba.mp4