Google Apps Script Complete Course New IDE 100+ Examples

Google Apps Script New Version Create custom functions within G Suite Docs Sheets GMail Drive Calendar and more

What you'll learn
Create custom functions within GSuite Apps Docs Sheets Gmail Slides
Explore how to write Google Apps Script Code within G Suite App
Create Google Script to power Google Apps
Create custom functions and macros for Google Sheets
Add custom menus, dialogs, and sidebars to Google Docs, Sheets, and Forms
Publish web apps — either standalone or embedded in Google Sites
Interact with other Google services
Build add-ons to extend Google Docs, Sheets, Slides, and Forms

Requirements
JavaScript and basic HTML and CSS knowledge
Internet Access
Google Account
Basic Web development understanding

Description
New IDE - More functions - Exciting new Course!!!!Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with Google Workspace. Code is in modern JavaScript Access to built in libraries that can really power up your Google Workspace AppConnect Google Workspace applications like Gmail, Calendar, Drive, and more.Interact with other Google services Calendar, Drive, Gmail, and Maps.Nothing to install - code editor right in your browserYour scripts run on Google's serversExtending Google Workspace with Add-onsRapid application development platform based on JavaScript that lets you create business and productivity applications quickly and easily.Loaded with Google Apps Script Code Examples - 100s of code snippets to do amazing things with Google G Suite - Sample projects to create advanced functionality with Google Apps - Google ServicesAdd custom menus, dialogs, and sidebars to Google Docs, Sheets, and Forms.Publish web apps — either standalone or embedded in Google Sites.Create customized user interfaces that are directly integrated into Google Workspace applications.Boost workflow efficiency when working with Google Workspace by automating or streamlining tasksConnect to non-Google services within Google Workspace applications, allowing you to retrieve or upload data from those services into and from Google WorkspaceExplore what you can create and how you can release functionality within your G Suite apps - Help with productivity connect Google Services together to DO EVEN MORE!!!!  Based on JavaScript ES6+ now packs more power with an easier to use editor - making coding fun.   Google apps script works the way you expect and need it to work - its by far my favorite coding language - if you've never used Apps Script before then this is something that you must try.   Once you start writing code with apps script it will change everything.  Google Workspace services are services that let you access the data of Google Workspace products such as Drive, Gmail, Calendar, Docs, Sheets, and others. These services are separate from APIs created for those products; in general, Google Workspace services are easier to use than Google Workspace APIs, but are optimized for only the most common use cases.Taught by a Google Developer Expert recognized GDE - with over 20 years of Coding Experience specializing in Google Apps Script - ready to help you learn more about creating amazing things with Google Apps Script.Introduction to Getting Started with Google Apps ScriptStandalone vs Bound ScriptsScript editor and Apps Script DashboardWriting Code creating Apps Script create a Doc with ScriptWhat's New with Apps Script EditorCreating and Deploying a Webapp doGet() - HTML output in WebApp URLDeployment of webapp Dev version and Exec Version.Google Apps Script Sheets Spreadsheet Service Class SpreadsheetAppThis service allows scripts to create, access, and modify Google Sheets files. Access and create Google Sheets files.How Macros work - generating Google Apps Script with Macro Recordings in SheetsSpreadsheetApp Class - Selecting Spreadsheet to manipulate with CodeSpreadsheetApp methods SpreadsheetApp.getActiveSpreadsheet()Selecting Sheets within a Spreadsheet - Spreadsheet object methods - Get data and contents of a Sheet into an array. sheet.getDataRange() data.getValues() sheet.getName()Standalone script selecting a sheet by URL or ID. List sheets - update sheet names sheet.setName();Create New Sheets on the fly with Apps Script - insertSheet()Sheet ranges - updating the background colors of cells, selecting cells and ranges of cells. getRange() getRange(a1Notation) A1Notation the default method used for creating (and displaying) cell references to other cells. All cell addresses in A1 notation consist of a column letter and a row numberGet range by numeric row and column values. sheet.getRange(rows,cols) range.setBackground(backColor) , range.setFontColor('white'), range.setFontSize(mySize+cols), range.setValue(total); getRange(row, column)MultiDimension arrays for content rows within the sheet. Get the range update content getRange(row, column, numRows, numColumns) getRange(row, column, numRows)Debugging and Dashboard settingsSheet object common methods - getLastColumn() getLastRow()Get Selection getSelection()Mini App - Copy Sheet Data to other part of SheetGet all the Data range from Sheet object sheet.getDataRange(); Returns a Range corresponding to the dimensions in which data is present.Dialogs and custom UI buttons - UI Menu within SheetsAppend Row - add new rows - Add row on top appendRow(rowContents)Insert insertRows(rowIndex)Cell Formulas - spreadsheet.getRange().activate() .setFormula()Custom Functions using the custom function Using a custom function - Is Email mini AppMini App - Copy Sheet to another new sheetAdding Notes to CellsCoding App MiniProject Challenge - Create a Custom Logger into a Sheet - track messages into logCoding App MiniProject Challenge - Create a custom Prepend Function Prepend Row ExerciseGoogle Apps Script Docs Document Service Class DocumentAppThis service allows scripts to create, access, and modify Google Docs files. The document service creates and opens Documents that can be edited.Bound Script getActiveDocument()Select and add Content to Body getBody() appendParagraph() appendPageBreak()StandAlone Script DocumentApp.openById()Add Body Content appendHorizontalRule()Create a Doc using Script DocumentApp.create()Get Doc properties add to itself within the new DocSet Name Get Editors and Get URLSelect Text getText()Use JavaScript Loop to generate rows of contentTranslate selected Content to Spanish LanguageApp.translate()body.getParagraphs() select and update text within ParagraphsDocumentApp Types and setting of DocumentApp.TextAlignmentBody Get Children getChild() .setFontSize() .getNumChildren() with loop to iterate body children element containersStyle Attributes DocumentApp.AttributeReplace text body.replaceText()el.setAttributes(); using attribute object values and propertiesClear body contentAdd list itemsAdd Tables data typesDocumentApp UI prompt and alertActive User Session.getActiveUser()UI DocumentApp showModalDialog() HTML output HTML from FileCursor position getCursor()editAsText() set part of text as boldSelected Text toUpperCase() getActiveDocument().getSelection()Adding Bookmarks with Code addBookmark()Insert Image into DocumentReplaceText ExerciseExercise Sheet data to Doc TableCoding App MiniProject Challenge - Add Text within the doc press menu buttonCoding App MiniProject Challenge - Find and highlight text from Doc ContentCoding App MiniProject Challenge - Insert Images in Doc content Insert ImagesGoogle Apps Script Drive Service Class DriveAppThis service allows scripts to create, find, and modify files and folders in Google Drive.Selecting files log all the file names from the driveIntroduction to Apps Script DriveApp Service getFilesHow to Get Files in specific Folder using DriveApp ServiceCreate a File HTML file make files within your gDrive apps script DriveApp Create a FileDrive details get storage Get info and gdrive folder Drive DetailsClasses File ClassTrash files move to trash Send Files to Trash with Google Apps ScriptFile permissions set File Access Permissions with Google Apps ScriptClass FileIteratorFolders Class FolderSet permissions and remove permission on FolderGet details of Folder Class FolderIteratorUser ObjectCoding App MiniProject Challenge - create an app to list folder details into SheetCoding App MiniProject Move File from one folder to anotherCoding App MiniProject Search files return file objectCoding App MiniProject Add and Remove EditorsCoding App MiniProject Webapp folder urls in webapp from SearchGoogle Apps Script Gmail Service Class GmailAppThis Service lets you send email, compose drafts, manage labels, mark messages and threads, and conduct a variety of other Gmail account management tasks. See also Mail Service, a simpler service that only allows the sending of email.Mail Service vs GmailApp Service sendEmail(recipient, subject, body) This service allows scripts to send email on a user's behalf. Unlike Gmail Service, Mail Service's sole purpose is sending email; it cannot access a user's Gmail account. This service allows users to send emails with complete control over the content of the email. Sending an email in Mail Service sendEmail(recipient, subject, body, options) getRemainingDailyQuota() Sending an email in Mail Service sendEmailSending an email in GmailApp Service sendEmail(recipient, subject, body) sendEmail(recipient, subject, body, options) How to send emails - Sending Emails with Apps ScriptCreate a draft email createDraft(recipient, subject, body, options) Drafts email in GmailApp ServicegetMessage() method in emails Threads within Gmail using GmailApp Service Inbox Threads.Sending an email from HTML template fileCoding App MiniProject Use Doc as Email templateReplace of content in email use it as a templateCoding App MiniProject how to use Spreadsheet data list to Send EmailsHTML BodyCoding App MiniProject Challenge send bulk emails from list in SheetsGmailApp Chat threadsMaking a draft emailMark message as read markMessageRead(message) Marks this message read and forces the message to refresh.Add a Star to Message starMessage(message) getStarredThreads(start, max) Retrieves a range of starred threads irrespective of labels.Get user labels apply labels getUserLabels() Retrieves a list of user-created labels.moveMessageToTrash(message) Message objectSearch for message contents search(query, start, max) Search Gmail with the given query.Coding App MiniProject Class GmailAttachment - send and create attachments - Get attachments GmailApp Attachment Classaccess Chat Threads GmailApp class using Apps Scriptfind messages - apps script GmailApp Search.Google Apps Script Calendar Service Class CalendarAppThis service allows a script to access and modify the user's Google Calendar, including additional calendars that the user is subscribed to. Allows a script to read and update the user's Google Calendar. This class provides direct access to the user's default calendar, as well as the ability to retrieve additional calendars that the user owns or is subscribed to.CalendarApp add location to info Class CalendarGet Events with optionsFull day events within the calendarAdd events with seriesSelecting Calendars using CalendarApp Class Code exampleDelete create and hide calendarHow to update Google Calendar Name add DescriptionUpdate calendar color , description and nameSelect and Update Calendar Events CalendarApp Event Class ExamplesCreate EventsProject - Challenge - Spreadsheet Calendar Lister - CalendarApp and SpreadsheetApp ProjectCalendar Event GuestCalendar Event Class using Google Apps ScriptGet Guest details - update guests add and remove guest classEventGuest updates Represents a guest of an event.EventRecurrence class set the recurrence settings for an event series.GuestStatus get guest statuses a guest can have for an event.Update RecurrenceRule which represents a recurrence rule for an event series.Coding App MiniProject Spreadsheet Calendar Lister - CalendarApp and SpreadsheetApp Projectcreate Events CalendarApp within Google Calendar with Apps ScriptGoogle Apps Script Slides Service Class SlidesAppThis service allows scripts to create, access, and modify Google Slides files. Google Slides documentation and features of the Slides service.Create a Slide - open by slide idHow to use Slides Service Class SlidesApp with Google Apps ScriptSlides Bound Script Updates select slides within Google Slides and get Slides Update themSlides UI Add a custom menu to the active presentation, including a separator and a sub-menuA slide in a presentation. Class SlideCoding App MiniProject remove a slide from Google Slides presentation Remove Slide Buttonadd custom menu options for Slides Users SlideApp UI MenuPresentation Class - appendSlide add Editor set Slide BackgroundUpdate textStyle Background Color Get TextRanges Get Page Elements Get SlidesAdd UI menu button to duplicate Slide from Current Selection Code ExampleInsert Drive Images with UI button Delete and remove selected SlidesList layouts Update Master Find text in shapes and remove shapes Source CodeCoding App MiniProject Create a Presentation from Sheets Generate Slides from Sheet data - ProjectGoogle Apps Script Forms Service Class FormAppThis service allows scripts to create, access, and modify Google Forms. Allows a script to open an existing Form or create a new one.Create a form create a form with Apps Script Forms Service Create a FormAdd Items to a form grid items, multiple choice and date itemsGet Form items updateUpdate existing form items with new values make requiredAdd items to Form using Google Apps Script to Google Form using FormAppsetup Feedback within Google Form Feedback Within FormFormApp Class FormResponseSetting form to quizAdding Form FeedbackSetting Form to Quiz updating adding Feedback to form choicesCoding App MiniProject FormResponses into Sheet Project Get form responses add to spreadsheet ProjectCoding App MiniProject send Google Form Responses list them within a Google Sheet FormResponseCoding App MiniProject How to Create a Math Quiz in Google Forms Apps Script Quiz Generator ProjectSet Progressbar shuffle questions add Scale Item ExamplesGoogle Apps Script Google Workspace servicesGoogle Workspace services are easier to use than Google Workspace APIs, but are optimized for only the most common use cases. Coding examples of common Google Apps Script ServicesClass ContactsApp within Google Services Apps Scriptuse LanguageApp Service within Google Apps Scriptgenerate Maps using Maps Service within Google Apps ScriptGoogle Apps Script Base Services Examples of CodeCoding Example using Content Service with Apps ScriptCoding Example HTML Service within Google Apps ScriptSend data from client side back to Google Apps Script Class google script hostGoogle WebApp Client Side data scriptlets services Host services GoogleStore values within Google Apps Script Class PropertiesService User Doc or scriptCreate a request to http endpoint API using UrlFetchApp ClassGoogle Apps Script Common Services Mini Apps and Useful Coding ExamplesExamples of mini projects and Code examples for applying Google Apps Script to Create added functionality within G Suite ServicesCoding App MiniProject Create Charts in Google Spreadsheets setup SheetsCoding App MiniProject add Charts to Slides Create Slides PresentationCoding App MiniProject Create PDF in Drive email as Attachment Slides as PDF in Drive.Coding App MiniProject  - Docs UI menu InteractiveCoding App MiniProject - Sheets UI menu button for advanced interactionGetting to know Sheets Simple Triggers on Edit and Change run some codeCreate a webapp onGet onPost Simple triggers with Apps ScriptAutomation setup Triggers run code on events and regular time intervals Creating a multi page webapp with apps scriptInteractive Document custom functions Introduction Document UI File Docs Interactive ProjectCustom webapp Quiz Setup from sheets using a web appExplore how to deploy your apps script project as an Addon Extending Google Workspace. Add-ons are customized applications that integrate with Google Workspace productivity applications such as Gmail, Google Sheets, and Google Docs.Taught by a Google Developer Expert instructor with over 20 years of web dev experience ready to help you learn more about Google Apps Script

Who this course is for:
Anyone who wants to create amazing things using Google Scripts, JavaScript developers who want to empower Google suite of products, Web developers who want to incorporate Google Script functionality, Application developers who want to access the power of Google G Suite, App Script Google Script developers