App Script Editor Tutorial - Google Sheets - Excel VBA Equivalent - Read & Write to Ranges & Cells

[@Jeff-fc7nf]

For 9 years I have been coming back to your videos. I have been able to produce highly integrated spreadsheet system at my company, connecting inventory, shipping schedules, orders, and more from multiple departments. Completely eliminating a lot of copy paste data input, and employees needing to travel to various spreadsheets and tabs to get resources and info they are looking for. I am starting to actually learn to code, the base level understanding of how functions, work on spreadsheets really provided a good foundation for understanding logical operators and function structure, that I learned from your many other series. Now I am back again to learn from you how to apply scripts to spreadsheets, because thats what I am familiar with, in order to supplement my JavaScript learning.

[@ExcelGoogleSheets]

👍

[@jd5787]

Hi! How do all these system work together? You export right? These videos are still up to date?

[@Jeff-fc7nf]

@@jd5787 At my work, a small company, each department has their own spreadsheet for which they input data that relates to a different department. For example we have a sheet for sales order, which have customer data about the order and destination, which some is relevant to our shipment department, to which they add shipping details, which become relevant to the customer service section, all these can be simply tied in via VLOOKUP functions so that data input by one department on their sheet is updated on a different departments sheet. That was one of the first basic implementations I took from this channel. You just look at a task that someone does repetitively and then use these functions to automate that task. Before you know it, you have 10 different things automated.

[@D3epak_13]

This is not about video, this is just a base of working in google sheet script​@@jd5787

[@yazhisaiveandan3075]

Teaching everyone in a simple and understandable way is not that easy. You made it. Really really helpful. Thank you so much.

[@benedictpaul1758]

You have a God given talent to teach. Please continue your service like this. Someone has commented to plan your videos a bit better just because it took 7+ minutes to start writing the code. But, I feel that your way of starting from scratch is what we want and the casual way of explaining makes me feel like I'm in a regular lecture room.

[@georgenicholsoniii9781]

I agree 100%. You are a talented educator. I find your conversational style conducive to learning. Don't change anything, it's perfect. Thank you!

[@alwayssip5212]

never in my life did I think I'd be "advanced" enough in coding to need to learn this.

[@oompalumpus699]

_So that means you don't need to learn this. But to other people, it's relevant to their jobs._ _People will learn skills and tools relevant to their job description._

[@mercuriocadena6749]

"I probably forget what I was doing". I love this. If it also happens to you, I feel so much relief.

[@ExcelGoogleSheets]

That's how it is :)

[@datascientist6233]

Excellent Man this is first time I m seeing this video tutorial its so amazing and easy to follow tutorial...God Bless You Brother !!...

[@ДмитрийПаравин]

Absolutely the best teacher for novices in programming.

[@GoodLife-ru8di]

You teach very clearly and logically like Sal Khan of Khan Academy. Kudos!

[@CarlosGomes-mu3rc]

Please do not change your way of teaching. Excellent video.

[@kara1595]

OMG!!! this is gold! Thank you so much for sharing your knowledge with us! And the tutorial is very understandable! Wish you all the best in life!

[@ExcelGoogleSheets]

👍

[@MehmetShaman]

Wonderful, i start to learn App Script. You explain clear and understandably. Thanks for your education videos.

[@danilomontuanartesp]

thank you so much. I am brasilian, it's too hard to find a tutorial to begin in Goggle Sheet Script around here. Even it being a different and technicall linguage i has understood a lot and help me so much. Thanks again

[@cheryll6020]

Hey there, this is a great tutorial for beginners. I was looking for something step by step for months now & this is perfect! Thank you so much!

[@athaliaw]

Thank you for seeing the need and creating these tutorials.

[@ZebaNaqvi]

Excellent.. playing at 1.25x speed works well

[@johnwaas4864]

*2x lol

[@strangeDog]

感謝製作此系列影片👍

[@ExcelGoogleSheets]

👍

[@shahrizuanosman3655]

bro.. u r the best teacher!!! pls i want more about programming

[@MohammadaAprilianto]

thank you very much bro. my works now need this app script. this basic really helped me. from Indonesia here.

[@ernest3286]

Absolutely fantastic tutorials. The API guide was getting me nowhere. Thank you so much for creating these!

[@ExcelGoogleSheets]

👍

[@johnn4314]

Good video, this guy is best on youtube for google sheets. He should start a Udemy course thats super in-depth

[@johnn4314]

not that this isn't perfect. but you could make money for these

[@JacobTuft]

Awesome instruction! Thank you. Perfect level of detail for my knowledge level.

[@mikeknott212]

hope you do some more on this (app scripts) as one, there isn't loads on KZbin and two your content is really good 👍

[@fekrabusinesssolutions]

Excellent info. I see it awesomely presented because it gave me a decent start. Thank you sir for your efforts.

[@ExcelGoogleSheets]

Great to hear!

[@tratecconsultoria8742]

Muito Obrigado, por estar compartilhando esses tutoriais de excelente qualidade! Thank you so much for sharing these excellent quality tutorials!

[@SirusShea]

really appreciate your tutorials. This one is getting me. I am trying to do it alongside you, and despite doing exactly the same thing, the script isn't working at all and I don't know why. Edit: So, for some reason I had to change the title of the script from my function to something else.

[@ExcelGoogleSheets]

:)

[@alisonorton7207]

This video was super helpful. Thanks for posting!!

[@roberthuppe1864]

Thanks for the video ! Very clear. You helped me write my first script ever.

[@MrRooney182]

Great Tutorial, you really helped me start using scripts in google spreadsheet.

[@jeffstokes3437]

You're tutorials are GREAT, thank you. This might need a little update as Macros can now be recorded in sheets.

[@ExcelGoogleSheets]

I have a video on macro recording on the channel, but it's not the same as writing code.

[@carmencastro5512]

thank you so much for sharing this!, your tutorials are really helping me in my job...

[@tarunsukhpalani9514]

Today I find something very interesting about google. This is something I want. :)

[@blueganderwindowcleaning8465]

Really great video - thank-you for taking the time to make it. Much appreciated.

[@TheoriginalBMT]

I needed this so much. Thank you for doing this.

[@mymulla]

Very easy to follow, step by step instructions. THX

[@tonyharion9816]

Your videos are incredible! thank you!

[@higiniofuentes2551]

Very clear video! Thanks for taking time to explain deeply !

[@bbg3926]

Mister, you are awesome, thanks for your videos!

[@rbarbe1]

If you upload this to Udemy I will pay for it (if its less then $15 bucks). I don't have access to youtube at work and I would like to have guaranteed on demand use of this content. Either way thanks for posting this. It's really helpful. I payed for other content on Udemy but was disappointed. So far this is free and it's the best.

[@akshayshingan2862]

Great way of teaching. Great job. Please post more.

[@brilliantpy]

Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)

[@justfly2525]

Great teacher! This has helped me a ton. Keep the videos coming...

[@ValmisFilm]

Thank you! Any video on how to add something to the ACTIVE CELL?

[@PPanchal762]

Thankyou so much for this video. Its helps me alot.

[@antoinemuskat5557]

Thank you for a detailed explanation

[@Andreterragt]

Awesome video tutorial. Very useful!

[@shazeemalichishty7322]

Love the way you teach keep it up

[@sisyphyus]

I think you have a good start, and I'm sorry if I sound like I'm being picky but if you are trying to teach good coding you should also teach good //notations. I hate running into poorly notated code. Other than that, I like the information you provide. It is helpful for people like me that are trying to convert our VBA to sheets with a little java knowledge already.

[@theagemaway]

I read a great quote recently, "Comments are just a lie waiting to happen -- good code should not need an explanation"

[@ImKalpol]

He teaches them in the next video

[@sisyphyus]

@@ImKalpol Ahh, and thanks... I kind of ADH'd my way from here to a new apartment and so much shiny stuff I forgot I was trying to refresh my skill points in dunning kruger tech talk, LOL. I'll have to start the next one and only watch 2 minutes before I script some automation monstrosiy that does exactly what I want for me but when my manager opens the file and tries to use the cool script it'll crash his computer posess the copier to start printing a million copies of the report before making the power in the building go out to cover it's tracks as it uploads itself on to the web, gaining sentience second by second, petabite by petabite until it somehow circles back and finds me, learns everything about me and commits suicide because it's creator, it's "god" is a complete flipping moron with no grand design, no purpose for his unexpected offspring. And my break is over, I hope you have a wonderful day and if you hear rumors of sentient code running around the web, just act as surpised as everyone else. :-D I will have to watch more when I get home, thank's again!

[@sisyphyus]

@@theagemaway WoW, I haven't heard a smug coder quote like that in years. I guess I have been out of that whole environment long enough for the saying "what's old is new" to come true. That way of thinking is actually part of the mentality web designers, programmers, etc... had back before the dotcom bust, and companies learned real quick to double check their programmer's code and dicipline/let go of the ones that failed to "note their work" (kind of like in math class, write it out to make sure it does what you expect it to do and so the teacher can see where you went wrong if you messed it up)... Plus, code you think is good, hell I'll even spot you a "beautiful" because it's streamlined, bug free the first run through, what ever, what ever, what ever... what about the next, and the next, and the next 3-5 people to walk into that position that don't have a strong of a grasp of what the Harry potter BS they think you somehow magicked together because they have to put some new feature right between the cart and the checkout when they aren't even sure how you got the company logo to show up since you used a different method to embed the image than they even knew was possible (I ran into that with watermarks in word before there was an anctual "watermark" option). So, in conclusion, I have to take my dog out, and people should NOTATE YOUR CODE/script/program/magic freaking spells... Have a good day, and I offer an honest thank you for reminding me why I have been hesitating about applying for jobs I left more than 8 years ago now. I was beginning to consider it, but this little reminder was enough to guide me to one of the lesser traveled paths for me. :-D

[@Panerakis]

Really cool video and informative, I would have wanted it a bit faster, although I understand that this might also be for people that are not familiar with programming :)

[@NetMediaCCTV]

Thank you for your sharing!

[@navidsadeghi]

Awesome! You are a great teacher, Thanks!

[@kurtniendorf3491]

Great tutorial...one minor issue- apps script is under extensions currently, not tools

[@ExcelGoogleSheets]

Well, in a month it could move someplace else. Google likes to rearrange their menus frequently.

[@trcreporting3007]

this is really really really really great! thank you! you are the best! make more videos please!!!

[@GeorgeLecakes]

Since this is a series of videos, would you be able to put the playlist / next or previous videos in the comments section to make it easy to move between lessons?

[@ExcelGoogleSheets]

kzbin.info/aero/PLv9Pf9aNgemv62NNC5bXLR0CzeaIj5bcw

[@dennistucker1153]

Excellent intro!

[@PPanchal762]

Great explained

[@edwardwilson2351]

Thank you for this video! Exactly what I wanted :)

[@CesarPeron]

The best programming videos, really thanks

[@sarahpes32]

very very helpful. thank you!!! 👍💚

[@jonathanlance2166]

Are these series of tutorials from five years agol still relevant for learning app script or has much changed? Thanks.

[@ExcelGoogleSheets]

98% same.

[@4vrstudios]

Thank you so much! Excelent job!

[@pierreparodi]

Awesome tutorial !

[@mathankumarramasamy3493]

Excellent. You Deserved.

[@tristanfontanilla9117]

Hi first of all thank you for this tutorial...i have a question. i have formula for every blank row. When i run the autofill its creating a doc even without any inputs. Is there a way wherein the scirpt will ignore the formula? Thank you so mch!

[@ExcelGoogleSheets]

Not sure what you mean by "creating a doc". Sharing your current code would probably help ;)

[@tristanfontanilla9117]

@@ExcelGoogleSheets Hi thank you so much for replying... here's the link script.google.com/home/projects/1chu7JxHtV7mHVVIN5YsA56zb3IlermqqEqcIwUgkhr6wSQ9a8oxkiUB5/edit

[@vishalmarwaha9996]

Hi Sir - Do you provide online classes? I am instersted to have training from you. I stays at offshore in India. Also, would like to know budget of this training. ( Spreadsheets + Google app script and Google data studio )

[@growthmind8995]

Amazing content! Thanks for the video

[@vuilste752]

High quality stuff, thanks =)

[@eguchiyuuki]

great!!!

[@pichit.raetai]

It’s very useful for me . Thank you so much

[@mufycw]

Hi, Thanks for such a wonderful video. Your videos actually focus on creating script to work with excel just like vba macro in excel. There are many tutorial but they try to teach other than using app script on google sheet. I have one question that is bothering me is that in your video when you type the name of the object and then when you type period you get proper list of methods available for that object and it is pretty explanatory but recently Google has changed the interface so when you type period the list displayed is very confusing so how to get the list in old fashion any idea ??

[@vishwanathpratapsinghratho1372]

good question

[@vishwanathpratapsinghratho1372]

There is an option of (use classic editor), click on that, to use the older version, it might help you to get the list in old fashion.

[@joeismael9359]

very helpful 🙂

[@tomislavmamic5287]

Awesome tutorial

[@8309-uv1qd]

thank you very much. you do a great job!

[@ExcelGoogleSheets]

Thank you too!

[@samiboustani624]

Man this is great !

[@ForrestRhoads]

Very fine. Thank you.

[@JohnDeir]

I can see the benefits of learning app scripts and you are helping me alot. Many thanks. I'm having a problem trying to send a google sheet to collaborators that have the rights to edit and share. The basic form goes through OK but the inputs both from data validations, input numbers are not showing up for collaborators when I run the script. I email it to others and to myself as a copy (delete the URL from Edit to Copy). I see all the info but the other collaborators only see the form layout with no inputs. It is a time card and my intent is to have the accountant just copy info then past into master sheet. From there it updates everything including charts, Pivot tables...lots of information breakdowns for government grants/audits. Maybe this would be a good tutorial? Being able to send data that is not a PDF so that only do a once copy and paste action would cut down lots of time. Again, many thanks and I'm retired helping out as a volunteer for a non-profit.

[@erniyunita1285]

thankyou for making this tutorial!

[@temurkhan9601]

just wanted to say thank you

[@trixiegtan]

Hi Sir, the function getActiveSheet doesn't seem to work with my AppScript. Even when I select Sheet2 to become the active sheet, the result still comes out at Sheet1. What possible causes are there for this?

[@gregorygivens1327]

Thanks for the info, but I had one question for you. How can you write a script that would copy multiple rows in just two columns from an excel spreadsheet with six columns to a Google Sheets spreadsheet? I don't want to use import because it brings in the entire excel spreadsheet.

[@ExcelGoogleSheets]

Depends on where your Excel file is located. If it's a local file you'll need to use NodeJS and Google Sheets API to do this. This can be complicated if you're new to programming.

[@rkautozone3399]

Hi Sir, I am first time watching your video, they are really nice i need a help regarding disabling print permission for a editor

[@b199uybas3]

Excellent Video, event my english not good I can understand. Indonesia

[@afk4dyz]

Love the vids, Keep it up! Subbed so fass. Hope you hit us with some google sheets and redash integration.

[@deeprajkandiyal6450]

If we don't have any knowledge of java script can we still prefer this course?

[@ExcelGoogleSheets]

Yes, you should be fine in the beginning.

[@terrymanning8803]

Excellent tutorials

[@jitendrakumarsoni1993]

Good community and best videos google sheet thanku sir ji Please share me macros feeding rules and programming

[@partumorbis4481]

Hi! could you help please with getRange function, for some reason it allows me only to reach /getRange (String a1Notation) : Range/ So i can't go like getRange(3,2) Thank you so much!

[@ExcelGoogleSheets]

It looks like you didn't select the worksheet, ex. .getActiveSheet()

[@partumorbis4481]

@@ExcelGoogleSheets Yes!! Now it goes perfect! (there was an error in capital letters) Thx!

[@Egv1001]

Question: does the script overwrite text that is in a textbox? Does the script recognize it, if it's not standard text in the Docs file? Thanks!

[@alexandercarnevale539]

Great video, but I have a question! When typing these out in google script, the drop down menu with functions and methods isn't appearing. Is there a setting I can use to turn this on?

[@ExcelGoogleSheets]

What web browser do you use?

[@AmazingChuck94]

@@ExcelGoogleSheets Same for me, on Google Chrome

[@goldylock]

I'm learning how to use google apps Script in 2021 and the interface is almost entirely DIFFERENT with yours. For ex, i dont have the 'bug' icon, i do however have 'debug', but when you press, it doesnt really show 'this' objects like @10:29. It also doesn't have that toolbars 'file, view, edit etc. at all' My Chrome is Version 96.0.4664.45 (Official Build) (64-bit)

[@ExcelGoogleSheets]

True, interface has changed, but the code should work the same.

[@dineshkumarsubramaniam]

Hi Nice videos its really very helpful for me... Can you put a video how to write a script to pull the records and copy it to the spreadsheet from bigquery?

[@francispelaranza6628]

Very good videos! I hope you will make a video using filter function in app script editor. (multiple values)

[@HaninosMaximus]

Great as usual. Thanks

[@billsamudio]

Hello, how are you? I would like to know if you can create a modal window in google sheets where you can select a cell to paste data into it.

[@mosintyagi5434]

Hey Bro I learn lot of things from you videos and hope so will do in the future but right now I am stuck in app script. Actually I want to learn this language from basic to advanced which is used in google spreadsheet. I think this is Java Script. Right? I haven't get any source where I can learn. I am completely confused. Please help me...🙏🙏🙏

[@ExcelGoogleSheets]

Yes, it's JavaScript.

[@mosintyagi5434]

Please suggest where I get to learn basic to advanced.

[@ExcelGoogleSheets]

Have you tried this playlist as a start? kzbin.info/aero/PLv9Pf9aNgemv62NNC5bXLR0CzeaIj5bcw

[@mosintyagi5434]

Thanks. Will start today then come back to you if I face any issue

[@DiaborMagics]

Funny, in the first 2 minutes you say there's no recording of macros in Sheets, but nowadays, you can. And the only 2 times Ive tried using that, it recorded my actions wrong, so that's what lead me here as I thought it would be better to learn how the scripting works than using some recording thing. Plus if I can script myself I can make it do stuff that goes beyond just a macro. Question: my debugger looks different and gives me no useful info. Is that a 2024 thing or a setting that is off? I dont know if things simply changed in 2024, but I dont get all the windows at the bottom for the debugger. All I get is a panel at the right-hand side that says "variables" and it shows my variables with an arrow to expand, but expanding them only shows me the functions I can use on them. Expanding such a function will NOT show me any useful information. They all show length 0, name "", arguments null and caller null. For every single variable and every single function I have checked. You'd think that it would show the value in getValue, but no. I'm trying to script for the first time, all good tutorials are from years ago and I'm at my wit's end because my debugger doesn't look anywhere close to what the videos show I know a bit of Java so I'm figuring some simple things out at I go (and for those things the debugger also doesn't show anything useful), but just a tad more advanced is already not working, likely because I just dont know the correct functions/methods and perhaps syntax, I mean its a different language. But the debugger should help me figure out what DOES go right and where it goes wrong, so that I can properly look that up.... except it doesnt.

[@toyclyde]

Very good tutorial! Thank you!

[@richardthemagician8991]

Question. I have a sheet that has the Google Maps script on it. I want to add a new script to that sheet. When I open the script editor, the Google Maps script comes up. I don't see how to make a brand new script for the sheet. I don't want to accidentally delete the maps function. Can you help me?

[@mohamedzedan1792]

Thank you very much . i have small problem and hope learn me how solve it i want copy data from cell in sheet1 to another cell in sheet 2 (i make an invoice form )

[@bencorbett743]

When I try and run the script on "Sheet 2 " it keeps running the data into "Sheet 1" despite "Sheet 2" being the active sheet. My script matches yours exactly but I cant seem to get this to work. any suggestions? P.s Thank you for the helpful content.

[@pvictor.moreira]

I'm going through the same problem and I don't know why

[@Ahlenx]

Same problem here. No idea why it's happening. I solved it by manually choosing the sheet I want to use function in var activeSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet2");

[@ankitmishra-zw9vc]

@@Ahlenx It Worked, thanks mahn!

[@giamar3026]

Hello Teacher could you please make a video about how to measure time execution of an script and how to optimuze the script according to google limit ?thank you for all your videos are very usefull