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”

automator screen shot

You can download the Workflow here.

When you right click and run the workflow on an Amazon .csv report you get a handy Day One entry like this:

Day one