Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script has been a powerful tool for automating and extending Google Workspace applications. Recently, Google introduced a new Integrated Development Environment (IDE) for Apps Script, packed with features designed to enhance the development experience. In this blog post, we’ll explore the new Apps Script IDE and how it can improve your scripting workflows. … Read more
We’ve all been there. You sit down to write an email, only to find yourself staring at a blank screen, crafting the same basic message you send all the time. What a waste of time, right? Well, fret no more! Google Workspace for Gmail has a handy feature called templates that can be your secret … Read more
Google Apps Script is a powerful tool that allows you to automate tasks across Google’s suite of apps. One practical use case is to create an API endpoint that outputs data from a Google Sheet as JSON. This can be particularly useful for integrating Google Sheets data with other applications. In this blog post, I’ll … Read more
🚀 Free on Kindle Until June 8th, 2024! 🚀 Get source code for this book at https://github.com/lsvekis/FrontEnd-Code-PlayGround Amazon US https://www.amazon.com/dp/B0D2G6BG3J CAN https://www.amazon.ca/dp/B0D2G6BG3J “FrontEnd Code Playground: HTML, CSS, and JavaScript Exercises to Develop Your Skills” is a comprehensive guide designed to accelerate your learning journey in front-end development. Authored by Laurence Lars Svekis, a seasoned web … Read more
In this tutorial, we will create a Google Apps Script that highlights duplicates in a specified column of a Google Sheet. The script will ignore the first occurrence of each value and only highlight subsequent duplicates. This can be particularly useful for data analysis, ensuring that you can easily spot repeated entries. Step-by-Step Guide Step … Read more
Unveiling the Extraordinary: Dive into “Echoes of the Unknown” (Free on Kindle!) Get this book free on Kindle for the next 4 days https://www.amazon.ca/dp/B0D5F6XRF2 Are you ready to enter a world where the ordinary meets the extraordinary? My latest book, “Echoes of the Unknown: Tales of Mystery and the Supernatural,” is a captivating collection of … Read more
Google Apps Script is a powerful tool for automating tasks across Google Workspace applications. In this blog post, we will walk through how to use Google Apps Script to update specific paragraphs in a Google Doc. We will cover two functionalities: We’ll also include an image to enhance the visual appeal of this post. Step-by-Step … Read more
Google Apps Script is a powerful tool that allows you to automate tasks across Google Workspace applications. In this blog post, we’ll walk through how to use Apps Script to update a specific paragraph in a Google Doc that contains only the words “Multiple Choice Questions” and change its formatting to an H4 heading. Step-by-Step … Read more
JavaScript is a powerful and versatile language, but it comes with its own set of quirks and oddities. Understanding these can help you write better code and debug issues more effectively. Here are ten lesser-known JavaScript quirks, complete with detailed examples. 1. Type Coercion in Comparisons JavaScript performs type coercion when comparing values with == … Read more
Printing documents programmatically can be very useful in automating workflows, especially when dealing with repetitive tasks. Google Apps Script provides a way to print documents from Google Docs, either as a whole or selectively. In this blog post, I’ll guide you through creating a Google Apps Script that prints an entire document or specific parts … Read more