0

I am using an IFTTT recipe which populates Google Sheets cells with a hyperlink formula like this one:

=HYPERLINK("http://twitter.com/guardian/status/941765632642691073", "link")

The result in the Google Sheet are cells with the hyperlink, pointing to tweet URLs, like the one below:

| link |

Is there a way to extract ONLY the URL from the hyperlink into another cell using a formula or a combination of formulas without the use of macro code? The desired result is the following:

| link | http://twitter.com/guardian/status/941765632642691073 |

5
  • 3
    Possible duplicate of Extract the link text and URL from a hyperlinked cell Commented Jan 13, 2018 at 22:21
  • The problem is that the IFTTT recipe delivers a hyperlink. I have hundreds of hyperlinks that i need to extract the URL and using macros seem to burden the server so much that it is not viable. The best would be to find a way to extract the URL using sheet formula only Commented Jan 14, 2018 at 11:09
  • 1
    There is no built-in function that does that. Have you considered to use another IFTT recipe? Commented Jan 15, 2018 at 0:58
  • I ended up reconstructing the URL using the REGEXMATCH inside a copy recipe I made in IFTTT. I guess the main obstacle is the limited API handlers offered by IFTTT to begin with. Zapier offers greater API access but it costs. Commented Jan 17, 2018 at 6:31
  • post that as answer, please. Commented Jan 17, 2018 at 15:33

1 Answer 1

1

I found a solution... I ended up reconstructing the URL using the REGEXMATCH formula inside a copy recipe I made in IFTTT. That throws the formula with the raw data directly into the Google Sheet cell and the process to extract the URL is happening on the fly. The main obstacle is the limited API handlers offered by IFTTT to begin with. I found that zapier offers greater API access, especially when comes to Twitter, but it costs.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.