Apps Script Code Examples

Introduction: In today’s digital age, personalization is key to maintaining connections, whether it’s with friends, family, or colleagues. One way to add a personal touch is by sending birthday greetings. However, manually keeping track of everyone’s birthdays and sending emails can be time-consuming and prone to errors. Fortunately, with the power of Google Sheets and … Read more

Here’s a Google Apps Script code to create 3 Google Docs with some random content within each function createBlogPosts() { var docTitles = [“Blog Post 1”, “Blog Post 2”, “Blog Post 3”]; // Loop through each title to create a document for (var i = 0; i < docTitles.length; i++) { var doc = DocumentApp.create(docTitles[i]); … Read more

Simplifying Google Apps Script to Convert PDF to Text please note Google’s OCR can read the text. The quality of the OCR results can vary based on the PDF content, such as images or scanned documents. You need to enable Drive Service V3 https://developers.google.com/apps-script/advanced/drive In this blog post, we’ll explore how to use Google Apps … Read more

Google Apps Script provides a powerful platform for automating tasks and extending the functionality of Google Workspace applications. In this tutorial, we’ll walk you through the process of creating a web app form that submits data to a Google Sheet when submitted. We’ll cover both the client-side code (HTML and JavaScript) and the server-side code … Read more

Sending HTML formatted emails allows you to include styling, images, and a structured layout that can enhance the communication and engagement of your emails. Google Apps Script provides a straightforward way to achieve this, leveraging the Gmail service. Here, we’ll walk through how to set up a script that sends an HTML email, and we’ll … Read more

Ever needed to display data from Google Sheets on a webpage in a manageable and organized way? Whether for a dashboard, a report, or any interactive project, paginating data on a web app can vastly improve readability and user experience. In this post, we’ll walk you through building a simple web app that fetches data … Read more

When working with documents, especially those that have been edited by multiple people or have undergone numerous revisions, the formatting can often become inconsistent. This is particularly true for heading styles, which are crucial for maintaining the structure and readability of a document. In this blog post, I’ll walk you through how to use Google … Read more

In document editing and formatting, there are often specific rules or formats that need to be applied for clarity and consistency. One common requirement might be to merge a standalone header or label with its corresponding content in the paragraphs that follow. This tutorial will guide you through the process of creating a Google Apps … Read more

Google Docs is a powerful tool for collaboration and document editing. While it offers many built-in features, sometimes you might need to perform specific tasks that aren’t directly supported out of the box. One such task is converting bullet points into plain text paragraphs. In this blog post, I’ll guide you through creating a Google … Read more

Formatting documents in Google Docs can often require repetitive manual adjustments, especially when preparing professional or academic documents that need a consistent layout. One common formatting task is adding spaces above headings to improve readability and structure. This blog post will guide you through automating the process of adding a space above every H3 heading … Read more