【GAS】Googleフォームの回答をスプレッドシートに書き込む方法

function OnSubmitForm( event_info )
{
    const WRITER                = new AnswerInfoWriter();
    const ITEM_AND_ANSWER_PAIRS = event_info.response.getItemResponses();
    const SPREADSHEET_URL       = 'https://***';
    const SPREADSHEET           = SpreadsheetApp.openByUrl( SPREADSHEET_URL );
    const SHEET                 = SPREADSHEET.getSheets()[ 0 ];

    WRITER.Write( SHEET, ITEM_AND_ANSWER_PAIRS );
}

AnswerInfoWriter = function() 
{
    function _Write( sheet, item_and_answer_pairs ) 
    {
        const LOCK = LockService.getScriptLock();

        if ( !LOCK.tryLock( 60 * 1000 ) ) 
        {
            Logger.log( '【 エラー 】 1分待機してもロックできなかったため、シートへ書き込まずに終了しました。' );
            return;
        }

        _WriteHeader( sheet, item_and_answer_pairs );
        _WriteData  ( sheet, item_and_answer_pairs );
        SpreadsheetApp.flush();

        LOCK.releaseLock();
    }

    function _WriteHeader( sheet, item_and_answer_pairs ) 
    {
        const TITLES = item_and_answer_pairs.map( pair => pair.getItem().getTitle() );
        
        TITLES.forEach( ( title, index ) => 
        {
            const CELL = sheet.getRange( 1, index + 1 );
            CELL.setValue( title );
        } );
    }

    function _WriteData( sheet, item_and_answer_pairs ) 
    {
        const ROW_NUMBER  = sheet.getLastRow() + 1;
        const ANSWERS     = item_and_answer_pairs.map( pair => pair.getResponse() );

        ANSWERS.forEach( ( answer, index ) => 
        { 
            const CELL = sheet.getRange( ROW_NUMBER, index + 1 );
            CELL.setValue( answer );
        } );
    }

    return {
        Write: _Write,
    };
}