JPG or PNG Images on Google Drive WILL NOT work with URL Image OR IMAGE Field in Table Chart

Looker Q&A Looker Studio
1

Permissions are set to “Anyone with the Link” can view, URL’s all take me directly to the correct image… I can follow a YouTube explainer video step by step and it simply shows a blank field with no image no matter what I do. HELP SOMEONE PLEASE

2

The URL of images on Google Drive needs to be transformed in order for you to be able to use them in Looker Studio.

Here’s more info: https://support.google.com/looker-studio/thread/63682913/images-uploaded-during-form-submission-is-not-showing-in-google-data-studio-table?hl=en

1 Like
3

You just saved my project thank you so much

4

Hi,
The link is not working, do you have more details? i have the same issue :disappointed_face:

5

The image URL has to be transformed from a URL like this
https://drive.google.com/file/d/XXXXXXX
to something like this
https://drive.google.com/uc?export=view&id=XXXXXXX

1 Like
6

HI Laura,

I’m a newbie at this and have not figured out how to work with the image that is being uploaded through google forms and stored automatically on google drive. I tried various options, however, i am unable to get the image to work. Can you share how I can get this done? Much appreciated!

7

I opted to transform the URL within Sheets using this formula (where column L has the image file from the Form); then brought that field into my data source with type of Image (which is an option for URL fields).

={ARRAYFORMULA((IF(ISBLANK($A2:$A), “” ,ARRAYFORMULA(Concat(“https://drive.google.com/uc?export=view&id=”, REGEXEXTRACT($L$2:$L,“id=([^&]+)”))))))}

You could also do a similar transformation within a calculated field in Looker Studio, but I am not the one to ask about writing a regex :rofl:

8

Thanks. Let me give it a shot! This is exasperating. Considering this is all within google itself!