Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
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
🎮 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
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
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
he Fetch API is an essential tool in modern JavaScript for making HTTP requests, replacing the older XMLHttpRequest method with a more modern and flexible promise-based approach. Whether you’re a complete beginner or someone looking to polish your skills, learning how to use the Fetch API is a great way to enhance your web development … Read more
Google Docs provides a powerful platform for creating and organizing documents, but managing heading levels across a document can sometimes become tedious. If you’ve ever wanted to automatically adjust headings to one level lower throughout a document, you’re in luck! The updateHeadingLevels script simplifies this process, ensuring all headings are updated correctly while preserving formatting. … Read more
Google Apps Script is a versatile tool that can simplify repetitive tasks in Google Sheets. In this post, we’ll explore a script that automates the process of matching course codes from multiple sheets and adding them as additional columns in a main sheet. This solution is perfect for managing large datasets where matching values across … Read more
Google Apps Script is a powerful tool that lets you automate tasks and enhance the functionality of your Google Sheets. In this post, we’ll walk you through how to create a script that filters data from a sheet named main and copies rows with non-empty values in columns A, B, and C into a new … Read more
Fetching data from an API and displaying it on a webpage is a foundational skill for any web developer. In this blog post, we’ll guide you through a simple example of fetching data from a REST API and dynamically outputting it on your webpage using JavaScript. This example covers: Let’s dive into the implementation! The … Read more
In this tutorial, we’ll walk through a simple yet fun project: building a webpage that fetches and displays a random dog image using the Dog CEO API. Whether you’re new to JavaScript or looking for a practical example of using the fetch() API to interact with a third-party service, this post has something for everyone. … Read more