# How to get images from a spreadsheet and put them in the screen?

**URL:** https://community.thunkable.com/t/how-to-get-images-from-a-spreadsheet-and-put-them-in-the-screen/2639270
**Category:** Questions about Thunkable X
**Tags:** beginner
**Created:** [October 11, 2023, 5:22pm UTC](https://community.thunkable.com/t/how-to-get-images-from-a-spreadsheet-and-put-them-in-the-screen/2639270 "2023-10-11T17:22:11Z")
**Posts on this page:** 11
**Page:** 1

<div class="post-metadata">

### Author: ![pg5036870](https://avatars.discourse-cdn.com/v4/letter/p/46a35a/32.png) [@pg5036870](https://community.thunkable.com/u/pg5036870)
#### Post date: [October 11, 2023, 5:22pm UTC](https://community.thunkable.com/t/how-to-get-images-from-a-spreadsheet-and-put-them-in-the-screen/2639270/1 "2023-10-11T17:22:11Z")

</div>

Hello,

I have a spreadsheet with 3 columns: name, image and rule. I have a fold with images in the drive and I copy each image’s link for the correspondente row in spreadsheet.

On thunkable screen, I have two labels: one for name and another for rule and an image. In the blocks, I get the information from spreadsheet and put them in the screen in their respective places.

The label with name and rule are working correctly, but the image doesn’t work, no image appears in the screen.

I’ll attach the blocks print so you can understand.

Hope you can help me.

 ![387525113_328250786462827_4478296514129729456_n](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/8/18fb68c188d4241f313d8ff9986257f6d0e45f50.jpeg)

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [October 11, 2023, 7:14pm UTC](https://community.thunkable.com/t/how-to-get-images-from-a-spreadsheet-and-put-them-in-the-screen/2639270/2 "2023-10-11T19:14:34Z")

</div>

1. Set a Text Input’s text to the `get row object` block for the “Foto” property.
2. Copy the result from the Text Input field.
3. Open an **Incognito** window in Chrome or another browser.
4. Paste the result and press return.

Are you able to see the image in the browser when you do that? If not, then you need to fix the image url permissions.

Are these Google Drive images or are they stored on your hard drive? It would also be helpful if you can post the image url from the spreadsheet so we can check it.

---

<div class="post-metadata">

### Author: ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [October 11, 2023, 7:34pm UTC](https://community.thunkable.com/t/how-to-get-images-from-a-spreadsheet-and-put-them-in-the-screen/2639270/3 "2023-10-11T19:34:18Z")

</div>

Hello @pg5036870 👋  
The images need to be saved as URLs on your Google sheet.  
Could you please try it?

---

<div class="post-metadata">

### Author: ![pg5036870](https://avatars.discourse-cdn.com/v4/letter/p/46a35a/32.png) [@pg5036870](https://community.thunkable.com/u/pg5036870)
#### Post date: [October 11, 2023, 8:10pm UTC](https://community.thunkable.com/t/how-to-get-images-from-a-spreadsheet-and-put-them-in-the-screen/2639270/4 "2023-10-11T20:10:37Z")

</div>

I opened the url’s link from images that are on spreadsheet on an incognito window and I was able to see the picture that I want to appear on thunkable’s screen.

The pictures are saved on Google Drive and the pictures’ links are from there.

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [October 11, 2023, 9:34pm UTC](https://community.thunkable.com/t/how-to-get-images-from-a-spreadsheet-and-put-them-in-the-screen/2639270/5 "2023-10-11T21:34:22Z")

</div>

I would think that they would work with the get row object as long as your property name exactly matches the column name (“Foto” with no spaces).

Can you post one of your urls?

---

<div class="post-metadata">

### Author: ![pg5036870](https://avatars.discourse-cdn.com/v4/letter/p/46a35a/32.png) [@pg5036870](https://community.thunkable.com/u/pg5036870)
#### Post date: [October 12, 2023, 11:06am UTC](https://community.thunkable.com/t/how-to-get-images-from-a-spreadsheet-and-put-them-in-the-screen/2639270/6 "2023-10-12T11:06:50Z")

</div>

The urls that I use in image columns are from a spreadsheet in Google Drive.

Here is a url from the spreadsheet: [2 de paus.png - Google Drive](https://drive.google.com/file/d/14KkofspiCojxTBk44ukiy6CQa2y5FJzq/view?usp=drive_link)

---

<div class="post-metadata">

### Author: ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [October 12, 2023, 11:54am UTC](https://community.thunkable.com/t/how-to-get-images-from-a-spreadsheet-and-put-them-in-the-screen/2639270/7 "2023-10-12T11:54:45Z")

</div>

Hey @pg5036870 👋  
You need the URLs that end in a file extension such as PNG, JPG, GIF, SVG, etc.  
Try to use Cloudinary instead of Google Drive.

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [October 12, 2023, 4:44pm UTC](https://community.thunkable.com/t/how-to-get-images-from-a-spreadsheet-and-put-them-in-the-screen/2639270/8 "2023-10-12T16:44:13Z")

</div>

Yep. @pg5036870 The urls you’re using are a Google Drive handler for images. They aren’t actually direct links to the images themselves.

---

<div class="post-metadata">

### Author: ![pg5036870](https://avatars.discourse-cdn.com/v4/letter/p/46a35a/32.png) [@pg5036870](https://community.thunkable.com/u/pg5036870)
#### Post date: [October 12, 2023, 5:05pm UTC](https://community.thunkable.com/t/how-to-get-images-from-a-spreadsheet-and-put-them-in-the-screen/2639270/9 "2023-10-12T17:05:10Z")

</div>

I tried with URL from original website, but it did not work on thunkable.

I used this URL: [2 de copas.png (538×689) (ufscar.br)](http://livresaber.sead.ufscar.br:8080/jspui/bitstream/123456789/1195/7/2%20de%20copas.png)

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [October 12, 2023, 8:18pm UTC](https://community.thunkable.com/t/how-to-get-images-from-a-spreadsheet-and-put-them-in-the-screen/2639270/10 "2023-10-12T20:18:44Z")

</div>

If you try to assign that to an Image component in the design tab in Thunkable, it doesn’t show anything. You need a url that works when manually assigned to an Image component.

Maybe that one fails because it has two spaces in the url?

I would recommend trying to host the images in Cloudinary as @ioannis suggested.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)
#### Post date: [January 10, 2024, 8:19pm UTC](https://community.thunkable.com/t/how-to-get-images-from-a-spreadsheet-and-put-them-in-the-screen/2639270/11 "2024-01-10T20:19:00Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
