Description
Stone River Elearning – Google Apps Script Quick Start Beginner Guide
Google Apps Script allows you to power up you G Suite with amazing functionality based on JavaScript
Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with G Suite.
Explore how you can using Google Apps Script to run code to make things happen within Google Suite of Apps.
The course covers the following in regards to Apps Script and how to use it
- Apply JavaScript methods within Apps Script like Date()
- Create a document using script – add content to the document
- Create a Spreadsheet using script
- Get object info like ID and URL
- Using session to get active user email address
- Using Mail Service to send emails via script
- DocumentApp and accessing updating existing docs by id
- SpreadsheetApp and accessing data contained in existing sheets
- Bound script in Docs and Sheets
- How to add UI menu items
- Running script funcitons from UI menu tab
- Creating UI alerts
- UI prompts to get user input and data
- Active document get cursor location
- Creating new sheet using script
- Updating and copying sheet data selected by user
Who this course is for:
- Web developers
- Application developers
- Anyone who wants to learn more about Google Apps Script
- Anyone who wants to automate Google Suite
- JavaScript coders
Requirements:
- JavaScript, HTML and CSS
- Prior programming knowledge
- Solid understanding of JavaScript
Course Curriculum
Introduction to writing Google Apps Script Code
- Introduction Apps Script (2:55)
- Google Script Setup (3:39)
- Get Coding Google Apps Script (7:10)
- Create Google Files (5:05)
- Create Spreadsheet Add Content (2:25)
- Send an Email Google Script (4:37)
- DocumentApp Class (6:38)
- Update element text (3:36)
- Get Update Spreadsheet (8:38)
- Bound Script UI Alert (5:54)
- Bound Script UI Prompt (4:05)
- ActiveDocument Cursor (3:37)
- ActiveSpreadsheet (7:06)
- Copy Sheet Data to New Sheet (4:27)
- Conclusion Apps Script (1:22)
Sale Page: https://stoneriverelearning.com/p/google-apps-script-quick-start-beginner-guide
Archive: https://archive.ph/wip/tLSlx
Reviews
There are no reviews yet.