### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [March 25, 2022, 2:08am UTC](https://community.glideapps.com/t/bulk-photo-upload/40064/1 "2022-03-25T02:08:04Z")
I understand to upload photo using File Picker or Image Picker.
But at my first, got existing data like 800++ rows with photo. How to upload the photos using google sheet?
To be exact, I have this kind of problem.
For each part number (Column B), had one photo. The photo is in Google Drive. But the first issue is, the photo name is not exactly the same.
Eg : Part number written in column B is 111362 (T) Used S65 but the Photo name in Google Drive is 111362.
Second issue, I have 800++ rows to be uploaded.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 25, 2022, 11:58pm UTC](https://community.glideapps.com/t/bulk-photo-upload/40064/2 "2022-03-25T23:58:02Z")
So you want to bulk upload photos from Google Drive to Glide with existing Google Drive links (do you even have them in the Sheet)? I don’t think there’s an easy way we can do that as of now.
> [@robot Importing data to Glide by use of robot (RPA)](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008):
>
> Challenge 1 In this moment of time it is not possible to import data (or paste chunks of data) into Glide. @Manu.n has shown a way to import a row at a time from Google sheets to Glide tables which is quite handy if you have not to much data to import. But if you have hundreds or thousands of rows this approach is not the way to go.
>
> > **Manu.n's approach - great for a smaller number of rows**
> >
> > \
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [March 27, 2022, 1:35am UTC](https://community.glideapps.com/t/bulk-photo-upload/40064/3 "2022-03-27T01:35:33Z")
Yeah…unless there’s a column that has the exact filename it will be really difficult to create something automated…
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [March 28, 2022, 2:56am UTC](https://community.glideapps.com/t/bulk-photo-upload/40064/4 "2022-03-28T02:56:28Z")
I noticed glide can read image with google drive link. What I thought is only can read with the Glide source.
So, it solved, I am using apps script to extract file name and the link.
and using vlookup with the file name.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 28, 2022, 3:11am UTC](https://community.glideapps.com/t/bulk-photo-upload/40064/5 "2022-03-28T03:11:54Z")
Once again I must reiterate that using Google Drive links to display images in your app will be problematic. I don’t have a good solution for you now to bulk upload those to Glide storage but if it ever becomes available, I would advise you to do it that way.
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [March 28, 2022, 3:30am UTC](https://community.glideapps.com/t/bulk-photo-upload/40064/6 "2022-03-28T03:30:28Z")
Ooo can i know what problem will I faced if i’m using Google Drive links ?
---
### Author:  [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)
#### Post date: [March 28, 2022, 3:33am UTC](https://community.glideapps.com/t/bulk-photo-upload/40064/7 "2022-03-28T03:33:52Z")
> **[Adding images](https://docs.glideapps.com/all/topics/ux/adding-images#external-hosting)**
>
> How to add and host images properly for your app.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [March 29, 2022, 3:34am UTC](https://community.glideapps.com/t/bulk-photo-upload/40064/8 "2022-03-29T03:34:13Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.