we can use Api in spreadsheet https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet
For example if we put this code to scripts it will send e-mail with last row.... function sendMail() { //test_mail-название листа в таблице var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Ответы на форму (1)'); var values = sheet.getDataRange().getValues(); // проверяем наличие хотя бы одной записи if (values.length < 2) return; var lastValueIndex = values.length - 1; var myEmail = 'deliv...@restoran-shinok.ru'; // Ваш e-mail var subject = 'НОВЫЙ ЗАКАЗ!!!'; //values[lastValueIndex][1]-это столбик из таблицы, нужно будет менять циферку. Так же проверил, можно ли несколько в одно объяденить, можно var mes=values[lastValueIndex][6]+("\n")+values[lastValueIndex][2]+("\n")+ values[lastValueIndex][3]+("\n")+values[lastValueIndex][4]+("\n")+values[ lastValueIndex][5]+("\n")+values[lastValueIndex][7]; // отправляем письмо MailApp.sendEmail(myEmail, subject,mes); } понедельник, 25 апреля 2016 г., 9:31:50 UTC+3 пользователь Jed Carty написал: > That is all the test button does right now. The interesting things I have > done are more on the back end where it uses web workers so it doesn't hurt > the performance of the wiki when you are loading things from slow sites. > Since things are mostly hidden from normal use now I posted in the dev > group and will probably not post here until I have something more > interesting to show for it. > -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to tiddlywiki+unsubscr...@googlegroups.com. To post to this group, send email to tiddlywiki@googlegroups.com. Visit this group at https://groups.google.com/group/tiddlywiki. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/d2abcf0d-5e65-4f46-958a-50e93332e628%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.