Is The Audible Daily Deal on my To Read List?
Audible Daily Deals are very hit or miss for me, and the last 6 months they have been completely miss. And since unnecessary emails are one of the main issues plaguing modern man according to Tim Ferriss, every useless message you can prevent will help you a lot. Not only that, but I got in the bad habit of getting Daily Deals that I didn’t necessarily want to read. Below I will show you how we can solve both those problems.
You will need:
- A Goodreads account
- Google Sheets
- A free Zapier account
Step 1, find your Goodreads To Read RSS feed. It is located here, on the right of the bottom bar:
And will look like this:
https://www.goodreads.com/review/list_rss/4780051?key=yg0k1ayyOvUD8Yyg3SoLYeMcUj6M8dkgspm76iaZYGgP_ZZe&shelf=to-read
(As a side note, I am always look for more good book recommendations).
Save a copy of this Google Sheet and plug your To Read RSS feed into the top.
Now, to get emails when there is a match will require you to setup a free Zapier account.
Create a new Zap with the trigger set to: “Updated Spreadsheet row”. Be sure to select the “True” field in the second tab of the spreadsheet. Then have Zapier email you if there is a match. Bonus points if you include a link to http://www.audible.com/dailydeal.
Make sure it looks every day. Go to File, Spreadsheet Settings and set Recalculate to every hour.
How it works
First, we are grabbing all the titles from your goodreads list in the first tab of the spreadsheet using importfeed:
=IMPORTFEED(A1,”items title”, false, 200)
The good news is that the feed title is also the book title.
In the second tab we are using importxml to pull in the title of today’s Audible daily deal.
=IMPORTXML($A$2,”//h1″)
Then we search the first tab for an occurrence of the Daily Deal title:
=iferror(VLOOKUP(B2,’To Read’!A2:A200,1,false), “”)
I like using iferror so my spreadsheets do not fill up with “N/A”.
I add in the match field for good measure. And to give Zapier something to look at that cannot have a “N/A” temporarily trigger an alert.
How it looks in your inbox:
There you have it. Now you will only get alerted when the Daily Deal is something you already wanted to read.
