Spreadsheet of Life

The Spreadsheet of Life (or SoL for short) is the backbone of my finances, holding data for helping me with all my financial decisions.

It is an ever expanding Google Sheets file that I use to take snapshots of my daily, weekly and monthly finances which is then summarised to me each day through automated emails, run through Google Apps Script.

It has an integrated daily summary of my Google Calendar, a summary learning section on a random topic created by Claude and a summary of my Todoist tasks.

SoL also contains health data such as distance travelled, steps and fluid intake which I send each evening from my phone to the file via Apple Shortcuts. It also has a Google Apps Script that summarises a number of newsletter sources for me each morning into one summary email.

The Spreadsheet of Life was my first real introduction to JavaScript, via Google Apps Script, allowing me to generate daily emails to myself. This also brought up several challenges such as storing snapshots of generated graphs within the file to be sent which I achieved using temporary storage in Google Drive.

It also taught me the full power of APIs from an early stage, allowing me to populate the sheet remotely from using Apple Shortcuts on my iPhone.