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 (https://developers.google.com/apps-script/reference)
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 automate Google Sheets? Check out our online course: https://courses.saperis.io/
saperis – Helping you become a Google Workspace Pro!
Sign up to our YouTube channel for more Google Workspace, Gmail, Google Docs, Google Drive, etc. videos: https://www.youtube.com/channel/UCJy6IEq0tVdteUXRau1lXbQ
saperis website: https://saperis.io/
saperis Linkedin: https://www.linkedin.com/company/saperis
saperis Twitter: https://twitter.com/Saperis_io
source
Check out my Google Sheets Automation online course: https://courses.saperis.io/
Brava👏
Thank you!
Very well explanation Madam…thank you so much…👍
Thank you. Completely knew to Google products. Long time Office (Excel) user. Worked great until the very end, then I got an alert "Google hasn't verified this app. The app is requesting access to sensitive info in your Google Account. Until the developer (………@gmail.com) verifies this app with Google, you shouldn't use it. ??
HI Great video. You are excellent at explaining things! I had the same issue with "TypeError: Cannot read property 'getRange' of null (line 4, file "Code")." However your link to your data helped. Thanks v much. I wa trying to LOAD a project from the scriopt editor and get that to operate and that didn't work. Any ideas why?
Hi Saperis, I really loved watching your video. Can you please help me get a code in Google forms. If there are 3 checkboxes – 'A' and 'B' and 'C'. And I want to make checkboxes 'B' and 'C' disabled if checkbox 'A' is checked, how do I do that. Can you please comment this code here if you get it.
Very well made, enjoyed watching it and learned a lot on the way. Thank you soooo much !
Thanks al lot. Helped a lot. Can we automate data from crm to spreadsheet.
Hello, I really liked your video… I was able to follow with ease. I did however encounter an issue that I was hoping you might be able to explain. I'm getting an error message ''TypeError: Cannot reas property 'getRange' of null formatReport. I'd be happy to share a screenshot….
I love your channel, thank you so much.
Please more videos about Google Apps Script and Form.
Greetings from Perú 🇵🇪
you are the best
why do i keep having this message "Error
TypeError: sheet.getRange is not a function" pls help
I just attend Google course in hiring east
Hi, I would like to know if it is possible to auto update gchart when you update something on gsheet? Charts or table linked from Gsheet to Gslides, currently clicking update to capture latest update. Thanks for your help in adv.
how to copy value if a cell is blank cell in spreadsheet in app script.
To get data on a repetitive basis i use google forms, the data users enter is stored on google sheets. But the problem i am facing is, i need to fetch data in table format, as i learn G-Forms doesn't allow that. Do you have any method to get data in table format?
"Tools > Script Editor" does not exist! I have "more tools" but still no "script editor"! Why is it so many 'help' advices are actually at best 'frustration traps' or worse, only server to doubt the presenter's knowledge?
Thank you so much, it's really useful lesson 😍
You definitely have a gift for teaching. I look forward to your other videos
Hello. Can I get value from the msSql database with Google App Script ? (without using third party app)
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.
Had an issue changing the top, left, right to true and false. How did you get the purple click? Just starting out with apps scripts.
What a great tut! I love the way you explain things. I could learn/listen all day!
I deployed it by creating a "web app". I included the link in an HTML file, but it appears as text instead of running the link. What am I doing wrong?
Thankyou for the video but at 22:41 when you need to get authorisation for the app I hit an issue I haven't been able to figure out:
I get the Custom Formatting menu appear, I click Format Report and get the 'Authorization Required' pop up, click Continue, it goes to Sign in, I sign in and I get:
Warning! Google hasn't verified this app. – Back to Safety.
Any ideas how I fix this?
thank you
This is amazing Chanel…. I would like to learn more on Google Suite, especially Google Scripting. Thank you!
are let and var the same?
Your video series was needed years ago. Thank you so much, I learned a lot.
well english..easy to understand
Best teacher I have seen in my life 😊😊
Wonderful and very useful.
One request if formating done by pagination.Please publish video on that
I am seeking a script that will print a letter on one sheet when pressing a button (Print) on another sheet. Is that possible? I have it as a macro in excel but not sure how to apply this in Google sheets.
Eres la mejor! Graciaaaaas desde Mexico City.
Hi! This helped me understand it better and makes me more motivated to learn Google Scripts, thanks. Cheers!
Hi can we posting csv spreadsheet to blogspot using GAS? Thanks
This is very informative. Can you also make a comprehensive tutorial on how to do multiple levels of dependent drop down menu on google sheets?
I didn't get the UI Part. can you please explain what is UI?
Amazing
Super nice! Wasn't looking for that but loved it anyway.