Google Apps Script

Exercise 21: Generating a Table of Contents in Google Docs Objective: Create a script to automatically generate a table of contents in a Google Document based on heading styles. Code Sample: function generateTOC() {   var doc = DocumentApp.getActiveDocument();   var body = doc.getBody();   var toc = body.appendParagraph(“Table of Contents”);   toc.setHeading(DocumentApp.ParagraphHeading.HEADING1);   var paragraphs = body.getParagraphs();   paragraphs.forEach(function(paragraph) { … Read more

Exercise 16: Automated Email Responses Using Gmail Objective: Write a script to automatically send a response to every email received with a specific subject. Code Sample: function autoRespondToEmails() {   var query = ‘subject:”specific subject” is:unread’;   var threads = GmailApp.search(query);   var response = “Thank you for your email. We will get back to you shortly.”;   threads.forEach(function(thread) … Read more

Exercise 11: Generating a Report from Google Forms Responses Objective: Create a script to generate a summary report from Google Forms responses in a Google Sheet. Code Sample: function generateFormReport() {   var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“Form Responses 1”);   var data = sheet.getDataRange().getValues();   var report = {};   for (var i = 1; i < data.length; i++) { … Read more

🚀 Boost Your Google Workspace Skills: Exciting Google Apps Script Exercises! 📊👩‍💻 Exercise 1: Create a Custom Menu in Google Sheets Objective: To create a custom menu in Google Sheets that triggers a simple script. Code Sample: function onOpen() {   var ui = SpreadsheetApp.getUi();   ui.createMenu(‘Custom Menu’)       .addItem(‘Show Alert’, ‘showAlert’)       .addToUi(); } function showAlert() {   SpreadsheetApp.getUi().alert(‘Hello, … Read more