Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script
Explore what you can do with Google Apps Script in Workspace. 🚀 Dive Deep into Google Apps Script with These Starter Projects! 🚀 Are you looking to boost your productivity and automate your workflows within Google Workspace? Look no further! Our latest blog post unveils a series of Google Apps Script exercises designed to … Read more
5 CODING Exercises Google Apps Script Exercises Explore what you can do with Google Apps Script in Workspace 1. Custom Email Campaign Manager Objective: Create a script that fetches contacts from a Google Sheets document, creates personalized emails based on a template, and sends them at scheduled intervals. Include functionality to track which contacts have already … Read more
Automating Google Docs Management with Apps Script: Splitting Documents by Headings In today’s fast-paced digital environment, efficiency and automation are key to handling documents and data. Google Apps Script offers a powerful way to automate tasks within Google Workspace, including Docs, Sheets, and more. One common task is the management of large documents, particularly when … Read more
Google Apps Script that removes blank lines from a Google Doc, you can use the following script. This script iterates through all the paragraphs in the document and checks if any of them are empty (i.e., contain only whitespace characters or nothing at all). If an empty paragraph is found, it is removed from the … Read more
Google Apps Script that inserts page breaks in a Google Doc just before each H3 element, you can follow this approach. This script iterates through the document’s elements, identifies H3 headings, and inserts page breaks immediately before each H3 element. How to Use This Script: This script checks each paragraph to determine if it’s styled … Read more
To modify the script to add each “Answer” item as a new line immediately following where it was removed, rather than at the end of the document, we need to adjust the logic to insert a paragraph right after the detected list item’s position. Here’s how you can do it: This script differs from the … Read more
🚀 Leveraging Google Apps Script: A Game-Changer for Web Developers! 🚀 Hey fellow developers and tech enthusiasts! Today, I want to dive into something that’s been a game-changer for me and could be for you too – Google Apps Script. It’s not just another tool; it’s a powerhouse for automating, integrating, and enhancing our web … Read more
Objective: Use Google Apps Script to send an email to a specific recipient. Instructions: Explanation: This script uses the MailApp.sendEmail() method to send an email. It requires the recipient’s email address, the subject of the email, and the body of the email as parameters. Code: function sendMyEmail(){ const recipient = “email@gmail.com”; const subject = ‘Test … Read more
Programmatically create a new Google Doc and insert text into it Instructions: Explanation: This script creates a new Google Doc titled “New Google Doc” and then inserts a paragraph of text into the document. Code: function createGoogleDoc(){ const paraContents = ‘My Name is Laurence Svekis’; const doc = DocumentApp.create(‘New Google Doc’); const body = doc.getBody(); … Read more
Objective: Read and log data from the first cell in a Google Sheets spreadsheet. Code: function readSpreadsheetData() { const ss = SpreadsheetApp.getActiveSpreadsheet() const sheet = ss.getSheetByName(‘Sheet1’); const range = sheet.getRange(‘A1’); const value = range.getValue(); Logger.log(value); } Instructions: Explanation: This script gets the active sheet of the current spreadsheet, accesses cell A1, reads its value, and … Read more