In this tutorial, we’re going to learn how to import Spotify data to Google Sheets by first creating a Spotify-Google Sheets integration. We can then easily pull multifarious types of data from Spotify to Google Sheets–such as the latest releases, trending songs, album tracks, and account data such as playlists, playlist tracks, and even add and delete tracks to and playlists from Google Sheets.
Steps to import data from Spotify to Google Sheets:
- Install Amigo Data in Google Sheets
- Create a Spotify API app and generate a token
- Get the API endpoint URL
- 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.
How to create a Spotify-Google Sheets integration import Spotify data to Google Sheets
We’ll learn step by step how to get Spotify data to Google Sheets.
How to import data from Spotify to Google Sheets
Step 1: Create a Spotify Google Sheets integration
We need a tool with which to connect Spotify to Google Sheets. For this, we’ll use Amigo Data to create a Spotify and Google Sheets integration, 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.
Alternatively, you can open a Google Sheets, then go to Extensions→Add-ons→Get add-ons. And search for Amigo Data and install.
Step 2: Create a Spotify API app
We need to create an app in Spotify for Developers platform so that we can integrate Spotify with Google Sheets.
- Go to https://developer.spotify.com/dashboard/ and log in with your Spotify account.
- Click CREATE AN APP.
- Name your app and give a brief description.
- Tick the checkbox and click the CREATE button.
This app will enable us to create a Spotify integration with Google Sheets.
Step 3: Generate access token and get the endpoint URL
To get the authorization token and the endpoint URL, navigate to the CONSOLE section.
On the left panel are all the categories of data that we can retrieve from Spotify and export to Google Sheets. Select any of the categories. Then click the endpoint for which you want to import the data, eg Get Playlist to export a Spotify playlist to Google Sheets.
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.
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.
Step 4: Import 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.
Follow the steps below to import the data from Spotify to Google Sheets.
- Go to Google Sheets and open a new spreadsheet. Then go to Extensions→Amigo Data→Connect.
- From the list of sources, select Custom API.
- 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.
- 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.
- 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 and then the delete icon to delete the non-required information. Flatten and expand all options and delete the ones you don’t require.
- Once that is done, click the IMPORT button to import the Spotify data to Google Sheets.
The Spotify data should be imported to Google Sheets in a moment. Below is a sample of the imported data.
You can likewise import any Spotify data into Google Sheets.
For example, to export a Spotify playlist to Google Sheets, select Playlist from the endpoint categories. Then click the Get a Playlist option. Enter the playlist ID. And then (optionallly) specify the fields to export if you want to export only specific fields such as track name, artists, and URL.
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.
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. Hope this spotify google sheets integration guide helped you.
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.
How do I export Spotify playlists to Google Sheets?
To export a Spotify playlist to Google Sheets, follow the steps below:
- Create an app in Spotify for Developers.
- Generate an access token while granting the necessary scopes.
- Get the playlist endpoint of the playlist to export.
- Launch Amigo and export the Spotify playlist to Google Sheets.
How do I export songs from Spotify?
To export specific songs from Spotify to Google Sheets, click the “Tracks” endpoint category. Then select the “Get Track” endpoint and enter the track ID. And then follow the steps mention in Step 4 of this article to export the track to Google Sheets.
Can you export your Spotify data?
Yes, you can export your personal Spotify data to Google Sheets. Simply click the “Users Profile” endpoint and enter the user ID to export the profile data for that user. To export other types of data such as a user’s playlist or recently played tracks, select the respective endpoints and export the data using Amigo.
Some related articles you may be interested in: