Automation Scripts

add_offline_time.py

This script adds my TV watching events as an Offline Time to RescueTime.

TV watching time events come from my HomeBridge-IFTTT setup. Each time an event triggers (TV-on or TV-off), my IFTTT recipe will run and add a new row to the spreadsheet (example below).

add_offline_time.py will run on a daily basis to scan the spreadsheet for un-logged time events, pair them up to create a duration and then add to my RescueTime activities labeled as "Watch TV" (it will then automatically marked as "Very Distracting" activity). After the duration is successfully added to RescueTime, the script will go back and upload the corresponding rows in the spreadsheet and mark them as Logged.

To install and run:

pip install -r requirements.txt 
# Make sure you have Google credentials.json in your directory
export RESCUETIME_API_KEY='[Your RescueTime API Key]' && \
export SPREADSHEET_ID='[Your Spreadsheet ID]' && \
python add_offline_time.py