• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

How to retrieve links from a newsletter

Hi,

I'd like to retrieve all links/URL from a newsletter and save them to a Google Sheet. The input is the newsletter RSS feed and the expected output is a list of links/URL, possibly with title, saved to a Google Sheet. Every time a new issue is published, the spreadsheet gets updated.

So far, I've tried the RSS by Pabbly, but the newsletter feed only gives you the link to the issue. I don't know how to send the HTML content of each issue to Pabbly.

I've also tried the Email parser, but:
a) the links in the actual email are encoded by the newsletter provider, so it's a no-go for me: I only get very similar URLs with meaningless names.
b) using the Text Formatter / Extract URLs gives me lots of garbage (Extract URLs also extract CSS and useless HTML code, not only URLs).

Now I'm stuck.

Can you point me to the right direction?

Thanks in advance.

MC
 
P

Pabblymember11

Guest
Hey @marcocevoli

To extract the needed data using a specific regex that is available online, try the "Text Formatter by Pabbly: Extract Pattern" action step.

You simply need to pass the regex in the Pattern fields and pass the content from where you want to extract the data.

1667468155652.png
 
Top