git push heroku master

Assumptions

• The user is in random time zones at random times and switches often, therefore the bot can't know about your daily schedule. This puts a lot of focus on averages, as it doesn't matter if a value was entered at 11pm that day, or 8am the next one, the numbers will even out, as only daily, weekly and monthly averages are considered when rendering graphs.

This repo contains the Telegram bot that is responsible for collecting the data.

There are 2 ways to input data: by the user telling the bot to ask for all the values, and by a regular interval of the bot asking you (similar to the deprecated mood bot)

lifesheet.json

Available values for schedule:

• eightTimesADay
• daily
• weekly
• manual

Using fourTimesADay, this will replace the mood bot

• How are you feeling today?

/awake

This will trigger the morning questions, like:

• Sleep duration
• Sleep quality
• Body weight

/asleep

This will trigger the end-of-day questions like

• Fitness related:
  • Alcohol intake
  • Macro adherence
  • Hunger issues?
  • Fatigu/Lethargy?
  • Feel stressed?
  • Caffeine intake?
  • How healthy do you feel today?
  • Number of steps
• Productivity related
  • Did I solve actual programming/technical problems?
• Social
  • Felt like enough time by myself?
  • Felt like enough in control of my own time and schedule?
  • Felt like enough socializing?
  • Felt like enough going out, bars, restaurants, dancing etc.
• Personal growth
  • Learned new skills or things?
  • Went out of my comfort zone?
  • Number of minutes of Audible
• Other
  • Meditated
  • Note: what was the main thing I did today?
  • Boolean: Did I set goals for the next day?
  • Do you feel excited about what's ahead in the future?

/week

This will trigger questions that take longer to reply, so they're only done weekly

• Fitness related
  • Current macros
    • g of Carbs
    • g of Protein
    • g of Fat
  • Body measurements
  • Overall training adherence
  • Note: Comments on fitness
• Productivity
  • Overall happiness with life progress of the week, do I go into the right direction?
  • Number of open Trello tasks (from howisFelix.today)
  • Number of emails in Inbox less than 5?
  • Average daily hours on computer
  • Average daily iOS screen time (minus MyFitnessPal and Strong app)
• Social
  • Felt like spent enough time with family?
  • Had deep conversations with close friends?
• Other
  • Did I travel, this includes every city more than 1h away, this is relevant for both fitness and productivity
  • Note of all locations I was at (cities)
  • Got out of my comfort zone & experienced/tried new things?
  • Do you feel like having to travel somewhere?
  • Do you feel like you're missing out on things?
  • Played computer games by myself
  • Played computer games with friends or family?

skip - Skip a question that was asked
report - Generate one page report
track - Track a specific value only
mood - Track your mood
awake - First thing in the morning
asleep - Right before going to sleep
week - Once per week metrics
skip_all - Remove all queued questions

npm run dev

After using npm run dev, open chrome:https://inspect to use the Chrome Dev Tools

.keys file or however you manage your secret env variables:

export TELEGRAM_BOT_TOKEN=""
export TELEGRAM_USER_ID=""
export TELEGRAM_CHAT_ID=""

export DATABASE_URL=""

export LIFESHEET_JSON_URL=""

Use the Heroku scheduler, and set it to run every hour to remind you to run certain commands according to the defined schedule (weekly, etc)

npm run reminder

Create a new Postgres database, and run the SQL queries defined in db/create_tables.sql

To analyze the data, check out the visual_playground subfolder https://github.com/KrauseFx/FxLifeSheet/tree/master/visual_playground

The original implementation abused Google Sheets as a database, and I used Google Data Studio to visualize the data. Both implementations ended up not working pretty quickly.