google drive apps script email attachment

So the first time you run the script, you may see an alert like below.Ĭlick on Review Permissions, and you’ll see another alert screen that you’ll need to bypass. Keep in mind that Google Script needs permission to access your Gmail account to send the email. Save the script by clicking the disk icon, and then run it by clicking the run icon (right arrow). The ndEmail function finally performs Google Scripts send email feature using your connected Google account.var message and var subject define the text that’s going to build your alert email.getRange and getValues pull the value from the cell specified in the getRange method.Var subject = 'Your Google Spreadsheet Alert' Var message = 'This is your Alert email!' // Second column Var emailAddress = emailRange.getValues() Var emailRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1').getRange('B2') Next, paste the following code inside the SendEmail() function: // Fetch the email address You’ll see a script window with a default function called myFunction(). To get into the script editor, click on Tools, and then click Script editor. Now that you have an email address to send an alert email to, it’s time to create your script. Just add a name column and an email column, and fill them out with the person you want to receive the alert email. You’ll also need to create a new spreadsheet that contains an email address. Step 1: Sending an Email with Google Sheetsīefore you can create a Google Apps Script to send an email from Google Sheets, you’ll also need a Gmail email address, which Google Apps Script will access to send out your alert emails. It’ll also save you the time of having to monitor your spreadsheet updates manually. No matter the application, this script is compelling. Or you could get an email if your employees report that they’ve billed the client for too many hours in your project tracking spreadsheet. You could receive an alert if the daily earnings in your sales report dip below a certain level. If the value is over a certain threshold limit, you can automatically send an alert email to any email address you like. In the following tutorial, you will learn how to check the value of a cell in Google Sheets.

Google drive apps script email attachment