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
Must have jаvascript
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:
Anyone using G Suite of products
Apps Script Developers