How to save charts created with Google Spreadsheet API

Question

I would like to know how to save charts generated by the Spreadsheet API to Google Drive. I've read the documentation and it doesn't mention anything specific, and I've confirmed how to do it in GAS. If anyone can tell me how to do this, please let me know.

Answer 1

Issue:

There's not direct way to do this on the API.

Possible workarounds include exporting the sheet containing the chart as image or PDF via Drive API's Files: export, or just use Apps Script.

Feature request:

There's a related feature request in Issue Tracker:

• Export Charts as Images

I'd suggest you to star it in order to keep track of it and to help prioritize it.

Related:

• Grabbing a Chart as image via JS script and Google Sheets API?
• Google Sheets API v4 - downloading/saving charts
• Export Google sheet Chart as an image
• API to export sheet that contains only a chart as a PDF or image