[Apps-Script] - Is there any way to render[insert] the Html/SVG in the Google Sheets that will be interactive and refreshable instead of an image?

[Qaiser Javed]

Hi All,

Need your help, please suggest what could be the solution.

Question:

We have created a visualization library that provides a bunch of custom charts. 

We provided all of our charts as an add-on for Google Sheets. The add-on helps users to create charts/visualizations on their data in the Google sheets environment in custom dialog only. 

When Chart renders in Google Sheets, the Google sheet app script API always provides us option as image format to add into the Sheet which is not interactive and refreshable. 

Is there any way to render[insert] the Html/SVG in the Google Sheets that will be interactive and refreshable instead of an image?

Thanks,

Qaiser

[Clark Lind]

I don't think so, not with the Sheets API at least. If you want to insert an interactive chart, you can try to use the visualization API instead. Good luck! (it isn't very friendly...)

[Stephen Barker]

You may want to look into the HTML service https://developers.google.com/apps-script/guides/html