Best answer

Find Spotify Song from URL

  • 23 April 2021
  • 3 replies
  • 1911 views

Hi everyone,

 

I have a Google Sheet where URLs to Spotify songs are added in regular intervals, for example:

https://open.spotify.com/track/4sdhaq0Z4KL5oCF5GCgTtt?si=dd9418fa67474b73

 

I’d like to add these songs to a Spotify playlist automatically every time a new song is added to the Google Sheet.

 

I’m trying to use the following logic:

If a new row is added to a Google Sheets spreadsheet, find the song via the URL and then add the song to a specified Spotify playlist.

 

However, the “Find Song” action for Spotify doesn’t seem to work with URLs. Any ideas for a workaround?

 

Best,

Jan-Sebastian

icon

Best answer by Danvers 29 April 2021, 12:31

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Hi,

I'm trying to do this too, but I need a little more (step by step?) help in how to use Formatter to pull the URI from the URL and then get it into a playlist.

Also, is this possible with the free account?

Thanks,

Bjørn

That’s genius - thank you!!!

Userlevel 7
Badge +12

Hi @Jan-Sebastian!

 

The Spotify track ID is part of the track url, so we can make this happen!

 

The track url is the text after “track/” and before the question mark, here’s what that would look like for the url above:

https://open.spotify.com/track/4sdhaq0Z4KL5oCF5GCgTtt?si=dd9418fa67474b73

 

To pull that ID from the full url, you can use the Formatter by Zapier app. That allows you to split any string of text based on a specific character, so you’ll be able to get that ID with a couple of additional steps (one to get the text after the slash and another to get the text before the question mark.

 

If you’re familiar with using regex expressions, you can also use the Formatter ‘Find Pattern’ which is under the Text options, which would save you a step 🙂