Google Sheets Based Life Tracking Dashboards

Davide de Souza is a quantified selfer who got serious about tracking as much as he could. He picked 35 of the most important areas of his life to track and set up semi-automatic feeds to push all the data into Google Sheets. He is collecting data using a combination of the Fitbit API and RescueTime plus some manual data entry.

The broad categories he is tracking are health, productivity, food and giving back. The dashboard tabs provide insightful summaries of his goals and progress. He has also been able to make various correlations which are difficult to accomplish today due to limited data aggregation tools. His project makes me realize just how powerful Google Sheets is.

 

[ Read More David De Souza ]


Have an amazing project to share? The Electronics Show and Tell is every Wednesday at 7:30pm ET! To join, head over to YouTube and check out the show’s live chat and our Discord!

Join us every Wednesday night at 8pm ET for Ask an Engineer!

Join over 38,000+ makers on Adafruit’s Discord channels and be part of the community! http://adafru.it/discord

CircuitPython – The easiest way to program microcontrollers – CircuitPython.org


New Products – Adafruit Industries – Makers, hackers, artists, designers and engineers! — New Products 11/15/2024 Featuring Adafruit bq25185 USB / DC / Solar Charger with 3.3V Buck Board! (Video)

Python for Microcontrollers – Adafruit Daily — Python on Microcontrollers Newsletter: A New Arduino MicroPython Package Manager, How-Tos and Much More! #CircuitPython #Python #micropython @ThePSF @Raspberry_Pi

EYE on NPI – Adafruit Daily — EYE on NPI Maxim’s Himalaya uSLIC Step-Down Power Module #EyeOnNPI @maximintegrated @digikey

Adafruit IoT Monthly — The 2024 Recap Issue!

Maker Business – Adafruit Daily — Apple to build another chip at TSMC Arizona

Electronics – Adafruit Daily — SMT Tip – Stop moving around!

Get the only spam-free daily newsletter about wearables, running a "maker business", electronic tips and more! Subscribe at AdafruitDaily.com !


1 Comment

  1. Wow! I don’t see that he has a bucket for “Time Spent Quantifying Self.”

    To track the details of your life at this level is certainly a sign of madness. But… To freely offer this information to the ‘Google Data Store’© makes the activity certifiably insane!

    Kudos for the infrastructure work though, and I do understand that bean counters like to count beans – so more power to them. Still, I’m left wondering if the endeavor eschews mental health for the socially endorsed (enforced?) ideal of perfect physical health.

Sorry, the comment form is closed at this time.