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. If you are organizing a party at your home, you can send personalized email invitations to all your friends with the help of mail merge. A business owner can use mail merge to inform customers about upcoming deals and offers. Here’s how you can do mail merge with Gmail: Install the Mail Merge for Gmail add-on. Gmail Mail Merge F.A.Q. 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 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. The concept behind it is this; students have a "dropbox" folder in their Google Drive accounts that you have shared with them. A Google Calendar List of Events Feed on Your Web Site.