一、Google apps script

https://www.google.com/script/start

function doPost() {
    var url = 'Google Sheet Url'
    var name = 'issue'
    var SpreadSheet = SpreadsheetApp.openByUrl(url);
    var SheetName = SpreadSheet.getSheetByName(name);
    var SheetNumber = SpreadSheet.getSheetValues(2,1,1,1)
    var SheetItems = SpreadSheet.getSheetValues(2,2,1,1)
    var SheetStatus = SpreadSheet.getSheetValues(2,4,1,1)
    UrlFetchApp.fetch('<https://notify-api.line.me/api/notify>', {
        'headers': {
           'Authorization': 'Bearer ' + '權杖'
        },
        'method': 'post',
        'payload': {
            'message': '測試訊息！'
        }
    });
}

Google Sheet

ISSUES

1. Import type：Filter
2. choose form your avaliable Jira filters：Resolved recently

FIELDS

1. Key, Summarym Priority, Status, Resolved

如何發佈

一、更新Google Sheet

二、至Google Apps Script按執行

註：只會發送行2(第一行issue)，所以發完一次就可以刪掉第一行issue，再繼續執行發送。