Code Snippet

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