About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

How do I remove unwanted tags from Google Alert RSS URLs for LinkedIn?

  • 9 January 2024
  • 3 replies
  • 59 views
D

I have an RSS feed from a google alert that lists URLs of interesting posts I want to post to a LinkedIn page..

 

The RSS feed prepends and appends elements to the actual URL of the article found.

Here is an example of the URLs in the RSS feed item link:

https://www.google.com/url?rct=j&sa=t&url=https://uk.news.yahoo.com/sony-drive-electric-car-using-122631827.html&ct=ga&cd=CAIyHDNhNjhjNTg3NzhjZWM2NjI6Y29tOmVuOkdCOlI&usg=AOvVaw3Y112e8T6E2w9ERxzkXL-h

 

I need to remove the prepended data which is this part https://www.google.com/url?rct=j&sa=t&url=

And to remove the appended data which is this part and anything following &ct=ga&cd=

which is a random unique string of letters and numbers &ct=ga&cd=

 

so I want to be left with the bare URL of the post…

which in the above example would be the part

 

https://uk.news.yahoo.com/sony-drive-electric-car-using-122631827.html

 

Then the Zap post that to a new page post on LinkedIn with the Title and Description from the post.

How can I extract the URL in the RSS, tried using regex and format changer but its not working...

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

Troy Tessalone
Userlevel 7
Badge +14

Hi @devsterp 

Try using Formatter > Text > Replace steps in the Zap.

https://zapier.com/apps/formatter/help

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
D

@Troy Tessalone done that in several different attempts, just not posting the data correctly…..

Troy Tessalone
Userlevel 7
Badge +14

@devsterp 

We would need to see detailed screenshots with how your Zap steps are outlined and configured for us to have full context.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions