Google Apps Script: Get Range in Sheets

In this video you will learn four different methods to get a specific range in Sheets with Google Apps Script.

00:00 Intro
00:20 getDataRange() method
2:00 getRange(a1Notation) method
3:25 getRange()
6:01 getRangeByName(name) method

#GoogleAppsScriptGetRange #GoogleSheets #GoogleAppsScript #AppsScript #GoogleWorkspace #saperis #ChanelGreco
-----

saperis - Helping you become a Google Workspace Pro!

[frdata]

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

[furfur]

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

[lholhofox]

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

[janjongste]

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?

[fliich]

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.

[janguita]

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

[vin]

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

[Dziadaaa]

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.

[giuliabera]

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?

[ivanurbina]

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.

[noorimpresiones]

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

[ammarshbeb]

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

[jbkedgn]

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?

[jordan]

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!

[alecallejas]

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!!

[gokhanboyac]

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

[carlstonejunior]

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

[jwalbanker]

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

[HumanityMatters]

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

[Savag]

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