Merge images uploaded from Google Forms to Google Sheets and merged to Google Slides with Autocrat

[@questtech2698]

You sir, is a genius. My suffering is over. Thank you so so so much.

[@ivantwohig]

i wish i found this 2 days ago! you saved my life.

[@ShivakumarHallur]

Thank you so much

[@kasvinimuniandy4178]

I REALLY NEEDED THIS!! THANK YOU SO MUCH!!

[@kruprem]

your trick is incridible , thank you so much

[@fajarwitamawijaya4646]

thanks a lot for sharing this

[@TNTMRDA]

I Got Error like this what to do?
GoogleJsonResponseException: API call to slides.presentations.batchUpdate failed with error: Invalid requests[7].replaceAllShapesWithImage: There was a problem retrieving the image. The provided image should be publicly accessible, within size limit, and in supported formats.

[@faizelpk9646]

Me also any solution

[@cancerdelpulmon1790]

THANK YOU SO MUCH

[@mnajibm2317]

you save my work bro

[@raw3380]

Nice video but I need a way to do this fully automatic, is there any way to change that line automatically?

[@rullyoctaviano1493]

Hi, i follow your step changing google drive link to google docs, the link can be opened but after the Autocrat process some of the photos show up and the others not and if i repeat the process, the other photos will show up and others not, it's random. What should i do?

[@i2iverboy]

Check the format of your photos.

[@rullyoctaviano1493]

The format is'nt the problem because if i manually insert image with the same link, the image will show. So confuse man 😅

[@i2iverboy]

@@rullyoctaviano1493 Google changes their codes so often, it really confusing. The best way is to play around it.

[@rullyoctaviano1493]

@@i2iverboy is the image size matters?

[@raw3380]

​@@rullyoctaviano1493It matters, if the image is too big it won't show up I just realized it

[@davenalual]

Find: drive.google.com/open?
Replace: drive.google.com/thumbnail?sz=w500&
Finollow ko lng po yung instructions sa autocrat, and ginamit ko po tong method na pinakita nyo po kasi mas madali. Salamat!

[@manasvkarlekar]

Cant we use placeholders and create tags for them?

[@robmertens8208]

Thanks for this video. This is what I'm looking for but for my form it doesn't work. I don't know what I'm doing wrong.

[@i2iverboy]

t's because Google spreadsheet had a problem for awhile. It should be working now.

[@wanmunirahbintiwannorhaimi9658]

how to create a new link for it to be recognisable to replace by the one given?

[@ricardobenhurportela3476]

Make a video showing the creation of the Google presentation file. Please.

[@cso-joycemesias8801]

Bakit po kaya ito ang error failed with error: Invalid requests[1].replaceAllShapesWithImage: There was a problem retrieving the image. The provided image should be publicly accessible, within size limit, and in supported formats.

[@ayadgabbar3086]

thanks a lot . I use autocrat , google forms merging with google documents not sheets and i want to put a photo in the doc.

[@EdgarLopez-sf4su]

Here's a gift for all of u guys
In other column try =arrayformula(SUBSTITUTE(T2:T[for the original image column],"drive.google.com/open","doc.google.com/uc",1))
:D

[@manasvkarlekar]

Cool

[@southbridgeforestHOA]

If my form images are in column E then I should enter this in?=arrayformula(SUBSTITUTE(E2:E,"drive.google.com/open","doc.google.com/uc",1))

[@naadisak]

hi all
help me pls ,, images missing after generated
thx u all

[@kamalayub1128]

thank you for sharing. i tried but mine still do not show any picture, just blanks. im not sure what im doing wrong. the steps seem easy enough.

[@rullyoctaviano1493]

Hi, do you find any solution for this?

[@ricardogarcia8297]

I changed all the link start part but it doesn´t work :( and there is a way to do it so you don´t have to do this manual change?

[@southbridgeforestHOA]

did you ever figgure this out to do it auto?

[@sujitpal4004]

can you make it from start to finish complete tutorial. how to we make it.

[@TanvirAhmed101]

It does not work keeps saying invalid image URL and it needs to be public

[@southbridgeforestHOA]

images must be in public folder

[@raulbezerra1929]

Not working anymore :/

[@bumpersmith]

very confusing explanation