Best answer

Find Spotify Song from URL

  • 23 April 2021
  • 3 replies

Hi everyone,


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


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 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

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:


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 🙂

That’s genius - thank you!!!


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?