Google Apps Script – send mail with map address – part 036.

By Cătălin George Feștilă | 11/08/2021

Open a Spreadsheet and rename the Sheet to test001.
Use the next source code:

function sendMap() {
  //var sheet = SpreadsheetApp.getActiveSheet();
  var sheet = SpreadsheetApp.getActive().getSheetByName('test001')
  var address = sheet.getRange('A1').getValue();
  var map = Maps.newStaticMap().addMarker(address);
  GmailApp.sendEmail('catafest@yahoo.com', 'Map', 'See below.', {attachments:[map]});
}

function sendMap() {

//var sheet = SpreadsheetApp.getActiveSheet();

var sheet = SpreadsheetApp.getActive().getSheetByName('test001')

var address = sheet.getRange('A1').getValue();

var map = Maps.newStaticMap().addMarker(address);

GmailApp.sendEmail('catafest@yahoo.com', 'Map', 'See below.', {attachments:[map]});

}

This will send a mail to my email address with a map from the address in column A1.

Leave a Reply Cancel reply