Google Drive Images are not merging through Autocraft [Google Form -> Google Drive Link -> Google Sheet -> Autocrat -> PDF]

[Spencer Bohlander]

Okay, so I have spent the better part of 5 hours looking up every video and FAQ forum I can find without any avail. I understand that the standard google provided url (https://drive.google.com/open?id=) for a google drive stored image is the problem but I have not encountered multiple variations of what people state they modify the url to in order to make it work but none seem to work. This list is below. Every option I've utilized below seems to have been phased out by 6 months so I'm assuming google has made changes here and now all are currently out of date. 

Can someone please provide the current URL modifier they use to take images collected via google forms and convert them into a PDF utilizing autocrat?

https://doc.google.com/open?id=

https://drive.google.com/uc?export=view&id=

https://doc.google.com/uc?export=view&id=

https://drive.google.com/thumbnail?sz=500&id=

https://doc.google.com/thumbnail?sz=500&id=

^Have tried multiple thumbnail sizes to see if it was an image size issue^

https://doc.google.com/uc?d=

https://drive.google.com/uc?d=

I'm sure you will need more context to diagnose my issue(s) so please let me know what y'all need. Thanks in advance!!!!

[Joseph Schmidt]

See the FAQ at Images.

I'm not aware of this processing failing.  

See arrayformula

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/216ef3a8-8183-4154-9712-3173c7e5a18bn%40googlegroups.com.

[GoogleGoof]

Hi Joe,

Thanks for the response. 

I've double/triple checked the FAQ. Have manually copy and pasted the thumbnail url modification into the google sheet without any avail. The rest of my merges (all standard merges) work flawlessly  through ,y process and I am setting the autocrat settings appropriately for an image. 

My test image is 291x404 pixels and 51.3kb w/ a 24 bit depth resolution of 96dpi. None of which I would think are abnormal.

As I mentioned, when I run the job, everything works as expected. My merge cells are updated appropriately and state a successful merge without any errors. My pdf file is generated and placed in the specified folder. I have the job triggers turned off for testing. 

Any additional advice would be appreciated. 

[GoogleGoof]

The only abnormal thing I've noticed is my <<TAG>> that I specify for my image does not appear on the PDF outputs. When I had broken tags, they were placed in the PDF as a text so I'm assuming that the program is recognizing the tag and attempting to place something in the location. 

[GoogleGoof]

Also, in my google slide template I am using as the catch-all for the autocrat merge, I can manually insert my image by linking the modified thumbnail URL so I am fairly positive I have the URL specified from the FAQ correct.

[Joseph Schmidt]

Are you changing the type of merge tag in the 3rd step on the right side where there is the list of merge tags?

Is the folder containing the images set to anyone can view?

What is in the status column of the rows?  The status column is the 4th column added by Autocrat.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/2446e931-7cf5-4903-99d6-6e8b62c355b4n%40googlegroups.com.

[GoogleGoof]

For some reason my reply isn't showing up so I'm responding here again. If you see multiples of this response then apologies. Also, thanks for helping troubleshoot this with me!

Yes, on the 3rd step I am changing the tag type to image on the left then selecting the column containing my modified url link to the google drive image on the right. For troubleshooting, I changed the tag to point to the original google drive url column my google forms creates and manually adjusted the url as a test.

Yes, I have changed the folder to the proper share settings. I tested this with another account on a different PC to see if I had access via the link.

Below are is a copy of the autocrat output columns. Note I removed the ID.

##########################
https://drive.google.com/file/d/#########################/view?usp=drivesdk
<<Job Number>>

Document successfully created; Document successfully merged; PDF created; Manually run by sbohl...@dixondirectional.com; Timestamp: Apr 8 2022 12:40 AM

-SB

[glua...@gmail.com]

Images are not working inside of a Table on a Slide.