Home > Software design >  Script Google Sheets to generate Google Maps picture and paste it into a cell
Script Google Sheets to generate Google Maps picture and paste it into a cell

Time:05-01

I tried to take a code and adapt it to my needs but without success as I am new in script.

This code allows to generate a google map with markers on several addresses and then to send it by email. In the original code, it was necessary to indicate the places or the addresses. I would like the addresses to be retrieved from different cells of the tab. In my code, the cells in question are between quotation marks and begin with the letter K. Then I would like the map to be inserted in the merged cells E15:M37 or simply E15 of the tab instead of receiving it by email.

I have also indicated the name of the tab in the code but I would prefer that the onOpen() function only runs in the active tab.

My Sheets:

https://docs.google.com/spreadsheets/d/1eZUlQK3-4WZmhQAIw5BTLsKkbTUheCTsdKEhdG0k87E/edit#gid=1047347094

My code:

function onOpen() {
  SpreadsheetApp.getUi().createMenu('⇩ M E N U ⇩')
    .addItem('           
  • Related