Video description
Google Apps Script is by far one of the best coding languages to get started with, as it allows you to access the power of all the Google services that simply work so incredibly well within the script. It is based on JavaScript, which makes it easy to get started.
You will start by learning how to write code in Google Apps Script and understand the features of Google Apps Script. You will learn to create projects and open the project to update and edit the code. Moving on, you will learn how to use the power of the Workspace services and create custom macros adding advanced functions to your spreadsheet with Google Apps Script. You will understand how to interact with Google Workspace services, see examples of using Classes in Workspace services, and learn how to access class methods.
Then we will explore some amazing applications that can be built with Google Apps Script. The projects of this course will demonstrate how to apply Google Apps Script code to create docs, create a web app with both GET and POST endpoints, make use of sheet data, get sheet data, send emails, and much more. We will wrap up the course by creating a web form that can send emails using your Gmail account.
By the end of the course, you will learn to interact with Google Workspace services and learn how to code Google Apps Script.
What You Will Learn
- Connect your code to a Google Workspace document
- Learn to create customized functionality within Google Workspace
- Learn to create projects and open the project to update and edit the code
- Learn to bring your Google Workspace to the next level
- Explore how to code Google Apps Script
- Learn how to use spreadsheet data and update it with code
Audience
This course is for Google Workspace users, web developers, and web designers. It can also be taken by application developers who want to learn Apps Script, Google Workspace users who want advanced and customized functionality, and JavaScript developers who want to learn Apps Script. This course is also useful to anyone who uses Google Workspace and wants custom functionality for Google Workspace users.
All you need is an internet connection and a Google Account, and you can start creating your coding apps.
About The Author
Laurence Lars Svekis: Laurence Svekis is an experienced web application developer. He has worked on multiple enterprise-level applications, hundreds of websites, business solutions, and many unique and innovative web applications. He has expertise in HTML, CSS, JavaScript, jQuery, Bootstrap, PHP, and MySQL and is also passionate about web technologies, web application development, programming, and online marketing with a strong focus on social media and SEO. He is always willing to help his students experience what technology has to offer and looks forward to sharing his knowledge and experiences with the world.
Table of contents
-
Chapter 1 : Getting Started with an Introduction to Google Apps Script
- Introduction to Google Apps Script
- Getting Started with Google Apps Script
- Create a WebApp URL Sharing and Deploying Scripts with Google Apps Script
- Google Workspace Services Creating a Bound Script that Powers Up Your Workspace
- Creating and Applying Code Within Your Script Helpful Resources and Tips
-
Chapter 2 : How to Do Amazing Things with Google Apps Script - Power Up Your Apps Script Code
- Introduction to Google Apps Script Power Up Your Apps Script Code
- How Marcos can Be Used to Create an App Script - Explore What an App Script Is
- How to Get Data from Your Spreadsheet and Use It Within Your Code with Script
- How to Use App Script for Creating Files on Drive and Tracking Data in Sheets
- How to Create a PDF Email from Sheet Data and Send the Email Using Sheet Data
- How to Set Up Bound Scripts Sheets UI Menu with Apps Script
- How to Create Custom Functions in Sheets with Google Apps Script Code
- How to Create Web Apps with Apps Script Launch Your Web App URL to Share
- Learn More about Creating Web Apps with Google Apps Script Do More with Web Apps
- How to Create an Apps Script Web API Endpoint for AJAX Connections Output Sheet
- Apps Script Web App Data Transfer from ClientSide to ServerSide Web App Sheet
- Google Apps Script Automation with Triggers
-
Chapter 3 : Google Workspace Services: Docs, Calendar, Drive, Forms, Gmail, and Sheets Slides
- Introduction to Google Workspace Services: Docs, Calendar, Drive, Forms, Gmail, and Sheets
- How to Use Document Service with Apps Script DocumentApp Class and Methods
- How to Set Up Form Submission to Sheet Spreadsheet Data to get responses
- Create Forms with Google Apps Script Code
- How to Use Spreadsheet Service SpreadsheetApp with Google Apps Script
- Apps Script How to Use SpreadsheetApp Update Sheets Data in Spreadsheet
- Coding Using Spreadsheet Range Selections and Updates of Cells with Apps Script
- How to Add Conditional Rules Format with Google Apps Script Code
- Apps Script How to Use CalendarApp Class Methods and Calendars in Workspace
- How to Create Apps Script Code to Access Drive Service DriveApp Functions
- Create, Move, Update Files and Folders Within Your Google Drive with Code
- Sending Emails Messages Thread Updates with GmailApp Gmail Service Functions
- Explore Slides Service with SlidesApp Class with Apps Script Code
-
Chapter 4 : Getting Started with Apps Script Projects
- Explore Google Apps Script - Connect the Power of Google Services Together
- Create a Doc with Apps Script
- How to Code DocumentApp to Create and Update Docs with Apps Script Code
- Copy Existing Docs with Google Apps Script Use the ID of a Doc to Open
- Selecting Spreadsheet Data with Apps Script
- Create New Docs Populate with Sheet Data
- How to Convert Docs to PDF and Email as Attachments
- Final Project Create Doc as PDF and Email to Sheet Data Email Address
- Chapter 5 : JavaScript and Google Apps Script Web App
- Chapter 6 : DocumentApp Bound Script Coding Projects
-
Chapter 7 : Apps Script Fetch and API Connections
- Apps Script Introduction
- How to Use Apps Script to Create a Spreadsheet
- How to Fetch Request a Web URL and Return the Response Data Apps Script UrlFetch
- How to POST with Apps Script UrlFetchApp Send Data to Endpoint API
- How to Send an Attachment with Apps Script Advanced Mail Options MailApp
- How to Output Google Sheet Data as JSON into a Web App
- Chapter 8 : Google Apps Script Coding Examples and Helpful Code Snippets
Product information
- Title: Google Apps Script - Exercise Coding Projects
- Author(s):
- Release date: June 2022
- Publisher(s): Packt Publishing
- ISBN: 9781804611760
You might also like
video
Google Apps Script for Developers
In this Google Apps Script for Developers training course, expert author Bruce Mcpherson will teach you …
video
Google Apps Script - A Project-Based Exercise Using Spreadsheets and Web Apps
Group site project with Google Script - Google Site and Web apps - Spreadsheet Do you …
video
Micro Applications with Google Apps Script
The course shows you how to apply a Google Apps Script to create a time-saving micro-application …
video
Google Apps Script for Beginners
Google Apps Script is a scripting language used in conjunction with Google web-based applications (Google Docs, …