GoogleJsonResponseException : Images won't load for all entries

119 views
Skip to first unread message

Bo Gorcesky (The Art Tech Teacher)

unread,
Sep 20, 2023, 10:08:38 PM9/20/23
to NV Autocrat Add-on
Hi everyone,
I am translating a ton of math vocabulary words for the students in my school.
I uploaded screenshots to a google drive folder, and then added the images into my spreadsheet using the extension, File Drop.
I altered the url to make it publically accessible (and made sure the Drive folder is set to the link with anyone can view).
I use the extension often, and this image trick with Autocrat, but I am getting an error message about the shapes when I try to put the images into a Google Slides template with Autocrat.Screenshot 2023-09-20 at 9.40.50 PM.png

I CAN run Autocrat and it will do the first slide by itself.

I delete the text in the Sheet and run Autocrat again, it can do two entries.

I do this a few times but when I try to do six, I get this error message ( see attached)

I am trying to get all of these images into a single Google Slide show.

All images are public and they are about 110KB - 400 KB in size.

I can also delete the sixth row and another slide will work - there is just no rhyme or reason on why sometimes I get the error and sometimes I do not.

Any ideas?

PS - This is what the slideshow looks like now: 

Joseph Schmidt

unread,
Sep 21, 2023, 9:02:00 AM9/21/23
to nv-autocr...@googlegroups.com
Did you convert the URL to bring back a thumbnail of the image?  See the FAQ in the description of the group.

This is a neat project.  

How many total rows do you have?  Autocrat seems to slow down as the number of rows increase when you want a single output file.  You may have to do them in batches and combine them.



--
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/7e3003b8-1c40-456d-a087-fbb9428c0f14n%40googlegroups.com.

Carlos Gil

unread,
Jan 4, 2024, 7:42:33 AM1/4/24
to NV Autocrat Add-on
I'm having a similar issue. I'm batching generations in 5 to 15 rows. It was working perfectly, until i hid some columns, then unhid them and it stopped working. I'm using the chart.googleapis.com thing. 

Any ideas?

Joseph Schmidt

unread,
Jan 4, 2024, 10:29:18 AM1/4/24
to nv-autocr...@googlegroups.com
I don't understand the problem.  What is a chart.googleapis.com ?  

Can you share an example spreadsheet and template?  Make sure they don't contain sensitive information.

I don't think hiding and unhiding columns should make a difference.



Reply all
Reply to author
Forward
0 new messages