Google Apps Script: Get Range in Sheets 

Exactly what I've been searching for. Comprehensive and clearly explained. You saved me a lot of time. Thank you so much

I am new to Google App Script. Your tutorials are very well structurated and worked best for me. Thank you for that.

ty love

Thank you very much for the video!! Very good and clear explanation! Keep'em coming!! ☺

Thank you for this. Is there a way we can get multiple ranges in app script say A1:A5 and C1 to C5 ?

Gracias por tener un ingles tan claro. Lo entendí perfectamente. Y has sido muy didactica. Muy amable. Gracias!

Thank you, for the help !

Thank you very much for the video .. what about blanks and formulas ?

Thank you for the clear video. You really know how to teach! How would you use getRange when the first two parameters should be the row and column of the currentActiveCell followed up bij numRows and numColumns?

Excelente, saludos desde Chile

best video tutorial ever! please, createTextFinder tool for some videos in the future 🙏

Please make a video for getting data from the rows which have true values..

Thanks for this tutorial. Very clear and concise. I was wondering is there a way to getRange() with a parameter you set in your function or by getting the current row or current cell? I'm having a hard time conceptualizing it this way.

Great explanation, I have a question: what if for example I want to store a cell value as a variable; Sheet1 Cell B2 value Is stored as "Sales". What method should I apply? Thank you!!

Great..👍👍

Hi, thank you for this video. I also need to get a hyperlink that is added on some part of the text in cells. I guess I need to use getActiveSpreadsheet function but I don't know how to do it.

Excellent teacher with excellent lessons) Please, can you tell me why google script logger shows ranges in different ways? For example, in the video when you used a1Notation, all results appeared in one row (not in different rows for better presenting information as other examples). I have the same problem: when I use getRange() with all 4 parameters (4, 14, 1, 23) , console.log() show me 23 rows :)) How could I solve this problem?

I love your tutorial. Question: Is there a way to set the column size of a google sheet by using javascript? I have been looking but could not find one. I want to use javascript, not the manual method. The google sheet I created is by javascript (where I got most of the methods from you, thank you); I want to add the capability of sizing a range of columns. Greatly appreciated.

Very interesting! I'm trying to get a variable range in a coulmn, so I think i need to get the range to lastRow of that Column. Is it possibile without a loop?

Hello, can we export a certain range field as example a1:f15 jpeg.

could u plz make a video on how to get active user using app script. I have seen that if the user is not the owner then getActiveuser() function is not working desirably

Hi how do i enable permissions. I went into the .json file and added the oauthScopes but it did not work

Hi I can't see the option Script editor in google Sheets, how to fix that?

is it possible to get ranges starting from the class Range? or do you always have to start from the class Sheet?

Is there a way to get fixed selected cells from all sheets (except master sheet) to a master sheet? For eg, If I have a sheet for each day of a month and I want to compile data from all sheets to a master sheet

Great video! I just have one question about getNameByRange. When I try to use it, the log says its not a function but it shows the pop up dialog box when I input an argument. I then tried getNamedRange(Name) but it says that the input of a string is wrong. All I'm trying to do is get the length index of a column through script. Any help would be greatly appreciated!

Those examples didn't work form me. I need the lastrow from lastcolumn. But lastcolumn don't have all the rows with values. So the last column have less values than the other columns. I can't find the right method for this issue. But I will find it! ;o)

My google sheets in tools, don't show Script editor. Why?

Assume that c column has email_list , How to send in e-mail body the selected data A1:B7

Is it possible instead of A1:B3. You instead use a cell with A1:B3

Hello, This line of code uses the id entered manually in the script let copyFile = DriveApp.getFileById('1GhpGpHM......').makeCopy(), copyID = copyFile.getId(), copyDoc = DocumentApp.openById(copyID), How could I use the ID that can be found manually written in the google spreadsheet, so that if I change it from the spreadsheet, it will also change automatically in the script. I have a list of IDs associated with some templates. I used : var ID_template = ss.getRangeByName('ID_template').getValue; and then let copyFile = DriveApp.getFileById(ID_template).makeCopy(), copyID = copyFile.getId(), copyDoc = DocumentApp.openById(copyID), but without any result. Can something be done about this?

var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName('Thông tin liên hệ (Câu trả lời)'); var emailTo = sheet.getRange(sheet.getLastRow(), 3).getValue(); I don't khow why there is an error "Cannot read property 'getRange' of null"(Sorry, i'm new)