# Uploading multiple images Google Sheet Chart at once **URL:** \ **Category:** Ask for Help\ **Created:** [April 5, 2021, 10:17pm UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174 "2021-04-05T22:17:53Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Eric\_Ruiz\_Molero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_ruiz_molero/32/15371_2.png) [@Eric\_Ruiz\_Molero](https://community.glideapps.com/u/Eric_Ruiz_Molero)\ **Post date:** [April 5, 2021, 10:17pm UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/1 "2021-04-05T22:17:53Z")
Hello again Glide Community, At this time I am doing an advanced-charts Glide app. I’m constructing the charts automatically with VBA in Excel and then I send them into Google Sheet. Finally I download each .SVG image and upload them one by one in Glide. Is there any chance to make quicker this last step? As Glide does not allow to upload multiple images I think there could be a way to upload the images on a external program to obtain each URL and then paste them on the Glide connected Google Sheet. Another way is to connect Cloudinary but I think you have to have a website to obtain the URL. Can anyone help me with this? Thank you in advance! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 5, 2021, 11:33pm UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/2 "2021-04-05T23:33:04Z")
Hope this would help you, regarding Cloudinary. It does require a website to have the multiple images upload function, but at least it’s an idea for your case. > [@Upload multiple images to Cloudinary](http://community.glideapps.com/t/upload-multiple-images-to-cloudinary/13524/): > > Intro I thought I was going to publish my first app in the Template store but external sources like Cloudinary integration are not allowed in a template. So after hours spend you will instead see the app here. Upload multiple images to Cloudinary Try out version: URL: [https://multiupload.glideapp.io/](https://multiupload.glideapp.io/) The app is using my personal Cloudinary account - so please keep uploads in the app low - and use your own Cloudinary account if you are going to do exploration of cloudinary Backg… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 6, 2021, 12:54am UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/3 "2021-04-06T00:54:44Z")
> [@Eric\_Ruiz\_Molero](#): > > I’m constructing the charts automatically with VBA in Excel and then I send them into Google Sheet. Finally I download each .SVG image and upload them one by one in Glide. That seems quite cumbersome. Have you considered generating the charts dynamically in Glide using [quickchart.io](http://quickchart.io)? ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [April 6, 2021, 1:21am UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/4 "2021-04-06T01:21:40Z")
Hola Eric What data source are you using to create your charts in Excel? Is it an external source (MS SQL Server, ODBC) or you create/write it manually in your Excel file? Saludos ---
**Author:** ![Eric\_Ruiz\_Molero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_ruiz_molero/32/15371_2.png) [@Eric\_Ruiz\_Molero](https://community.glideapps.com/u/Eric_Ruiz_Molero)\ **Post date:** [April 7, 2021, 11:00am UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/5 "2021-04-07T11:00:49Z")
Yes, thank you @ThinhDinh that post I had already seen it and It’s useful but it makes me have a website for it. And the uploading it’s quite slow. I need to have another solution. ---
**Author:** ![Eric\_Ruiz\_Molero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_ruiz_molero/32/15371_2.png) [@Eric\_Ruiz\_Molero](https://community.glideapps.com/u/Eric_Ruiz_Molero)\ **Post date:** [April 7, 2021, 11:01am UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/6 "2021-04-07T11:01:55Z")
I am using the Spanish Goberment database which is on PC Axis. I export it to Excel and then I have a codified button that creates the graphs automatically with Visual Basic. ---
**Author:** ![Eric\_Ruiz\_Molero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_ruiz_molero/32/15371_2.png) [@Eric\_Ruiz\_Molero](https://community.glideapps.com/u/Eric_Ruiz_Molero)\ **Post date:** [April 7, 2021, 11:03am UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/7 "2021-04-07T11:03:47Z")
haha yes, but it took me an afternoon to program the Visual Basic code. It’s not hard. [Quickchart.io](http://Quickchart.io) I don’t think it could do the same and my code. As I have different graphs in the same excel sheet, and my code detects when the data starts and ends on each graph. ---
**Author:** ![Eric\_Ruiz\_Molero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_ruiz_molero/32/15371_2.png) [@Eric\_Ruiz\_Molero](https://community.glideapps.com/u/Eric_Ruiz_Molero)\ **Post date:** [April 7, 2021, 11:06am UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/8 "2021-04-07T11:06:21Z")
I have tried the Google Sheet Adds “Mass Uploader” but Glide does not detect an image inside a cell, it must me an URL. It could be a go to do a Webflow Integromat UploadCare to Google Sheet project, to be a quick and reliable programme and have it all automated. By now I will do it by hand but I will automate it in a near future. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 7, 2021, 11:08am UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/9 "2021-04-07T11:08:46Z")
> [@Eric\_Ruiz\_Molero](#): > > I don’t think it could do the same and my code. As I have different graphs in the same excel sheet, and my code detects when the data starts and end on each graph. You might be surprised at what can be done with Glide computed columns, quickchart, and a little imagination. Have a browse through the following topic for some inspiration… > [@heart\_eyes Quickchart.io: the Cloudinary of Charts —on the fly charts!](https://community.glideapps.com/t/quickchart-io-the-cloudinary-of-charts-on-the-fly-charts/15946): > > GAME CHANGER! Stumbled upon this site today—a way to create on the fly charts using data from your Glide tables. Images render instantly and you can select one of 14 different charts, customize colors, styles etc all through URL parameters! The video below shows my first attempt to create a chart from scratch and implement it in Glide. Took me less than 5 minutes. End result: ---
**Author:** ![Eric\_Ruiz\_Molero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_ruiz_molero/32/15371_2.png) [@Eric\_Ruiz\_Molero](https://community.glideapps.com/u/Eric_Ruiz_Molero)\ **Post date:** [April 7, 2021, 11:20am UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/10 "2021-04-07T11:20:10Z")
Yes, that’s cool I already seen it. You have an image type chart and you insert data there. But in my case I have multiple excels like this: ![FireShot Capture 039 - Libro1 (Recuperado).xlsm - Hojas de cálculo de Google - docs.google.com](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c11246dd99dcf4db3dd101d23a9bd029eff4050c.png) As you can seen the chart data is separated in the Doc. And the result in VBA Excel code is this: ![Sensible data](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6f49b37442e0fadf343a853e79e1577c67a37a6b.png) It’s a XLColumScattered to 100% with the data inside each bar. Are you sure I can achieve this on QuickChart? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 7, 2021, 11:30am UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/11 "2021-04-07T11:30:00Z")
XLColumScattered? Can you provide a reference to that chart type? (Google doesn’t seem to know about it) ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [April 7, 2021, 12:39pm UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/12 "2021-04-07T12:39:15Z")
Hola de nuevo, Does your Spain Government database come from “Instituto Nacional de Estadística” (INE)? If so, they have an API JSON service which will make your life easier and eliminate some manual steps that you are doing: [Productos y Servicios / Datos abiertos / API JSON / Inicio](https://www.ine.es/dyngs/DataLab/en/manual.html?cid=45) In this way, you can consult INE’s data from GS directly at any time, create your own queries and have data on the cloud to be read/used with other web services like [Quickchart.io](http://Quickchart.io), Glide, Integromat, etc. But again, I don’t know if you are working with INE’s database yet! Feliz día! ---
**Author:** ![Eric\_Ruiz\_Molero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_ruiz_molero/32/15371_2.png) [@Eric\_Ruiz\_Molero](https://community.glideapps.com/u/Eric_Ruiz_Molero)\ **Post date:** [April 7, 2021, 3:35pm UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/13 "2021-04-07T15:35:54Z")
Sorry, the name is: xl Column Stacked 100. I beleive GS has that type of chart. ---
**Author:** ![Eric\_Ruiz\_Molero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_ruiz_molero/32/15371_2.png) [@Eric\_Ruiz\_Molero](https://community.glideapps.com/u/Eric_Ruiz_Molero)\ **Post date:** [April 7, 2021, 3:37pm UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/14 "2021-04-07T15:37:11Z")
No , it’s from another organism. Their database is hosted on PC Axis database and they don’t have any API JSON. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 7, 2021, 3:45pm UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/15 "2021-04-07T15:45:53Z")
> [@Eric\_Ruiz\_Molero](#): > > Sorry, the name is: xl Column Stacked 100. I beleive GS has that type of chart. Okay, or by another name… a 100% Stacked Bar Chart, yes? That’s certainly possible with a combination of Glide + quickchart. In fact, I posted an example demonstrating creating a Stacked Bar chart a while back… > [@heart\_eyes Quickchart.io: the Cloudinary of Charts —on the fly charts!](https://community.glideapps.com/t/quickchart-io-the-cloudinary-of-charts-on-the-fly-charts/15946/124): > > I used a Construct URL column the other day to do a fairly complex stacked bar chart with quickchart. I’m outside at the moment, but can post an example a little later. The extra math required to make a 100% Stacked Bar should be reasonably straight forward with Glide computed columns. Note that the only reason that I’m encouraging you down this path is that it will potentially save you a few manual steps, and your charts will appear instantly in the app. ---
**Author:** ![Eric\_Ruiz\_Molero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_ruiz_molero/32/15371_2.png) [@Eric\_Ruiz\_Molero](https://community.glideapps.com/u/Eric_Ruiz_Molero)\ **Post date:** [April 8, 2021, 8:11am UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/16 "2021-04-08T08:11:00Z")
Thank you @Darren_Murphy It’s great to know that! But I have to figure out how to transform the data. Quickchart is a go, but I don’t see clearly how to order the data to be in the data array. Normally, I have this type of data: ![Sin título](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/cc97777103ad5097df62eb98f696d8215f958770.png) As you can see each A,B,C,D is a chart. And I don’t see clearly how I could order this data vertically to be dynamic and easy to edit and transform. As Glide works only in colums I find it difficult to figure out. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 8, 2021, 10:20am UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/17 "2021-04-08T10:20:34Z")
Yeah, you’d probably need to flip that 90 degrees, and have a row for each year, then include a column that identifies the chart so you can use that as a filter. ---
**Author:** ![Eric\_Ruiz\_Molero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_ruiz_molero/32/15371_2.png) [@Eric\_Ruiz\_Molero](https://community.glideapps.com/u/Eric_Ruiz_Molero)\ **Post date:** [April 26, 2021, 5:19pm UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/18 "2021-04-26T17:19:26Z")
For anyone interested I have solved it with Drive and Google Sheet Automation with [Automate.io](http://Automate.io). On Drive you can upload multiple images at once so if you say to [Automate.io](http://Automate.io) to extract de URL of each uploading and place it on the Google Sheet of your Glide Apps the problem is solved 🙂 ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/uploading-multiple-images-google-sheet-chart-at-once/25174/19 "2024-01-17T16:52:28Z")