Apps Script Code Examples

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

Apps Script Code Examples

by

Google Apps Script is a powerful tool for automating workflows, integrating APIs, and enhancing productivity within Google Workspace applications. In this blog post, we’ll explore five beginner-friendly projects demonstrating how to work with APIs using Apps Script. These projects will teach you how to send GET and POST requests, handle JSON and XML data, authenticate … 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