In Google sheets, you can insert a clickable image to a cell which links to a function in app script. Can we also insert this clickable image and link it to app script from our server using Google Spreadsheet API? Or Can we call app script from our server?
1 Answers
1
votes
Can we also insert this clickable image and link it to app script from our server using Google Spreadsheet API?
No. You can't even change the color of a cell. The best you can do is change a formula in a cell.
Or Can we call app script from our server?
Yes, use google-apps-script HTML service. I expect you can insert your "clickable image" with google-apps-script as well, but did not check.
