Unanswered

Find URL within an email and paste it to a sheet

(0) Share

Report

Posted on by julis

136

I'm trying to build a flow that extracts some data from an email and inserts it into a Google Sheet (has to be Google unfortunately).

My main question is, can I somehow parse out a specific URL from the email body html? The emails are automated emails from an outside system, but the link I need is always in a button with a specific text. I think I'll be able to fund the URL itself from the HTML, but I'm not sure what actions would be best.

Do I need one of the data operation actions? Or something else completely?

My second, less important question: can I somehow cut out parts of the subject line before inserting it into the sheet? This is less pressing, because, if push comes to shove, I can use functions within the sheet to solve this.

Thank you in advance!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

julis 136 on at

Like (0)

Report

hey Alex,

what do you mean by provide more information? I can't really copy the email details, but it's always a button with a specific text, and I need the link you get by clicking the button:
My only idea is converting the HTML to text and then somehow splitting it? I don't know if that would even work.

If possible, I'd really like to solve it without any extra cost.

Was this reply helpful? Yes No
AlexEncodian 4,409 Moderator on at

Like (0)

Report

@julis

The more information comment was related to the subject line string manipulation. You can manipulate strings / cut things out / extract substrings / split etc in Power Automate. How you do it will depend on the structure of your string

Was this reply helpful? Yes No
julis 136 on at

Like (0)

Report

Hi Alex,

The strings are something like: "Hello XY, item name is ready for processing"
I need to extract both "XY" and "item name".

Was this reply helpful? Yes No