Examine the spreadsheet using GAS
It is a script that gets a cell in the specified range and checks how many character strings are entered in the range of that cell. Numbers are not counted: A: A wind and writing A can be monitored for writing.
//Retrieve the current spreadsheet var ss_copyFrom = SpreadsheetApp.getActiveSheet(); //Acquire line A var Avals = ss_copyFrom.getRange("A:A").getValues(); // Get the number of strings (numbers excluded) var Alast = Avals.filter(String).length; //Debug Confirmation in Log Logger.log(Alast);
If you want to get the string itself you should do as follows
//Retrieve the current spreadsheet var ss_copyFrom = SpreadsheetApp.getActiveSheet(); //Acquire line A var Avals = ss_copyFrom.getRange("A:A"); // Get a character string (numbers are excluded) var Alast = Avals.filter(String).length; //Debug Confirmation in Log Logger.log(Alast);