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
Improve this question
3
  • any reason why not get it directly in PNG format?
    – user0
    Jun 9, 2019 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, 2019 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, 2019 at 0:10

1 Answer 1

Reset to default
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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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