Search code examples
javascriptgoogle-apps-scriptgoogle-sheetstwittergoogle-sheets-formula

How to fetch twitter profile picture URL from the profile link?

How can I fetch profile picture URL from the profile link of a Twitter account in Google Sheets?

For example, enter image description here

I will put profile link manually in column A and I want profile picture URL generated in the next cell.

Thank you in advance.

I checked all the existing questions and answers but no one has explained how to do this effectively using Google Sheets.

Solution

  • You can use this API self made service from this guys:

    https://ssbytes.com/api/twitterdp.php?q=fractefactos

    You only need to change the q parameter.