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:
