gas + trello + slackのイメージ

main.js

let trello = new Trello(trello_key, trello_access_token);

//get each cards
let boards = trello.getLists(boardID);
var talk = "現在のプロジェクトステータスです\n";
var storyPoints = [new Date()];

boards.forEach(function (board) {
    var cards = trello.getCards(board.id);
    var points = trello.mergeStoryPoint(cards);
    talk += board.name+"のストーリーポイントは"+points+"です。\n";
    storyPoints.push(points);
});

//post to slack
postMessage(slackChannelID,talk);

//write spreadsheets
var lastRow =  sheet.getLastRow()+1
storyPoints.push(storyPoints[1]+storyPoints[2]-storyPoints[3]);
sheet.appendRow(storyPoints);