Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
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
On January 25, 2025, the tech community of London, Ontario came together for an incredible day of learning and collaboration at Google DevFest 2024, hosted at The D.B. Weldon Library, Western University. From 11:00 AM to 4:00 PM, over 130 enthusiastic developers, students, and tech enthusiasts gathered to explore the latest in AI, Android, Cloud, … 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
Script: function lockFirstRowAsHeading() { // Open the active spreadsheet var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); // Check if the first row is already frozen if (sheet.getFrozenRows() !== 1) { // Freeze the first row sheet.setFrozenRows(1); } // Notify the user SpreadsheetApp.getUi().alert(“The first row has been locked as a heading.”);} How It Works: Steps to Use: Result: The … 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
When working on large Google Docs, organizing content systematically can be daunting, especially if you’re dealing with sections categorized under specific headings. This is where Google Apps Script comes to the rescue! In this blog post, we’ll explore a function, reorganizeDocByHeading2, that reorganizes the content of a Google Doc based on predefined categories under “Heading … Read more
Apps Script Code function countHeading4InDocument() { const DOCID = ‘YOUR_DOCUMENT_ID_HERE’; // Replace with your Document ID const doc = DocumentApp.openById(DOCID); const body = doc.getBody(); const paragraphs = body.getParagraphs(); let heading4Count = 0; // Iterate through all paragraphs for (let i = 0; i < paragraphs.length; i++) { const paragraph = paragraphs[i]; if (paragraph.getHeading() === DocumentApp.ParagraphHeading.HEADING4) … Read more
Apps Script Code function addBlankLineAndBoldExplanation() { const DOCID = ‘YOUR_DOCUMENT_ID_HERE’; // Replace with your Document ID const doc = DocumentApp.openById(DOCID); const body = doc.getBody(); const paragraphs = body.getParagraphs(); // Iterate through all paragraphs in the document for (let i = 0; i < paragraphs.length; i++) { const paragraph = paragraphs[i]; const text = paragraph.getText().trim(); // … Read more
Apps Script Code function addHorizontalLineAboveHeading4() { const DOCID = ‘YOUR_DOCUMENT_ID_HERE’; // Replace with your Document ID const doc = DocumentApp.openById(DOCID); const body = doc.getBody(); const paragraphs = body.getParagraphs(); // Iterate through the paragraphs in reverse order for (let i = paragraphs.length – 1; i >= 0; i–) { const paragraph = paragraphs[i]; // Check if … Read more