Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
🚀 The Problem: Restoring Default Heading Styles in Google Docs Google Docs allows users to modify heading styles to fit their needs. However, after making several changes, resetting all headings back to default styles (as defined in the document’s theme) is not straightforward. Currently, Google Docs does not provide a built-in way to reset all … Read more
Imagine you have content in a Google Doc that looks like this: Exercise 1: Introduction to Functions Learning Objective: Understand how functions work in JavaScript.Exercise 2: Variables and Scope Learning Objective: Learn about variable declaration and scope in JavaScript. You want to:✅ Set each “Exercise” heading to Heading 3.✅ Move “Learning Objective:” and the following … Read more
Setting up Twitter API First, create a Twitter developer account and an app to acquire the Bearer token. Then, utilize UrlFetchApp in Google Apps Script to access Twitter API, incorporating “Authorization: Bearer …” in the request header. Below is a step‐by‐step guide on how to use Google Apps Script (GAS) to connect to the Twitter … Read more
🎯 Use the promo code JANB25 to unlock HUGE savings on my top-rated courses for the next 4 days only! Don’t miss out on this chance to boost your skills and level up your career at the best price available! 🔥 Did you miss a deal before? Now’s your chance! Grab these incredible courses today … Read more
Apps Script Code (Code.gs) function showModal() { var html = HtmlService.createHtmlOutputFromFile(‘Index’) .setWidth(400) .setHeight(300); SpreadsheetApp.getUi().showModalDialog(html, ‘Select a Sheet’);}function getSheetNames() { var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets(); var sheetNames = sheets.map(sheet => sheet.getName()); return sheetNames;}function findSheetData(sheetName) { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName); if (!sheet) return { success: false, data: [] }; var data = sheet.getDataRange().getValues(); return { success: true, data: … Read more
🎮 Building a Brick Breaker Game with JavaScript 🏗 Game Structure 📌 HTML Layout The game consists of a container (div.container) that holds the game elements: <div>Score: <span class=”score”>0</span> | Lives: <span class=”lives”>3</span></div><div class=”container”> <div class=”game-message”>Start Game</div> <div class=”ball”></div> <div class=”paddle”></div></div> The game-message div appears initially, allowing players to start the game when they click … Read more
If you’re working on a JavaScript project that involves handling keyboard events, you may have encountered an issue where e.keyCode no longer works. This is because e.keyCode has been deprecated and is no longer recommended for use in modern JavaScript. Instead, you should use e.key, which provides a more readable and maintainable way to detect … Read more
Large documents often contain structured sections with headings. If you decide to change formatting or restructure your document, manually updating each heading can be a hassle. Google Apps Script lets you: ✅ Automate repetitive tasks – No more manual editing.✅ Ensure consistency – Keep document formatting uniform.✅ Save time – Update headings instantly. 🔹 Script … Read more
Free JavaScript and Web Development eBooks – Limited-Time Promotions Are you looking to level up your JavaScript and web development skills? Here’s a fantastic opportunity to grab FREE eBooks on JavaScript, HTML, CSS, and web development—each packed with hands-on exercises, real-world applications, and expert insights. These books will be available for free for a limited … Read more
Welcome to Google Apps Script: 140 Common Coding Examples, a comprehensive guide designed to equip you with essential tools and techniques for automating and enhancing Google Workspace. This book is packed with practical, easy-to-understand code snippets that streamline workflows, simplify data handling, and add powerful functionality to Google Docs, Sheets, Forms, and more. Whether you’re … Read more