Generates a list of all sale items in: markdown
that looks like this on a reddit post, html
that looks like this when rendered, and plain text
that looks like this.
Now also has a csv
output that you can import to Google sheets: Current sale 2 for 1 sale - Unpauseable (Ends April 16, 2021).
Use at your own risk. I have good intentions, but you shouldn't go copy pasting scripts into your browser's console all willy nilly. Just as a heads up, Firefox will give you this warning message when you try to paste things into the console. You should probably heed the warning:
Firefox warning message in the console → Scam Warning: Take care when pasting things you don’t understand. This could allow attackers to steal your identity or take control of your computer. Please type ‘allow pasting’ below (no need to press enter) to allow pasting.
You don't need to know how to code or read any code to use this script. It would be preferrable, as stated above, but the only thing you need to know is how to copy & paste.
- Copy the script into your clipboard from here: Audible Special Promo Sale Scraper.js —
(Ctrl+A)
>(Ctrl+C)
- Go to the sale page.
- As an example, here's the current (June 2020) US sale page: https://www.audible.com/special-promo/2for1.
- The script won't work if you navigate to one of the sub pages of the sale. It has to be the first page of the sale.
- Open your browser's developer tools console. The easy way is to right click anywhere on a website, choose
Inspect element
from the context menu and then click theConsole
tab. - Paste the script
(Ctrl+V)
into the console and press enter. This video shows where the code should be pasted.
The console will just about immediately log each book it finds in the console so you got some idea where it's at. When the script is done scraping, it will replace the contents of the page with 3 text boxes with the different outputs. You can refresh the page to load the normal Audible sale page again.
Tested in Firefox and Chrome. Should work in other modern browsers too: Safari, Edge
The script was written specifically for the US 2for1 sale and as such I'm not even certain if it will work in any other sale, let alone a similar sale on a different region. There is a possibility it might.
There's a variable called slimMarkdown
at the very top of the script. Change this to var slimMarkdown = true;
and you'll get the title wrapped in a link to the Audible store page and rating below that. If you want anything slimmer, you're going to have to edit the script. There should be only 2 occurences of slimMarkdown
so it should be easy to find where to edit it.
You can use online Markdown editors to preview or convert it to another format. At the very least you should be able copy the text from the preview and paste it to your email client and retain the styling.
Online Markdown editors:
Desktop and some mobile markdown applications may have similar or more extensive export options
When you download the HTML
it gets a basic html wrapper around making it so you could just upload it as is to a website and share the link. For other use cases, you'll probably want to copy it from the textarea.
There are also 3rd party services where you can put the HTML
and share a link:
- codepen - Requires an account and I also couldn't save my large wishlist unfortunately
- jsfiddle
- Github pages - A pretty good way to host a simple site. It's not hard to upload your website or single html file in this case, but it is quite the long process, and may be hard to understand if you're not familiar with how github works.
Here's my wishlist in jsfiddle.
This is forcefully slimmed down to just the title → link to audible
because plain text is very plain...
This is the advanced format of the bunch, which all of the outputs as the base. Downloaded file is indented (poorly) and the JSON in the textarea is in single line.
The CSV format is pretty typical, but it does use a couple formulas that I have only tested to be working in Google Sheets.
Here's my whole wishlist in goole sheets.
I have edited it a little after import:
- I converted all cells to text to get rid of some wonky weird text alignment (a little more about that below under "how to import csv to Google Sheets")
- Click on the top left corner to select all cells
- Choose text formatting from the
Format
menu (It's somewhere in there)
- Made all rows taller to make the cover image bigger
- Click on the top left corner to select all cells
- Drag one of the rows to be taller (the image fits itself in the available space)
- General width adjustment of each col
- Clipped the text contents of cols
J
andK
- Click on both cols...
- And choose Clip from the
Format
menu (It's somewhere in there)
- I edited the header row
- Made the text bold
- Changed text color
- Changed background color
- and lastly I froze the header row from the
View
menu
- How to import csv to Google Sheets
- You'll likely want to use the import option: Replace spreadsheet
- And you will want it to convert numbers, dates and formulas to make sure formulas work right.
- This does align some numbers and dates differently, but you should be able to fix that by converting all cells to text afterwards.
- That said, spreadsheet applications converting what was originally text into numbers is notorious for dropping out changing the formatting in a way that you probably don't want. I didn't see anything weird happening in this case.