Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Are you looking for a simple and effective way to translate text in your web applications? In this blog post, we’ll walk through building a multi-language translator using Google’s free Translate API and JavaScript. This lightweight solution lets users enter text, select a target language, and get instant translations—all without an API key or complex … Read more
Managing large documents in Google Docs can be challenging, especially when dealing with multiple sections under Heading 1. Manually splitting these sections into separate documents is time-consuming and prone to errors. With Google Apps Script, we can automate this process by identifying each Heading 1 section and creating a new document for each. This script … Read more
🚀 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