Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Welcome to this extensive guide on Artificial Intelligence (AI) using Node.js and JavaScript. This guide is designed to help you understand how to implement AI concepts using JavaScript on both the frontend and backend with Node.js. We’ll cover everything from getting started, understanding AI and machine learning basics, to building practical AI applications. This guide … Read more
Welcome to this comprehensive guide on implementing Artificial Intelligence (AI) using Vanilla JavaScript. This guide is tailored to help you understand how to build AI applications without relying on external frameworks or libraries. We’ll cover everything from getting started, understanding the core concepts, practical examples, code samples, quizzes with answers, and coding exercises. By the … Read more
Welcome to this extensive guide on the JavaScript Document Object Model (DOM). Whether you’re a beginner or looking to deepen your understanding, this guide is designed to help you master DOM manipulation using JavaScript. We’ll cover everything from the basics to advanced topics, complete with practical examples, coding exercises, quizzes, and valuable tips and tricks. … Read more
Welcome to this in-depth guide on Google Apps Script for Google Sheets. Whether you’re a beginner or looking to enhance your spreadsheet automation skills, this guide is designed to help you master Google Apps Script in the context of Google Sheets. We’ll cover everything from setting up your environment to building complex scripts, complete with … Read more
Managing lengthy documents can be a daunting task, especially when sections like the Table of Contents (ToC) become cluttered or outdated. Whether you’re refining a report, preparing a manuscript, or updating a collaborative project, having the ability to automate the removal of specific sections can save you valuable time and effort. In this blog post, … Read more
Here is a Google Apps Script to convert a Google Doc to a PDF and save it to your Google Drive. The script accepts the document’s ID, converts it to a PDF, and saves the file in a specified folder. Script function convertDocToPdf() { const docId = “YOUR_DOCUMENT_ID”; // Replace with your Google Doc ID … Read more
This Google Apps Script demonstrates the power of automation in Google Workspace. Whether you’re managing files in Google Drive or cleaning up messy Google Docs, this script offers a simple yet effective solution. Here’s a Google Apps Script function that performs the following tasks on a Google Doc: Script: function formatDocumentSpacing() { const doc = … Read more
Google Apps Script is a powerful tool for automating tasks in Google Workspace. In this post, we’ll explore a script that integrates seamlessly with Google Sheets, helping you manage files in Google Drive and clean up Google Docs with ease. Features of the Script This script offers three main functionalities: How It Works 1. Adding … Read more
Steps to Implement: Code: function listFilesInFolder() { const folderId = “YOUR_FOLDER_ID”; // Replace with your Folder ID const folder = DriveApp.getFolderById(folderId); const files = folder.getFiles(); const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); // Clear existing content in the sheet sheet.clear(); // Add headers sheet.appendRow([“File Name”, “File ID”, “File Path”]); while (files.hasNext()) { const file = files.next(); const fileName … Read more
Below is a Google Apps Script that will split your Google Doc into separate documents based on Heading 1 (H1) tags, using the H1 text as the new document titles. The new documents will be saved in a folder within your Google Drive. Script Code: function splitDocByHeading() { var doc = DocumentApp.getActiveDocument(); var body = … Read more