Google Apps Script Tutorial for Beginners
If you’re looking to automate a task in Google Sheets, Google Docs, Gmail, etc. then you can do so be using Google Apps Script. In this Google Apps Script Tutorial for beginners I’ll show you how to automate the formatting of a Google Sheets document.
0:00 Intro to this Google Apps Script
0:49 What is Google Apps Script?
3:27 Explanation of our demo scenario
4:00 What are algorithms in programming?
4:52 What are variables in programming?
5:43 Follow along tutorial begins
12:45 What are objects in programming?
15:00 What is dot notation in programming?
16:18 Where to find the official Google Apps Script Documentation (developers.google.com/apps-sc...)
17:50 Finish the last step of the tutorial
20:10 Fixing the SyntaxError
21:00 Run automation script to format Google Sheet
#GoogleAppsScriptForBeginners #GoogleSheetsAutomation #GoogleAppsScript #Coding #GoogleWorkspace
-----
Want to learn how to be more productive with Google Workspace? 🤩
bit.ly/productivity-for-creat...
saperis - Helping you become a Google Workspace Pro!
Sign up to our KZread channel for more Google Workspace, Gmail, Google Docs, Google Drive, etc. videos: / @saperis
saperis website: saperis.io/
saperis Linkedin: / saperis
saperis Twitter: / saperis_io
Пікірлер: 770
If you enjoyed this video, you might also like this one: kzread.info/dash/bejne/qmesvLqDncWWZbg.html
@justiceinkoom2983
Жыл бұрын
Please can you make a video on HOW TO SHOW THE USER INPUTS IN THE NEXT SECTION OF A GOOGLE FORM.
@justiceinkoom2983
Жыл бұрын
To throw more light on what I'm asking for: I want to create a google form that when the user enters some inputs in the first section those input will appear in the next section of the form.
I am a coder and have worked with Javascript before. But the fact that she has explained these concepts in such lucid language so that non coders can grasp it is amazing. Great Job. 🎉
@saperis
Жыл бұрын
Thank you for the feedback. I believe in teaching concepts and not simply sharing code which viewers can copy & paste.
@Zulonix
9 ай бұрын
@@saperis Did you intend to say "copy and turn to pasta?" ;-)
Check out my Google Sheets Automation online course: courses.saperis.io/
I am a python coder ... i have to say this was a delightful intro to gscript and well worth my time ... i LOVE your style ... so clear and concise ... no fat.
@saperis
Жыл бұрын
I'm happy you liked it. Have fun with Apps Script!
Hello @Saperis, This one video cleared up a bunch of important concepts including adding script execution to the menu etc. Minute for minute the best video on the subject that I've seen. Very neatly done!
@saperis
3 жыл бұрын
Great to hear and thank you for watching! 😀
@spadealt456
2 жыл бұрын
🧡
I have watched many coding tutorial videos, and you have done such a fantastic job at explaining code to non-coders. Thank you so much
Thank you so much! For a complete beginner in programming, this tutorial taught me so much more than I'd expected. Really appreciate your content and your articulate style of teaching. 30 out of 10!
@saperis
2 жыл бұрын
Thanks for watching and learning with our video. Learning to code is a challenge but one you can master. 👍
@spadealt456
2 жыл бұрын
🧡
@madavplc703
2 жыл бұрын
Hello madam how to make student results viewer in Google sheet by typing index number
@ifeanyibarth5137
9 ай бұрын
Non coders understand? Nah!
I've watched 10+ videos to get started on GS and was about to give up, but thank goodness I stumbled across your channel. Thank you very much
@saperis
2 жыл бұрын
Great to hear! 😀
Your video series was needed years ago. Thank you so much, I learned a lot.
@saperis
3 жыл бұрын
You're very welcome! I'll be adding a new Google Apps Script video every month.
@spadealt456
2 жыл бұрын
🧡
ive been in the coding game for about 2 years now, and by far the best tutorial for beginners indeed. usually when people say for "beginners" they still treat it like its advanced, or they already know coding/JavaScript terms. studying for an interview tomorrow and this helped a lot, so thank you. and also thank youfr breaking it down BY TERM for the true (no pun) beginners.
@saperis
Жыл бұрын
Happy to hear you find the video helpful. By the way, I've started making pure JavaScript videos for beginners. You might find them helpful. All the best for your job interview!
I just want to say what a well explained video. For someone who struggles understanding things easily, you do a fabulous job breaking things down. I am so excited to learn more from your videos. So glad I found this video!
@saperis
Жыл бұрын
Happy to hear that! We have a playlist full of beginner friendly JavaScript videos you might want to check out: kzread.info/dash/bejne/qmesvLqDncWWZbg.html
Finally, a true BEGINNER’s guide. I have zero knowledge in scripts and the other videos I watched were too overwhelming. This video really helped me a lot. Thank youuu
@saperis
Жыл бұрын
Glad it helped! There's a playlist with beginner friendly coding videos. Feel free to watch any video that might interest you: kzread.info/head/PLNwCcck1-mNgASuUVvHeK282pvHzgWP-6
legit just made my personal "Data Science" playlist. Great teaching style!
@saperis
2 жыл бұрын
Wow, I feel honored I made it on that playlist! I've since changed my style of explaining a bit. If you want to, you could let me know if the new style works well too. This is my newest Apps Script video: kzread.info/dash/bejne/qW11urSfosu6c7Q.html
I am not a coder but loved the way she's explained it. precise and at a pace that a beginner can grasp the concepts and do it simultaneously.. Amazing job!
@saperis
Жыл бұрын
Happy you liked the video 😀
I've watched a lot of tutorials on google apps for beginners and all of them are so hard to understand. THIS IS THE ONLY channel that made sense to me. thanks! :D
@saperis
3 жыл бұрын
Happy to hear that! 😀
I appreciate the time and detail you include in your explanations
Love your tutorial. explaining object and then breaking it down to its component. Awesome!
@saperis
Жыл бұрын
Glad you enjoyed it! 😀
What a great tut! I love the way you explain things. I could learn/listen all day!
@saperis
3 жыл бұрын
Thanks for the feedback Corey. I put out a new Google Apps Script tutorial every month so stay tuned. 😀 And you might want to check out my online course: courses.saperis.io
@spadealt456
2 жыл бұрын
🧡
Very nice teaching here! Not only did the tutorial work and showed me how to do what I wanted, but the way you explained it is clear and understandable. This was my first foray into using the Apps Scripts, but it is not my last! Thank you.
@saperis
2 жыл бұрын
Happy you liked it! We have an entire playlist with Google Apps Script videos. You might want to give it a look: kzread.info/head/PLNwCcck1-mNhiOoAGICW3fYKTP5gHZyjR
Best teacher I have seen in my life 😊😊
@saperis
3 жыл бұрын
That's so nice of you! Check out my online course if you want to dive deeper into Google Apps Script: courses.saperis.io
@savashzaynal6502
2 жыл бұрын
Yes she is very good, that said however either your to young, you have not seen many teachers or you have the world's worst luck.
This is my first video on the journey to learn appscript. I am truly impressed by the way you teach. Thank you so much for this video.
@saperis
2 жыл бұрын
Happy you liked it! 😀 I have an entire Google Apps Script playlist with lots of video tutorials you might find interesting: kzread.info/head/PLNwCcck1-mNhiOoAGICW3fYKTP5gHZyjR
This was super helpful! Thank you for creating this vid, can't wait to see what else you post.
@saperis
3 жыл бұрын
You just made my day Tiph! Thank you for the feedback. 😀 If you have a chance do check out my Google Apps Script online course: courses.saperis.io Have a good one!
Thanks Kathie. This is the first time I actually managed to create and run a Google Apps Script successfully. Your presentation is well-structured and easy to follow.
@saperis
10 ай бұрын
Glad it was helpful! 😀
You're a natural teacher, thanks a lot for the quality of the video
@saperis
3 жыл бұрын
Thanks for the kind words. I truly enjoy creating these videos and sharing my knowledge with my viewers.
This is one of the best beginner videos I've watched ever on anything.
@saperis
2 жыл бұрын
Thanks for watching and learning with us. We have many more beginner-friendly Apps Script videos you can check out.
Awesome video!! You explained so well. I will have to rewatch it again to understand better. I am completely new to the App Script...Hopefully, I can get used to of using this.
@saperis
2 жыл бұрын
I'm sure you will learn it! Have fun.
You definitely have a gift for teaching. I look forward to your other videos
@saperis
3 жыл бұрын
Thanks for your motivating words! You might also want to check out my Google Apps Script online course: courses.saperis.io The first lessons are for free so you can try out the course with no strings attached.
@ramsubramanian359
3 жыл бұрын
Very True.
This is great! Assigning to my teachers as summer PD!
@saperis
4 жыл бұрын
Hi Paul. Thank you very much! I think Google Apps Script is awesome and I'm sure your teachers will be enjoying learning it. I also have some more Apps Script videos on my channel you can check out. Greetings, Chanel
Thanx for that quiet , slow explanation and wonderful algorithm of teaching what is coding for beginners. I subscribed and am waiting for your new videos.
Loved that tut. Style and flow - perfect! Thank you.
@saperis
Жыл бұрын
Glad you liked it! 😀
Another dev here. I know lots about Javascript but your video introduced me to the Google Apps sandbox and API and how to expose scripts to my Sheets. Thanks so much!
@saperis
2 ай бұрын
Glad I could help! 😃
Your video is great! The explanation is super crystal clear! Thank you!
@saperis
3 жыл бұрын
Thank you Carol! By the way, check out my Google Sheets Automation online course: courses.saperis.io Greetings, Chanel
I like when you mention what all the basic stuff means as you go along. I'm new to this craic and it's annoying having to pause other people's videos, Google stuff, then come back lol.
@saperis
2 жыл бұрын
Well, many tutorial creators assume that their viewers already have coding experience. I on the other hand create videos for viewers with little or no coding know-how. That's why my videos are good for beginners but experienced coders find them to be too basic.
Super helpful tutorial! I created my first Google Apps Script!
Thank you for your sharing. Very useful for beginners!
Thanks for doing a great job of explaining the basics of Google App Script. Sometimes you just need that one clear lesson to get your head around things, so thank you for that.
@saperis
Жыл бұрын
Happy this video helped you better understand Google Apps Script 😀
thank you so much, i am graceful to find your channel!, I'll keep it up watching all your tutorials
@saperis
2 жыл бұрын
Thank you! We are always happy to hear from our viewers. 😀
Hi! This helped me understand it better and makes me more motivated to learn Google Scripts, thanks. Cheers!
@saperis
3 жыл бұрын
Great to hear Livia! Have fun with learning Google Apps Script. 😀
Thanks so much for this tutorial, starting to write my Google Script codes !
@saperis
2 жыл бұрын
Happy to hear that! Have fun with Apps Script. 😀
You're top notch .... The Best instructor.
@saperis
Жыл бұрын
Thank you for watching my video and learning through it. 😀
Very well made, enjoyed watching it and learned a lot on the way. Thank you soooo much !
@saperis
3 жыл бұрын
Glad it was helpful! 😀
Great video!! You made it very easy to follow along and I actually made my first script work!!!
@saperis
2 жыл бұрын
Congrats on your first script! 😀
Eres la mejor! Graciaaaaas desde Mexico City.
@saperis
3 жыл бұрын
Muchas gracias! Has visto que tengo un curso online? Lo puedes ver en courses.saperis.io
I love your video. It helps me to understand how does GA Script work as a beginner. Please keep uploading new videos. I believe many will appreciate.
@saperis
Жыл бұрын
Thanks for setting the record straight 👍
This helps me a lot getting started with App Script. Thank you Chanel
@saperis
2 жыл бұрын
Great to hear! Have fun with Google Apps Script. 😀
Productivity at its peak! Thankyou!
@saperis
Жыл бұрын
Thanks for watching 😀
Brilliant! Best video I’ve seen ! Perfect for a complete newbie ! Thank u 🙏
@saperis
Жыл бұрын
Glad it was helpful! 😀
Wow! I am impressed. I am a software engineer as well. I have to admit that no one really talks about these basics and good practices any more including the documentation. The whole industry has become adhoc development campus. I normally do not subscribe to the one time videos that I watch, but I did end up subscribing.
@saperis
Жыл бұрын
Happy to hear you like this video. You know the saying where you give someone a fish and they will eat for a day. But if you TEACH them how to fish they will eat every day. I believe in teaching the HOW and WHY so that aspiring developers can apply concepts instead of only copy & pasting code. And yes, learning to read and use the documentation of any technology is super important in my opinion.
Yes @saperis , you are a good teacher.
@saperis
2 жыл бұрын
Thank you 🙏
"Easy programming language" --- U are the best ! 😊
@saperis
Жыл бұрын
Thank you 😀
Excellent. Was having trouble with Google script, but this helped a lot, thanks!
@saperis
2 жыл бұрын
Glad it helped!
Super nice! Wasn't looking for that but loved it anyway.
@saperis
3 жыл бұрын
In that case, I'm glad the KZread algorithm brought you to my video. 😀
Wow, great tutorial! Thank you very much. Really well done!
@saperis
3 жыл бұрын
You're very welcome! 😀
That's a actually really good intro to programming in general. Very professional and helpful. Thank you
@saperis
2 жыл бұрын
Glad you like it! 😀
Finally, someone who knows how to walk us through it.
@saperis
Жыл бұрын
If you've liked this video I suggest you check out this playlist: kzread.info/head/PLNwCcck1-mNgASuUVvHeK282pvHzgWP-6
Thank you so much, Saperis It is what I look for so far Love from Indonesia
@saperis
2 жыл бұрын
Happy to help. 😀
Teaching is truly an ART and you got it, I really like your style. 😁
@saperis
Жыл бұрын
Thank you very much 😀
This video really helped me thanks!🙂
Thanks a lot saperis for these Apps script tutorials.👌
@saperis
Жыл бұрын
Glad you like them! We have a whole playlist full in case you want to binge watch coding videos: kzread.info/head/PLNwCcck1-mNgASuUVvHeK282pvHzgWP-6 😀
OMG! Thank you so much
Very detailed explanation of the basic definitions. Thank you for your video!
@saperis
2 жыл бұрын
Glad it was helpful! 😀
@spadealt456
2 жыл бұрын
🧡
Brilliant tutorial for an introduction to Google Script.
@saperis
8 ай бұрын
Happy you liked it 😃
Just lovely! Thank you.
@saperis
2 жыл бұрын
Glad you enjoyed it! 😀
I love your channel, thank you so much. Please more videos about Google Apps Script and Form. Greetings from Perú 🇵🇪
@saperis
3 жыл бұрын
Thank you for the feedback! 😀
just learning how to code and i can say that the way you've demonstrated everything helped me out A LOT, very good tutorial.
@saperis
8 ай бұрын
Glad it helped! 😃
Thank you so much for this great tutorial, much appreciated it.
@saperis
Жыл бұрын
You're very welcome!
well done and clear basics!
@saperis
6 ай бұрын
Thank you for watching 😃
Thank you so much. Very helpful for me.
@saperis
2 жыл бұрын
You are welcome! 😀
New subscriber earned. Thanks a bunch!
@saperis
Жыл бұрын
Awesome, thank you!
Excellent tutorial, thank you so much!
@saperis
Жыл бұрын
You're very welcome!
Thank you for this!
@saperis
2 жыл бұрын
My pleasure!
Thank you, i love it.
@saperis
3 жыл бұрын
I'm glad you like it! Do check out my Google Apps Script online course: courses.saperis.io
Lovely tutorial, thank you so much!
@saperis
2 жыл бұрын
Glad it was helpful! 😀
Thank you for this video!!!
@saperis
10 ай бұрын
You are so welcome! 😀
Thanks for the video! With this and some forums I was about to get my first script going!
@saperis
2 жыл бұрын
Happy to hear that!
Thank you so much, it was really helpful!
@saperis
3 жыл бұрын
Happy to hear that 😀
Very very very helpfull video! TY!!!
@saperis
2 жыл бұрын
Glad it was helpful! I try to make coding videos that are easy to follow along.
thank you so much for this video. really appreciate
@saperis
2 жыл бұрын
Glad it was helpful! 😀
Amazing didactics! Thank you for sharing!
@saperis
3 жыл бұрын
My pleasure! 😀
so nice teaching, teacher like you very rare on KZread, I just found you today, and soon i will learn a lot from you.... .
@saperis
Жыл бұрын
Happy to hear that! 😀
धन्यवाद 👍
loving this...
@saperis
3 жыл бұрын
Hi Jose. I'm so happy to hear that. I really love Google Apps Script and how you can automate tasks with it. By the way, check out my other videos on Apps Script. And I'm currently putting together an online course about it. More infos here: courses.saperis.io/ Greetings, Chanel
Very cool!
Fantastic. Thank you for sharing...
@saperis
2 жыл бұрын
My pleasure! 😀
well made, helped a lot, clear
@saperis
2 жыл бұрын
Great! Now you can go on and create awesome automation scripts. 😀
I think i’m in love… with gs of course 😍
@saperis
2 жыл бұрын
Yeah, Google Sheets and Apps Script are to fall in love with. 😀
just loved it! Thank you for your efforts :)
@saperis
2 жыл бұрын
Glad you enjoyed it!
Thank you so much for this beautiful piece of knowledge. Respect and regard for you
@saperis
Жыл бұрын
Glad it was helpful! 😀
Thank you for making this video. I would love to understand enough to use appscript.
@saperis
3 жыл бұрын
Glad it was helpful! Learning a new skill is all about not giving up. Just keep at it and you'll learn it. 👍
Awesome 👍
Super helpful! Thank you!
@saperis
2 жыл бұрын
Glad it was helpful! 👍
That was awesome. Thanks.
@saperis
Жыл бұрын
Glad you liked it! 😀
Thank you so much it worked kindly please teach more about google spreadsheets the way you teach is awesome and understandable.
@saperis
4 жыл бұрын
Thank you very much! I'm happy that others can learn from my experience and go on to create useful Google Apps Script automations. - Chanel
Super helpful video :) thank you!
@saperis
4 жыл бұрын
You‘re welcome Jacob. Let me know if there‘s any other Google Apps Script related topic you would want me to cover. - Chanel
Thanks for making the video.
@saperis
3 жыл бұрын
My pleasure!
Superwomen What a teacher 😍 Love from india
@saperis
2 жыл бұрын
Thank you very much for learning with us on our KZread channel. 😀
wow. Thank you so much for, this was a very good tutorial!
@saperis
6 ай бұрын
Glad it was helpful! 😃
You are are a very good teacher, thanks.
@saperis
2 жыл бұрын
Thanks you for the feedback and the view! 😀
Your such a great teacher!!!
@saperis
2 жыл бұрын
Wow, thank you! 😀
Thanks very much for your great tutorial. I've been experimenting with coding because many of my students work in Korea as software engineers. I wanted to understand what they were doing and your tutorial was my first success.
@saperis
11 ай бұрын
Happy to hear that. By the way, there's an entire playlist with beginner-friendly videos that might interest you: kzread.info/head/PLNwCcck1-mNgASuUVvHeK282pvHzgWP-6
@Jimdaewong16
11 ай бұрын
@@saperis I'm going to watch them next for sure.