Search API Connector Documentation


Import Spotify Data to Google Sheets


In this guide, we’ll walk through how to pull Spotify music data directly into Google Sheets, using the API Connector add-on for Sheets.


Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Connect to the Spotify API

If you haven’t connected API Connector to Spotify before, you’ll first need to initiate the connection as follows:

  1. Open up Google Sheets and click Extensions > API Connector > Manage Connections.
  2. In the list of available connections, find Spotify and click Connect.
  3. You will be directed to and asked to authorize the connection. Click Agree.
  4. You’ll then be returned to your Google Sheet, and can verify that your Spotify connection is active in the Connections screen.

Part 2: Create Your Spotify API Request URL

For our first request, we’ll get some basic information about your Spotify account.

  • API root:
  • Endpoint: /v1/me

Putting it all together, we get the full API Request URL.

Part 3: Pull Spotify API Data into Sheets

Now let’s copy that into API Connector.

  1. In API Connector, click Create, and paste in the Request URL we created above.
  2. Under OAuth, choose Spotify from the dropdown menu. You should see a “Connected” badge.
  3. We don’t need any headers so just leave that section as is.
  4. Create a new tab and click Set current to use that tab as your data destination.
  5. Name your request and click Run. A moment later you’ll see some information about yourself populate your sheet.

Part 4: More Example API URLs

Now that we’ve got the basic handshake down, let’s get some more interesting data. Try the following URLs (one at a time).

  • Get your own most played tracks
  • Get your own most played artists
  • Get your recently played tracks
  • Search for artists matching a keyword
  • Search for tracks matching a keyword
  • Get audio features of a list of track IDs,4VqPOruhp5EdPBeR92t6lQ,37R0bQOQj5a7DOqh1TGzvB

Part 5: API Documentation

To see more API endpoints and example responses, I suggest checking out out the Spotify Web API reference located at

Previous Import Shopify Data to Google Sheets
Next Import Strava Data to Google Sheets

Leave a Comment

Table of Contents