Spotify New recently played track.

Google Sheets Add row to spreadsheet.

Record my Spotify play history and track audio features in a Google Sheet

by sampoustie

1

Connect

Every time a track plays in Spotify, this applets records a row in a Google Sheet with the track name, artist, date played, and the track's audio features (such as key, tempo and danceability).

If

New recently played track

This trigger fires every time you have played a new track on Spotify.

With

Get audio features from a track

This query returns the audio feature from a track

Then

Add row to spreadsheet

This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.

You might also like

Popular services on IFTTT

More on Spotify and Google Sheets

About Spotify

Spotify is a digital music service that gives you access to millions of songs. Applets can help you save your Discover Weekly and Release Radar playlists, share your favorite tunes, and much more.

Learn more

More integrations with Spotify

About Google Sheets

Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.

Learn more

More integrations with Google Sheets