Query the Spotify API

Sample sheet: https://app.quadratichq.com/file/599e0fa8-3f4c-401b-b917-6615ade9514f


To get started with the Spotify API make sure you've set up your developer account correctly: [https://developer.spotify.com/dashboard/create](https://developer.spotify.com/dashboard/create). From here you can retrieve your client_id and client_secret. You'll need these to make any requests.

We'll use Spotipy, a lightweight Python library for the Spotify Web API.

Making requests

Get popular tracks for an artist

# install and import Spotipy and required SSL library 
import micropip
await micropip.install('spotipy')
await micropip.install('ssl')

import spotipy
from spotipy.oauth2 import SpotifyClientCredentials

# Create a Spotipy instance using your credentials from: https://developer.spotify.com/dashboard
sp = spotipy.Spotify(auth_manager=SpotifyClientCredentials(client_id="<your_client_id>",

# Perform your query
artist = c(1,2)
results = sp.search(q=artist, limit=40)
track_list = []
for idx, track in enumerate(results['tracks']['items']):

# Return the track list to the sheet 

Output from Spotify

Need help making this connection? Feel free to reach out to support@quadratichq.com for help.

Quadratic logo

The infinite canvas spreadsheet with code.

Try it now