Hey Everyone- Hoping someone else has experienced this and has workaround, or knows how to escalate to Google for a fix.
I use apps script to create a backend Google sheet from a template and then build proposals (PDFs) using images store on the cloud (Cloudinary hosting). This is all automated with the end users never actually opening up the sheet. Been doing this for many years without issues.
Starting a week or so ago, I am intermittently getting errors in some sheets (no commonality) where the image fails to render, instead showing #REF!. When the sheet is opened, you see a message stating "Warning: Some formulas are trying to send and receive data from external parties" and if you click on the IMAGE() field you get an authorization modal stating "You must allow access to fetch data from external URLs for all IMPORTHTML(), IMPORTXML(), IMPORTFEED(), IMPORTDATA(), IMAGE() functions in this spreadsheet"
After authorizing the image again renders, but I've now seen the issue return to previously authorized sheets. This is causing major issues to our service.
Does anyone have ideas for how to programatically authorize a sheet, or somehow update settings to remove the need to do this ad hoc? Thanks so much to anyone who has ideas.
Best,
Peter