Category Archives for "AppScript Development"

Alert by email when input data on google spreadsheet meets given condition

Here is the sample sheet: make a copy of the sheet Suppose you want to receive an email when the status column changes to ‘approved’. Install a trigger first Note that simple trigger does not work since we need to send an email from the trigger. You have to install the trigger. Create a function […]

Continue reading

How to parse and extract data from Gmail to Google Sheets

Extracting data from Gmail messages and then routing that data to other automation steps is an easy task to do using Google Apps Script. My bank sends transaction confirmation emails for each transaction in my account. I will parse and collect the expense data into a Google Sheet. By the end of the month, I […]

Continue reading

How to get input from HTML form using Google Apps Script

There are different ways to display an HTML form from Google Apps Script. You can display a form in a Google Sheet (from a custom menu for example) or you can create a standalone web app and display the web form. Let us first see how to display an HTML form from a Google Sheet. […]

Continue reading

How to use Google Apps Script to send email with attachment

send mass email from google sheets

This example shows you how to send email from a Google Sheet with an attachment. Suppose we have a Google Sheet with all the clients and their email addresses. We need to get a PDF form filled and signed by each of these clients. The plan is to send the PDF form as attachment to […]

Continue reading

From Google Sheets, how to send email based on date

Suppose you want to send reminder emails automatically from your Google Sheets. The email needs to be sent when the invoice is overdue. So it requires to check the current date with the invoice due date. Let us see how to do that in Google Sheets using Google Apps Script. We have a Google Sheet […]

Continue reading

How to send HTML email in Google Apps Script

You can send HTML email from Google Apps Script. For example, suppose you want to send emails from your Google Sheet when certain events occur. You can send email using MailApp.sendEmail() function like this:

where the message is a string with HTML content. An Example Suppose you have a Google sheet with a list […]

Continue reading

How to send email when cell value changes in Google Sheets

Suppose you want to trigger an email to yourself when a cell value is changed in the Google Sheet. Here are the steps that this script will do: – Collect the details about the row that was updated. – Compose an email with the details from the changed row – send the email to one […]

Continue reading

How to get cell value in Google Sheets using apps script

There are different ways to get the cell values. This article shows you different ways to get cell values from the Google Sheet. Some of the methods (like getCell(row, col) ) will be easier if you want to iterate through the cells. Get selected cell value in your Google Sheet Script First, let us add […]

Continue reading

How to add new contacts using Google Apps Script (example code)

Suppose you have a Google Sheet full of contacts. You want to add some of those contacts to your Google/Gmail Contacts. This article has all the sample apps script code to do it. By the way having all your contacts neatly organized in your Google Contacts list has several advantages. You can create groups, send […]

Continue reading