London Ontario 2025 Summary of the Presentation: Unleashing the Power of Google Apps Script and Gemini

Meet me at https://gdg.community.dev/events/details/google-gdg-london-presents-google-devfest-2024-london-on-ca/ Devfest in London Jan 25, 11:00 AM – 3:00 PM (EST) Western University, 1151 Richmond St, London, N6A 3K7 This presentation by Laurence Svekis explores the integration of Google Apps Script and Gemini AI to streamline workflows, enhance automation, and unlock new possibilities in Google Workspace. It provides an overview of Apps Script as a … Read more

Organizing Your Google Docs with Apps Script: A Guide to Sorting Sections by Headings

When working on large Google Docs, organizing content systematically can be daunting, especially if you’re dealing with sections categorized under specific headings. This is where Google Apps Script comes to the rescue! In this blog post, we’ll explore a function, reorganizeDocByHeading2, that reorganizes the content of a Google Doc based on predefined categories under “Heading … Read more

Apps Script that counts the number of Heading 4 elements in a Google Doc

Apps Script Code function countHeading4InDocument() { const DOCID = ‘YOUR_DOCUMENT_ID_HERE’; // Replace with your Document ID const doc = DocumentApp.openById(DOCID); const body = doc.getBody(); const paragraphs = body.getParagraphs(); let heading4Count = 0; // Iterate through all paragraphs for (let i = 0; i < paragraphs.length; i++) { const paragraph = paragraphs[i]; if (paragraph.getHeading() === DocumentApp.ParagraphHeading.HEADING4) … Read more

Apps Script that adds a blank line above every occurrence of the word

Apps Script Code function addBlankLineAndBoldExplanation() { const DOCID = ‘YOUR_DOCUMENT_ID_HERE’; // Replace with your Document ID const doc = DocumentApp.openById(DOCID); const body = doc.getBody(); const paragraphs = body.getParagraphs(); // Iterate through all paragraphs in the document for (let i = 0; i < paragraphs.length; i++) { const paragraph = paragraphs[i]; const text = paragraph.getText().trim(); // … Read more

Apps Script code that adds a horizontal line above each Heading 4

Apps Script Code function addHorizontalLineAboveHeading4() { const DOCID = ‘YOUR_DOCUMENT_ID_HERE’; // Replace with your Document ID const doc = DocumentApp.openById(DOCID); const body = doc.getBody(); const paragraphs = body.getParagraphs(); // Iterate through the paragraphs in reverse order for (let i = paragraphs.length – 1; i >= 0; i–) { const paragraph = paragraphs[i]; // Check if … Read more

Automating Document Formatting: Convert and Update Heading 3 to Heading 2 in Google Docs

Organizing a Google Doc can often involve repetitive tasks like updating headings or restructuring content. One such common task is converting specific headings to a different style while modifying their text content. In this blog post, we’ll explore a handy Google Apps Script that automatically updates Heading 3 elements to Heading 2, transforms their text … Read more

Automating Document Cleanup: Consolidate Duplicate Categories in Google Docs with Apps Script

Managing content in a Google Doc can be tedious, especially when dealing with repetitive headings and disorganized structure. If you’ve ever faced the challenge of consolidating duplicate categories while retaining their content, this blog post is for you. We’ll explore a simple Google Apps Script that automates this task, ensuring your document stays clean, organized, … Read more

Resetting Google Docs Heading Styles with Google Apps Script

Google Docs is an excellent tool for creating and managing documents, but sometimes the formatting can get messy, especially when headings have inconsistent styles. Whether it’s due to manual adjustments or imported content, fixing heading styles manually can be tedious. Fortunately, Google Apps Script provides a simple solution to reset all headings in a document … Read more

Simplify Google Docs with Google Apps Script – Automate Heading Cleanup

If you work extensively with Google Docs, you’ve probably found yourself needing to clean up headings or rearrange content. Repetitive tasks like updating headings or removing redundant lines can consume valuable time. Thankfully, Google Apps Script provides a powerful way to automate such tasks. In this post, we’ll walk through a Google Apps Script function … Read more

8 Free Books in January 2025 Discover These 7 Amazing Books on JavaScript and Google Apps Script – Free on Kindle for a Limited Time!

Discover These 7 Amazing Books on JavaScript and Google Apps Script – Free on Kindle for a Limited Time! Looking to expand your programming skills or deepen your understanding of JavaScript and Google Apps Script? You’re in luck! For a limited time, you can grab seven incredible eBooks for free on Kindle. These books cover … Read more