100 Days of Code

Why Am I Doing This?

I’d like to get better at both Google Apps Script and Python. Posting to my blog which has been a ghost town for years is my way of holding myself accountable.

Although nobody reads this and I’ll delete this post if I end up failing, but it at least FEELS kinda motivating to have it posted publicly.

It’s also good to be able to get back to writing and seeing how bad WordPress has borked their UI since I last used it.

Might also be a huge waste of time, although that’s unlikely.

We’ll see.

What have I learned so far?

April 6th 2020 – Day 4

Well hello again. Been doing this on and off, but recently got back into it and was able to do two pretty cool things. First and foremost I was able to create a time series forecast using Google sheets. I was also able to create my first Google Apps Script OAuth script using a variation of this from Github. I was using it to pull in Google Search Console data from Google Data Studio and I used a modified version of this script to make it happen. Progress is slow but good.

Feb 19th 2020 – Day 3

Didn’t do as much as I would’ve liked today, although I was able to create my first custom menu in Google Sheets while working through the third part of the Google Codelabs course.

I also created a private list on Twitter of people who are pretty heavy into Google Apps Script automation. Will be good to see the level of conversations they’re having and sharing so I can better understand what’s happening in the space.

Hope to pick back up more tomorrow.

Feb 18th 2020 – Day 2

I ran into some issues with Jupyter notebooks at work so downloaded the Anaconda Python installer to get it to work. I also was able to create an array formula which helped with a Google Sheets query which had to have 48 columns returned. It was loosely based on this article.

I finished the second “Fundamentals of Apps Script with Google Sheets” course offered by Google Codelabs which was useful. Slowly making progress.

One thing that I was unable to do was upload a CSV to BigQuery. Look forward to the day when I’m able to do it.

Feb 17th 2020 – Day 1 (also Michael Jordan’s birthday):

I created a script that converts a dollar value to Swiss Francs based on code from here: https://codelabs.developers.google.com/codelabs/apps-script-fundamentals-1/#4. It’s pretty useless, but is cool to see the script creation process start to take form. Also stoked to dig into Ben Collins’ Google Sheets Courses to learn more.

I also started to experiment with Jupyter Notebooks after finally learning to install them. RealPython looks like it’ll be a useful community to be a part of.