Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script
Laurence Svekis, a recognized Google Developer Expert (GDE) for Google Workspace, is known for his live speaking events that focus on empowering developers with Google Apps Script and AI integrations. Over the years, Laurence has shared his expertise in automating workflows, enhancing productivity within Google Workspace, and utilizing APIs to streamline development processes. Laurence’s talks … Read more
Formatting content in Google Docs can sometimes require manual adjustments that are both time-consuming and prone to errors, especially when working with large documents. One common formatting issue involves headings that start with unnecessary characters, such as colons, which can disrupt the visual flow and readability of your document. In this post, I’ll show you … Read more
Google Apps Script is a powerful tool that enables you to automate tasks and extend the functionality of Google Workspace apps, including Google Docs. In this blog post, we’ll explore a practical script that merges paragraphs into the preceding H3 headings and removes trailing colons from those headings. This can be especially useful for formatting … Read more
In Google Apps Script, the Logger class provides simple logging functionality that can help you debug your scripts by recording messages in the Google Apps Script log. This log can be viewed in the Apps Script editor under the “Executions” or “Logs” tabs. Basic Usage of Logger.log The Logger.log method is used to record messages. … Read more
In this blog post, we will delve into a Google Apps Script function that calculates the cost per item, considering any applicable discounts. This script is especially useful for e-commerce platforms or any other scenarios where discounts and coupon codes are used to determine the final cost of products. We will explain the code in … Read more
Google Apps Script is a powerful tool that allows you to automate tasks and enhance your Google Sheets capabilities. In this blog post, we will demonstrate how to use Google Apps Script to calculate the total cost from a sample data table. This script can be especially useful for financial calculations, budgeting, or any scenario … Read more
In this blog post, we will explore how to use Google Apps Script to copy data from one Google Sheet to another. Specifically, we will copy five columns, excluding one column, and ensure that our destination sheet has an auto-incrementing number for the first column. Additionally, we will eliminate any duplicate rows in the process. … Read more
Importing data from one Google Sheet to another can streamline data consolidation and ensure that you always have the latest information in one place. Google Apps Script provides an efficient way to automate this process. In this blog post, we will walk through how to import data from one spreadsheet to another using Google Apps … Read more
Automatically generate PDFs from your Google Sheets data: Step-by-Step Guide: function createPDF() {var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();var folder = DriveApp.getFolderById(‘your-folder-id’);var pdf = DriveApp.createFile(sheet.getBlob().getAs(‘application/pdf’));folder.createFile(pdf);} Explanation:
Track and log changes in your Google Sheets data. Here’s how: Step-by-Step Guide: function onEdit(e) {var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();var range = e.range;var newValue = e.value;var oldValue = e.oldValue;var logSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘Log’);logSheet.appendRow([new Date(), range.getA1Notation(), oldValue, newValue]);} Explanation: