Get data from url

Hi Gliders,

I have a url from a NFT website, from which i want to pull data from. Can someone help me how can i do so? example URL :

i wants to be able to pull the image, avatar number, avatar attributes.

Unless they have an API, you can’t really do this using computed columns.

If you’re using Google Sheets, you may find some luck with IMPORTXML as long as you can extract the right xpath: IMPORTXML - Docs Editors Help

However if you constantly need to update this then IMPORTXML might not scale very well.


Hi Thinh,

thank for the reply. i was wondering if there was a way to show the image from the url, like when i paste it in discord or whatsapp, it comes up with an image

You would have to extract the image from the URL first using the methods I mentioned above before being able to display it in Glide, assuming you’re using something like a card list to display the URL and its associated info.

but i still need API?

Try IMPORTXML first, or maybe a JS snippet that loads the URL’s HTML and find the img tags. Just an idea, I’m not sure the JS snippet will work due to CORS problems.

unfortunately i started with glide sheets. is there a way to add google sheets now?

i have another option. i am able to get data like the below. Is there a way for me to split them in to my labeled text boxes :slight_smile: I have coloums label with the attribute name (eg: hair style)

user will copy paste data into one text box, and then glide needs to auto fill my columns accordingly.

Background White
Hair Style Short Messy
Hair Color Black
Facial Hair Goatee
Top Tan Blazer with Off-White Shirt and Tan Tie
Bottom Khaki Slacks
Footwear Redbrown Leather Workboot with Brown Sole
Glasses Black Books
Accessories Black Smartphone

I’m not sure what you need here. If you can add some screenshots we might be able to help.

  1. User will copy data from the website like shown below:

  2. Paste in box shown below:

  3. I need to use glide to split the game into the correct boxes:

Sounds like you can split the text and use calculated columns to get each field separately, but you still need users to press a button to load them to the right fields as shown in your second screenshot.

This is also assuming the data follows the perfect format for every single URL, which I assume might not be the case.

users will copy and paste date from the external website.

can you let me know which calculated columns i need to use ?

Originally I was thinking you can use a new line character to split it, but you also have “titles” like Matrix Avatar or Attributes in there, and you might not know in advance how many attributes are there to split the correct way.

At the end of the day, if you have to ask users to do that I think it’s bad UX. We don’t have a good way to do this now.

1 Like

Hi Thinh,

this is dara will copy paste, see below:

Background White
Hair Style Short Pixie
Hair Color Black
Facial Hair
Top Gray Oxford with Buttons
Bottom Gray Slacks
Footwear Black Suede Chelseas with Brown Sole

How can i split this text. What is the symbol i need to type into split text, to split for every new line

Just use a CRLF (carriage return line feed) - ie. the enter key

Hi Darren,

I managed to split the pasted text into a array using split text. How do now remove the ‘titles’ eg: Background, hair style , hair color etc?


If you are confident that the order of the elements will always be the same, then you should be able to use one of the Array Plugins to remove the elements that you don’t need.

I’d suggest maybe the Array Slice plugin.


Hey Darren,

Do you have any idea how i can generate a link preview, example: when i paste a url on discord or whatsapp, it shows a image thumbnail in the chat without having to click it

How will you “paste” it in the app though, I mean which component for the entry and which component to “show” that URL? It will probably not be possible anyway, but I just want to know more about what you’re trying to do.

The app is used to check the rarity of the NFT. users will copy their NFT url and paste it into the app and they should be able to see a preview of it, similar when you paste into FB or discord : sample below :