Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save noblejasper/3a3dcf90da637be06e460c25a00b513d to your computer and use it in GitHub Desktop.
Save noblejasper/3a3dcf90da637be06e460c25a00b513d to your computer and use it in GitHub Desktop.
Gmailの添付CSVファイルをスプレッドシートに自動で入れたい
var ss = SpreadsheetApp.openById("{スプレッドシートのID}");
var sh = ss.setActiveSheet(getTargetSheet(ss.getSheets(), "{シートの名前}"));
function import() {
// 最新mailからCSVを取得
var csv = getNewestCSVFromGmailAttachment();
// シートをまっさらに
sh.clear();
// シートに書き込み
sh.getRange(1, 1, csv.length, csv[0].length).setValues(csv);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment