Extending Google Sheets
출처 : https://developers.google.com/apps-script/guides/sheets
Writing data
To store data, such as a new product name and number to the spreadsheet, add the following code to the end of the script.
function addProduct() {
var sheet = SpreadsheetApp.getActiveSheet();
sheet.appendRow(['Cotton Sweatshirt XL', 'css004']);
}
The above code appends a new row at the bottom of the spreadsheet, with the values specified. If you run this function, you'll see a new row added to the spreadsheet.