google-apps-script - 获取当前的 Google 表格网址

Question

我想邮寄当前的 google 表格 URL，例如https://docs.google.com/spreadsheets/d/19sig7bVj6m247Gxap92Bc7-eb5TAMn4NQng9k_Zsqrk/edit#gid=0. 我的代码Code.gs如下所示。

var TO_ADDRESS = "[e-mail]";
var sendEmailTo = (typeof TO_ADDRESS !== "undefined") ? TO_ADDRESS : mailData.formGoogleSendEmail;
if (sendEmailTo) {
      MailApp.sendEmail({
        to: String(sendEmailTo),
        subject: "Contact form submitted",
        htmlBody: SpreadsheetApp.getActiveSpreadsheet()  //this is not working
      });
    }

如何获取当前的 google sheet URL？

标签： google-apps-scriptgoogle-sheets

Answer 1

var url = SpreadsheetApp.getActiveSpreadsheet().getUrl()

if (sendEmailTo) {
      MailApp.sendEmail({
        to: String(sendEmailTo),
        subject: "Contact form submitted",
        htmlBody: url
      });
    }