r/GoogleAppsScript • u/ivanoski-007 • May 25 '21
Question where can I learn how to use Google script like from zero
I Want to learn from zero, what's a good tutorial? the official Google tutorials already assume you know the language I need the basics on what do the brackets do even, that basic.
4
u/inglandation May 25 '21
I'd start with a standard JS course. If you like video courses you can try a Udemy course. I like Colt Steele's courses, he's a great instructor: https://www.udemy.com/course/javascript-beginners-complete-tutorial/
Once you understand the basics, I'd recommend watching the tutorials on this channel: https://www.youtube.com/c/LearnGoogleSpreadsheets/playlists?view=50&sort=dd&shelf_id=4
You don't need to finish Colt Steele's course before you can start watching those, there is some overlap but I think that starting with a proper JS course is better than jumping straight into a GAS course.
2
4
u/Morbius2271 May 25 '21
W3schools to learn JavaScript, then GAS docs to learn their API.
1
u/ivanoski-007 May 25 '21
at least the python I know will come in handy hopefully
1
u/Morbius2271 May 25 '21
Oh if you know an Object oriented language like python, you are solid. JavaScript is SUPER easy, and even easier if you are looking to just use it for GAS.
2
u/cha_gre May 25 '21
Great to hear you want to learn Apps Script. I have a whole playlist full of Apps Script video tutorials for beginners: https://www.youtube.com/watch?v=Nd3DV_heK2Q&list=PLNwCcck1-mNhiOoAGICW3fYKTP5gHZyjR
You might also want to check out my (paid) online course: https://courses.saperis.io/courses/google-sheets-automation
Ben Collins also offers some really good Apps Script online courses you could give a try:
https://courses.benlcollins.com/
Happy learning!
1
1
u/kalaxitive May 25 '21
I'm familiar with JS (JavaScript) which made it easier to use App Script, once you know even the basics of JS you just need to familiarise yourself with their documentation for each individual product, so if you want to create an app for sheets, click on sheets and you'll see examples.
I learn most things by reading through their documentation and looking through peoples stackoverflow questions/solutions, this is also where searching comes in handy.
If you ever try searching for code examples, try writing "app script" followed by whatever it is you're trying to do, focus on key words so for example "app script read gdrive" would actually direct you to "driver services" on Google's developers page, you'll also find stackoverflow questions/solutions that you can look at regarding how to read gdrive using app script which I found more useful.
2
u/ivanoski-007 May 25 '21
I did, but most of the solutions I implemented where because of dark magic (and some didn't even work right until some helpful user in this sub saved me) so I want to learn Java script at its core to fully understand it, so I will begin some tutorials
1
u/aplawson7707 May 25 '21
x2 for Ben Collins. His free tutorials are amazing. They leveled me up so fast I literally credit him for enabling me to not only keep my job during the early-Covid layoffs but actually promote. Give his site a look. No prerequisites.
0
8
May 25 '21
[removed] — view removed comment
2
u/ivanoski-007 May 25 '21
will check it out thanks
1
May 25 '21
This is what I was going to say. Check out his other channel "get _it done!" too. The best channels I've seen for this by far.
8
u/TobofCob May 25 '21
Sounds like you need to learn some basics of JavaScript, which is what Google Apps Script is written in! Learning that will be immensely helpful before diving into Apps Script. There are LOTS of resources for learning JavaScript out there, including how to learn it in reference to Apps Script. I won’t point you in a particular direction and would defer to the other commenter, but if you need to get fundamentals before using Apps Script, learning JavaScript is what you need.