Video: .MP4, 1280x720 30 fps | Audio: AAC, 44.1 kHz, 2ch | Duration: 01:01:27
Genre: eLearning | Language: English + Subtitles | Size: 389 MB

Automate sending of emails from your Google Spreadsheet !

Explore how you can automate G Suite with Google Apps Script connect Spreadsheet data and send emails using GoogleScript
What you'll learn

Google Apps Script

Creating apps with Google Script

Google Spreadsheet App Class and methods

Requirements

Must have jаvascript

Coding experience

Google Account

Description

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 jаvascript 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:

jаvascript Developers

Anyone using G Suite of products

Coders

Apps Script Developers




DOWNLOAD
uploadgig