I want to upload an image to existing Google spreadsheets through Google's API. However, I a) haven#t been able to figure out how nor b) if there's even a more or less "easy" way of doing it.
Among others, I looked e.g. at: Insert image into Google Sheets cell using Google Sheets API or R script to insert images into Google Sheets
Also looking at ?googlesheets::gs4_formula indicate that adding images is generally possible. However, it looks like this can only be done for web images.
Is there any way to upload images from a) disk or b) plotted objects within R to an existing google sheet through R?
More specifically:
- Is there a dedicated APi endpoint or would be the existing ones do the trick?
- Is it possible to define a file path instead of a web path in the IMAGE function of Gsheets?