Stone River Elearning – Google Script Apps Email From Spreadsheet list
Create advanced functions within your spreadsheet
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
Who this course is for:
- web developers
- application developers
- anyone who wants to learn more about the power of Google Apps Script
Course Curriculum
- Email from Spreadsheet Introduction (4:38)
- Google Apps Script Bound Script (2:25)
- Get ready set Scripting (6:59)
- Get Values from Spreadsheet Google Apps Script (3:51)
- Google Apps Script Create User Object (4:51)
- Spreadsheet UI Alert UI Buttons Yes No (3:52)
- HTML Template for email (4:42)
- Send Email Message Mail function within Google Apps Script (3:12)
- Update Spreadsheet column from Google Script (4:43)
- Final Code Review Project review and code overview Google Script (5:01)
Sale Page: https://stoneriverelearning.com/p/google-script-apps-email-from-spreadsheet-list
Archive: https://archive.ph/wip/ZPp5M
Reviews
There are no reviews yet.