Google Apps Script Spreadsheet Emailer Project
4.1 (2 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.
1,618 students enrolled

Google Apps Script Spreadsheet Emailer Project

Explore how you can automate G Suite with Google Apps Script connect Spreadsheet data and send emails using GoogleScript
4.1 (2 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.
1,618 students enrolled
Created by Laurence Svekis
Last updated 5/2020
English
English [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour 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
  • Google Apps Script
  • Creating apps with Google Script
  • Google Spreadsheet App Class and methods
Course content
Expand 19 lectures 01:01:27
+ Introduction to creating an email project using Google Apps Script
19 lectures 01:01:27
Spreadsheet UI Setup
09:40
Source Code
00:04
Make Bold Get Selection.
03:21
Source Code
00:03
Popup Dialog UI
05:27
Source Code
00:04
Get Sheet Data Values
05:51
Source Code
00:04
Loop Data or Rows
06:07
Source Code
00:10
Update Sheet with results data Google Apps Script G Suite
05:07
Source Code
00:11
Send an Email using Google Apps Script
06:41
Source Code
00:06
Spreadsheet Email Project Conclusion.
04:03
Full Google Script Source Code
00:27
Requirements
  • Must have JavaScript
  • Coding experience
  • Google Account
Description

Automate sending of emails from your Google Spreadsheet !

Add a UI button in the spreadsheet that will send emails, update the results all within the spreadsheet itself.  One of the most asked for functionality for G Suite to use spreadsheet to manage email communications.  HERE IT IS......

Please note that JAVASCRIPT KNOWLEDGE is REQUIRED - This is a coding course you can use the source code as is for the functionality but the course is CODING...  Demonstrating how to write Google Apps Script code and create a simple project that can connect G Suite Apps together for advanced and automated functions.

Source Code is included

Step by step instructions on how to build the project - this is a starter project designed to get you started and then you can customize and extend on what is covered within the lessons.

  • Setup of Spreadsheet UI Object

  • Adding buttons to sheet toolbar

  • Running functions with button click

  • Permissions for Sheets and emails

  • Sending HTML email using data from the Spreadsheet

  • Tracking sent emails

  • How the Emails look within Gmail

  • Testing of email app

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

Fast friendly support within the Q&A section.

Start building your own version of the app - by the end of the course you will have a fully functional application that can send emails from your spreadsheet.

Who this course is for:
  • JavaScript Developers
  • Anyone using G Suite of products
  • Coders
  • Apps Script Developers