Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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

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 🙂

That’s genius - thank you!!!

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

Terms & Conditions