I have a google sheet and I have cell B1
called Address
which contains:
405 E 42nd St, New York, NY 10017
I would like to embed a google map into my google sheet in cell D5
that looks like this:
Note: I don't need other landmarks, but if they are there it won't bother me.
Research:
I googled it, and came up with zilch. I found code on how to import an image, but that's not the hard part. The hard part is getting the image of the map, or better yet, embedding a live dynamic map that changes when the address on the sheet changes (preferable).
I can use this api to get a static image:
but I don't know how to get it into the sheet.