Skip to content

Monthly

Email yourself a monthly backup of your Liked Songs

On the 1st of each month you get a CSV listing every liked song, artist and album.

Runs
Monthly
Apps
Spotify
AI
Not needed
Access
user-library-read

Send this to your assistant

Create a ClickRuntime automation: on the 1st of every month, email me a CSV of all my Spotify liked songs with track, artist and album.

Paste it into your assistant. It tells you what it will send or change before it runs live.

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

Years of tapping the heart icon in Spotify add up to a personal record of your taste: thousands of Liked Songs. All of it sits inside one service. If an account is hacked, closed after a billing problem, or you decide to switch to another streaming service, there is no simple export, and rebuilding the list from memory is impossible. Songs also disappear from Spotify when licenses expire, and you only notice when a track turns grey.

On the first of each month, ClickRuntime pages through your saved tracks, builds a CSV with track name, artist, album and the date you added it, and emails the file to you. The result is a plain text copy that you can keep in your inbox, open in a spreadsheet or import into another service.

People who treat their library as something worth keeping, and those who might switch services, tend to want it.

What you get out of it

  • Your library survives account problems

    A hacked or suspended account no longer means the end of years of curation. The latest CSV in your mailbox preserves what you had liked. Few people think about this until a login stops working, and by then it is too late to make a copy.

  • Switching services stays possible

    Importers for other platforms accept lists of tracks and artists, so a CSV makes it far easier to move to another service, or to run both, without starting over. Lock-in matters less when your history can be exported on your own schedule.

  • Unavailable songs are documented

    When Spotify removes a song from its catalog, it vanishes from your playlist without notice. Monthly files show which tracks used to be there, so you can find them elsewhere. Over several years, that list can become surprisingly long.

  • Taste over time is recorded

    The added date lets you see what you liked in which month, so you can build a playlist of the songs that defined a particular summer or year. It makes a good starting point for playlists that mark seasons or events.

  • No manual export is ever needed

    Spotify's own data export is slow and generic. A monthly copy to your inbox means there is always a recent version, even when you forget about it for a year.

How it works

What happens, step by step

  1. On the 1st of each month, ClickRuntime goes through every song in your Spotify Liked Songs.

  2. It builds a spreadsheet-style CSV with the track name, artist, album and the date you liked it.

  3. The CSV arrives in your inbox with the total number of songs in the subject line, so you always have a copy of your library.

Before it runs live

  • Connect Spotify

What you get

RunsMonthly
Email yourself a monthly backup of your Liked Songstoday, 9:00Succeeded
Email · Liked songs backupSpotify liked songs backup (1,248 tracks) track,artist,album,added_at Harbour Lights,Northwind,Coastlines,2026-09-30

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.
  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

  • Run it at a different time, more or less often, or only on weekdays
  • Add an AI step, for example to summarize, sort or draft a reply
  • Add another app, for example also send it to Slack
  • Combine it with other Spotify steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.
liked_songs_backup.pyexample
import csv, io
from clickruntime import on_trigger, credentials, http, notify

@on_trigger
def run(event):
    h = {"Authorization": f"Bearer {credentials.connection('spotify', 'personal')}"}
    buf = io.StringIO()
    writer = csv.writer(buf)
    writer.writerow(["track", "artist", "album", "added_at"])
    url, count = "https://api.spotify.com/v1/me/tracks?limit=50", 0
    while url:
        page = http.get(url, headers=h).json()
        for item in page["items"]:
            t = item["track"]
            writer.writerow([t["name"], ", ".join(a["name"] for a in t["artists"]), t["album"]["name"], item["added_at"][:10]])
            count += 1
        url = page["next"]
    notify.email_me(f"Spotify liked songs backup ({count} tracks)", buf.getvalue())
    return {"tracks": count}

FAQ

Common questions

How many songs can the backup handle?
Spotify returns saved tracks in pages of up to 50, and the run keeps asking until it reaches the end, so libraries of several thousand songs are covered. Very large libraries simply take a little longer to collect.
What columns are in the CSV file?
It includes the track title, artists, album, the date you liked it and the Spotify track link or ID. If you want other details, like duration or release year, mention them when you set it up.
Can I restore the songs to Spotify from the file?
The CSV is a record that you can use with importer tools or to rebuild the list by searching. A separate automation could re-add tracks by their Spotify IDs, which makes restoring much faster if ever required.
What permissions does it need?
user-library-read. Nothing else in your accounts is used.
Does it need AI?
No. It runs without AI, so it doesn't use your plan's AI allowance.
How many runs does it use?
One run each time it runs (monthly). Checks that find nothing to do and stop right away aren't counted.
Can I change how it works?
Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Set up “Email yourself a monthly backup of your Liked Songs” from your assistant

Copy the prompt above, or connect your assistant first. Free plan, no credit card.