Import Data From Spotify To Google Sheets

Import Data From Spotify To Google Sheets
Reading Time: 6 minutes

Steps to import data from Spotify to Google Sheets:

  1. Install Amigo Data in Google Sheets
  2. Create a Spotify API app and generate a token
  3. Get the API endpoint URL
  4. Import the data to Google Sheets with Amigo Data add-on

Spotify is one of the largest music and audio streaming platforms and serves as one of the largest repositories of music. Tens of thousands of songs and podcasts are uploaded to Spotify daily, and millions use its services. All major record labels and artists have a presence on Spotify.

Spotify makes most of the data on its platform available to the public. With the Spotify API, you can access and import all the data to Google Sheets–information such as an artist’s top tracks, new releases from a specific country or all countries, get a list of an artist’s related artists, and so on along with all the metadata.

Why import data from Spotify to Google Sheets

There are not just nerdy but pragmatic reasons to import data from Spotify to Google Sheets. Record labels and artists may take their music off Spotify or you could lose access to your account. Think of all the childhood music you’ve lost. If only you have them somewhere such as Google Sheets, you’ll have a treasure trove of memories and nostalgia.

Here are a few things you can use use the data for:

If you are an artist, you can

  • Identify which types of songs are popular
  • Identify the seasonal trends and interests of listeners
  • Monitor other artists, their top tracks, their release cycles, and so on

If you are an audiophile, then you can

  • Keep all the catalogue of your music in a safe place
  • Curate songs by artists
  • Get the latest releases and track new hits
  • Have the list of the top tracks and artists according to your activity.

Let’s learn how to import data from Spotify to Google Sheets. 

Step 1: Getting the tool to import the data

We need a tool with which to import data from Spotify to Google Sheets. For this, we’ll use Amigo Data, a simple but versatile Google Sheets extension that’s easy to use, rich in features, and gives you the ability to pull data from several different sources.

You can get it from the Google Workspace Marketplace here.

Get Amigo Data to import data from Spotify to Google Sheets

Alternatively, you can open a Google Sheets document, then go to Extensions→Add-ons→Get add-ons. And search for Amigo Data and install.

Step 2: Creating a Spotify API app

We need to create an app in Spotify for Developers platform so that we can integrate Spotify into Google Sheets.

Spotify developers' dashboard
  • Name your app and give a brief description.
Creating an app to access Spotify API
  • Tick the checkbox and click the CREATE button

Step 3: Generating access token and getting the endpoint URL

To get the authorization token and the endpoint URL, navigate to the CONSOLE section.

On the left of the screen, click any of the categories. Then click the endpoint for which you want to import the data.

List of different data endpoint categories

For this tutorial, let us import the list of newly released albums. Click Browse and then click Get New Releases.

On the next screen as shown below, enter the country code that you want the information. (Or leave it blank if you want to import the data for all the countries.) Then set the limit and specify the offset if you want (these are optional too).

Then click the GET TOKEN button to generate the token.

Getting the API token

Once the token has been generated, click the TRY IT button to verify if the input parameters are valid. If you see no error, then you can proceed to the next step–which is, to import data from Spotify to Google Sheets.

Mark the endpoint and the access token, as they will be needed for the next step.

If you set a query parameter (eg. country, limit), the full URL excluding the quotation marks is to be used. Or you can just enter the parameters manually as queries in Amigo Data–for example: Key: country, Value: US; key: limit, value: 50.

API URL of the desired data

Step 4: Importing data from Spotify to Google Sheets

If you haven’t already installed the Amigo Data add-on for Google Sheets, you need to do so because we’ll be using it to import data from Spotify to Google Sheets.

If you have, then follow the instructions below to import the data from Spotify to Google Sheets.

  1. Go to Google Sheets and open a new spreadsheet. Then go to Extensions→Amigo Data→Connect.
  2. From the list of sources, select Custom API.
  3. Keet GET as the option for HTTP request. Then go back to the Spotify developers page and copy the endpoint and paste it in the API URL bar.
  4. Click the Authentication tab and select Bearer from the dropdown menu. Then go back again to the Spotify developers page and copy the token and paste in Credentials.
  5. Keep the other options as they are and click PREVIEW.

The preview data is cluttered and unorganised. So make sure to organise and delete the information you don’t require by clicking the FLATTEN button. Flatten and expand all options and delete the ones you don’t require.

  1. Once that is done, click the IMPORT button.

The data should be imported in a moment. Below is a sample of the imported data:

Data imported to Google Sheets from Spotify

You can likewise import any data from Spotify into Google Sheets. 

Note: The access token expires after one hour, which is set by Spotify for security purposes. You can navigate to the Console page and click the GET TOKEN button to generate a new token.

This tutorial uses the more basic but easier to understand method to get the API endpoint. For a detailed description of Spotify API and endpoints, see the Spotify API Documentation.

Setting refresh schedule

To get the information updated periodically, click the report you want to update automatically, toggle on the Refresh Schedule and select the schedule–hourly, daily, weekly or custom days.

Then click Save & Run.

Alerts via email or Slack

You can get the report sent to your email or a Slack channel if you want to.

To set up an alert, click Get Alerts→Add alert data+. Edit the details and click Set Alert.

Conclusion

There are plenty of data you can import from Spotify to Google Sheets. And with Amigo Data, you can import all of them without a hassle with just a few clicks. Whether it is importing tracks from your favourite artist or your lists of songs and podcast episodes or generating a list of recommendations and importing them to Google Sheets, Amigo Data can be your companion.

See also

Spotify is just one of the many from which you can import data to Google Sheets with Amigo Data. You can use it to import data from open data platforms of governments of various countries such as the US, India and the UK; stock data; weather data; data from databases such as Redshift and Snowflake; etc.

And while you are here, why not take a tour of our other articles? We have a large collection of tips and tutorials on Google Sheets. Click HERE to start.

Some related articles you may be interested in:

https://blog.tryamigo.com/youtube-analytics-to-google-sheets/

https://blog.tryamigo.com/import-data-google-search-console-to-google-sheets/

https://blog.tryamigo.com/export-data-from-google-trends-to-google-sheets/

One response to “Import Data From Spotify To Google Sheets”

Leave a Reply