Create ImportRange with Google Apps Script Code in Google Sheets

[@gasparlam4267]

Great tutorial! I have been looking for solution like this for months! My solution is to copy paste the range at the start of a day and write the importrange formula at the bottom of the "old range". So this would import only the new data coming in for today and it is in real time. Please consider using this method and automate it everyday :)

[@gqAlysanne]

Hello thank you for the video it really helps, i'm wondering how would i apply this code if i need to add the copied values at the end of a table

[@KANSALENTERPRISES-b3z]

thanks sir

[@practicalsheets]

Thank you!

[@abdullahquhtani4247]

Excellent and will be great if it is possible to import ONLY new records of the imported range I imported earlier. I hope you got my point 😊

[@DumitruDolinta]

Great tutotrial, thank you! But I have a question. What if I need to import from few sheets and get values only from some of collumns?

[@practicalsheets]

IF you need several Tabs from the same Sheet you will still need one ImportRange per Tab. For the columns you may use CHOOSECOLS. It would be something like this {CHOOSECOLS(IMPORTRANGE(ID;Range1);1;2);CHOOSECOLS(IMPORTRANGE(ID;Range2);2;3)} Regards!

[@jonathantogonon-b7h]

@@practicalsheets can you show video tutorial for this

[@practicalsheets]

@@jonathantogonon-b7h Of course. It goes in my queue Kind Regards

[@mohammadaakib3841]

@practicalsheet I have did same but when I delete some rows from input data then it's gets deleted from importantrange sheet as well, I want once data import from input sheet it should be paste value and if new data entered in input sheet then also added in importrange sheet as values only

[@practicalsheets]

this is a bit more complex, we should update almost day by day and check all rows I'll think about an updated video Kind Regards

[@Uh-e8r]

Great Video. Now, How to "paste" or "import" that range of data to the spesific cell that we want ? Can u help ? Please that would be Like Copy paste using GAS

[@practicalsheets]

Hi! I'm not sure if I understand. In the video I try to do that Kind Regards

[@sanjayabhatta3056]

using this code will it be able to import more that 50,000 rows?

[@MohammadAakib-bz7xw]

Thank you for sharing your knowledge it's an useful video. But I have one problem if some of entries delete from source than it's also getting deleted from IR sheet, values should be there if some entries deleted from source so how to do that? pls reply soon

[@practicalsheets]

It´s much more tricky, because then we wold have to compare row by row and see if it still exists Let me think abut it Kind Regards

[@kritikuz]

Help me sir, Importrange always ref! Internal import error.

[@practicalsheets]

Were you able to solve? Regards!

[@kritikuz]

Yes, I solved with google app script🎉😆

[@kritikuz]

From =Importrange() formulas is not efficient

[@AmanJuyal-p9c]

if we have data from multiple sheets in the same format and I need to compile and append it in a worksheet how can i do it

[@AkhmadGifari]

how fast the loading than importrange or appscript?

[@practicalsheets]

I think ImportRange will work a bit faster Regards!

[@AkhmadGifari]

why you made this tutorial when the formula =importrange is faster than appscript? 😁@@practicalsheets

[@practicalsheets]

It depends in how you define "faster" importrange has 2 advantages: is more practical, and refreshes constantly But it also has disadvantages and limitations. It crashes with large amounts of data, and the updates are "when it wants to". You could program your GAS code to update whenever you´d like it to Regards! @@AkhmadGifari