% Off Udemy Coupon - CourseSpeak

Google Apps Script Complete Course Beginner to Advanced

Learn to power up your Google Suite of products using Apps Script to connect - automate - add advanced functionality

$9.99 (94% OFF)
Get Course Now

About This Course

<div>Google Apps Script is a coding language in the cloud that is based on JavaScript - allowing you to connect the Google Workspace Services to do amazing advanced functionality within your Google Workspace.</div><div><br></div><div>Increase the power of your favorite Google apps — like Calendar, Docs, Drive, Gmail, Sheets, and Slides. Apps Script lets you do more with Google. All on a JavaScript platform in the cloud.G Suite Services.</div><div><br></div><div>Course content covers every step to get started with Google Scripts including an overview of the editor and what it does and how to use it.&nbsp; Followed by more detailed syntax and code examples of applying Google Script in real world projects.&nbsp; Perfect for students of all levels, with a step by step approach for anyone who has not used Google Script Before.</div><div><br></div><div>Apps Script allow you to power up your favorite Google apps and do more with them, way more.</div><div><br></div><div>Automate, add functionality, use spreadsheet data, create documents, interact with emails, generate reports, use data the list is endless on all the amazing things you can do with Google Apps Script.</div><div><br></div><div>Warning once you start using Google Apps Script you may want to use it for everything!!!</div><div><br></div><div>Just like JavaScript apps script is easy to write, uses the same structure as JavaScript and core fundamental functionality.&nbsp; &nbsp;If you know JavaScript you can get started with apps script in minutes.&nbsp; Functions, variables, loops, and more the same syntax as JavaScript.&nbsp; &nbsp;With the added power of Google Classes you can connect data from your Google Apps and build on it.&nbsp; Its the easy way to power up your applications.</div><div><br></div><div>Course will cover&nbsp;</div><div><ul><li>Standalone script</li><li><span style="font-size: 1rem;">IDE editor</span></li><li><span style="font-size: 1rem;">Quick demo to setup and get started with.</span></li></ul></div><div><span style="font-size: 1rem;">Document - DocumentApp</span></div><div><ul><li><span style="font-size: 1rem;">Get document</span></li><li><span style="font-size: 1rem;">Document body</span></li><li><span style="font-size: 1rem;">Get elements within body</span></li><li><span style="font-size: 1rem;">Create docs on the fly</span></li><li><span style="font-size: 1rem;">Document UI for alerts and responses.&nbsp; Interact with users.</span></li><li><span style="font-size: 1rem;">Selection of data and construction of content</span></li><li><span style="font-size: 1rem;">Styling your doc content</span></li></ul></div><div><span style="font-size: 1rem;">Spreadsheet - SpreadsheetApp</span></div><div><ul><li><span style="font-size: 1rem;">How to Get spreadsheet data</span></li><li><span style="font-size: 1rem;">Create spreadsheets and update, create and use the data</span></li><li><span style="font-size: 1rem;">Get ranges - select sheets and get content</span></li><li><span style="font-size: 1rem;">Get Sheet data and iterate through it to output it</span></li><li><span style="font-size: 1rem;">Write to spreadsheet using script</span></li><li><span style="font-size: 1rem;">Spreadsheet UI for added interactions with users</span></li><li><span style="font-size: 1rem;">Update sheet with new data</span></li><li><span style="font-size: 1rem;">Sidebar menu update sheet show sheet data and more</span></li></ul></div><div><span style="font-size: 1rem;">Google Sites - Standalone scripts</span></div><div><ul><li><span style="font-size: 1rem;">Sites class and how to use them</span></li><li><span style="font-size: 1rem;">Sites dashboard navigation and use</span></li><li><span style="font-size: 1rem;">Design sites interface with options to create pages and more</span></li><li><span style="font-size: 1rem;">Add scripts to sites to create data driven and interactive pages</span></li><li><span style="font-size: 1rem;">Output and setup sites content quickly and easily</span></li></ul></div><div><span style="font-size: 1rem;">Google Drive - DriveApp Class</span></div><div><ul><li>Get drive data and use it</li><li><span style="font-size: 1rem;">Setup files create new files</span></li><li><span style="font-size: 1rem;">Move files from one folder to another</span></li><li><span style="font-size: 1rem;">Get folder contents and list it</span></li><li><span style="font-size: 1rem;">Create files copy files and update files</span></li><li><span style="font-size: 1rem;">Search drive files and folders</span></li><li><span style="font-size: 1rem;">Get permissions and set permissions</span></li><li><span style="font-size: 1rem;">List files from folders in Google Sheet show permissions update permissions</span></li></ul></div><div><span style="font-size: 1rem;">Calendar Calendar - CalendarApp Class</span></div><div><ul><li><span style="font-size: 1rem;">Create events</span></li><li><span style="font-size: 1rem;">Get event details</span></li><li><span style="font-size: 1rem;">Update color style</span></li><li><span style="font-size: 1rem;">Output events to Google Sheet</span></li><li><span style="font-size: 1rem;">Using Calendar events checking availability and more</span></li></ul></div><div><span style="font-size: 1rem;">Gmail - GmailApp Class</span></div><div><ul><li>Send message</li><li><span style="font-size: 1rem;">Get inbox contents from folder</span></li><li><span style="font-size: 1rem;">Create labels and move files</span></li><li><span style="font-size: 1rem;">Get counts of emails and content</span></li><li><span style="font-size: 1rem;">Mark Emails as read&nbsp;</span></li><li><span style="font-size: 1rem;">Track emails and use the content&nbsp;</span></li><li><span style="font-size: 1rem;">Search emails</span></li><li><span style="font-size: 1rem;">Star Messages</span></li></ul></div><div><span style="font-size: 1rem;">Step by step training lessons</span></div><div><br></div><div>This course covers everything you need to learn about Google Apps Script, including practice exercises, loads of examples, source code and step by step training.&nbsp; Along with friendly support in the Q&amp;A to help you learn and answer any questions you may have.</div><div><br></div><div>Try it now you have nothing to lose, comes with a 30 day money back guarantee.&nbsp;&nbsp;</div><div><br></div><div>Taught by a knowledge instructor with many years of web development experience, ready to help you learn.</div><div><br></div><div>Join now and create your own Google Scripts Apps see what is possible.</div><div><br></div>

What you'll learn:

  • Create custom functions within G Suite Apps Docs Sheets Slides Gmail Drive and more
  • Create Google Script to power Google Apps
  • Use Google Script to to add functionality automation and more to Google Docs Sheets plus