Script to export list of Audible books into a Google Sheet document and update automagically that Google Sheet as new books are added to your Audible library.

It also allows you to print your Audible library to the screen using the default fields of interest (ASIN, TITLE, AUTHORS, DURATION, PURCHASE_DATE) or any of the many fields provided by Audible (currently 80 fields, available using the -l option)).

It uses mkb79's excellent Audible API.

Here's a sample.

(with screenshot)

• Python >= 3.6
• depends on following packages:
  • audible
  • pygsheets

In the future....

pip install audible2sheet

But for now use git to clone/download the files

Also See Authentication sections

Since there are so many things that you can tweak in terms of configuration, I decided to put all that information in a configuration file instead of passing the configuration as CLI arguments

Unless specified otherwise using -c /some/other/path, the configuration file is expected to be in your homedir (~) as .audiblesheet.ini.

I provide a sample of a cfg file in audible2sheet.ini_ORIG that looks like this:

[general]
root_path = .audible2sheet
# root_path = /Users/user_name/.audible2sheet

[audible_cfg]
# MANDATORY
email = [email protected]
# Not mandatory but you will be prompted for it if not specified
password = MyK0mplXPasswd
# Can be changed but are defaulted to the below values
session_file_path = audible_session.txt
# Check out the Localizations section in this page: https://github.com/mkb79/Audible
locale = us
library_file_path = audible_books.txt
# Minimum length (in minutes) to be kept in the library
min_length = 1
# ASINS to omit in case you don't want publically show that you like the Twilight series ;-)
# (space-separated)
asins_to_omit =
# Audible content to ignore (comma-separated)
# Find available choices here: https://www.audible.com/advsr under Program Type
# Based on my own list showing that "Product" (Audiobook?) is the most prevalent
# Episode                 1
# Lecture                15
# Newspaper / Magazine    2
# Performance            12
# Product               602
# Radio/TV Program        5
# Show                    1
# Speech                  6
content_type_to_omit = Speech,Newspaper / Magazine

[google_sheet_cfg]
creds_file_path = audible2googlesheet.json
sheet_name = my_audible_books_generated_by_audible2sheet
cache_file_path = gsheet_books.txt
# The below email must be a valid email to be used by Google Sheet to grant you read/write access to the sheet
email = [email protected]!!!

So, cp audible2sheet.ini_ORIG ~/.audible2sheet.ini; chmod 600 ~/.audible2sheet.ini and then at the very least specify your email audible email in the audible_cfg section. If you don't want to be prompted each time, also specify your password.

If you are not in the US, change the locale as well. Check out the Localizations section in this page: https://github.com/mkb79/Audible

In order to access your Audible library, you need to provide login and password (see configuration above) to the script in order to log in on your behalf. The first time you do this, you will be challenged with a CAPTCHA image that looks like this:

and prompted at the command line with:

Answer for CAPTCHA:

(Note that you might be prompted more than once if you answer incorrectly)

Once the CAPTCHA has been successfully verified, your access is granted and your session is saved in your ~/.audible2sheet/audible_session.txt file unless specified otherwise in the configuration file.

Finally, your locale ("us" by default) can be specified if you live outside the US. Check out the Localizations section in this page: https://github.com/mkb79/Audible

Once your session has been established you no longer need to specify your email or password until the session expires. It seems to expire after few hours at this point.

Follow the instructions here: https://pygsheets.readthedocs.io/en/stable/authorization.html (More specifically the top of the "Authorizing pygsheets" section)

Then the "Service Account" section which is what is used in this in Audible2sheet: https://pygsheets.readthedocs.io/en/stable/authorization.html#service-account

The downloaded .json file must be placed here ~/.audible2sheet/audible2googlesheet.json unless specified otherwise in the configuration file.

Note that the standard columns that audible2sheet creates for you are:

• ASIN
• TITLE
• AUTHORS
• DURATION
• PURCHASE_DATE

Feel free to remove any of them except ASIN which is used as a key to determine if any book is missing in the sheet.

You can also shuffle the order of the columns as long the column header names remain the same as above.

You can also add new columns that you want to manage yourself like whether you read the book and when, your rating of the book, etc...

Just print the list of books to the screen:

audible2sheet.py

If you don't specify your Audible password in the cfg file, you will be prompted for it with:

Please enter your Audible password:

You can redirect it to a file of your choosing

audible2sheet.py > audible_books.txt

Just print/use the list of books that was previously fetched from Audible (from cache file)

audible2sheet.py -a

Create/update your Google Sheet with the list of books from Audible

audible2sheet.py -g

Show the books retrieved from Audible in JSON format (useful for debugging)

audible2sheet.py -r

Show the books retrieved from Audible in |-separated format

audible2sheet.py -R "asin title authors narrators"

Show all the fields available from Audible

audible2sheet.py -l

Show the help/usage:

audible2sheet.py -h

Currently:

usage: audible2sheet.py [-h] [-c CFG_FILE] [-r] [-R PRINT_SPECIFIC_RAW_DATA]
                        [-l] [-L LIST_VALUES_OF_SPECIFIED_FIELD] [-g] [-a]
                        [-A] [-f ASIN_FILTER] [-v]

Pull Audible library books and output them to the screen or to a Google Sheet.
The list of books to the screen/STDOUT is "|"-separated

optional arguments:
  -h, --help            show this help message and exit
  -c CFG_FILE, --cfg_file CFG_FILE
                        Configuation file (default:
                        /Users/jerome/.audible2sheet.ini)
  -r, --print_raw_data  Print the raw data as returned by Audible (default:
                        False)
  -R PRINT_SPECIFIC_RAW_DATA, --print_specific_raw_data PRINT_SPECIFIC_RAW_DATA
                        Print the specified raw data column (space-separated)
                        as returned by Audible (default: None)
  -l, --list_raw_data_fields
                        List all the raw data fields as returned by Audible
                        (default: False)
  -L LIST_VALUES_OF_SPECIFIED_FIELD, --list_values_of_specified_field LIST_VALUES_OF_SPECIFIED_FIELD
                        List all the values associated with the raw data
                        specified field (default: None)
  -g, --google_sheet_export
                        Export the Audible book list to the Google Sheet
                        specified in the configuration file. (default: False)
  -a, --use_audible_cache_file
                        Use Audible cache file instead of requesting the data
                        (default: False)
  -A, --use_audible_raw_cache_file
                        Use Audible raw cache file instead of requesting the
                        data (default: False)
  -f ASIN_FILTER, --asin_filter ASIN_FILTER
                        Ignore all books except the one with the specified
                        ASIN (default: None)
  -v, --verbose         Verbose output to show addditonal information
                        (default: False)

I'm purposely omitting "books" that have a zero-length and "books" of type "Speech" and "Newspaper / Magazine".

That can be tweaked in the configuration file.

✨🍰✨