Google Apps Script - Exercise Coding Projects

Google Apps Script - Exercise Coding Projects

by Laurence Svekis
Released June 2022
Publisher(s): Packt Publishing
ISBN: 9781804611760

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

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

  1. Chapter 1 : Getting Started with an Introduction to Google Apps Script
    1. Introduction to Google Apps Script
    2. Getting Started with Google Apps Script
    3. Create a WebApp URL Sharing and Deploying Scripts with Google Apps Script
    4. Google Workspace Services Creating a Bound Script that Powers Up Your Workspace
    5. Creating and Applying Code Within Your Script Helpful Resources and Tips
  2. Chapter 2 : How to Do Amazing Things with Google Apps Script - Power Up Your Apps Script Code
    1. Introduction to Google Apps Script Power Up Your Apps Script Code
    2. How Marcos can Be Used to Create an App Script - Explore What an App Script Is
    3. How to Get Data from Your Spreadsheet and Use It Within Your Code with Script
    4. How to Use App Script for Creating Files on Drive and Tracking Data in Sheets
    5. How to Create a PDF Email from Sheet Data and Send the Email Using Sheet Data
    6. How to Set Up Bound Scripts Sheets UI Menu with Apps Script
    7. How to Create Custom Functions in Sheets with Google Apps Script Code
    8. How to Create Web Apps with Apps Script Launch Your Web App URL to Share
    9. Learn More about Creating Web Apps with Google Apps Script Do More with Web Apps
    10. How to Create an Apps Script Web API Endpoint for AJAX Connections Output Sheet
    11. Apps Script Web App Data Transfer from ClientSide to ServerSide Web App Sheet
    12. Google Apps Script Automation with Triggers
  3. Chapter 3 : Google Workspace Services: Docs, Calendar, Drive, Forms, Gmail, and Sheets Slides
    1. Introduction to Google Workspace Services: Docs, Calendar, Drive, Forms, Gmail, and Sheets
    2. How to Use Document Service with Apps Script DocumentApp Class and Methods
    3. How to Set Up Form Submission to Sheet Spreadsheet Data to get responses
    4. Create Forms with Google Apps Script Code
    5. How to Use Spreadsheet Service SpreadsheetApp with Google Apps Script
    6. Apps Script How to Use SpreadsheetApp Update Sheets Data in Spreadsheet
    7. Coding Using Spreadsheet Range Selections and Updates of Cells with Apps Script
    8. How to Add Conditional Rules Format with Google Apps Script Code
    9. Apps Script How to Use CalendarApp Class Methods and Calendars in Workspace
    10. How to Create Apps Script Code to Access Drive Service DriveApp Functions
    11. Create, Move, Update Files and Folders Within Your Google Drive with Code
    12. Sending Emails Messages Thread Updates with GmailApp Gmail Service Functions
    13. Explore Slides Service with SlidesApp Class with Apps Script Code
  4. Chapter 4 : Getting Started with Apps Script Projects
    1. Explore Google Apps Script - Connect the Power of Google Services Together
    2. Create a Doc with Apps Script
    3. How to Code DocumentApp to Create and Update Docs with Apps Script Code
    4. Copy Existing Docs with Google Apps Script Use the ID of a Doc to Open
    5. Selecting Spreadsheet Data with Apps Script
    6. Create New Docs Populate with Sheet Data
    7. How to Convert Docs to PDF and Email as Attachments
    8. Final Project Create Doc as PDF and Email to Sheet Data Email Address
  5. Chapter 5 : JavaScript and Google Apps Script Web App
    1. Introduction to Creating a Web App URL for Webform Submission
    2. HTML Send Email Through Apps Script
    3. Send POST Request to Google Apps Script
    4. Send Email When the Form Is Submitted
  6. Chapter 6 : DocumentApp Bound Script Coding Projects
    1. Add Date to Google Doc at Cursor Document Apps Script Example
    2. Adding Images from the Web and Drive to Google Docs
    3. Copy All Images from Doc into Your Google Drive
    4. Highlight Emails in a Doc Using Regex
  7. Chapter 7 : Apps Script Fetch and API Connections
    1. Apps Script Introduction
    2. How to Use Apps Script to Create a Spreadsheet
    3. How to Fetch Request a Web URL and Return the Response Data Apps Script UrlFetch
    4. How to POST with Apps Script UrlFetchApp Send Data to Endpoint API
    5. How to Send an Attachment with Apps Script Advanced Mail Options MailApp
    6. How to Output Google Sheet Data as JSON into a Web App
  8. Chapter 8 : Google Apps Script Coding Examples and Helpful Code Snippets
    1. Google Sheets Data Exercise Sending Emails and Updating Sheet Content Using UI

Product information

  • Title: Google Apps Script - Exercise Coding Projects
  • Author(s): Laurence Svekis
  • Release date: June 2022
  • Publisher(s): Packt Publishing
  • ISBN: 9781804611760