Spreadsheet of Life
Jul 2020 - Jun 2025
Category: Personal Design
Google Sheets Used in 6 projects
Google Apps Script Used in 2 projects
Apple Shortcuts Used in 1 project
Description
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.
SoL also contains health data such as distance traveled, steps and fluid intake which I send each evening from my phone to the file via Apple Shortcuts.
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.
SoL also contains health data such as distance traveled, steps and fluid intake which I send each evening from my phone to the file via Apple Shortcuts.
Lessons Learned
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.
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.
Project Links: