åæãšæ³šæäºé
ãã®èšäºã§ã¯ä»¥äžãåæãšããŠããŸãã
- Google ã¢ã«ãŠã³ããæã£ãŠãã
ãã®èšäºã®ãŽãŒã«
Google Apps Script ã䜿ã£ãŠæå®ããã¡ãŒã«ã¢ãã¬ã¹ã«ã¡ãŒã«éä¿¡ããããšãšäžæžãäœæãããããšããã®èšäºã®ãŽãŒã«ãšãªããŸãã
ã¡ãŒã«éä¿¡æã«ã¯ä»¥äžã®å
容ãæå®ããŠéä¿¡ããŸãã
- éä¿¡å ã®ã¡ãŒã«ã¢ãã¬ã¹
- ä»¶å
- æ¬æ
- æ·»ä»ãã¡ã€ã«
- éä¿¡å ã¡ãŒã«ã¢ãã¬ã¹
- éä¿¡è å
ãŸããã¡ãŒã«éä¿¡ã¯ããã«ä»¥äžã®ããã«äžæžãã®äœæã®ã¿ãè¡ããŸãã

Google Apps Script ã§ã¡ãŒã«éä¿¡åŠçãå®è£ ãã
ããã§ã¯ãæ°ããã¹ãã¬ããã·ãŒããäœæãããããã以äžã®ããã« Google Apps Script ãéããŸãã
ã·ãŒãå
ã¯ç©ºã®ç¶æ
ã§å€§äžå€«ã§ãã

以äžã®ããã« Google Apps Script ã®ãšãã£ã¿ãéããŸãã

ããã§ãsendEmail
ãšããã¡ãŒã«éä¿¡åŠççšã®é¢æ°ãäœæããmyFunction
ãšããããã©ã«ãã®é¢æ°ãä¿®æ£ããŠã³ãŒã.gs
ã®å
容ã以äžã®ããã«ããŸãã
function myFunction() {
const target = {
to: 'xxxxxxx@example.com',
name: 'æ ªåŒäŒç€Ÿãã',
};
sendEmail(target);
}
// targetã¯ä»¥äžãšãã
// { to: éä¿¡å
ã¡ãŒã«ã¢ãã¬ã¹ãname: éä¿¡å
äŒç€Ÿå }
//
function sendEmail(target) {
// éä¿¡å
ã¡ãŒã«ã¢ãã¬ã¹ã®æå®ïŒããã©ã«ãã ãšGoogle Apps Scriptå®è¡è
ã®ã¡ãŒã«ã¢ãã¬ã¹ïŒ
// Google Apps Scriptå®è¡è
ãæã€ã¡ãŒã«ã¢ãã¬ã¹ããããã¯ãã®ãšã€ãªã¢ã¹ã®ã¿æå®å¯èœ
const _from = 'hello@example.com';
const _subject = 'åŒç€Ÿæ°ãµãŒãã¹ã®ã玹ä»';
const _senderName = 'æ ªåŒäŒç€ŸRitaiz';
// ã¡ãŒã«çšã®ãã³ãã¬ãŒããã¡ã€ã«èªã¿èŸŒã¿ïŒåŸè¿°ïŒ
let template = HtmlService.createTemplateFromFile('emailTemplate');
// ãã³ãã¬ãŒãemailTemplateã«clientãšããŠtargetãæž¡ã
template.client = target;
// ããã¹ãã¡ãŒã«ç𿬿
// åä¿¡åŽãHTML圢åŒã®ã¡ãŒã«ã«å¯Ÿå¿ããŠããªãå Žåçš
const _textMessage = 'ãæ
åœè
æ§ \n åŒç€Ÿæ°ãµãŒãã¹ã®ã玹ä»ã§ãã';
// clientãåã蟌ãã ç¶æ
ã®ãã³ãã¬ãŒããmessageã«æ ŒçŽãã
let _htmlMessage = template.evaluate().getContent();
const _options = {
htmlBody: _htmlMessage,
name: _senderName,
from: _from,
};
// ã¡ãŒã«éä¿¡
GmailApp.sendEmail(target.to, _subject, _textMessage, _options);
// äžæžãäœæ
// GmailApp.createDraft(target.to, _subject,_textMessage,_options);
}
äžèšã§myFunction
ãå®è¡ãããšãsendEmail
颿°ãå®è¡ãããŠãtarget
å
ã®to
ã«æå®ããã¡ãŒã«ã¢ãã¬ã¹ã«ã¡ãŒã«ãéä¿¡ãããŸãã
äžèšã®ã³ã¡ã³ããèŠããšããããçè§£ã§ããããšæããŸããã¡ãŒã«ã®æ¬æãšããŠãHTML 圢åŒã®ã¡ãŒã«ãéä¿¡ããããã«ãemailTemplate.html
ãšãããã¡ã€ã«ãäœæãããããå©çšããŠããŸãããã®emailTemplate.html
ã«ã€ããŠåŸè¿°ããŸãã
ã¢ã¯ã»ã¹æš©ãèš±å¯ãã
åããŠã¡ãŒã«éä¿¡åŠçãå®è¡ãããšã以äžã®ããã«ãæ¿èªãå¿
èŠã§ãããšãããã€ã¢ãã°ã衚瀺ãããŸããããã§æš©éã確èª
ãã¯ãªãã¯ããŸãã

æš©éã確èª
ãã¯ãªãã¯ãããšä»¥äžã®ããã« Google ã¢ã«ãŠã³ãã®éžæãã§ããã®ã§ãã¡ãŒã«éä¿¡ã«å©çšããã¢ã«ãŠã³ããéžæããŸãã

æåŸã«ä»¥äžã®ããã« Gmail ãžã®ã¢ã¯ã»ã¹èš±å¯ã確èªãããã®ã§èš±å¯
ãã¯ãªãã¯ããŸãã

ããã§ä»¥éã¯ç¢ºèªãããã«ã¡ãŒã«éä¿¡åŠçãå®è¡ã§ããããã«ãªããŸãããªããåŸè¿°ãã Google Drive å ã®ãã¡ã€ã«ãæ·»ä»ãããªã©ãGmail 以å€ã« Google Drive ã®ã¢ã¯ã»ã¹ãå¿ èŠãªå Žåãªã©ãæªèš±å¯ã®ã¢ã¯ã»ã¹ãå¿ èŠã«ãªãå Žåã¯ãã®éœåºŠç¢ºèªãããŸãããåãæé ã§èš±å¯ããããšãã§ããŸãã
ãã³ãã¬ãŒããã¡ã€ã«ãäœæãã
HTML 圢åŒã®ã¡ãŒã«ãéä¿¡ããããã«ãã³ãŒã.gs
ãšåãéå±€ã«emailTemplate.html
ãäœæããŸãã
以äžã®ããã«ããïŒããã¿ã³ãã¯ãªãã¯ããŠHTML
ãã¯ãªãã¯ããŸãã

ããã§ã¯ãã¡ã€ã«åãemailTemplate
ãšããŸãã

ãã¡ã€ã«åå ¥ååŸã« Enter ãæŒããšã以äžã®ããã«ãã¡ã€ã«ãäœæãããŸãã

emailTemplate
ã®äžèº«ã以äžã®ããã«ããŸããã¡ãŒã«æ¬æã¯é©åœãªãã®ã§ãã
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body style="font-size: 10px;">
<p><?= client.name ?> </br>ãæ
åœè
æ§</p>
<p>çªç¶ã®ãé£çµ¡å€±ç€ŒããããŸãã</br>
åŒç€Ÿæ°ãµãŒãã¹ã«ã€ããŠã玹ä»ããããé£çµ¡å·®ãäžããŸããã
</p>
</body>
</html>
äžèšã§ïŒã€ãã€ã³ããšãªãã®ãã<?= client.name ?>
ã®éšåã§ããããã¯ããã®emailTemplate
ã®åŒã³åºãå
ã§ããã³ãŒã.gs
ã®sendEmail
颿°å
ã§ä»¥äžã®ããã«ããŠemailTemplate
ã«client
ãšãã倿°åã§ããŒã¿ãæž¡ããŠããŸãã
// targetã¯ä»¥äžãšãã
// { to: éä¿¡å
ã¡ãŒã«ã¢ãã¬ã¹ãname: éä¿¡å
äŒç€Ÿå }
//
function sendEmail(target) {
//... çç¥ ...//
// ã¡ãŒã«çšã®ãã³ãã¬ãŒããã¡ã€ã«èªã¿èŸŒã¿ïŒåŸè¿°ïŒ
let template = HtmlService.createTemplateFromFile('emailTemplate');
// ãã³ãã¬ãŒãemailTemplateã«clientãšããŠtargetãæž¡ã
template.client = target;
//... çç¥ ...//
}
äžèšã®ããã«ããããšã§client
ãšãã倿°ãemailTemplate
å
ã§å©çšããããšãã§ããŸãã
<?= client.name ?>
ãšããããšã§ãclient
ã®äžã®name
ãšããããããã£ãåŒã³åºããŠããŸãããŸããclient
ã«ã¯ãã®ä»ã®ããããã£ãå«ããããšãã§ããããããã³ãã¬ãŒããã¡ã€ã«ã«åã蟌ã¿ããæ
å ±ãããã°ãclient
ã«å«ããŠããããšã§äœ¿çšã§ããŸãã
ã¡ãŒã«éä¿¡ã¯ããäžæžããäœæãã
ãã§ã«åè¿°ããã³ãŒãã«å«ããŠããŸãããã¡ãŒã«éä¿¡ã§ã¯ãªãäžæžããäœæããå Žåã¯ãGmailApp.sendEmail
ã®ä»£ããã«GmailApp.createDraft
ãå©çšããã ãã§ OK ã§ãã
// ã¡ãŒã«éä¿¡
// GmailApp.sendEmail(target.to, _subject, _textMessage, _options);
// äžæžãäœæ
GmailApp.createDraft(target.to, _subject, _textMessage, _options);
ãã¡ã€ã«ãæ·»ä»ãã
以äžã®ããã«options
ã®attachments
ã«æ·»ä»ãã¡ã€ã«ãæå®ããããšã§ã¡ãŒã«ã« Google Drive å
ã«ãããã¡ã€ã«ãæ·»ä»ããããšãã§ããŸãã
//æ·»ä»ããããã¡ã€ã«ã®IDãæå®ïŒãã¡ã€ã«ã®IDååŸæ¹æ³ã¯åŸè¿°ïŒ
let attachmentId = '1sqKN9CA188l-slkIQ0wQQ-9dU5duk2IS';
let attachment = DriveApp.getFileById(attachmentId);
const _options = {
htmlBody: _htmlMessage,
name: _senderName,
from: _from,
attachments: [attachment],
};
options
ã®attachments
ã¯é
åã§æž¡ããããã以äžã®ããã«ããã°è€æ°ã®ãã¡ã€ã«ãæ·»ä»ããããšãã§ããŸãã
//æ·»ä»ããããã¡ã€ã«ã®IDãæå®ïŒãã¡ã€ã«ã®IDååŸæ¹æ³ã¯åŸè¿°ïŒ
let attachmentId = '1sqKN9CA188l-slkIQ0wQQ-9dU5duk2IS';
let attachment = DriveApp.getFileById(attachmentId);
let attachmentId2 = '1RWaAA1l9XUaKWQuMkbv6_CKSX8xNVYP9';
let attachment2 = DriveApp.getFileById(attachmentId2);
const _options = {
htmlBody: _htmlMessage,
name: _senderName,
from: _from,
attachments: [attachment, attachment2],
};
Google Drive å ã®ãã¡ã€ã«ã® ID ãååŸãã
Google Drive å ã«ãããã¡ã€ã«ã® ID ã¯ã以äžã®ããã«ããŠãŸãå ±æçšã®ãªã³ã¯ãã³ããŒããŸãã

ã³ããŒãããªã³ã¯ã確èªãããšä»¥äžã®ããã«ãªã£ãŠããã1sqKN9CA188l-slkIQ0wQQ-9dU5duk2IS
ã®ãããªéšåããã¡ã€ã«ã® ID ã«ãªããŸãã
https://drive.google.com/file/d/1sqKN9CA188l-slkIQ0wQQ-9dU5duk2IS/view?usp=drive_link
ãŸãšã
Google Apps Script ã䜿çšããããšã§ Gmail ã®ã¡ãŒã«éä¿¡ãäžæžãäœæãè¡ãããšãã§ããŸããæ·»ä»ãã¡ã€ã«ã®éä¿¡ãå¯èœã§ãã