The Increase Your Google App Productivity with Google Script Bundle
What's Included

Google Apps Script 2020: Build 16+ Fun Projects Sites GSuite

- Certification included
- Experience level required: All levels
- Access 233 lectures & 21 hours of content 24/7
- Length of time users can access this course: Lifetime
Course Curriculum
233 Lessons (21h)
- Your First Program
- Getting started with Google Apps Script Projects CourseIntroduction Google Scripts Projects3:44
- Introduction to Google Apps ScriptStart Google Apps Script1:190 Google Apps Script Introduction2:351 Getting Started with Apps Script3:512 Apps Script Editor7:243 Create a Document6:384 Create a Spreadsheet4:345 JavaScript in Apps Script Variables5:196 JavaScript in Apps Script Arrays6:067 JavaScript in Apps Script Objects4:428 JavaScript in Apps Script Functions3:419 JavaScript in Apps Script Conditions3:3110 JavaScript in Apps Script Loops2:4611 Apps Script Coding3:1812 Create a Web App5:5413 Google Apps Script Email4:3114 Google Apps Script Calendar3:2715 Google Apps Script Drive6:5616 Google Apps Script Conclusion22:25
- Form Submission auto response with Google Sheets and Apps Script0 Introduction Google Scripts3:291 Google Forms Setup4:592 Send Email via Script9:033 Setup Trigger v27:054 Copy to another Sheet8:555 Copy content on Submit4:336 Sheet data sorter4:387 Check Sheet Data for Value7:178 Quick Fixes and Updates2:139 Update Spreadsheet UI3:5810 Conclusion Spreadsheet Data3:59
- Advanced Services YouTube API made easy with Google Apps Script0 Introduction youTube Project2:471 Project Setup Google Apps Script3:272 Search YouTube3:443 Use Data Results From Search3:544 Create a Web App5:345 Create HTML index page6:586 Get Data from Google Script3:477 Output Results to HTML Page4:148 Output Results to HTML Page 26:199 Output Results to HTML Page 32:4610 Add to Spreadsheet5:0511 Code Review youTube Project5:09
- Spreadsheet UI email functionality0 Email from Spreadsheet Introduction4:381 Google Apps Script Bound Script2:252 Start Scripting6:593 Get Values from Spreadsheet3:514 Create User Object4:515 Alert UI Buttons Yes No3:526 HTML Template4:427 Send Email Message3:128 Update Spreadsheet column4:439 Final Code Review5:01
- Fun with Spreadsheet series of mini projects that are useful for many projects0 SpreadsheetApp Introduction2:451 Bound Script Starter Lesson5:112 Add More Content to Spreadsheet10:503 Spreadsheet Formulas5:294 Update Sheet Content7:175 Spreadsheet UI4:446 Finder and Replace Content5:237 Finder and Replace Content 29:528 Get Cell Values7:159 Get Content as HTML8:1110 Email Spreadsheet HTML table3:3211 Copy Spreadsheet as PDF5:3312 Copy Spreadsheet as PDF 25:4813 Copy Spreadsheet as PDF 33:4114 Content Copy5:2315 Search Drive Files2:5816 Search Drive Files 25:48v17 Value Checker if Exists6:2918 Course Conclusion Code Review7:49
- API Data From Spreadsheet0 Google Get Post Web API Introduction3:001 Web Developer Setup5:022 Write Google Apps Script3:383 Get Spreadsheet Data5:594 Web App Content5:295 Connect to WebApp URL5:156 Post Data to Sheet7:077 WebApp POST3:238 Add POST to Spreadsheet5:259 DeBug and Clean Web App5:1910 Application Conclusion Code review5:28
- Google Drive Image Gallery0 Introduction Image Gallery2:261 Web Application Setup5:582 Google Script Web App5:363 Get Drive Images9:144 Connect to WebApp JSON4:225 Create Page Elements3:106backup JavaScript Popup Image Modal Part 26:567 JavaScript Popup Image Modal Part 23:538 Code Review Image Gallery8:09
- Google Apps Script Make Images HTML5 Canvas save to Gdrive0 Image Uploader Project Introduction2:561 Google Apps Script Web App4:252 Images as base646:523 Base64 image client side7:064 Client Side Options4:275 Client Side JavaScript7:116 Add Text to Canvas5:007 Add Logo to Canvas2:378 Upload Image to Canvas6:469 Save Canvas Image to gDrive4:1710 Google Apps Script Save Image7:2711 Final Tweaks and Updates5:2012 Image Uploader Project Conclusion6:55
- Google Apps Script WYSIWYG editor and email HTML maker0 HTML Editor Introduction4:041 WYSIWYG Project Setup4:252 Create a Apps Script Web App4:483 Output File in Web App3:194 Client Side Coding Project4:455 Client Side Request Values3:566 Create Editor on Client Side4:437 Client Side Options Setup5:088 Add Button Events4:199 Add Button Events 22:4210 Save HTML as file to gDrive 15:0211 Save HTML as file to gDrive 27:1012 Save HTML as file to gDrive 34:5913 Load File Names as options3:2914 Existing Files Options4:2515 Load File Contents HTML4:1816 Add File Names7:5917 Create as PDF File7:5418 Send HTML Email5:0319 Final Project Conclusion Editor R11:1320 Load File By ID into Editor R7:18
- Google Apps Script Form Submission Send Email0 Course Introduction4:321 Google Script Setup5:062 Create Form3:333 Google Apps Script4:254 Setup Form Trigger6:025 On Form Submit4:476 Send Email8:007 Object Send Email6:088 Final Tweaks and Testing6:26
- Google Apps Script PDF uploader Project0 PDF Uploader Project Section3:031 Getting started with Apps Script3:412 Create a simple Script6:143 Spreadsheet App11:594 Update Spreadsheet content4:525 Get Content from Spreadsheet7:526 Add Content to Spreadsheet7:237 Spreadsheet content4:578 Create Web App6:009 Templated HTML webApp7:3310 Sheet Values on Client Side8:2911 Upload PDF to Drive8:3612 Upload PDF to Drive 29:5613 Upload PDF to Drive 37:3014 Project Review Conclusion10:33
- Google SitesQuick Start Google Sites0:570 Google Sites Introduction3:421 Introduction to Google Sites2:292 Getting Started with Sites4:213 Looks and Feel Themes4:024 Page Layouts4:265 Add more Pages6:146 Publish Site2:477 Delete Restore Site2:398 Add Images, Files and Scripts5:409 Add Google Script Web App4:2310 More Content Options25:0011 Google Sites Conclusion2:49
- Gmail App Class Get Email Threads Email Image Project0 Image Gmail to Drive Project Introduction section1:511 Get inbox threads5:142 View GmailThread Info7:333 check for attachments7:494 Copy Image To GDrive5:025 Move Emails Add Labels5:346 Get Active User2:287 Move Image to Folder Project 16:378 = Move Image to Folder Project 28:579 Code Review and Conclusion5:20
- WebApp Sheet data as API0 Sheet Data as JSON API Introduction3:171 Create Google Script3:522 Use HtmlService createHtmlOutput8:263 parameters in the URL6:284 Client side - Server Side Code5:315 Output from a file8:306 Spreadsheet Data8:217 Spreadsheet Data 22:338 Data as JSON Output5:099 SheetData as JSON Output2:3710 WebPage Connection Fetch6:1011 Request parameters3:1812 Request parameters 24:5213 Sheet Data as JSON API Conclusion1:19
- Google Apps Script Consent Form Exercise - JavaScript CloudIntroduction Google Apps Script Consent Form Exercise2:301 Setup Google Script4:232 Developer Environment11:443 HtmlService Output HTML6:154 HtmlService Try and Catch2:345 HTML form submission to GS9:166 Google Script RUN5:197 SpreadSheet App add data10:068 Send and Email with PDF of Doc10:289 Add to Sites4:5910 Source Code Overview6:18
- Google Sheets as JSON data source for JavaScript0 Spreadsheet as JSON introduction2:071 SpreadSheet Setup4:332 Google SpreadSheet as JSON5:123 JavaScript Fetch JSON5:484 Get JSON Promiseall JavaScript Example9:595 Code explained JavaScript Map8:156 Code explained JavaScript Promise All5:597 Spreadsheet Data Clean Up JSON10:588 Build the object using Sheet name4:209 Output Sheet data to HTML5:03
- Google Apps Script - Project Exercise Spreadsheet web app Team Site on Sites0 Team Site Introduction2:210 Google Script Google Sites Project23:071 Google Apps Script Introduction4:022 Google Apps Script Create First Script5:503 Run your Script make things Happen10:234 Output HTML Create webapp5:315 Create Index page as HTML7:296 Get user Session Email1:247 Build Client Side Code JavaScript5:308 Get Spreadsheet content to client side8:409 JavaScript Build Post Output4:1510 Build Output Items4:1011 Bring web app into Google Sites6:3212 Submit a new post to Spreadsheet6:2513 Send Data to Google Script8:5814 Google Script Sort Column Data5:0115 Detect URL parameter Page number5:5116 Add Pagination Pages for posts28:3217 Add Pagination Pages part 26:1918 Add Pagination Pages part 3-211:3019 Application Tweaks3:4320 Remove Record from Spreadsheet7:2321 Update Spreadsheet data remove row6:2822 Date Sort Bug Fixes3:2323 Style and Updated View Content7:5024 Final Tweaks6:47
Google Apps Script 2020: Build 16+ Fun Projects Sites GSuite
Laurence Svekis | Instructor | Google Development Expert | Application Developer
581,302 Total Students
33,520 Reviews
Description
Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with G Suite. This course gives you an introduction to Google Apps Script. Find out how it works, get a quick refresher on JavaScript fundamentals like variables, arrays, objects, loops, functions, and conditions. Try it out and see with just a few lines of code how you can create a doc, spreadsheet access the Google Calendar add events and send emails with Script. This course comes with 16 projects that you need to build while you learn.
1,082 positive reviews from 7,640 students enrolled
- Access 233 lectures & 21 hours of content 24/7
- Build amazing web apps
- Connect to your Google Spreadsheet as a source of data for your website
- Emails users with the power of Gmail
- Track users in a spreadsheet
- Get messages from users right into a spreadsheet
- Share content of your drive
Projects
- Form Submission auto response
- YouTube API - Connect to YouTube
- Spreadsheet User data Project
- Spreadsheet Mini Projects
- Spreadsheet Data as API JSON
- GDrive Image Gallery
- HTML5 Canvas image uploade
- HTML editor saving HTML files
- Simple Auto Response
- PDF Uploader
- GmailApp
- WebApp Sheet Data as API
- Consent Form Exercise: JS Cloud
- Google Sheets, JSON data source for JS
- Build a team site on sites
- Simple Google Sheet input
"I am very pleased with this course, it has great real-life examples. The teacher explained it all in depth and it is easy to follow. Thanks Laurence!" – Ivan Josipovic
Specs
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: all levels
- Have questions on how digital purchases work? Learn more here
Requirements
- Any device with basic specifications

Google Apps Script: Set Up Simple Twitter Posting Bot

Google Apps Script Complete Course: Beginner to Advanced

Google Apps Google Script: Content System Web App Project

Google Apps Script Projects

Google App – Gmail: Increase your Email Productivity

Dynamic Quiz App Using Google Sheets as Source Google Script
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.