!.md

Как сделать автоматическую отправку данных из Гугл таблиц на Email? [7gdrXQbME4U] #docs

https://productforums.google.com/forum/#!topic/docs/7gdrXQbME4U

Code.gs

var ID = "xxx";
var EMAIL = "[email protected]";
var RANGEA1 = "Sheet1!A2:F10";

function sendData() {
  var spreadsheet = SpreadsheetApp.openById(ID);
  var data = spreadsheet.getRangeByName(RANGEA1).getValues().datesToString();
  var message = {};
  message.subject = "Данные";
  message.to = EMAIL;
  message.htmlBody = dataToHtmlTable_(data);
  MailApp.sendEmail(message);
}

Array.prototype.datesToString = function(){
  return this.map(function(row){
    return row.map(function(cell){
      return cell && cell.getTime ? Utilities.formatDate(cell, Session.getScriptTimeZone(), "yyyy-MM-dd") : cell;
    });
  });
}

function dataToHtmlTable_(data){
  return JSON.stringify(data, null, "  ")
  .replace(/^\[/g, "<table>")
  .replace(/\]$/g, "</table>")
  .replace(/^\s\s\[$/mg, "<tr>")
  .replace(/^\s\s\],{0,1}$/mg, "</tr>")
  .replace(/^\s{4}"{0,1}(.*?)"{0,1},{0,1}$/mg, "<td>$1</td>");
}