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”

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: