Analyzes your Spotify listening data collected through IFTTTT and stored in Google Sheets
WARNING! I have no idea how to stop IFTTTT from logging all of my data into Google Sheets. If you don't want it to log your songs forever, continue at your own risk. (Mine has been logging songs for literal years with no end in sight)
I run this in the terminal because I write code from the terminal like a madman. (I'm not sure how this would affect running through an IDE, etc.)
- Make sure you have Python installed
- Install
pandas: runpip install pandasin the terminal. Extra information can be found here
- Follow the instructions for installing Jupyter Notebook and Anaconda here. For help with understanding how Jupyter Notebook works, find information here
- Download the Jupyter Notebook version of the code (the file that ends in
.ipynb). You will still need to install pandas (see above in general Python Setup)
- You will need this IFTTTT applet and connect it to an account with Google Sheets
- Wait for your data to roll in as you listen to songs!
- Make sure the Google Sheet that is created is open for viewing for anyone with a link
- Copy the Google Sheet link from the browser (i.e. not the link that Sheets gives you to share, yes they are different!) insert it in line 6 of the code
- Add a row at the very top with the following headers: "date" "song" "artist" for columns a, b, and c
- Run the code! (Feel free to change it accordingly, I usually run this at the end of each month to see my monthly round-up and other cool data facts)
This repository would not be possible without IFTTTT, Google Sheets, and wherever I got the convert_google_sheet_url() function.
Pull requests should be open.
For testing, please feel free to use the .xlsx Excel spreadsheet (this is for more advanced users) OR use my Google Sheet with my Spotify wrapped: https://docs.google.com/spreadsheets/d/1AUxY8Cjr5MMgrTzoewKzGfqO1fnUzzkOBapEGpt1I7A/edit?gid=0#gid=0
Any questions about this code, please email me at lizstip3@gmail.com
