https://i124.fastpic.org/big/2024/0922/6f/1e65e1ada15736bc442f7dba0383536f.jpg
Google Apps Script Learn Coding Projects Exercises Resources
Duration: 10h 25m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 3.66 GB
Genre: eLearning | Language: English
Explore how you can get started with Google Apps Script using code to interact with Google Workspace GSuite Apps
What you'll learn :
Explore how to open up the script editor and write code
How to create projects and open the project to update and edit the code
How to create customized functionality within Google Workspace
How to interact with Google Services using Apps Script
How to bring your Google Workspace to the next level
Expand your Google Workspace knowledge with exercises and challenges
How to deploy a web app - yes a URL that runs frontend code and can be shared to the world
Google Workspace Services Creating a Bound Script that powers up your Workspace
How you can create bound applications that allow you to use the Google Workspace container and create customized interaction within it.
What you can do with apps script by creating standalone applications that connect to the Google Workspace and Google Services
Create a WebApp URL Sharing and Deploying Scripts with Google Apps Script
How to do amazing things with Google Apps Script
Create custom Macros adding advanced functions to your Spreadsheet with Google Apps Script
Connect your code to a Google Workspace document.
How to get data from your spreadsheet and use it within your code with script
The UI menu and how to add custom functions for users within Spreadsheets
How to interact with Google Workspace services examples of using Classes in workspace services and how to access class methods
Requirements :
Prior coding experience with any language preferably JavaScript
Google Account
Description :
Google Apps Script is a coding language based on JavaScript that runs in the cloud. You can do really amazing things with Apps Script, within just a few lines of code. It allows you to supercharge your Google Workspace apps, to save time, and do a lot more. Google Apps Script allows you to interact with the Google Suite of products, and create customized functionality within those products. There is nothing to install, it's based on JavaScript which makes it easy to get started with, and because of the code syntax being JavaScript there is a massive amount of coding examples and support online.
Enroll now to get instant access to:
9+ hours of premium lessons
61 page downloadable workbook for Section 1 includes source code, tips, resources and challenges
46 page downloadable workbook for Section 2 includes source code, tips, resources and challenges
11 page downloadable workbook for Section 3 includes source code, tips, resources and challenges
Premium instructor support to help you learn
Lifetime access to course updates
Included 3 Ebooks loaded with exercises and source code, with coding tips for learning Google Apps Script!
Each lesson is designed to demonstrate a particular aspect of Google Apps Script coding, with exercises to challenge you!
Lessons and content for the lessons is designed from common questions and coding challenges that students have contacted me about.
The possibilities are endless, let your imagination guide you.
Many students have expressed how much fun and how exciting it is to write code and have it do so many cool things.
This is one of the best ways to learn to code, its easy to start, every line of code can do a lot, its logical and fun to write.
Google Apps Script is by far one of the best coding languages to get started with, as it allows you to access the power of all the Google Services that simply work so incredibly well within the script.
If you want to learn Google Apps Script - this course is a must have - bring your coding to the next level or get more familiar with all the amazing things that can be done with Google Apps Script.
Easy to get started with - its online so nothing to download all you need is an internet connect and a Google Account and you can start creating your coding apps. Its based on JavaScript so there is so many resources and code samples everywhere that you can use. The only limit is your imagination. Start coding to day within minutes creating amazing applications that can do A LOT!!!! You won't believe it until you try it. You can do it all!!!
Anyone can get started with it quickly and easily. I guarantee once you start writing some code, and see how easily it can do amazing things it will leave you wanting more.
This course is designed to help anyone get started with code, loaded with coding examples and code snippets you can try. Learn more with a step by step approach which helps demonstrate the power of Google Apps Script with simple examples. Coding examples are designed as starting exercises which can be used to bring your applications to the next level. Each lesson is specifically designed to demonstrate how a particular aspect of Google Apps Script can be used to perform common tasks and functions.
Resources, code examples, links, tips. everything you need in order to start coding and bring your applications to life.
The code presented in this course is designed to demonstrate what is possible with Google Apps Script. There is a lot that can be done and projects in this course are starter projects and exercises to help you learn about Apps Script. I do suggest that as you view the lessons of this course, to try the code alongside the lesson, so that you can see the code in action and test the various functions that will be presented.
You will need a Google Account in order to write Google Apps Script. Google Apps Script can be created directly within a web browser, the IDE for writing the code is online. Code does get saved files within your Google Drive.
A prerequisite to being able to write App Script code is JavaScript. Apps Script code is written in modern JavaScript, in addition there are built in libraries that can be accessed within the Google Workspace products like Sheets, Docs, Gmail, Calendar, Drive and more. There is nothing to install. You can write and edit the code directly in your Browser.
There is a lot that can be done with apps script, including publishing web apps, creating custom functions in Sheets, adding menus and dialogs to Docs, Sheets and Forms, interacting with other Google Services like Maps, Drive, Gmail, Calendar and much much more. You can also build and publish addons to the Google Workspace Marketplace.
Section 1 - How to get started with Google Apps Script
Quick Getting Started Introduction to Google Apps Script - How to write Code in Google Apps Script features of Google Apps Script and resources that you can use in order to write your code.
Includes a quick start set of lessons, to get you started quickly and easily.
Explore how to open up the script editor and write code
Includes Downloadable PDF guide with source code and resources to get started with Google Apps Script
Overview of the Apps Script IDE editor for code
How to create projects and open the project to update and edit the code
How to automate functions with Triggers and run code within a preset time
How to get help and how to run the code
Create a WebApp URL Sharing and Deploying Scripts with Google Apps Script
What you can do with apps script by creating standalone applications that connect to the Google Workspace and Google Services
How you can create bound applications that allow you to use the Google Workspace container and create customized interaction within it.
Google Workspace Services Creating a Bound Script that powers up your Workspace
How to deploy a web app - yes a URL that runs frontend code and can be shared to the world
How to output HTML into a web app
How to share you apps script project
How to translate a string value into another language in ONE LINE OF CODE !!!! Select from 100s of languages its easy.
Section 2 - How to do amazing things with Google Apps Script - How to use the power of the workspace services and create useful code to do a lot.
Section Source Code Getting Started with Google Apps Script Ebook Download
Create custom Macros adding advanced functions to your Spreadsheet with Google Apps Script
How Marcos can be used to create apps script - explore what apps script is and how it works within your Google Workspace
Connect your code to a Google Workspace document.
Spreadsheets and how apps script can be used when bound in a container
How to get data from your spreadsheet and use it within your code with script
Container vs bound Scripts with helpful tips and resources for coding.
How to open existing apps script projects and how to edit projects code
How to send emails from your bound spreadsheet apps script code.
How to create new files and add them to drive within a bound script.
How to use apps script for Creating Files on Drive and tracking data in Sheets
How to create a PDF Email from Sheet data and send the email using Sheet data
How to setup Bound scripts sheets UI menu with apps script
The UI menu and how to add custom functions for users within Spreadsheets
How to create Web Apps with Apps Script launch your webapp URL to share
Learn more about creating web apps with Google Apps Script Do more with Web Apps
How to use your Spreadsheet in a web application connecting with JavaScript to your endpoint and outputting the Sheet data into your web page with Frontend AJAX requests. HTML CSS JavaScript JSON AJAX - You won't believe it
How to create an Apps Script Web API Endpoint for AJAX connections output Sheet
Apps Script Web app Data transfer from ClientSide to ServerSide WebApp Sheet creating web apps and connecting the frontend code to the backend code. HTML CSS JavaScript within you WEBAPP
Automation with Google Apps Script - run while you sleep!
Google Apps Script Automation with Triggers Simple Triggers
Section 3 - Google Workspace Services Docs Calendar Drive Forms Gmail Sheets Slides - How to interact with Google Workspace services examples of using Classes in workspace services and how to access class methods
How to use Document Service with Apps Script DocumentApp Class and methods
How to setup Form Submission to Sheet spreadsheet data to get responses.
Create Forms with Google Apps Script Code Forms Service Creating form
How to use Spreadsheet Service SpreadsheetApp with Google Apps Script
Apps Script How to use SpreadsheetApp update Sheets data in Spreadsheet
Coding using Spreadsheet range selections and updates of Cells with AppsScript
How to add Conditional Rules Format with Google Apps Script code
Apps Script how to use CalendarApp Class Methods and Calendars in Workspace
How to create Apps Script code to access Drive Service DriveApp functions
How to select files within a folder, get properties and loop through the Fileiterator object.
Create Move Updates Files and Folders within your Google Drive with Code
How to update the contents of a file, and change the name
How to select an html file or text file and turn it into a PDF that gets emailed
Sending Emails Messages Thread updates with GmailApp Gmail Service Functions
How to reply to a message and get message info from the GmailMessage object
How to add email attachments to your drive with Apps Script.
Explore Slides Service with SlidesApp Class with Apps Script code.
How to add layouts selecting layouts from the presentation.
How to set random background colors to your slides.
How to generate images from all the slides in your presentation and save the images to your drive.
Section 4 - Google Apps Script Coding Examples and Helpful Code Snippets - Explore some amazing applications that you can build with google apps Script.
Google Sheets Data Exercise sending emails and updating sheet content using UI
Common questions and Coding examples
Helpful tips and resources with sample code
Fun coding projects
Video responses to student questions.
Google Apps Script allows you to create custom blocks of code that do stuff, and there is a lot of stuff you can do with it.
Container-bound Scripts - the Google file the Apps Script is attached to is known as the container. Bound scripts behave just like Standalone scripts but they have several special functions, they do not show up in drive and they cannot be detached from their container files. Script can be bound to Sheets, Docs, Slides, or Forms. To reopen the script in the future you can open the container file and select the script editor, or you can go directly to the dashboard. Apps Script home page, and select the project from there. For bound scripts it will show the container file icon, with a small Apps Script logo on it indicating that it is a bound script.
Apps Script Web app Data transfer from ClientSide to ServerSide WebApp Sheet data and more
ClientSide to ServerSide WebApp
Google web apps can run client side code that can easily be used to connect to server side Apps Script functionality. To execute server-side functions from client-side code, use services RUN is an asynchronous client-side JavaScript API available in web app HTML-service pages that can call server-side Apps Script functions.
In this example we will demonstrate how to send data objects from the Apps Script server side into the client side and use the data object within JavaScript. Also how we can send data from the client side input field values to the server side script to then be used to update and append content into a selected spreadsheet.
Google Apps Script Triggers Simple Triggers automation and more
Google Apps Script Triggers for Automation
Triggers allow you to run a function automatically within Apps Script. There are simple triggers that are built in and use custom functions in order to start and invoke the function. Within the event object of each event, the triggered function contains an event object that has information about the context in which the event occurred. Some commonly used simple triggers are onOpen() which runs when the spreadsheet, document, is opened. There is onEdit() that runs when the user changes a value in a spreadsheet. Also for web apps doGet() and doPost() are simple triggers that get invoked when the user visits the web application on either method.
Simple triggers must be in a bound script in order to run the application triggers, they also fire automatically without asking for user permissions. They will not run if the file is opened in read only mode. They are also limited in some services that would require authorization. They cannot run for longer than 30 seconds. Simple triggers are subject to Apps Script trigger quota limits.
Installable triggers provide more flexibility for users, they let Apps Script run a function automatically and can also run services that require authorization. Just like the simple triggers the event object is included in each event, that contains information about the context of the event. Installable triggers always run under the account of the person who created them. Installable triggers are subject to Apps Script trigger quota limits.
Taught by a Google Developer Expert for Workspace ready to help you learn and answer any questions you might have.
In 2019 Laurence Svekis was recognized by Google as a GDE (Google Developer Expert) for Google Workspace. Having a real passion for the amazing things that can be done with Google Apps Script it's been a real joy to create this project based course, so that others can learn and try Google Apps Script. The contents of this coruse contains many coding exercises to practice and learn more about how to apply Google Apps Script code. Please note that having prior JavaScript coding experience although not required is strongly suggested as Google Apps Script uses the JavaScript code syntax and it renders in the JavaScript engine.
JOIN TODAY and START Coding..
The Document Service allows scripts to create, access, and modify Google Docs files. DocumentApp is the parent class for the Documents, which contains properties that can be used to update the styling of elements, methods to create and open the documents. Once you have created a Document you can select the Document as an object and use the Classes
Видео
