/TypeScript/Google sheets automatic update rook

Google sheets automatic update rook

function storeFollowers(){
    var sheet = SpreadsheetApp.getActiveSheet();
    var datarange = sheet.getDataRange();
    var numRows = datarange.getNumRows();
    var numColumns = datarange.getNumColumns();
    var nextColumn = numColumns + 1;
    sheet.getRange(1, nextColumn).setValue(new Date());
    for (var i=2; i <= numRows; i++){
      var numLikes = sheet.getRange(i, 3).getValue();
      sheet.getRange(i, numColumns + 1).setValue(numLikes);
    }
}

Source: computerworld.com

Similar codes

0 vote247 views1 answer
Typescript globalThis
TypeScript
-1 vote248 views2 answers
Cannot find name 'HttpHeaders'
TypeScript
6 votes243 views2 answers
Typescript random boolean
TypeScript
2 votes257 views1 answer
Typescript initialize map inline
TypeScript
0 vote280 views1 answer
How to register a static assets folder spring boot
TypeScript
1 vote263 views1 answer
How to check if its a character in r
TypeScript
0 vote270 views1 answer
How to combine pdf documents C#
TypeScript
3 votes258 views3 answers
Cannot find module 'typescript' angular 9
TypeScript
3 votes246 views1 answer
How to make s3 bucet objects publicj
TypeScript
1 vote291 views1 answer
'mat-label' is not a known element:
TypeScript