Turn Amazon Order History into a Markdown Table for Day One

The other day I posted about using Keyboard Maestro to automate the process of getting my monthly Amazon Order history into a Day One Journal entry. That was the first step of the automation of this task.

This has been a bit more challenging to automate than I was first thinking. I’m working towards this 3 step process:

  • Step 1: open up Day One and in Safari open up the URL for Amazon Order History report screen. [Done]
  • Step 2: automatically download this month’s Amazon Order History report [Need to figure this out]
  • Step 3: create a journal entry from a downloaded Amazon Order History .csv file [Now Done]

I am still messing around with Keyboard Maestro for step 2 but was able to hack together a pretty handy Automator workflow for step 3. It’s a python + BASH script that

  • takes a .csv file, strips out the unnecessary columns,
  • totals up the amount spent for the month
  • create a Markdown table of the important columns from the .csv
  • creates a Day One Journal entry and tags it “Money”

Continue reading “Turn Amazon Order History into a Markdown Table for Day One”