Google Apps Script

Google Apps Script

Thank You, Hack Canada 2025 – A Truly Inspiring Event!

by

https://gdg.community.dev/events/details/google-gdg-on-campus-wilfrid-laurier-university-waterloo-canada-presents-hack-canada-build-with-ai-hackathon I want to extend a huge thank you to everyone who made the Hack Canada – #Build With AI Hackathon such an incredible experience! Over the past three days (February 21-23, 2025), we saw an amazing gathering of talent, innovation, and collaboration at the Lazaridis School of Business and Economics in Waterloo. It was … Read more

How to Add Custom Tabs in Google Docs Using Apps Script

by

Google Apps Script provides powerful automation features for Google Docs. One useful feature is inserting custom tabs within a document. In this blog post, we’ll create a script that adds two tabbed sections—“Advanced1” and “Advanced2”—allowing users to quickly navigate between them. What the Script Does ✅ Inserts two tabbed sections labeled “Advanced1” and “Advanced2”.✅ Allows … Read more

Enhancing Google Docs with Apps Script: Formatting Selected Text with Bold

by

Google Apps Script is a powerful tool for automating and enhancing Google Docs functionality. One common use case is modifying selected text dynamically, such as making it bold. In this blog post, we’ll explore a function that takes a user’s text selection in a Google Document and applies bold formatting while handling partial selections. Understanding … Read more

Automate Document Splitting in Google Docs Using Google Apps Script

by

Managing large documents in Google Docs can be challenging, especially when dealing with multiple sections under Heading 1. Manually splitting these sections into separate documents is time-consuming and prone to errors. With Google Apps Script, we can automate this process by identifying each Heading 1 section and creating a new document for each. This script … Read more

Restoring Default Heading Styles in Google Docs

by

🚀 The Problem: Restoring Default Heading Styles in Google Docs Google Docs allows users to modify heading styles to fit their needs. However, after making several changes, resetting all headings back to default styles (as defined in the document’s theme) is not straightforward. Currently, Google Docs does not provide a built-in way to reset all … Read more

The Problem: Formatting Exercises in Google Docs

by

Imagine you have content in a Google Doc that looks like this: Exercise 1: Introduction to Functions Learning Objective: Understand how functions work in JavaScript.Exercise 2: Variables and Scope Learning Objective: Learn about variable declaration and scope in JavaScript. You want to:✅ Set each “Exercise” heading to Heading 3.✅ Move “Learning Objective:” and the following … Read more

Working with APIs Google Apps Script

by

Setting up Twitter API First, create a Twitter developer account and an app to acquire the Bearer token. Then, utilize UrlFetchApp in Google Apps Script to access Twitter API, incorporating “Authorization: Bearer …” in the request header. Below is a step‐by‐step guide on how to use Google Apps Script (GAS) to connect to the Twitter … Read more

Display sheets in popup Modal

by

Apps Script Code (Code.gs) function showModal() { var html = HtmlService.createHtmlOutputFromFile(‘Index’) .setWidth(400) .setHeight(300); SpreadsheetApp.getUi().showModalDialog(html, ‘Select a Sheet’);}function getSheetNames() { var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets(); var sheetNames = sheets.map(sheet => sheet.getName()); return sheetNames;}function findSheetData(sheetName) { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName); if (!sheet) return { success: false, data: [] }; var data = sheet.getDataRange().getValues(); return { success: true, data: … Read more

Automate Heading Updates in Google Docs with Google Apps Script

by

Large documents often contain structured sections with headings. If you decide to change formatting or restructure your document, manually updating each heading can be a hassle. Google Apps Script lets you: ✅ Automate repetitive tasks – No more manual editing.✅ Ensure consistency – Keep document formatting uniform.✅ Save time – Update headings instantly. 🔹 Script … Read more

140 Google Apps Script Coding Snippets PDF Download Copding Examples Apps Script

by

Welcome to Google Apps Script: 140 Common Coding Examples, a comprehensive guide designed to equip you with essential tools and techniques for automating and enhancing Google Workspace. This book is packed with practical, easy-to-understand code snippets that streamline workflows, simplify data handling, and add powerful functionality to Google Docs, Sheets, Forms, and more. Whether you’re … Read more