Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script
To create a web application using Google Apps Script that outputs the contents of a Google Spreadsheet into a client-side JavaScript object, you’ll need to write code for both the server-side (Google Apps Script) and the client-side (HTML with embedded JavaScript). Here’s how you can set it up: 1. Google Apps Script: Server-Side First, you’ll … Read more
You can achieve this task using Google Apps Script, which allows you to automate actions within Google Docs. The script below selects all H4 elements in a Google Doc and converts them to regular text that is bolded. This is done by finding all the text elements formatted as Heading 4, changing their attributes to … Read more
Creating a Table of Contents (ToC) in a Google Docs document using Google Apps Script, focusing only on Heading 1 styles, is a straightforward task. Below is a script that does exactly that. It scans through your document, identifies all the text that has been styled as Heading 1, and then generates a ToC at … Read more
Unlock the Power of Google Workspace with “Coding with Google Apps Script: A Step-by-Step Journey” – Free on Kindle for a Limited Time! Are you looking to dive into the world of Google Apps Script and transform the way you interact with Google Workspace? Look no further! For a limited time, the best-selling book “Coding … Read more
Unlock the Full Potential of Google Workspace with “Coding with Google Apps Script: A Step-by-Step Journey” – Free on Kindle for a Limited Time! Read the first 2 chapters Free at Amazon – Get your free Kindle version of the book today US https://www.amazon.com/dp/B0CXXLMMHQ Can https://www.amazon.ca/dp/B0CXXLMMHQ Over 200 Apps Script Coding Exercises here https://github.com/lsvekis/Coding-with-Google-Apps-Script/ In … Read more
This guide will walk you through creating a basic web app that dynamically loads HTML content without refreshing the page, enhancing your site’s interactivity and speed. To update your Google Apps Script web app to dynamically load HTML content without reloading the page, and to incorporate JavaScript addEventListener for better handling of user interactions, follow … Read more
The book on Google Apps Script offers a thorough exploration into the world of automation within the Google Workspace, catering to both novices and seasoned users through its extensive range of practical examples that span from basic concepts to sophisticated techniques. It begins with an introduction to the core principles of Google Apps Script, acquainting … Read more
This cheat sheet provides a quick reference to commonly used JavaScript syntax and constructs tailored for Google Apps Script development. Variables and Data Types Declaring Variables: var name = ‘John’; // Old-school JavaScript variable (function-scoped) let age = 25; // Preferred for block-scoped variables const isStudent = true; // Constant value Data Types: let string … Read more
Language Basics: JavaScript Fundamentals for Google Apps Script Google Apps Script is built on JavaScript, one of the most popular programming languages. Understanding the basics of JavaScript is crucial for creating effective Google Apps Scripts. Below, we’ll explore key JavaScript fundamentals that you’ll frequently use in Apps Script. Variables and Data Types In JavaScript, variables … Read more