How to process incoming data in Google Spreadsheet?

Question

Google Sheets

There is a google spreadsheet.
Using the ifttt service, data from gmail mail is entered into it when a new letter arrives. Then I want to send them to VKontakte via their api (the script for sending VK works)
But I can’t figure out how to read the cell values ​​from the last row.
And still for some reason the trigger on change of the table does not work. Is it supposed to send data? But it sends data only if I change it manually in the table.
until I figured out how to get the last line, here is the code. But I am tormented by the task of how to extract values ​​from the ranges a1: f1 from this line.

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];

var dia = ss.getRange("A1:A").getValues();
var filtr = dia.filter(String).length;

ps: var a=sheet.getRange("A1").getValue();this code is passing value from cell .
how to combine it with the selected filter on the last line where there is data?
ps: I need it for myself) Happy New Year everyone) I’m leaving for the new year, my normal phone is broken, I want letters from the mail to come by SMS .. everything comes, but for now I get the line number by SMS instead of the cell value from the last line and the trigger does not work on table change :D

Answer 1

Look at the sources of FormEmailer .