What you'll learn:
- Build interesting projects that can be used to develop Google Apps Script Skills
- Super Charge your Google G Suite Apps with Google Apps Script - over 19 Projects ready for you
- Learn G Suite Google Apps Script and how to custom code your G Suite with Amazing functions
- How to apply Google Apps Script in Projects
- Explore how to use Google Apps Script - Classes and Methods to power up GSuite
- How to apply Google Apps Script
Google Apps Script will amaze you
This course is packed with content designed to teach you how to use Google Apps Script and build powerful real world projects. Full source code is included.
New content and projects are added regularly. Be sure to check the final sections of the course for the latest projects and updates.
Even if you have never seen Google Apps Script before, this course is designed for you. When you connect Google Workspace products together with Apps Script, you unlock powerful workflows that save time and let you build impressive applications with minimal code.
This course is taught by an official Google Developer Expert for Google Workspace. You will learn how to create powerful applications by connecting Google Workspace products using Google Apps Script.
This is the perfect course for anyone who wants to truly understand and use Google Apps Script.
No prior Apps Script experience is required. A complete step by step introduction covers the JavaScript fundamentals you need to get started. You will be able to impress friends, family, and colleagues with what you can build using Google Apps Script.
Write a small amount of code and accomplish a lot with Google Apps Script.
Student feedback includes
I never knew Google Apps Script could do all this
This course was perfect for learning and building my own projects
I think I found a new career path and I love Google Apps Script
This is simply amazing
Google Apps Script is easy to learn and as a JavaScript developer I picked it up quickly
Everything you need to get started with Google Apps Script is included in one comprehensive course.
Google Apps Script is a scripting platform developed by Google for lightweight application development within Google Workspace.
What you will build and learn
Build powerful web apps
Use Google Sheets as a data source for your website
Connect web apps using JavaScript and fetch requests
Send automated emails using Gmail
Track and manage users in Google Sheets
Collect user messages directly into spreadsheets
Create image galleries from files stored in Google Drive
Automate repetitive tasks and workflows
Google Apps Script allows rapid application development and seamless integration with Google Workspace services.
No traditional database is required. Use Google Apps Script as your backend to save time and simplify development.
Build with Google
Google Apps Script provides feature rich APIs to extend Google services and build custom web applications.
Code directly in your browser
All you need is a web browser to build and deploy Apps Script projects.
Share and publish your apps
Store and manage projects in Google Drive or publish them as web apps.
You will learn the core concepts of Google Apps Script, which is based on JavaScript, and how to connect Google Workspace products together to build powerful solutions. Each lesson focuses on practical projects that take you from idea to finished application.
Each section is self contained. You can skip ahead if you already know the material and choose the projects that interest you most.
Course content and projects
Introduction to Google Apps Script
Learn how Apps Script works and review JavaScript fundamentals such as variables, arrays, objects, loops, functions, and conditions. Create documents, access spreadsheets, add calendar events, and send emails using just a few lines of code.
Project 1 Form submission autoresponder
Create custom email responses triggered by form submissions. Connect Google Workspace services to automate workflows.
Project 2 YouTube API integration
Connect to YouTube and retrieve video data for use in web applications. Build a web app that searches YouTube and displays results.
Project 3 Spreadsheet user management dashboard
Store user data in Google Sheets and perform actions such as sending emails and updating records directly from the spreadsheet interface.
Project 4 Spreadsheet mini projects
A collection of useful spreadsheet code snippets and mini projects that demonstrate commonly requested functionality.
Project 5 Spreadsheet data as a JSON API
Output spreadsheet data as JSON and use it as a data source for websites using JavaScript fetch.
Project 6 Google Drive image gallery
Use Google Drive as an image source and build a dynamic image gallery for your website.
Project 7 HTML5 Canvas image uploader
Create images in an HTML5 canvas, add text and logos, and save the final images to Google Drive.
Project 8 HTML editor with file saving
Use a rich text editor to create and edit HTML files stored in Google Drive.
Project 9 Simple email autoresponder
Create email templates, use triggers, and track responses in Google Sheets.
Project 10 PDF uploader
Create PDF files using blobs and send them via email.
Google Sites overview
Learn how to use Google Sites to host and showcase your web apps and projects.
Project 11 Gmail automation
Send emails with image attachments, save files to Google Drive, and organize messages using Gmail labels.
Project 12 Web app Sheets data API
Expose Google Sheets data as a web API using Apps Script.
Project 13 Consent form web app
Build a form based web app that generates a PDF copy of user responses.
Project 14 Google Sheets as a JSON data source
Use Google Sheets as a backend data source for JavaScript driven websites.
Project 15 Team site message board
Build a team posting board using Google Sites, Google Sheets, and Apps Script.
Project 16 Website form to Google Sheets
Submit data from a website directly into a Google Sheet.
Step by step learning with clear explanations
Fast and friendly support available in the Q and A section
Experienced instructor with over 20 years of development and teaching experience
You have nothing to lose. Join now and start building powerful, time saving applications with Google Apps Script.
Create your own automation powered applications with Google Apps Script and Google Workspace.
