0

I have a Google Sheet with a chart built from data in the sheet. I've published the chart, but the URL isn't an image link. I need it to be a direct link to a valid image format (either .jpg or .png). Changing the format to image gave me a PNG image, but the software I'm using requires a file extension in the URL. (like https://drive.google.com/file/link.png)

Example URL:

https://docs.google.com/spreadsheets/d/e/DOC_ID/pubchartoid=678215946&format=image
3
  • any reason why not get it directly in PNG format?
    – user0
    Jun 9 '19 at 23:39
  • I don't want to download and re upload it, I want a direct link that updates when the chart does.
    – Ian Hyzy
    Jun 9 '19 at 23:59
  • well, there is no workaround for this. you are supposed to use the embed code for uploading purposes if you want to keep it interactive.
    – user0
    Jun 10 '19 at 0:10
0

Google Sheets hasn't a built-in feature that returns a link like the one you are looking for. You could use Google Apps Script to export the chart somewhere that is able to serve the files the way that your software requires.

NOTE:

Google Drive used to have a feature to host files and publish them as web sites which worked very similar to what you are looking for but this feature was retired some years ago. There is a "trick" to get a "direct link" to a file but it uses the file id not the file name and extension.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.