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
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
- Internet Access
- Google Account
- Basic Web development understanding
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. Followed by more detailed syntax and code examples of applying Google Script in real world projects. Perfect for students of all levels, with a step by step approach for anyone who has not used Google Script Before.
Apps Script allow you to power up your favorite Google apps and do more with them, way more.
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.
Warning once you start using Google Apps Script you may want to use it for everything!!!
Course will cover Google Apps Script Complete Course Beginner
- Standalone script
- IDE editor
- Quick demo to setup and get started with.
Document – DocumentApp Google Apps Script Complete Course Beginner
- Get document
- Document body
- Get elements within body
- Create docs on the fly
- Document UI for alerts and responses. Interact with users.
- Selection of data and construction of content
- Styling your doc content
Spreadsheet – SpreadsheetApp Google Apps Script Complete Course Beginner
- How to Get spreadsheet data
- Create spreadsheets and update, create and use the data
- Get ranges – select sheets and get content
- Get Sheet data and iterate through it to output it
- Write to spreadsheet using script
- Spreadsheet UI for added interactions with users
- Update sheet with new data
- Sidebar menu update sheet show sheet data and more
Who this course is for: Google Apps Script Complete Course Beginner
- Anyone who wants to create amazing things using Google Scripts
- 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