Google Apps Script Complete Course Beginner to Advanced

Course will cover

• Standalone script
• IDE editor
• Quick demo to setup and get started with.

Document – DocumentApp

• 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

• 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

Google Sites – Standalone scripts

• Sites class and how to use them
• Sites dashboard navigation and use
• Design sites interface with options to create pages and more
• Add scripts to sites to create data driven and interactive pages
• Output and setup sites content quickly and easily

Google Drive – DriveApp Class

• Get drive data and use it
• Setup files create new files
• Move files from one folder to another
• Get folder contents and list it
• Create files copy files and update files
• Search drive files and folders
• Get permissions and set permissions
• List files from folders in Google Sheet show permissions update permissions

Calendar Calendar – CalendarApp Class

• Create events
• Get event details
• Update color style
• Output events to Google Sheet
• Using Calendar events checking availability and more

Gmail – GmailApp Class

• Send message
• Get inbox contents from folder
• Create labels and move files
• Get counts of emails and content
• Mark Emails as read
• Track emails and use the content
• Search emails
• Star Messages

Step by step training lessons

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.  Along with friendly support in the Q&A to help you learn and answer any questions you may have.

Try it now you have nothing to lose, comes with a 30 day money back guarantee.

Taught by a knowledge instructor with many years of web development experience, ready to help you learn.

Join now and create your own Google Scripts Apps see what is possible.