art of the smart

The website of Alejo Grigera: techie, entrepreneur, and curious observer of the world.

[2017-10-11] An Update on Ob2SS

projects apps-script

Hey folks, I wanted to give everyone a quick update on my project, Ob2SS (the Object 2 SpreadSheet script for Google Spreadsheets).

First, I've moved the project to it's own domain at This helps keep my site free of baggage and gives folks a place where they can get the code, read t...

Continue Reading »

Object Passing In Google Sheets

code apps-script spreadsheets

Suppose you're building a spreadsheet in Google Sheets, and you have each row corresponding to- essentially- an entity. Now you're clever, and set up Apps Scripts in order to manage more complex aspects of your worksheet. But how do you pass objects from the spreadsheet context to the script c...

Continue Reading »

Here are the top 3 things I love and hate would like to see change in the Grav CMS.

Things to love

A flat CMS is stupendously convenient. Not having to muck around with a database saves a lot of time and headache. It makes migrations easier because you don't need to worry about where your...

Continue Reading »

A Reliable Bitcoin Strategy

finance bitcoin etherium investing

With all the recent run-up of Bitcoin and Etherium, I have had a lot of friends and family come out of the woodwork asking me about it. A few of them have asked how many I own (less than you think) or how much I've made (more than I deserve). A few have asked if I have any advice, which I'm happy...

Continue Reading »

Suppose you have a spreadsheet to collaborate with colleagues. You've made one field where they can type in whatever they want, but you know that you want some level of standardization, otherwise you can't do aggregate analysis later. What do you do?

The answer is to use Data Validation while si...

Continue Reading »