# How do I display images from a Google Sheet

**URL:** https://community.thunkable.com/t/how-do-i-display-images-from-a-google-sheet/1674079
**Category:** Questions about Thunkable X
**Tags:** beginner, help, google-sheets
**Created:** [January 15, 2022, 8:54pm UTC](https://community.thunkable.com/t/how-do-i-display-images-from-a-google-sheet/1674079 "2022-01-15T20:54:04Z")
**Posts on this page:** 11
**Page:** 1

<div class="post-metadata">

### Author: ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)
#### Post date: [January 15, 2022, 8:54pm UTC](https://community.thunkable.com/t/how-do-i-display-images-from-a-google-sheet/1674079/1 "2022-01-15T20:54:04Z")

</div>

Hi, I have a Source Google Sheet ( **Airline Code** s) which contains several hundred images in a column called “Logo”. These images are entered as URL’s from my own Google Drive (see below:)

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/d/bd55585e10910fc83c271c2196d962fe0fb7cbc4.png)

I have created the rest of this screen but I would like the **Airline’s Logo (image)** to appear above the found record’s result. I have already searched the Community help forum and have only solutions relating to Airtable or Firebase. The spreadsheet will eventually have over 17,500 entries. Most of them will have a logo (image) against their individual records.

Here is my design screen:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/1/118f3f0a2822ad13eebf42a7cd9f61a267719962.png)

When a result is found and clicked on, the relevant row will display that record’s details but it will not display the image for that row.

Below, is an image of blocks so far:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/c/6c9b54723d684af94b653053891082f3b1447aef.png)

Any help would be greatly appreciated.

Many thanks,

Andos.

---

<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: [January 15, 2022, 9:43pm UTC](https://community.thunkable.com/t/how-do-i-display-images-from-a-google-sheet/1674079/2 "2022-01-15T21:43:34Z")

</div>

You are setting the LogoImage’s Visible property to the url rather than setting its Background Picture property.

 ![Image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/a/8af13f261b947df394c27c3e399fcf315e7be632.jpeg)

---

<div class="post-metadata">

### Author: ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)
#### Post date: [January 15, 2022, 9:45pm UTC](https://community.thunkable.com/t/how-do-i-display-images-from-a-google-sheet/1674079/3 "2022-01-15T21:45:36Z")

</div>

Thanks @tatiang, what needs to be changed as I wish to show the logo image not the background.

Many thanks,

Andos.

---

<div class="post-metadata">

### Author: ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)
#### Post date: [January 15, 2022, 9:52pm UTC](https://community.thunkable.com/t/how-do-i-display-images-from-a-google-sheet/1674079/4 "2022-01-15T21:52:53Z")

</div>

Hi @tatiang, I have just changed the block from “visible” to “picture” and still no image is showing.

I cannot see an option to display the **image of a “URL”** in the blocks.

See below:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/5/d5b702356b2a83dacfc2fa4005be24e6d12326a4.png)

Many thanks,

Andos.

---

<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: [January 15, 2022, 9:54pm UTC](https://community.thunkable.com/t/how-do-i-display-images-from-a-google-sheet/1674079/5 "2022-01-15T21:54:38Z")

</div>

That looks correct. Please assign the value of `get property LOGO of object app variable row data` (the blocks currently attached to the `set LogoImage's Picture to` block) to a Text Input’s text. Then copy and paste what appears and post it here.

What you should see is the full url for the image you wish to display.

---

<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: [January 15, 2022, 9:56pm UTC](https://community.thunkable.com/t/how-do-i-display-images-from-a-google-sheet/1674079/6 "2022-01-15T21:56:12Z")

</div>

You’re going to run into a problem with Google Drive files. Unless they are set to allow **anyone** to see them, they will not be visible from a mobile device or web app. They may work in a browser preview but that’s only because you are signed into your Google account.

When you post the url I mentioned above, I can test it and let you know if I can see the image.

---

<div class="post-metadata">

### Author: ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)
#### Post date: [January 15, 2022, 10:05pm UTC](https://community.thunkable.com/t/how-do-i-display-images-from-a-google-sheet/1674079/7 "2022-01-15T22:05:42Z")

</div>

Hi @tatiang, I am new to this, where do I find the “text input” block?

Thanks,

Andos.

---

<div class="post-metadata">

### Author: ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)
#### Post date: [January 15, 2022, 10:41pm UTC](https://community.thunkable.com/t/how-do-i-display-images-from-a-google-sheet/1674079/8 "2022-01-15T22:41:49Z")

</div>

Hi @tatiang, is this what you mean? I have replaced the pink “Logo” text with a green “AirlCodeSearchInput’s text” block. See below:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/c/ec10e57cf6215fe46f20dbed5a9a0300c8fb9aad.png)

I tried it on “Live Test” using the record “AAA” and all the data of that record appeared but nothing showed from the “LOGO”

This was the result:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/a/fa73037110950eb4ab7af95a83ec8f485ef0daa0.png)

I didn’t receive any URL in the result.

The URL I should have received was:

> **[AAA.bmp](https://drive.google.com/file/d/1JFgtyN4IQpHzq8ghsaIBnza9S6WxNCf3/view?usp=sharing)**
>
> Google Drive file.

The share link for my Source Data Google Sheet (Airline Codes) is:

> **[Airline Codes](https://docs.google.com/spreadsheets/d/1QXJs4PMNfkpcw48cqVIuBj4xWp9_bGPRiKJtlGEMMY0/edit?usp=sharing)**
>
> DECODE
> 
> LOGO,ICAO CODE,OPERATOR,COUNTRY,HEXCODE FROM,HEXCODE TO,CALLSIGN,REMARKS,TEMPLATE
> StringFilter,StringFilter,Hidden,Hidden,Hidden,StringFilter,Hidden,CardsContent
> https://drive.google.com/uc?id=1-...

The link for my project is:

[https://x.thunkable.com/copy/583cc9d3f60a182b463050f8ebece47e](https://x.thunkable.com/copy/583cc9d3f60a182b463050f8ebece47e)

I hope this helps.

Many thanks,

Andos.

---

<div class="post-metadata">

### Author: ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [January 15, 2022, 10:58pm UTC](https://community.thunkable.com/t/how-do-i-display-images-from-a-google-sheet/1674079/9 "2022-01-15T22:58:55Z")

</div>

For the images to show in the app, they need to be shared or they need to reside in a shared folder.

Currently, your image files are not shared. I just clicked on one of them and got the screen to request access which means it will not display in the app.

---

<div class="post-metadata">

### Author: ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)
#### Post date: [January 15, 2022, 11:01pm UTC](https://community.thunkable.com/t/how-do-i-display-images-from-a-google-sheet/1674079/10 "2022-01-15T23:01:14Z")

</div>

Thanks @muneer, I shall share the folder.

Many thanks,

Andos.

---

<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: [April 15, 2022, 11:01pm UTC](https://community.thunkable.com/t/how-do-i-display-images-from-a-google-sheet/1674079/11 "2022-04-15T23:01:43Z")

</div>

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