Setup Guide

Open the link below and click Make a copy. This saves a personal copy to your own Google Drive — your data stays private and only you can edit it.

In your copied sheet, click the Settings tab at the bottom. Fill in your Last.fm username and API key in column B.

When you made a copy in Step 1, Google showed a notice saying "The attached Apps Script file and functionality will also be copied" — that's the sync script. It came with the template, so there's nothing to add.

You can confirm it's there by going to:

You'll see the Last.fm sync code already loaded and ready. No changes needed — just close that tab and move on to Step 4.

Go back to your sheet. You'll now see a Last.fm menu in the top menu bar, next to Help. Click it and select Start Auto-Update (90 min).

That's it — your sheet will now automatically pull in new plays from Last.fm every 90 minutes. The 90-minute interval is intentional: some sources like Deezer can have a delay before scrobbles appear on Last.fm, so a longer window helps make sure nothing gets missed.

Now link your sheet to the site so your charts load from it. In dankcharts.fm, open Settings (the ⚙ icon), choose Google Sheets, and paste your sheet's URL.

Want to add plays directly from dankcharts.fm using the + Add Play button? You'll need to deploy the script as a Web App first. Here's how:

1. Open the Apps Script editor

In your Google Sheet, go to:

2. Create a new deployment

In the Apps Script editor, click:

3. Configure the deployment settings

A dialog will open. Set the following:

Click Deploy. You may be asked to authorize — follow the same steps as in Step 4 (Advanced → Go to [app name] (unsafe) → Allow). Once done, copy the Web App URL it gives you.

4. Paste the URL into dankcharts.fm

In dankcharts.fm, go to:

Paste the URL into the Apps Script Web App URL field and save. The + Add Play button will now work.

Go to last.fm/api/account/create and fill in the form. The values can be anything — here's a quick example:

After submitting, Last.fm will show you an API Key (32 characters) and a Shared Secret. Copy both — you'll need them in the next step.

Open Settings (the ⚙ icon), select Last.fm as your data source, then scroll down to the Scrobble Setup section. Expand Use custom API credentials and paste in both values.

Click Connect to Last.fm. Last.fm will open in a new tab asking you to grant access to your account. Click Allow access, then come back to dankcharts.fm and click I've authorized ✓.

The status indicator will change to ● Connected as [your username] — you're all set.

Navigate to the Raw Data tab. Every row has a ✎ edit button on the right. Click it to open the edit panel for that entry — you can fix the artist, track title, album, or timestamp.

Once your corrections are ready, click Push to Last.fm. A corrected scrobble will be submitted to your Last.fm history with the details you entered.