Google Script Apps Email From Spreadsheet list
4.8 (6 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,604 students enrolled

Google Script Apps Email From Spreadsheet list

Google Script Apps Google Script Apps Email From Spreadsheet list
4.8 (6 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,604 students enrolled
Created by Laurence Svekis
Last updated 12/2019
English
English [Auto-generated]
Current price: $129.99 Original price: $199.99 Discount: 35% off
12 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 44 mins on-demand video
  • 8 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to build applications with google Apps Script
  • How to create code and connect GSuite Applications
Course content
Expand 18 lectures 45:55
+ Introduction to connecting Spreadsheet and Google Apps Script
18 lectures 45:55
Source Code
00:02
Get Values from Spreadsheet Google Apps Script
03:51
Source Code Get Active Row
00:06
Google Apps Script Create User Object
04:51
Source Code Get Values
00:09
Spreadsheet UI Alert UI Buttons Yes No
03:53
Source Code
00:14
HTML Template for email
04:42
Source Code
00:10
Send Email Message Mail function within Google Apps Script
03:12
Send Email Source Code
00:05
Update Spreadsheet column from Google Script
04:43
Source Code
00:26
Final Code Review Project review and code overview Google Script
05:01
Final Google Script Source Code Project
00:26
Requirements
  • JavaScript HTML and CSS
  • Previous coding experience
  • Google Account
Description

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!!!

Who this course is for:
  • web developers
  • application developers
  • anyone who wants to learn more about the power of Google Apps Script