Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
📘 Introduction Have you ever wished you could summarize the contents of multiple Google Docs with the help of AI and email the results to your inbox? This tutorial will show you how to do just that using Google Apps Script and Gemini AI. With this system, you can: This is perfect for creating executive … Read more
📘 Introduction Have you ever wanted to create Google Docs automatically and send an email summary of their contents? With Google Apps Script, you can automate this entire process. This is perfect for report generation, executive summaries, or consolidating multiple Google Docs into one easy-to-read summary. In this post, you’ll learn how to: By the … Read more
📘 Introduction Have you ever wanted to generate PDFs automatically and extract key details from them, like invoice totals? With Google Apps Script, you can automate this process. In this guide, you’ll learn how to: This is useful for managing invoices, receipts, and other financial documents. By the end, you’ll have a system that can … Read more
📢 Introduction Imagine being able to generate AI-powered content and automatically store it in a Google Doc. With Google Apps Script and the Gemini API, you can achieve this in just a few lines of code. This guide will walk you through a simple script that: By the end, you’ll have a fully functional script … Read more
📢 Introduction If you’ve ever needed test data for a project or wanted to see how to fetch and store API data into a spreadsheet, this guide is for you! With just a few lines of Google Apps Script, you can: This script is perfect for generating sample test data for development, analysis, or practice … Read more
Google Apps Script triggers are automated event listeners that run scripts automatically based on specific actions or scheduled times. With triggers, you can automate repetitive tasks, respond to user actions, and set schedules for scripts to run at specific intervals. Triggers allow you to create event-driven workflows. For example: This guide will explain what triggers … Read more
📢 Introduction Are you tired of manually generating monthly reports for your team or clients? Imagine clicking one button to automatically: With Google Apps Script, you can achieve all this with a few lines of code. In this guide, we’ll walk you through how to set up this automation step-by-step. 🎉 What Will This Script … Read more
Have you ever wished Google Sheets could do more than just standard calculations like SUM, AVERAGE, or VLOOKUP? Do you often find yourself repeating the same complex logic in multiple places? If so, it’s time to unlock the power of Custom Formulas in Google Apps Script. Custom formulas allow you to create your own functions, … 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