Explore how you can create a simple powerful application with Google Apps Script that connects your Google Suite together
Use Google Apps Script to create advanced functions within your spreadsheet
Use the spreadsheet to manage a user list, click the members on the list and send out confirmation emails. Track emails that have been sent. Create your own custom HTML template mail that gets sent to the users on the list. Use the spreadsheet UI menu to add buttons for administration of the spreadsheet data. You will be amazed at how easy it is to create powerful functionality that helps power up your Google Suite of products.
JavaScript is a prerequisite to this course.
Course covers applying Google Apps Script to build a project application.
- Add items to the spreadsheet UI menu that can trigger functions in Google Apps Script
- Select user active cell content from the spreadsheet
- Create HTML template to send email
- Use Alerts to accept user actions
- Update values of the spreadsheet data
- Select ranges and update content in the range
- Get content from the spreadsheet
- Send email from Google Apps Script
Google Script Apps Email From Spreadsheet list Source code is included so you can copy and paste the code to try for yourself.
Step by step learning
Fast friendly support is always available within the Q&A section
Experienced instructor with over 20 years of experience ready to help you learn
You have nothing to lose – Join now and start learning to create your own version of this helpful application today!!!
- web developers
- application developers
- anyone who wants to learn more about the power of Google Apps Script
Course Curriculum
- Start
Email from Spreadsheet Introduction (4:38)
- Start
Google Apps Script Bound Scrip (2:25)
- Start
Get ready set Start Scripting (6:59)
- Start
Source Code
- Start
Get Values from Spreadsheet Google Apps Script (3:51)
- Start
Source Code Get Active Row
- Start
Google Apps Script Create User Object (4:51)
- Start
Source Code Get Values
- Start
Spreadsheet UI Alert UI Buttons Yes No (3:52)
- Start
Source Code
- Start
HTML Template for Email (4:42)
- Start
Source Code
- Start
Send Email Message Mail function within Google Apps Script (3:12)
- Start
Send Email Source Code
- Start
Update Spreadsheet column from Google Script (4:43)
- Start
Source Code
- Start
Final Code Review Project review and code overview Google Script (5:01)
- Start
Final Google Script Source Code Project
ABOUT INSTRUCTOR
