Match Names In Two Worksheets And Get Data ` Tutorial: Automating a Help Desk Workflow - Google Apps Script. Function getColIndexByName(colName) { var sheet = SpreadsheetApp.getActiveSheet(); var numColumns = sheet.getLastColumn(); var row = sheet.getRange(1, 1, 1, numColumns).getValues(); for (i in row[0]) { var name = row[0][i]; if (name == colName) { return parseInt(i) + 1; } } return -1;} function emailStatusUpdates() { var sheet = SpreadsheetApp.getActiveSheet(); var row = sheet.getActiveRange().getRowIndex(); var userEmail = sheet.getRange(row, getColIndexByName("Contact email")).getValue(); var subject = "Helpdesk Ticket #" + row; var body = "We've updated the status of your ticket.
\n\nStatus: " + sheet.getRange(row, getColIndexByName("Status")).getValue(); body += "\n\nNotes: " + sheet.getRange(row, getColIndexByName("Notes")).getValue(); body += "\n\nResolution: " + sheet.getRange(row, getColIndexByName("Resolution")).getValue(); // Create a vertical panel.. var panel = app.createVerticalPanel(); // ...and add the grid to the panel panel.add(grid); Youpd. How to Create Mail Merge in Gmail using Google Docs. Learn how to create Mail Merge with Gmail and send personalized email messages in bulk.
You may also add file attachments to the mass emails. Mail Merge for Gmail lets you send personalized email messages to multiple contacts in one go. The individual messages have almost the same content but some parts of the message can be customized. For instance, you can greet each recipient by their first name, you can include their postal address in the message body, personalize the subject line, attach different files while the other parts of the email body remain the same.
Mail Merge in Gmail is for everyone. Here’s how you can do mail merge with Gmail: Install the Mail Merge for Gmail add-on. It is always a good idea to test your email campaign before sending a blast to multiple people. Gmail Mail Merge F.A.Q. Here are some answers to frequently asked questions around Mail Merge for Gmail and Google Apps: Three Google Sheets Scripts That Help Teachers Save Time. One of the great things about technology is that it can help use do things more efficiently which in turn means we get to spend more time on the more enjoyable parts of teaching, like working with students instead of working with paperwork.
If you're a Google Apps user there are three Google Sheets (spreadsheets) scripts that I recommend trying. These scripts can help you save time on on sorting, grading, and assessing students' work. Flubaroo is an easy-to-use script that will grade multiple choice quizzes for you. You can even set-up the script to email all of your students their grades with just one click. Complete directions for using Flubaroo can be found here. gClassFolders is a script that will create folders for you for as many course sections as you need.
Doctopus is a Google Spreadsheet script that can help teachers manage the flow of shared work in in their Google Drive accounts. A Google Calendar List of Events Feed on Your Web Site.